Retrieve Audience Stats from the Google Ads API

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?

SELECT audience.id 
,
  audience.resource_name, audience.name 
,
  audience.status,
  audience.description,
  audience.dimensions,
  audience.exclusion_dimension
FROM audience

Thanks,

Google Ads API Team

Feedback
How was our support today?

[2025-09-08 07:28:22Z GMT] This message is in relation to case "ref:!00D1U01174p.!500Ht01u5vGQ:ref" (ADR-00331941)