I was using like this $googleAdsRow->getAdGroupAd()->getAd()->getShoppingProductAd();
Thanks On Tuesday, 28 January 2020 14:52:48 UTC+5:30, cv wrote: > > Hi, > > My query looks like > > $query = "SELECT > segments.date, > > campaign.id, > campaign.name, > campaign.status, > ad_group.id, > ad_group.name, > ad_group.status, > > metrics.clicks, > metrics.impressions, > metrics.ctr, > metrics.cost_micros, > metrics.conversions, > metrics.cost_per_conversion, > metrics.conversions_from_interactions_rate, > metrics.average_cpc, > metrics.active_view_impressions, > metrics.average_cpm, > metrics.view_through_conversions, > metrics.absolute_top_impression_percentage, > metrics.top_impression_percentage, > ad_group_ad.ad.id, > ad_group_ad.ad.type, > ad_group_ad.ad.name, > ad_group_ad.status, > > ad_group_ad.ad.shopping_product_ad, > ad_group_ad.ad.shopping_smart_ad > > FROM > ad_group_ad > WHERE > ad_group_ad.status = 'ENABLED' > AND campaign.status = 'ENABLED' > AND ad_group.status = 'ENABLED' > AND segments.date >= $startDate AND segments.date <= > $endDate"; > > > Thanks, > > On Tuesday, 28 January 2020 14:49:23 UTC+5:30, cv wrote: >> >> Hi Xiaoming, >> >> Thank you for your response. >> >> I would also like to say that does I need to pass ad_group.type = >> SHOPPING_PRODUCT_ADS otherwise it is giving >> Segmentation fault (core dumped). >> >> Thanks >> >> On Tuesday, 28 January 2020 01:52:02 UTC+5:30, adsapiforumadvisor wrote: >>> >>> Hi, >>> >>> Thanks for reaching out. You would be able to fetch data for >>> ShoppingProduct Ads by querying the ad_group_ad >>> <https://developers.google.com/google-ads/api/fields/v2/ad_group_ad> >>> resource and use code similar to this example query >>> <https://developers.google.com/google-ads/api/docs/shopping-ads/reporting>. >>> Please let me know if you have any further questions. >>> >>> Thanks and regards, >>> Xiaoming, Google Ads API Team >>> >>> >>> >>> ref:_00D1U1174p._5001USx07w: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 adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com 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 adwords-api+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/169d1503-f9c1-4971-b948-f6be1ae3b7af%40googlegroups.com.
