Migrate fields to Google Ads

45 views

Skip to first unread message

Project YSS

unread,

Sep 17, 2019, 7:47:08 AM9/17/19

to AdWords API and Google Ads API Forum

Hi, when we migrate from AdwordAPI to GA API:

report type: ad_performance_report and fields: fields IsNegative, LabelIds, Labels
we got one problem:
Based on the migrate document, it will have resource and fields as the following:
resource: ad_group_ad and fields: ad_group_criterion.negative, label.resource_name, label.name
But when we call API with resource and fields as above, we got a message: "Cannot select fields from the following resources: 'AD_GROUP_CRITERION', 'LABEL', since the resource is incompatible with the resource in FROM clause"
Can you please tell me why we got that and is there any way we can achieve the above fields with corresponding resource(ad_group_ad: ad_group_criterion.negative, label.resource_name, label.name)
And the same question for reports and fields:
resource: feed_item and fields: feed_placeholder_view.placeholder_type, feed_item_target.ad_schedule
resource: managed_placement_view and fields: detail_placement_view.display_name

Thank you,

Google Ads API Forum Advisor Prod

unread,

Sep 17, 2019, 5:20:08 PM9/17/19

to ad...@septeni-technology.jp, adwor...@googlegroups.com

Hello,

The ad_group_criterion.negative, label.resource_name and label.name cannot be selected with ad_group_ad resource. This is the reason you are getting incompatible error. The list of fields that can be selected along with this resource are listed here. You could use the ad_group_criterion resource or label resource to get ad_group_criterion.negative, label.resource_name and label.name value respectively. Please find below the sample report queries for reference.

SELECT ad_group.id, ad_group.resource_name, ad_group_criterion.criterion_id, ad_group_criterion.negative FROM ad_group_criterion LIMIT 100
SELECT label.id, label.name, label.resource_name, customer.id FROM label LIMIT 100

Similar can be handled for other resources as well. You could use feed_placeholder_view, feed_item_target and detail_placement_view to query the resource and the fields that can be selected along with the resources. Let us know if you have any additional concerns.

Regards,
Nikisha Patel, Google Ads API Team