Take the Pain Out of Weekly SEM Reports With This Template

Published: October 17, 2013

Author: Jay Stampfl

SEMs all know the importance of weekly reports — and we know that the nuances of performance changes and layered metrics aren’t so easily depicted. Pivot tables work, but they’re clunky; graphs look good, but they’re not always practical. Until now.

There are a number of ways to produce better-looking reports that do not sacrifice the flexibility to dig into the metrics. I have attached a completely free tool that is going to show how to create a graph that will dynamically show the values you want it to while not compromising presentation. It uses a pretty simple trick that leverages nestled vlookups to generate the desired information.
All you need to do is download this Dynamic Graph and save it as a template. Then go to AdWords and download a report with these columns. After that, just copy and paste your date in the report, and voila: you have a ready-made report that you can send out, play around with, and use to paint that pretty picture for that weekly status meeting.

Enjoy!