Google Ads API: Do we still have to exclude id 3000000 and 3000006 in keyword_view?

[Mat]

Hi,

with the AdWords API we used to pull Keywords Performance Reports like this:

var report = AdWordsApp.report("SELECT Id, Impressions FROM KEYWORDS_PERFORMANCE_REPORT WHERE Id NOT_IN [3000000, 3000006]");

Is this part ...

WHERE Id NOT_IN [3000000, 3000006]

... obsolete or still viable or even necessary when using "keyword_view" with the Google Ads API? E.g:

query = ('SELECT '

              'ad_group_criterion.criterion_id, '

              'metrics.impressions

              'FROM keyword_view '

              'WHERE ad_group_criterion.criterion_id NOT IN (3000000, 3000006)' #< obsolete?

              )

... or do we instead have to specify the "campaign.advertising_channel_type", like in this example?

...
'AND campaign.advertising_channel_type = \'SEARCH\' '
...

Regards

Mat

[googleadsapi...@google.com]

Hi Mat,

Thank you for reaching out. You can still use NOT IN because as seen on this guide, this isn't obsolete yet. Specifying the campaign.advertising_channel_type will just filter your results to all campaigns whose advertising_channel_type is SEARCH. You may also want to check this guide for the equivalent fields of keyword performance report from AdWords API to Google Ads API.

Let me know if this helps. Feel free to write back if you have further clarifications.

Regards,

Dave

Google Ads API Team

=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
    https://ads-developers.googleblog.com/search/label/google_ads_api
    https://developers.google.com/adwords/api/community/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

Was your question answered? Please rate your experience with us by taking a short survey.
If not -- reply to this email and tell us what else we can do to help.

Take Survey

Also find us on our blog and discussion group:
http://googleadsdeveloper.blogspot.com/search/label/adwords_api
https://developers.google.com/adwords/api/community/

--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 adwor...@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscribe@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+unsubscribe@googlegroups.com.
Visit this group at https://groups.google.com/group/adwords-api.
To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/b92df0c0-02d0-4451-9b30-5df93b46f142%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Mat]

Hi Dave,

thx for the quick response.

However, I was referring to this topic:

https://developers.google.com/adwords/api/docs/guides/reporting?hl=de#special_criterion_ids

Do these special keyword ids (3000000, 3000006) still have to be taken into account when using the Google Ads API?

Regards

Mat

[David Antunes]

Hi,

I have the same question, is there any update on this?

Many thanks,

David

[Google Ads API Forum Advisor]

Hi David,

Developers have reported that ad_group_criterion.criterion_id of 3000000 3000006 do not get reported in keyword_view, although we have no documentation. 

Google Ads API no longer supports special IDs. Instead, you will find data split up in the corresponding reports. So there's no good way to replicate the values returned by the special IDs in the new UI. E.g. the equivalent data for keyword ID = 3000000 is on the display_keyword_view report. '3000006' is no longer available.

Let me raise this with my team to be certain, we will get back to you a soon as possible.

Regards,

Aryeh Baker Google Ads API Team

ref:_00D1U1174p._5004Q2Ll7WZ:ref

[Google Ads API Forum Advisor]

Hi David,

As per feedback from the rest of our team, the Google Ads API doesn't support "single attribution reports" anymore, so these special IDs are no longer relevant. I hope this helps.

Best regards,

Peter Laurence Napa Oliquino Google Ads API Team

ref:_00D1U1174p._5004Q2Ll7WZ:ref

[David Antunes]

Thank you very much Peter and Aryeh for the answers.

Kind regards,

David