Hi All,
I am attempting to migrate our Product Partition report but running into a
few problems. I'm referencing the fields
here:
https://developers.google.com/google-ads/api/docs/migration/reports#product_partition
The question boils down to: what resource do I want in my from clause?
Here are the errors I'm running into:
query: "select customer.id, campaign.id, ad_group.id,
ad_group_criterion.criterion_id, segments.ad_network_type, segments.date,
segments.device, ad_group_criterion.listing_group.type,
metrics.impressions, metrics.clicks, metrics.cost_micros,
metrics.search_click_share, metrics.search_impression_share,
metrics.conversions from ad_group where segments.date DURING
LAST_7_DAYS "
page_size: 5000
Failure message: errors {
error_code {
query_error: PROHIBITED_RESOURCE_TYPE_IN_SELECT_CLAUSE
}
message: "Cannot select fields from the following resource:
\'AD_GROUP_CRITERION\', since the resource is incompatible with the
resource in FROM clause."
}
Or:
query: "select customer.id, campaign.id, ad_group.id,
ad_group_criterion.criterion_id, segments.ad_network_type, segments.date,
segments.device, ad_group_criterion.listing_group.type,
metrics.impressions, metrics.clicks, metrics.cost_micros,
metrics.search_click_share, metrics.search_impression_share,
metrics.conversions from ad_group_criterion where segments.date DURING
LAST_7_DAYS
"
Failure message: errors {
error_code {
query_error: PROHIBITED_METRIC_IN_SELECT_OR_WHERE_CLAUSE
}
message: "Cannot select or filter on the following metrics:
\'impressions\'(could not support requested resources:
\'AD_GROUP_CRITERION\', \'AD_GROUP_CRITERION\'), \'clicks\'(could not
support requested resources: \'AD_GROUP_CRITERION\',
\'AD_GROUP_CRITERION\'), \'cost_micros\'(could not support requested
resources: \'AD_GROUP_CRITERION\', \'AD_GROUP_CRITERION\'),
\'search_click_share\'(could not support requested resources:
\'AD_GROUP_CRITERION\', \'AD_GROUP_CRITERION\'),
\'search_impression_share\'(could not support requested resources:
\'AD_GROUP_CRITERION\', \'AD_GROUP_CRITERION\'), \'conversions\'(could not
support requested resources: \'AD_GROUP_CRITERION\',
\'AD_GROUP_CRITERION\'), since metric is incompatible with the resource in
the FROM clause or other selected segmenting resources."
}
Thanks
Pete
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
---
You received this message because you are subscribed to the Google Groups
"AdWords API and Google Ads API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/adwords-api/a6430fd3-ddb9-4520-9dfd-5d1d2da52701%40googlegroups.com.
