How to pull Shopping product id and Max Cpc

[Mads Ellegård]

Hi, 

I want to pull some information from Shopping. I want to know product id and max cpc bid (the number I am bidding in the interface). 

It doesn't seem to be doable via the Shopping Performance Report. I was thinking that I could use the Product Partition Report. I would then use attribute: "ID" (Criterion ID) and Cpcbid (Max CPC). Would that get information I am looking for?

I am using Supermetrics to pull the data, but I want to make sure I got this straight before I convince them to develop something new. 

Thanks!

Mads

[Kevin Weitzner]

I do this via a product partition report.  I pull Campaign ID, ProductGroup, CpcBid, Id, and AdGroupId.

If you look in the product group column, you can get your PLA IDs, just have to string replace the * / item id=", and other " with nothing.

If you want to assign bids you will need your criterion ID, campaignID, adgroupID, and PLAID in order to determine which exact item you are pushing a bid onto. (if your products appear in more than one campaign/adgroup/product group).

[Teja Makani]

Hello Mads,

As Kevin said, Please give that a try and let me know if you have any further questions.

Regards,
Sai Teja, AdWords API Team.

[Mads Ellegård]

Thanks guys! I probably dont need PLAID if I have criterion ID?

[Teja Makani]

Hello Mads,

The PLA ID in the Kevin's response refers to the product id of your products and you can strip it from the ProductGroup filed of the Product Partition Report as mentioned. Using criterion Id is not recommended as there might be more than one product having the same criteria. Please let me know if you have if you have any further questions.

Regards,
Sai Teja, AdWords API Team.

On Friday, October 19, 2018 at 7:02:24 AM UTC-4, Mads Ellegård wrote: