While fetching data from geographic view, only getting a single entry for a
campaign for a specific date, but while checking for the same data for that
campaign channel in ad sense there are record present for few other
countries with less or minor revenue compare to the major country revenue
for which data exists in the geographic_view, How can i get the entire geo
locations data records by a specifc campaign, for now I'm using below query
SELECT
campaign.id,
campaign.name,
customer.id,
customer.descriptive_name,
campaign.status,
campaign.serving_status,
campaign.primary_status,
campaign.primary_status_reasons,
metrics.average_cost,
metrics.average_cpc,
metrics.average_cpm,
metrics.average_cpv,
metrics.clicks,
metrics.conversions,
metrics.conversions_value,
metrics.impressions,
metrics.ctr,
metrics.cost_per_conversion,
metrics.cost_per_all_conversions,
metrics.cost_micros,
segments.date,
geographic_view.location_type
FROM geographic_view
WHERE segments.date >= '2024-11-25' AND segments.date <=
'2024-11-25'
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/293c0cab-ff94-487f-ae34-ba4dd20bf3den%40googlegroups.com.
