This is the subhead for the blog post
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!
One Response to Take the Pain Out of Weekly SEM Reports With This Template