Negative Keywords Report

[program...@ggmgastro.com]

Hello,

I just wanted to know if there´s a Negative Keyword report.

Unfortunately, the result from "CAMPAIGN_NEGATIVE_KEYWORDS_PERFORMANCE_REPORT" and "KEYWORDS_PERFORMANCE_REPORT" are not correct.  For some reasons, I will just retreive 2018 rows but we do have more negative keywords in just one adgroup.

CampaignNegativeKeywordsPerformanceReport - C#

ReportDefinition definition = new ReportDefinition

                {

                    reportName = "campaign negative report",

                    reportType = ReportDefinitionReportType.CAMPAIGN_NEGATIVE_KEYWORDS_PERFORMANCE_REPORT,

                    downloadFormat = DownloadFormat.CSV,

                    dateRangeType = range,    //ALL_TIME

                    selector = new Selector()

                    {

                        fields = new string[]

                        {

                            "AccountCurrencyCode",

                            "AccountDescriptiveName",

                            "AccountTimeZone",

                            "BaseCampaignId",

                            "CampaignId",

                            "CampaignName",

                            "CampaignStatus",

                            "Criteria",

                            "CustomerDescriptiveName",

                            "ExternalCustomerId",

                            "Id",

                            "IsNegative",

                            "KeywordMatchType"

                        },

                        //predicates = preds.ToArray()         //I´ve excluded every predicate to get the most results out of it

                    }

                };

                ReportUtilities utilities = new ReportUtilities(GoogleAdwords_Manager.Helper.Settings.SelectedAccount.User, "v201809", definition);

                using (ReportResponse response = utilities.GetResponse())

                {

                    using (StreamReader reader = new StreamReader(response.Stream))

                    {

                        var lines= reader.ReadToEnd().Split(Environment.NewLine.ToCharArray()); //returns a few lines :(

                    }

                }

Maybe there are some limitations?

For my current solution, I need to have all Negative Keywords from a campaign or an adgroup. 

Currently, I am using the getKeywords function which was shown in the tutorials, but the speed is really slow because it has to download each keywords page by page for an entire campaign.

Thanks in advance

[Zweitze]

From the top of my head, you can get negative keywords on group level by:

• Request KEYWORDS_PERFORMANCE_REPORT;
• Set IncludeZeroImpressions to true, because those negatives never get impressions(!);
• Add a predicate on field IsNegative, equalling value "true"
  

Note that you can't get negative keywords through this way. So if you need all negative keywords, on group level and on campaign level, you need two reports.

[Bharani Cherukuri (AdWords API Team)]

Hello, 

In addition to what Zweitze mentioned, here are some additional details: You may use the Keywords Performance Report with the selector field including the IsNegative field which will return if the keyword is negative. This report type will return all the keywords in the account with one row per keyword. Please find below the sample report query for this:

__rdquery: SELECT CampaignId,CampaignName, AdGroupId,Criteria, IsNegative FROM KEYWORDS_PERFORMANCE_REPORT WHERE IsNegative IN ["True"]

Please make sure that you set the includeZeroImpressions to true as negative keywords will not have any metrics. You will be able to pull the keywords filtering based on the specific Campaign or AdGroup. Can you give this a try and let me know if you have any other questions?

Regards,

Bharani, AdWords API Team

[program...@ggmgastro.com]

Thank you for your reply.

Unfortunately the reporting api returns an exception with the given error: "includeZeroImpressions is not supported for this request"

[Bharani Cherukuri (AdWords API Team)]

Hello, 

Could you share us the complete report definition so I can take a closer look? You can select the Reply privately to author option and share the details only with me to troubleshoot this.