Hi,
I've been using the following GAQL to retreive report data from
geographic_view on daily basis for months, and it was working fine. But
today I found some spends are missiong, after I checked step by step, I
found some spends data is missing because that these special ADs is not
based on ad_group, and they are only based on campaign, when I omited
ad_group.id and ad_group.name from the GAQL, it could response all spends
back. but I need ad_group info for later data processing, I gave many trys
on this issue, and willing to find a single GAQL query to retrieve correct
spend data with same dimensions, but I could not find a way to do it. Could
somebody tell me a right way to do?
SELECT
segments.ad_network_type,
segments.date,
segments.device,
geographic_view.country_criterion_id,
customer.id,
customer.descriptive_name,
ad_group.id,
ad_group.name,
campaign.id,
campaign.name,
campaign.app_campaign_setting.app_id,
campaign.app_campaign_setting.app_store,
metrics.clicks,
metrics.cost_micros,
metrics.impressions
FROM geographic_view
WHERE
segments.date = '{date}'
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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
"Google Ads API and AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion visit
https://groups.google.com/d/msgid/adwords-api/ed049425-199b-40a8-9dd9-41da95ab5f3cn%40googlegroups.com.
