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?
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.
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.
For php users that uses googleads-php-lib:
$reportUtils = new ReportUtils();
$report = $reportUtils->DownloadReport($reportDefinition, null, $user, array('skipReportSummary'=>true));
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.
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)
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With