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, and traffic sources. They each generate their own reports. It’s always been a hassle to try to line up multiple reports. For those that are not familiar with Excel formulas, it can be pretty frustrating.
This tutorial will make that task a lot simpler. I show you, using POF and Prosper202 reports, how to quickly join the two reports so you can see the all the performance metrics by ad. This technique, of course, can be applied to any traffic source and, in reality, to any task that involved combing data tables.
If you haven’t checked out our previous Excel tutorials, I highly recommend you do so before beginning this one, at least the previous pivot table tutorial. As a marketer, I’ve found Excel to be an instrumental tool for data analysis. It’s a skill that will surely benefit you in the long run.
Without further ado, please enjoy the video!