Consolidate Data from Multiple Reports Quickly Using Pivot Tables

In a previous Excel tutorial on pivot tables, I showed you how you can easily analyze data when you have one large complicated table. What if, however, you had 2 tables? As marketers, we work with multiple networks, tracking platforms, … Read More

Fast Mobile Data Analysis via Excel Pivot Tables

The name “Pivot Table” somehow makes it sound like it’s some advanced gizmo only reserved for the Excel wizards.  It’s actually quite the opposite.  It’s an easy, fast, yet powerful, way for marketers who are not familiar with Excel to … Read More

Excel Tutorial Series (Part 3): Filtering Unique Entries and Combining Reports

This is the 3rd and final part of this Excel tutorial series. If you haven’t watched the previous 2 parts, please go watch those first: Part 1 and Part 2.  Remember to download the Follow Along Workbook to follow along … Read More

Excel Tutorial Series (Part 2): INDEX, MATCH, and Error Handling

If you haven’t watched Part 1 of the Excel tutorial series, please go and watch that first.  Remember to download the Follow Along Workbook to follow along with the video. If you’ve already completed Part 1, use the same file … Read More

Excel Tutorial Series (Part 1): Manipulating Tracking Codes

Update: Since POF added new reporting formats, you must be sure to use the old reporting format, which we use in the tutorial. After going to the “Run Report” page, you must click on “Click here to see previous reporting … Read More