Splitting campaign spend by city

[Erik Møiniche-Kiebe]

Can I generate a query to split the campaign spend by city even though the campaign weren't targeted to specific cities? 

I'm currently using the query below but it seems to only work on campaigns that was targeted towards specific cities. My guess is that I should use something different than campaign_criterion.location.geo_target_constant

SELECT

  segments.date,

  customer.id,

  customer.descriptive_name,

  campaign.id,

  campaign.name,

  campaign_criterion.location.geo_target_constant,

  customer.currency_code,

  metrics.cost_micros

FROM

  location_view

WHERE

  segments.date BETWEEN '{}' AND '{}'

[Google Ads API Forum Advisor Prod]

Hi Erik,

I recommend using the geographic_view since this will give you data on the physical location of the user or an area of interest rather than targeted locations.

Cheers,
Anthony
Google Ads API Team

Anthony Google Ads API Team

ref:_00D1U1174p._5004Q26AdOm:ref

[Erik Møiniche-Kiebe]

Thanks I'll look into that.

Erik