Hi Team, We are trying to fetch *adspend* data including metrics (Impressions, Clicks, Cost, Conversions and Conversion_value) from Google Ads API and we have identified by using GAQL & python client library we can achieve this from *ad_group_ad* endpoint as show below. SELECT segments.date, segments.device, campaign.id, campaign.name, campaign.status, campaign.advertising_channel_type, ad_group.name, ad_group_ad.ad.id, ad_group_ad.ad.name, ad_group_ad.ad.tracking_url_template, metrics.cost_micros, metrics.clicks, metrics.impressions, metrics.conversions, metrics.conversions_value, customer.currency_code FROM ad_group_ad WHERE segments.date = '2024-01-01'
Here we have another requirement is that we need to fetch *search_terms* data also, for that we are fetching as below SELECT segments.date, segments.device, campaign.id, campaign.name, campaign.status, campaign.advertising_channel_type, ad_group.name, ad_group_ad.ad.id, ad_group_ad.ad.name, ad_group_ad.ad.tracking_url_template, metrics.cost_micros, metrics.clicks, metrics.impressions, metrics.conversions, metrics.conversions_value, customer.currency_code, search_term_view.search_term FROM search_term_view WHERE segments.date = '2024-01-01' But here my issue, the overall impressions, clicks, cost, conversions & conversions for 2024-01-01 is varying between *ad_group_ad and search_term_view, *but ideally it should not vary right?? since we introduce *search term* column, it should break up the various metrics into smaller parts but the aggregates should match up when without search_term column. Example: From *ad_group_ad* endpoint the response as campaign_id - 23232141 adgroup_name - Blue Spruce ad_id - 4262288 impressions - 14 clicks - 3 cost - 2 >From *search_term_view* endpoint the response as campaign_id - 23232141 adgroup_name - Blue Spruce ad_id - 4262288 search_term - 6.5 ft artificial christmas tree impressions - 6 clicks - 1 cost - 1 campaign_id - 23232141 adgroup_name - Blue Spruce ad_id - 4262288 search_term - artificial christmas trees impressions - 6 clicks - 0 cost - 0 >From the above example, we can observe that aggregated impressions, clicks & cost from *ad_group_ad *are not matching with *search_term* splitted impressions, clicks & cost. missing data: impressions - 2 clicks - 2 cost - 1 I hope you understood, Can you please help me with this? Thanks in advance, Mohan. -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 "Google Ads API and AdWords API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion visit https://groups.google.com/d/msgid/adwords-api/8a68062c-5392-4d3b-88d9-11e3bcbe2f90n%40googlegroups.com.
