How to get product item id as listed in merchant center feed ?

[que...@itrc.fr]

Hi there,

I would like to know if it is possible to get the item id of a product listed in merchant center (and not the ProductItemId who is different)...

Could you help me to retrieve this info ?

Thanks !

[Thea Vega (AdWords Scripts Team)]

Hi,

Here is an example on how to list all products in merchant center which will return the list of products using the merchant Id.

Let me know if this is what you're looking for.

Thanks,

Thea

AdWords Scripts Team

[que...@itrc.fr]

Hi 

Yes this is what I'm looking for.

Now, I got another issue.

Could you tell me if it possible to get a list of all merchant center products with the adwords stats for each product (average cpc, ctr, clicks, etc.) ?

Thank you. 

[Thea Vega (AdWords Scripts Team)]

Hi,

You may use the Shopping Performance Report. See below sample script to get you started.

function main() {
  var report = AdWordsApp.report(
      'SELECT MerchantId, AverageCpc, Ctr, Clicks ' + //you can add or remove metrics, segments, and attributes to your liking
      'FROM   SHOPPING_PERFORMANCE_REPORT ' +
      'WHERE  Impressions < 10 ' +
      'DURING LAST_30_DAYS');

  var rows = report.rows();
  while (rows.hasNext()) {
    var row = rows.next();
    var merchantId = row['MerchantId'];
    var aveCpc = row['AverageCpc'];
    var ctr = row['Ctr'];
    var clicks = row['Clicks'];
    Logger.log("merchant id: %s | average cpc: %s | ctr: %s | clicks: %s ",merchantId,aveCpc,ctr,clicks);
  }
}

Hope this helps.

[que...@itrc.fr]

Thank you Thea.

When I try this code nothing shows up in the log console...

What am I doing wrong ?

[que...@itrc.fr]

I was just doing a bad request with impressions < 10 ...

could I join the product offer id in the request ?

thank you

[Thea Vega (AdWords Scripts Team)]

Hi,

You may use the OfferId supported by Shopping Performance Report.