Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Exclude "Total" row in Google AdWords performance report

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?

like image 982
mbreske Avatar asked Dec 19 '12 19:12

mbreske


People also ask

How do I automate a Google ad report?

To create automated Adwords reports in analytics just go to an Adwords based report like Paid Keywords Report or any of the Adwords tab reports. Once you see the data you want to send to your clients, click the share button at the top of the Google Analytics page.

What is segments in Google ads?

A category (like ad type or day of the week) that you can add to your campaign's tables and charts in order to organize your performance data around that criteria.


3 Answers

For php users that uses googleads-php-lib:

$reportUtils = new ReportUtils();
$report = $reportUtils->DownloadReport($reportDefinition, null, $user, array('skipReportSummary'=>true));
like image 199
AndreyP Avatar answered Oct 02 '22 22:10

AndreyP


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.

like image 37
Ewan Heming Avatar answered Oct 03 '22 22:10

Ewan Heming


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)
like image 39
eshwar Avatar answered Oct 03 '22 22:10

eshwar