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.

How to Drive Calls that Actually Convert

Our experts are here to explain how gaining call tracking data can help you close the gap in your customer journey and tailor their experience so they actually convert.

Analyzing the AdWords Distance Report

The distance report provides a unique view of your geographic data. The report helps users understand how distance from a location impacts search ad performance.

How to Master Attribution for Easy Budget Planning

In this webinar, Hanapin’s Cassie Oumedian and Google’s Julia Meter will provide tips on using AdWords attribution to directionally decide where you should allocate your budget, and how you can use the changing industry to your advantage.