Sunday, March 16, 2008
Analyze Google AdSense Data Using Pivot Tables
Webmasters who use Google’s AdSense service to place ads on their site know that the analytical tools that AdSense supplies are pretty weak. Fortunately, it is easy to get report data from the site and into Excel where we can use all of the analytical tools that Excel provides. The purpose of this post is to demonstrate how webmasters can use PivotTables to analyze AdSense data. There are many reports that you can create in AdSense, and they are all candidates for analysis within Excel, but I will be demonstrating how to use pivot tables to analyze the "This month, by day" report that is
Posted by Tim on 03/16 at 02:59 AM in
AdSense
in
Dates
in
Excel
in
Excel 2007
in
Functions
in
Date Functions
in
Day
in
Month
in
WeekDay
in
Year
in
RoundUp
in
VLookUp
in
PivotTables
in
Table
Comments (1) • Permalink • Tell-a-Friend
Comments (1) • Permalink • Tell-a-Friend
Page 1 of 1 pages
