Step-By-Step Excel Reporting - A Video Tutorial

By Jacob Brown | @jakebrownppc | Sr. Account Analyst at Hanapin Marketing |

The video below explains the step-by-step on how to go about reporting in Excel. This process works if your account is structured in an organized manner at campaign level. For example: Location_Program campaign level structuring.

Before watching the video download, check out campaign level statistics with a filter on impressions as seen below:

Filtered Report

Once you have this data ready to go you can delete the top row (date range row), and the totals listed at the bottom of the Excel sheet. Then, you can proceed.

Is your account not yet organized in this manner? This article explains how you can structure campaigns is this manner by utilizing Excel.

The Latest PPC Updates to Catapult Campaigns in 2019

In this webinar, Hanapin’s Kelly Pollock and Optmyzr’s Fred Vallaeys will point out which updates have made (and will make) a major impact on digital marketers, and what we should be preparing ourselves for as we fly into 2019.

Top Tips for Building Your Digital Marketing Team

While hiring is only one part of building your team, hiring the right candidates to add to your team is a vital step in building a high performing team. Molly Nagy, Senior HR Coordinator, talks about her experience working with hiring managers within and outside...


Enter your email address below.