Negative Keywords date added

[Mihai Iliescu]

Hello

I'm trying to get the negative keywords that were added in the last 90 days at campaign/adgroup level. 

This is what I tried :

1. Tried with CAMPAIGN_NEGATIVE_KEYWORDS_PERFORMANCE_REPORT but it's not possible (no daterange segment is available).

2. Downloaded the KEYWORDS_PERFORMANCE_REPORT with IsNegative->true condition on the last 90 days, but it shows all negative keywords, not taking the date range into account..

3. Also tried to look at the account change history via CustomerSyncSelector but there is no info on negative keywords (only removed keywords).

Does anyone know a solution for this ?

[Bharani Cherukuri (AdWords API Team)]

Hello Mihai, 

You could use the Keywords Performance Report by setting the IsNegative to true. Please note that Date is a segment field and segmenting this by Date, will automatically segment the rows by day on which statistics such as impressions and clicks were generated. Please note that this report will not return the keywords for the last 90 days. 

On the other hand, the CustomerSyncService will return the changes entities within the last 90 days. This service will only return the changedCriteria and removedCriteria IDs. It is currently not possible to pull the negative criteria using this. Let me know if you have any other questions.

Thanks,

Bharani, AdWords API Team

[Mihai Iliescu]

Hello Bharani,

I pulled the data from the  Keywords Performance Report using IsNegative and Date. 

Then I tried adding the column Impressions, but i got thousands of rows all with value 0 for impressions.

The idea was that if there is a row with impressions >0 it would mean that it was added in the specified daterange, but they all come back zero.

Also if there were negative keywords added before they had an impression, this approach would not work.

I understand that this report shows all the data it has on Keywords from a specific date range, segmented by day, but I don't know how this data could be used to determine the number of keywords added in the last X days.

Thanks,

Mihai

[Bharani Cherukuri (AdWords API Team)]

Hello Mihai,

If you set the includeZeroImpressions field to true, this will include all the keywords that have zero impressions. If you're looking to get the keywords that have impressions greater than zero, you will have to make sure that includeZeroImpressions field is set to false. It is currently not possible to pull the negative keywords that were added for a specific date range. To pull only the negative keywords irrespective of the date range, you could also try using the Campaign Negative Keywords Performance Report. 

Let me know if you have any other questions. 

Regards,

Bharani, AdWords API Team

[Mihai Iliescu]

Hello Bharani,

I'm trying to get the number of negative keywords added in the last 90 days. I don't need the actual keywords, just how many they are.

Pulling the Keywords Performance Report using IsNegative and Date, and includeZeroImpressions set to false returns an empty report, although I know there are negative keywords added in the last 30 days in that account.

Wordstream's audit tools appears to be able to pull this data, but I don't know how.

https://cl.ly/1H2a2h0U1h47

Thanks,

Mihai

[Bharani Cherukuri (AdWords API Team)]

Hello Mihai, 

Through the API, it is currently not possible to pull the negative keywords list for last 90 days. Please note that Date is a segment field and segmenting the API reports by Date, will automatically segment the rows by day on which statistics such as impressions and clicks were generated. It is not possible to identify the keywords that were added during a date range using the reports. As negative keywords do not have any stats, checking for impressions > 0 also will not be helpful. 

On the other hand, you will be able to use CampaignCriterionService.get() to pull the NegativeCampaignCriterion attributes for the negative keywords. Please note that service does not let you filter the keywords added during a date range or within specified days. You could try to log the creation date at your end when you create a new keyword. That way, you will be able to get the list of keywords which were added in a given duration. To get additional details or stats for those keywords, you could later use the AdWords API reports or services. 

We will not be able to comment on how Wordstream is pulling this data. You will have to check with their support team regarding this.

Thanks,

Bharani, AdWords API Team

On Friday, August 3, 2018 at 7:27:46 AM UTC-4, Mihai Iliescu wrote: