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 formats.” Then, run the “Daily Creative Delivery” report to get the same report we use in the video.
Excel is an extremely powerful tool to quickly analyze performance data. Anything that you can export as a report can be analyzed using Excel. While it’s not able to handle massive amounts of data (hundreds of thousands of entries), it can quickly generate an analysis report using several basic functions. You do not have to learn any programming.
I am going to post a 3-part Excel tutorial video series, starting with Part 1 today. Over the next couple of days the other parts will be posted. The tutorials will go over the basic functions you need to build a model that analyzes your ads. At the end of the tutorial, you would be left with a primitive version of iPyxel’s Campaign Viewer. You should have already received this tool when you subscribed to our mailing list, so the purpose of the tutorials isn’t to create something similar for your use but rather for you to learn the basic Excel functions that you can apply to any data analysis you want to do.
To accompany the tutorials, I have also prepared for you the workbook that I used in the video so you can follow along. The first two tabs in blue are example raw reports that you can practice with. The tabs in green are the completed tabs that you can refer to should you get stuck. Please don’t hesitate to ask any Excel question you may have in the comments section.
Download the Follow Along Workbook Now | 87.9 KB
Mastered Part 1? Go to Part 2 now!