Retrieve Audience Stats from the Google Ads API

[Sergio Ortiz]

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 and 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?