Export Data from Bid Landscape

[Y...@globalindustrial.com]

Hi,

Is there any one can help me on exporting the data with the Bid Landscape API?

I want to call the bid and impression estimation for each adgroup in a campaign, then export the data into a google sheet.

Would I be able to do so? Can someone help me at the script level?

Thank you so much,

Kara

[Luis Xander Talag (AdWords API Team)]

Hi Kara,

You may use the DataService.getAdGroupBidLandscape() method to fetch the bid landscapes for your ad group. You may refer to this guide for more information and you may also look to this complete sample code in Java (also available in other languages) for your reference. However, since the API doesn't have a feature on exporting data from the service call into a spreadsheet, you should create a method on your end to do this.

Let me know if you have further clarifications.

Thanks and regards,

Luis

AdWords API Team 

[Y...@globalindustrial.com]

Hi Luis,

This is very great!

Would you know where I can find the CRITERION_ID? I only see the ad group ID in the shopping reports.

Thanks,

Kara

[Luis Xander Talag (AdWords API Team)]

Hi Kara,

You could use the AdGroupCriterionService.get() method to retrieve the id of criterion. You may check this sample code in Java (also available in other languages) for your reference. In reports, you could get the criteriaId by searching the report field name in this link. Also, you could check this guide for table of criterion IDs.

Feel free to write back if you have further clarifications.

Regards,

Luis

AdWords API Team

[Y...@globalindustrial.com]

Hi Luis,

Thanks for the reply. It's very helpful!

Kara

[Y...@globalindustrial.com]

Hi Luis,

For the shopping campaigns, since the bid modifier is based on product group, not keywords.

Could you please tell me what criteria type I can select?

The attachment is the code for the AdGroupCriterionService.get()  function.

Thank you so much,

Kara

[Luis Xander Talag (AdWords API Team)]

Hi Kara,

I could see in your code that you've already used the PRODUCT_PARTITION criteria type which I believe is the answer to your question. However, could you clarify if you encountered any issue when making a request using those code? If so, could you provide the complete SOAP request and response logs so I could investigate? Please reply via Reply privately to author.

Regards,

Luis

AdWords API Team

[Y...@globalindustrial.com]

Hi Luis,
I figured it out. I need to change the fields in productgroup['criterion'] based on the document.

Thanks,

Kara