Get All Products in a campaign

[Kamran Iftikhar]

Hi All,

Is there way to get all the products in a campaign through adwords API?

I want to see what products are there in a particular campaign.

 

Regards,

Kamran

[Shwetha Vastrad (AdWords API Team)]

Hi Kamran,

You need to use the API to retrieve Shopping Performance Report, which provides shopping campaign statistics aggregated at the product (OfferId field) level. You can filter for products from a particular campaign by using predicates. 

Regards,

Shwetha, AdWords API Team.

[Kamran Iftikhar]

Hi Shwetha,

Thanks for the quick response, I want to get all the items, even no impression for those. also even if the campaign is Paused.

My requirement is to get the all the products listed with in a campaign.

I know we can get adgroups, criterion for a campaign using Adwords API, want to know if this option is also available.

Regards,

Kamran

[Avkeren Cohen]

Hi Shwetha,

Won't the OfferId field give me the product group Item Id.

And only if I subdivided the entire product group by item Id it will then give me as the  OfferId the Id of each item?

[Shwetha Vastrad (AdWords API Team)]

Hi Kamran and Avkeren,

I'm afraid the OfferId field doesn't support zero impressions. You can retrieve the AdGroups and Criteria associated with a campaign using API services and reports, but I'm afraid you'll need to use the Shopping Performance Report to get the products in your shopping campaigns. 

The OfferId will be the Item Id retrieved from the Merchant Center account. Even if the AdGroup is subdivided into product groups using other dimensions, the Shopping Performance Report will have product-level results. Whereas in the Product Partition Report an impression for a product will be attributed to the row for every product partition that contains the product. 

[Kamran Iftikhar]

Hi Shwetha,

Thank you very much for the update.

Just to confirm:

So in short there is no way to get ALL the products listed with in a campaign. we can only get products that had at least one impression during any time frame searched for through Shopping Performance Report.

Regards,

Kamran

[Shwetha Vastrad (AdWords API Team)]

Hi Kamran,

Yes, it's not possible to get all products within a campaign using API reports if they don't have impressions. You can use the data available in the Product status and Products approved columns in the UI to get these details. You can also get this data from the Products tab in the AdWords UI.

[Kamran Iftikhar]

Hi Shwetha,

Thanks for the update. I am marking this as complete as this is not possible through the adwords API.

Regards,

Kamran