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 '{}'

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 
"AdWords API and Google Ads API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/35bfece5-48ab-4356-9313-307546489a10n%40googlegroups.com.

Reply via email to