Inaccurate costs when querying geographic_view

[Nathan]

My understanding of geographic_view is that it reproduces the Ads "Geographic" report. I'm trying to reproduce this report per "United States (Postal Code)" view. 

My test query is below. This specific query drills into the performance of 1 test US postal code (geoTargetConstants/9007313)

Am I misunderstanding this? The metrics returned are significantly different than what's displayed in the UI.

SELECT 

campaign.id, segments.geo_target_postal_code, 

metrics.all_conversions, metrics.clicks, metrics.ctr, metrics.ctr, metrics.impressions, metrics.cost_micros, metrics.interactions,

metrics.average_cost,

metrics.average_cpc,

metrics.clicks,

metrics.conversions, metrics.all_conversions, metrics.cost_per_conversion

FROM geographic_view 

where campaign.id=$CAMPAIGN_ID 

and segments.date >= '2019-06-01' AND segments.date < '2019-07-01' and segments.geo_target_postal_code='geoTargetConstants/9007313'

DISCLAIMER: Any advice or comments provided by an employee of Healthcare Research LLC (HCR) is provided with the understanding that neither the employee nor HCR is rendering legal advice. HCR customers (including myCNAjobs.com and HealthHire.com) are responsible for ensuring job and other content meets EEO standards and all applicable State and Federal law requirements. HCR is not responsible. HCR may make recommendations via phone consultation, email, webinars, or other site content or data reports. The recommendations are not intended to be legal advice and it is recommended that all customers seek advice of its own counsel to ensure such compliance. 

[Google Ads API Forum Advisor Prod]

Hello Nathan, 

Could you please share the specific client customer Id to check this further? You can share the details privately via Reply privately to author option. 

Regards,
Bharani, Google Ads API Team

ref:_00D1U1174p._5001UCals4:ref