Take the Pain Out of Weekly SEM Reports With This Template

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.

Screen Shot 2013-09-27 at 11.56.55 AM

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.

Categories

Enjoy!

Jay Stampfl -Jay Stampfl, who joined 3Q Digital in January 2013, originally started working in performance display in 2007 with adBrite. In 2010, he continued his digital marketing career with the French-owned search agency eSearchVision, where he managed some of the most recognizable brands in America. Jay has a background in Evolutionary Biology research and received a degree in Biological Anthropology from UC Berkeley.