If you or a client operate several sites that utilize Adsense to improve monthly revenue then you may have struggled with the best way to present that information in your reports. The following approach is how our company organizes information for our clients, and it works well enough that we've adopted it for our own sites. We now actively look forward to the first of the month so that we can see how our sites have been performing.
Your clients are probably just like ours, they have the attention span of three-year olds. You can spend an hour on a perfectly worded email only to get a response back of "Sounds good". The truth is that your client relies on you not just for your expertise, but also for the convenience you provide them. You are a time-saver, and to that end you need to become an expert at condensing information into executive-sized bites that your client can consume on the go.
An executive report, done correctly, allows both you and your client to quickly assess the status of all their sites in one page. Our approach was to use Excel charts with 7-day and 30-day moving averages to quickly visualize the overall health of a single site or network of sites.
Collect and Organize the Data
You can download the data from Adsense in CSV form, a format that Excel can easily read. Underneath the "Advanced Reports" section of Adsense select the appropriate channels that you want to report on and download the CSV file.
If you'd like to see how we quickly arrange the data I recommend downloading this sample report.
Identify Your Weaknesses
Assuming that you have more than one site to track you undoubtedly have a site that performs considerably better than the others. What you need to watch for are the sites that have revenue drop off sharply, or don't at the very least pay for themselves every month. If you have a site that is costing you money three or more months in a row, you need to strongly consider dropping it entirely.
There's no end to the type of reports that you can create with the data that Google provides. Using this approach you could create a report based on ad size, position or even click-through percentage. Track changes to the sites so that you're able to attribute revenue fluctuations to specific events. Site redesigns, layout changes or ad placement adjustments are all worth noting. This will keep you sane as you try explain to your client why their site about animated gifs just isn't doing as well as it used to.