facebookIcon tracking


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.
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.

1 S Wacker Drive
Suite 2250

Chicago, IL 60606(650) 539-4124


Want to become a client?

Contact Us decorative arrow

Want to join the team?

View Our Openings decorative arrow

Find us on social media.

Press inquiries.

Email Us decorative arrow

Expert insights for your inbox. Subscribe to our content.

Accept No Limits.

Learn more about 3Q/DEPT READ MORE