I'm trying to create a geographic report that shows the cost from *my
google ads camapign* split by province. I'm using google ADS API for python.
The GAQL query that I use to extract data is :
query = """SELECT segments.year, segments.week, campaign.name,
segments.geo_target_city, segments.geo_target_province, metrics.cost_micros
FROM geographic_view WHERE segments.week = '{start_date}'
""".format(start_date=start_date)
If I use a certain customer ID of my MCC account and in particular the
account ID that contains all the italy campaigns I have results, but if I
use another account ID I didn't obtain any data.
Please find here the accounts (censored). In green the one that works and
in red the one that doesn't work <https://i.stack.imgur.com/m65q8.png>
The weird thing is that if I switch table in the from and I use "campaign"
instead of "geographic_view" I have the data. Unfortunately in "campaign" I
ahve not the province and city information that I need.
query1 = """SELECT segments.year, segments.week, campaign.name,
segments.geo_target_city, metrics.cost_micros FROM campaign WHERE
segments.week = '{start_date}' """.format(start_date=start_date)
Should I change any setting in google ADS? Anyone understand why I have
this issue? Thank you.
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 on the web visit
https://groups.google.com/d/msgid/adwords-api/beb4dc5a-829a-420e-9768-559e929aa618n%40googlegroups.com.
