Not able to get REMOVED KEYWORDS

[Vijaysinh Parmar]

Hello,

My Adwords Customer ID : 1255040287

I am trying to get removed keywords using the following queries but I am not get any results.

ad_group_criterion (Not getting any results

SELECT ad_group_criterion.keyword.text FROM
ad_group_criterion WHERE ad_group_criterion.status IN(REMOVED,UNKNOWN)

keyword_view(Not getting any results)

SELECT ad_group_criterion.type,ad_group_criterion.status,
ad_group_criterion.keyword.text FROM
keyword_view where ad_group_criterion.status IN(REMOVED,UNKNOWN)

Could you please help how to get data for removed keywords?

also I am not getting zero impression data datewise using bellow query even I am passing condition for impressions>=0 

SELECT campaign.name,metrics.impressions,segments.date FROM campaign WHERE segments.date > '2021-01-01' AND segments.date < '2021-01-20' and metrics.impressions >= 0

please let me know if any way to get datewise data including zero impressions?  

[Google Ads API Forum Advisor Prod]

Hi Vijaysinh,

Thank you for posting your concern.

Upon investigating, I couldn't able to find any removed keywords in your accounts. This is the possible reason why the API report did not return any keywords in response.

However, if there are indeed keywords that have removed status but were not included in the report, please provide the following details via Reply privately to author option to investigate:

• Complete API request and response logs with request ID
• Id of the removed keywords on this account

As for the second concern, I am afraid that the report will indeed not retrieve campaign with zero impression as the metrics.impressions >= 0 filter is included and this condition prevents the zero impression to show.

With this, I would suggest removing the segment fields in the report as entities with zero impressions are always excluded when segmenting a report according to this guide.

Regards,

Ernie John Blanca Tacata Google Ads API Team

ref:_00D1U1174p._5004Q2B3NX9:ref

[Vijaysinh Parmar]

24th Jan 2021 I have removed these keywords,

IDs: 10565830,10905171,11751241,11752491,12279811

Resource : customers/1255040287/adGroupCriteria/8513735736/{above_ids}

I have attached screenshot from changehistory. 

also, I want zero impressions data how to get it if adding metrics.impressions >= 0 will not give me zero impressions data?

Could you please share query to get zero impressions campaigns names with date?

Regards,
Vijaysinh Parmar,

Skype :: vijaysinh.p

+91-9033781187,8147992633