Step-By-Step Excel Reporting - A Video Tutorial

By Jacob Brown | @jakebrownppc | Account Manager 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.

Smart Ways to Get More Marketing Budget and Better Tools

In this new live webinar, Kristin Vick from Hanapin Marketing and Jeff Sauer from Jeffalytics discuss how marketers can ensure they have the budget they need to be effective with online advertising and get the right tools to make that argument.

The Hero Conf Difference

Of the 50+ search and social conferences you can choose from, we're here to show you why Hero Conf is a can't miss event for busy digital marketers like you.

A 180 of Google Analytics 360

The enterprise version of Google Analytics offers several paid search perks including, advanced data integrity, integrations and reporting.