Exclude "Total" row in Google AdWords performance report

6
votes

I am downloading Ad Performance reports (in CSV format) using the .NET client library for Google AdWords API v201209.

The final row of data in every report I download is an aggregate row. An example looks like:

Total, --, --, --, --, --, --, --, --, --,2.6, --, --, --,516,13,16

I do not need the aggregate data. Currently I'm stuck having to write code to remove it manually or deal with skipping this row during parsing.

Is there a way to exclude this row from being included in the downloaded report?

4
google-ads-api

4 Answers

2
votes

For php users that uses googleads-php-lib: 

$reportUtils = new ReportUtils();
$report = $reportUtils->DownloadReport($reportDefinition, null, $user, array('skipReportSummary'=>true));
1
votes

Not possible at the moment, I'm afraid. I usually request a numeric field at the beginning of each row, so I can filter out rows that I don't want; this also works for the header rows, which can't be removed either.

1
votes

I use version 201509. You can suppress Totals as well as Report Header and Column Headers in report_downloader parameters

report_downloader.DownloadReport(
report, outputfile, 
skip_report_header=True,
skip_column_header=False,
skip_report_summary=True, 
include_zero_impressions=False)
0
votes

As of now, you can set an HTTP header:

skipReportSummary: true|false | If true, report output 
                                will not include a summary 
                                row containing the report 
                                totals. If false or not  
                                specified, report output
                                will include the summary row.