AdWords Report Tool Instruction

Introduction

The AdWords Report Tool is designed to make it easier to produce an AdWords report in a standard format.

The report format is so simple that I think it is inadaquete to send to a client on its own. However I think it provides an excellent summary report in a clear and concise fashion.

There is currently pretty much nothing that you can customise about the report layout. I might work on this in the future.

Privacy

The URI of the report is a sha1 hash of the reports contents; people will not be able to guess what your report is called unless they know the data in it. If they do know the URI then they will be able to access it for a maximum of 30 minutes after you ran the report. After 30 minutes the file will be deleted.

The directory in which the reports are contained is not viewable.

You have no guarantee (other than my word) that I won’t look at any reports stored on my server. If anyone know a good way to prevent me from doing this please let me know.

Output

See the sample report output. Sample out of date. Latest reports contain GRAPHS

The report has a title, two tables and a summary. There is nothing you can do to change this at the moment.

Limited customisations may be possible by using inline HTML. You can try and use HTML to change the color or font which will work for the HTML preview but might not work in the pdf. The tool uses HTMLDoc to convert to a PDF and this does not support everything you might want.

I am looking into adding logos or other images into the final document.

Input

The report has seven input fields

1. Report Title

Enter a title for your report that will appear at the top of the first page.

2. Report Data

Paste an AdWords report into this field. The tool expects a tsv report with six columns. You can mess about with what is in the columns a little bit, but I recommend you stick with Month, Campaign, Impressions, Clicks, Cost and Conversions. I decided it would be easier to paste the whole of the report into the tool rather than just the data. If you just paste the data you might get an incomplete report or you might get an error.

3. Comma separated list of Campaigns to Exclude from Table 1 (will be included in Table 2)

Enter campaigns to exclude from table 1. The data from these campaigns will be included in table 2. I like to report on brand campaigns separately which is why I added this feature.

4. Title for Table 1

A title for the first table.

5. Include a 2nd Table?

Use this check box to decide if you want to include a 2nd table.

5. Title for Table 2

A title for the second table.

6. Commentary

Comment on the report in this field.

ToDo

• Add customisable logos to the report. 14th Oct: This is going to be more difficult than I thought.