KEYWORDS_PERFORMANCE_REPORT - full keyword list

[Paul Foltache]

Hi, 

I'm currently using adhoc KEYWORDS_PERFORMANCE_REPORT  to fetch keywords performace and it works great.

Now I want to get the full list of keywords. I tried to use the same report type without the columns that prevent 0 impressions results (ex: Date) and even if it seems to work I also get wrong (extra) keywords.

For example:

correct keywords returned: foot patch detox, foot pacht, patch anti tabac, patch detox

wrong keywords returned: pro evolution soccer 2010 patch, patch msn 7.5, pro evolution soccer 2006 patch, fifa 09 patch

I also tried with CRITERIA reports with CriteriaType set to KEYWORDS and still get extra keywords.

And this is how intended to get the full keyword list:

report_definition = {

            :selector => {

                :fields => ['Id', 'AdGroupId', 'KeywordMatchType', 'KeywordText', 'DestinationUrl', 'Status'],

                :predicates => {

                    :field => 'AdGroupId',

                    :operator => 'IN',

                    :values => @adgroups_ids,

                    :order! => [:field, :operator, :values]

                },

                :date_range => {

                    :min => from,

                    :max => to

                },

                :order! => [:fields, :predicates, :date_range]

            },

            :report_name => 'Custom KEYWORDS_PERFORMANCE_REPORT',

            :report_type => 'KEYWORDS_PERFORMANCE_REPORT',

            :download_format => 'CSV',

            :date_range_type => 'CUSTOM_DATE',

            :order! => [:selector, :report_name, :report_type, :date_range_type, :download_format]

        }

Any suggestion is appreciated, 

Paul 

[Paul Foltache]

I just found out that the extra keywords are negative keywords. They are returned also with AdGroupCriterionService.

The thing is that if I choosethe IsNegative column it prevents 0 impressions results from being returned.

Any idea how get the complete list of keywords (0 impressions inculded) without the negative keywords?

Paul

[Paul Foltache]

Gonna use AdGroupCriterionService. I can use :criterion_use or :ad_group_criterion_type or xsi:type in order to filter the results.

If anyone knows how to do this using adhoc reports, suggestions are welcome.

Hope someone finds this helpful,

Paul 

[Anash P. Oommen]

Hi Paul,

You could try using a Predicate in your report definition -  IsNegative EQUALS false.

Cheers,
Anash P. Oommen,

AdWords API Advisor.

[Paul Foltache]

Thank you Anash, 

I will try it and get back to you. Doesn't setting the IsNegative predicate limit the results same as asking it as a column?

In report definition it say for "Is Negative": prevents 0 impressions entries for being returned.

Anyway I'll test this.

Thank you

Paul