Hello Support Team,
I’m working on pulling *audience level* stats through Fivetran. Since Fivetran connects directly to the Google Ads API and loads raw data into our warehouse without transformations, my goal is to replicate the same audience level data I see in Google Ads. In the console, when I query ad or ad group stats, I get the expected results with the raw data from Fivetran, but that is not currently happening with audiences. I am facing two main issues: 1. I’m seeing discrepancies across metrics when pulling data via Fivetran. To get audience-level stats, I union data from both ad_group_audience_view <https://developers.google.com/google-ads/api/fields/v21/ad_group_audience_view> and campaign_audience_view <https://developers.google.com/google-ads/api/fields/v21/campaign_audience_view>, but the resulting values don’t match what I see in the Google Ads console for most metrics such as cost, impressions, interactions, and conversions. The only metric that aligns perfectly is *views*, which makes me doubt that aggregation is the root issue; if it were, I wouldn’t expect views to match while the others don’t. 2. When I query the raw data in our warehouse, I find that views only match the Google Ads console if I filter out the “*Removed*” state from the *audience segment state* in the console. I raised this with Fivetran, and they shared the API query they use to pull the data: query: "SELECT campaign.base_campaign, metrics.conversions, ad_group_criterion.status, metrics.interactions, metrics.interaction_event_types, campaign.id, segments.device, metrics.active_view_impressions, metrics.clicks, ad_group_criterion.criterion_id, metrics.active_view_measurable_impressions, metrics.active_view_measurability, ad_group_audience_view.resource_name, metrics.conversions_value, segments.ad_network_type, metrics.impressions, metrics.view_through_conversions, metrics.active_view_viewability, ad_group.id, metrics.video_views, customer.id, ad_group_criterion.user_list.user_list, ad_group_criterion.user_interest.user_interest_category, metrics.active_view_measurable_cost_micros, ad_group.base_ad_group, metrics.cost_micros, segments.date FROM ad_group_audience_view WHERE segments.date BETWEEN \'2025-01-01\' AND \'2025-01-31\'" As you can see here, there are no filters applied besides from the date. Since the *views* match with Google Ads console, why can't I get the same value for the other metrics? Could you provide guidance on the proper way to retrieve accurate *audience level* stats so they match the results I see at other granularities (campaign, ad group, ad) in Google Ads console? -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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/c0714a3e-0a0c-4213-901c-e2d6ecbe223an%40googlegroups.com.
