Example Dashboard shows 12 month trend for all Adwords Metrics available in Google Analytics in an Excel spreadsheet

How effective is your Adwords spend?

Get a complete 12 month overview of everything that happened relating to Adwords. This easily customizable Dashboard runs inside Excel and is free for users of NEXT Analytics. Just download it, and one click later, you’ll know how well your pay per click campaigns are doing.

Download it

Download this free Excel Spreadsheet

Customize It

It’s a simple Excel spreadsheet, so it’s easy to change. Don’t like the look of the charts — Change Them! Add your company logo, add some new titles, go for it.

If you want to change the data being reported, that’s easy too:

Open the worksheet named “nextv54plus_actions”.

Change the year and month to a 12 month range that suits your reporting needs in cell B4. For example, pasted the following to cell B4 to change the report to show June 2014 to June 2015:

Prompt,add,
[DATE-ORDERING],201406~201407~201408~201409~201410~201411~201412~201501~201502~201503~201504~201505

Change the Segment by modifying cell B5. Remove the gaid:-1 and put in your desired segment value.

Change the Profile either by modifying your default value (in the Subscription dialog box, the Data Access tab). Or you can lock this spreadsheet to a specific profile ID value by entering one after the last comma in cell B6.

 

Questions?

Post your questions on our Support Page. It’s fast and easy, and you’ll know everything you need to know.

2017-02-12T13:05:56-04:00