Thank you for your support. I tried shopping_performance_view <https://developers.google.com/google-ads/api/fields/v8/shopping_performance_view> but no success. Could you help to build correct query?
I am getting empty results for all my queries. For example: SELECT shopping_performance_view.resource_name FROM shopping_performance_view SELECT segments.product_type_l1, campaign.id, ad_group.id FROM shopping_performance_view WHERE customer.id = 1684984350 AND campaign.id = 14527668859 AND ad_group.id = 121937616370 SELECT campaign.id, ad_group.id, segments.product_item_id FROM shopping_performance_view WHERE customer.id = 1684984350 AND campaign.id = 14527668859 AND ad_group.id = 121937616370 This is my product group in Ads manager. I want to get same data in popup. [image: Screen Shot 2021-09-10 at 17.04.52.png] Attaching AdGroup info for reference GET: https://googleads.googleapis.com/v8/customers/1684984350/adGroups/121937616370 { "resourceName": "customers/1684984350/adGroups/121937616370", "status": "ENABLED", "type": "SHOPPING_SMART_ADS", "explorerAutoOptimizerSetting": { "optIn": true }, "targetingSetting": { "targetRestrictions": [ { "targetingDimension": "AUDIENCE", "bidOnly": true }, { "targetingDimension": "GENDER", "bidOnly": true }, { "targetingDimension": "AGE_RANGE", "bidOnly": true }, { "targetingDimension": "PARENTAL_STATUS", "bidOnly": true }, { "targetingDimension": "INCOME_RANGE", "bidOnly": true } ] }, "id": "121937616370", "name": "[AdSIST] ad category 1630897372", "baseAdGroup": "customers/1684984350/adGroups/121937616370", "campaign": "customers/1684984350/campaigns/14527668859", "cpcBidMicros": "1000000", "cpmBidMicros": "1000000", "targetCpaMicros": "0", "cpvBidMicros": "0", "targetCpmMicros": "1000000", "effectiveTargetCpaMicros": "0" } SELECT product_group_view.resource_name, ad_group.id, ad_group.name, ad_group_criterion.criterion_id, ad_group_criterion.keyword.text, ad_group_criterion.keyword.match_type, ad_group_criterion.listing_group.type, ad_group_criterion.resource_name, ad_group_criterion.status FROM product_group_view WHERE campaign.id = 14527668859 and ad_group.id = 121937616370 { "results": [ { "adGroup": { "resourceName": "customers/1684984350/adGroups/121937616370", "id": "121937616370", "name": "[AdSIST] ad category 1630897372" }, "adGroupCriterion": { "resourceName": "customers/1684984350/adGroupCriteria/121937616370~293946777986", "status": "PAUSED", "listingGroup": { "type": "SUBDIVISION" }, "criterionId": "293946777986" }, "productGroupView": { "resourceName": "customers/1684984350/productGroupViews/121937616370~293946777986" } }, { "adGroup": { "resourceName": "customers/1684984350/adGroups/121937616370", "id": "121937616370", "name": "[AdSIST] ad category 1630897372" }, "adGroupCriterion": { "resourceName": "customers/1684984350/adGroupCriteria/121937616370~296303633664", "status": "ENABLED", "listingGroup": { "type": "UNIT" }, "criterionId": "296303633664" }, "productGroupView": { "resourceName": "customers/1684984350/productGroupViews/121937616370~296303633664" } }, { "adGroup": { "resourceName": "customers/1684984350/adGroups/121937616370", "id": "121937616370", "name": "[AdSIST] ad category 1630897372" }, "adGroupCriterion": { "resourceName": "customers/1684984350/adGroupCriteria/121937616370~597787114522", "status": "ENABLED", "listingGroup": { "type": "UNIT" }, "criterionId": "597787114522" }, "productGroupView": { "resourceName": "customers/1684984350/productGroupViews/121937616370~597787114522" } } ], "fieldMask": "productGroupView.resourceName,adGroup.id,adGroup.name,adGroupCriterion.criterionId,adGroupCriterion.keyword.text,adGroupCriterion.keyword.matchType,adGroupCriterion.listingGroup.type,adGroupCriterion.resourceName,adGroupCriterion.status" } Thank you Bat On Thursday, September 9, 2021 at 6:26:33 PM UTC+9 adsapi wrote: > Hello Bat, > > Thank you for reaching out to us. > > In the Google Ads API's perspective, you can get product counts by using > the shopping_performance_view > <https://developers.google.com/google-ads/api/fields/v8/shopping_performance_view> > and > utilize this segment field (segments.product_item_id > <https://developers.google.com/google-ads/api/fields/v8/shopping_performance_view#segments.product_item_id> > ). > > Regards, > [image: Google Logo] > Mark Kevin Albios > Google Ads API Team > > > ref:_00D1U1174p._5004Q2NSKdC:ref > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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/d2b40f4c-a903-49bc-9503-94f06479fe12n%40googlegroups.com.
