Hi Team!
I'm trying to get the data from location_view breakdown by campaign. but 
missing one of campaign which could found in campaign view?

SELECT
location_view.resource_name,
campaign_criterion.location.geo_target_constant,
metrics.conversions_value,
metrics.clicks,
metrics.ctr,
metrics.impressions, 
metrics.average_cpm,
metrics.cost_micros,
campaign.id, campaign.name, segments.date FROM location_view
where metrics.impressions > 0 AND segments.date DURING YESTERDAY

I'm sure impression > 0 is true
Can you please tell me how to fix it?
Thank you very much for your help

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/4ad4a363-836c-43cf-806c-ad1788eb8b7an%40googlegroups.com.

Reply via email to