Forum Moderators: buckworks & skibum

Message Too Old, No Replies

Adwords custom report tool

Adwords custom report tool

         

Jack03

9:41 am on Apr 23, 2010 (gmt 0)

10+ Year Member



We're a professional agency managing Google Adword's campaigns for our clients. We have developed a campaign report in Excel that shows our clients how their campaign is structured in an easy-to-read format.

The problem we have is that we have to cut-and-paste this entire report and it takes several hours to compile for each client. We need a solution that taps the Google Adwords API for the information we need and puts that information into a ready-to-deliver to the client Excel/web based/ format.

Maybe is not even necessary to use the Google Api if there is a way to convert the .csv, XML or HTML to a good report. We also want each page of the report to contain our logo and the logo of the client.

Does anyone have a suggestion?

JavaCofe

2:38 pm on Apr 29, 2010 (gmt 0)

10+ Year Member



pivot tables :) (or 'data pilots' if you use OpenOffice)

Lots and lots of varied granularity pivots... I have about 15 or so I use on a daily basis, but I would happily trade them for a indexable database since they can be very bloated with a long account history.