AdWords
3.4K members online now
3.4K members online now
For questions related to Google Shopping and Merchant Center. Learn to optimize your Shopping ads
Guide Me
star_border
Reply

Relation between offerId and productId (for matching Adwords Shopping performance report with GMC)

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hello everyone,

 

I was wondering if there is any official statement describing how the productId in the Google Merchant Center (GMC) is generated. When I look at my products from the API, I see the productId is for example online:en:US:968520 and the corresponding offerId is 968520. So from the looks of it, the system seems to be

{channel}:{language}:{country}:{offerId}

is this correct?

 

My goal is that I can combine the Google Adwords Shopping Performance Report with the Products from the GMC. In the report, there are fields for language, country and offerId. My question is, can I use these fields to savely match the statistics to the products from the GMC? I can't use the offerId alone, as there might be duplicates in different languages and countries (as officially suggested best practice by Google).

 

I wasn't able to find any information about this productId. If this is just an inofficial use, I may be subject to change at any time and then I cannot match the Adwords Report to Products any more.

 

If you need any more information, please don't hesitate to ask, I'll be happy to provide it to you.

 

Best regards,

Georg

1 Expert replyverified_user
1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by topic author Georg D
April 2017

Relation between offerId and productId (for matching Adwords Shopping performance report with GMC)

[ Edited ]
Top Contributor
# 2
Top Contributor

(1) yes -- that looks correct.
(2) technical yes; practically, likely not.
 
when a feed-file is used to submit product-inventory-items,
a channel, language, and target-country are defined (once),
during the data-feed-registration process -- then google,
automatically, adds those details to each item-offer that
is submitted in the feed.

however, for the api, since there is no equivalent to a registration-processes --
channel, language, and country are simply required to be submitted, for each

item-offer (product-resource).

google creates a productid from those registered or submitted
properties -- regardless of how an item is submitted/inserted.

offerid, defined by the api, is equivalent to the id attribute within a data-feed --
however, the api documentation often refers to productid as, id of the product.

productid is defined by the content-api-for-shopping:

channel:languageCode:countryCode:offerId


that said, depending on the use-case, the best likely course would be to create
the desired report from among information that can be obtained by using only
one of the api's.

 

the content-api is mainly for submitting shopping-ad

inventory-data and not designed for general queries;

their quotas tend to reflect this usage/restriction.

google has separate forums for each api, for any needed clarification, more
authoritative answers, and any follow-up or additional questions or issues:
https://groups.google.com/forum/#!forum/adwords-api
https://groups.google.com/forum/#!forum/adwords-scripts

https://groups.google.com/forum/#!forum/google-content-api-for-shopping

 

View solution in original post

Marked as Best Answer.
Solution
Accepted by topic author Georg D
April 2017

Relation between offerId and productId (for matching Adwords Shopping performance report with GMC)

[ Edited ]
Top Contributor
# 2
Top Contributor

(1) yes -- that looks correct.
(2) technical yes; practically, likely not.
 
when a feed-file is used to submit product-inventory-items,
a channel, language, and target-country are defined (once),
during the data-feed-registration process -- then google,
automatically, adds those details to each item-offer that
is submitted in the feed.

however, for the api, since there is no equivalent to a registration-processes --
channel, language, and country are simply required to be submitted, for each

item-offer (product-resource).

google creates a productid from those registered or submitted
properties -- regardless of how an item is submitted/inserted.

offerid, defined by the api, is equivalent to the id attribute within a data-feed --
however, the api documentation often refers to productid as, id of the product.

productid is defined by the content-api-for-shopping:

channel:languageCode:countryCode:offerId


that said, depending on the use-case, the best likely course would be to create
the desired report from among information that can be obtained by using only
one of the api's.

 

the content-api is mainly for submitting shopping-ad

inventory-data and not designed for general queries;

their quotas tend to reflect this usage/restriction.

google has separate forums for each api, for any needed clarification, more
authoritative answers, and any follow-up or additional questions or issues:
https://groups.google.com/forum/#!forum/adwords-api
https://groups.google.com/forum/#!forum/adwords-scripts

https://groups.google.com/forum/#!forum/google-content-api-for-shopping

 

Relation between offerId and productId (for matching Adwords Shopping performance report with GMC)

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

Alright,I will ask over on the api forums. Thank you very much!