Re: How to exclude negative locations from location_view
Hi Mat, Sorry about that -- silly mistake on my part! I was looking into your question and a separate question at the same time and mixed up the campaign IDs. I just ran a report against a campaign in another account with negative location criteria, and your filter of campaign_criterion.negative != TRUE resulted in negative criteria being excluded from the report. Could you share the campaign ID and date range for your report so I can check your exact case? Thanks, Josh, Google Ads API Team ref:_00D1U1174p._5001UCZdYE:ref -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com 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 adwords-api+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/47rDj0PTX9LL00km-EsVtaQMyYsgsYDc3Pew%40sfdc.net.
Re: How to exclude negative locations from location_view
Hi Josh, I beg your pardon? I did not provide any particular campaign in my query. And as you can see, I've already added "'AND campaign_criterion.negative != TRUE '" to my query (which should yield the same results as "campaign_criterion.negative = false") . And still there are negative location criteria in the response - hence the question. Regards Mat Am Freitag, 28. Juni 2019 01:16:21 UTC+2 schrieb adsapiforumadvisor: > > Hi, > > You can exclude negative criteria from the results by adding > *campaign_criterion.negative > = false* to your query. The particular campaign in the query you provided > does not have any negative location criteria, however. > > Thanks, > Josh, Google Ads API Team > > ref:_00D1U1174p._5001UCZdYE:ref -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com 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 adwords-api+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/0a05e682-876c-43a3-ad9f-55aa9faadb68%40googlegroups.com.
RE: How to exclude negative locations from location_view
Hi, You can exclude negative criteria from the results by adding campaign_criterion.negative = false to your query. The particular campaign in the query you provided does not have any negative location criteria, however. Thanks, Josh, Google Ads API Team ref:_00D1U1174p._5001UCZdYE:ref -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com 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 adwords-api+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/O59SA0PTS5YW00rHHF-0uDTTa-4lFj_Ivlmw%40sfdc.net.
How to exclude negative locations from location_view
Hi,
how can I exclude negative locations from a location_view report?
My query:
query = ('SELECT '
'campaign.id, '
'campaign.status, '
'campaign.serving_status, '
'campaign_criterion.negative, '
'location_view.resource_name, '
'metrics.clicks, '
'metrics.cost_micros, '
'metrics.conversions '
'FROM location_view '
'WHERE campaign.id = {} '
'AND campaign_criterion.negative != TRUE '
'AND campaign.status = ENABLED '
'AND campaign.serving_status = SERVING '
'AND segments.date BETWEEN "{}" AND "{}"'.format(campaign_id,
start, end)
)
... still returns excluded locations. What's wrong?
Regards
Mat
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
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 adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/adwords-api/4e66e611-e3bd-4020-b9b4-02b26f85c2c5%40googlegroups.com.
