How-to Create Pretty AdSense Earnings Graphs & Charts
Via webmaster world:
To create your own pretty charts, simply follow these quick instructions:
1) Download your CSV file from Google (its above every report you can make) I recommend taking the “All Time” report because if gives a larger sample size.
2) Open Microsoft Excel or a similar spreadsheet application. These instructions are really for Excel, but most spreadsheet packages are similar.
3) Open the CSV file in Excel, you’ll have a table of figures.
4) Delete only the column heading marked “Date” (for some reason this messes charts up) (don’t delete the entire column or you can’t tell what you’ve done over time!)
5) Delete the rows at the bottom of your sheet that indicate Totals. (otherwise you have a spike at the end of your graph which makes everything else hard to interpret)
6) Highlight column A (should be date) and highlight column B (most likely to be Page impressions) and go to Insert > Chart. Go through the wizard (its really simple) looking at the lovely charts you can make. Settle on the first bog standard line graph. Next, Next, Next, until you hit the part that asks where you want to create it (in the current worksheet- no, or in a new worksheet- yes!) Click Finish and bang! Instant charts.
7) Now repeat for A+C, A+D, A+E and A+F.
Save to disk, then print. Analyse, marvel and plot for world domination.
9) Profit! (okay, I had to do that).
Comments
4 Responses to “How-to Create Pretty AdSense Earnings Graphs & Charts”
Leave a Reply
I couldn’t see a direct contact address, but I’ve recently started writing a a graph generator and was wondering if you would like to beta test it and if you like it recommend it.
http://www.big-llc.com/adsensereport/
Cheers,
Marc
Marc, if you’re serious about people logging in with their information, that’s just flat out wrong. You’re basically just stealing everyone’s login information. I would be interested in an excel doc that would allow me to import data and it do all the work for me though, that would be a good resource.
[...] Feedmoney recently posted a nice and simple way to create those graphs and charts with ease using Microsoft Excel. I tried it out and it works very well. It gives you a detailed view of how your earnings, CTR, CPM have progressed with time. [...]
[...] Feedmoney recently posted a nice and simple way to create those graphs and charts with ease using Microsoft Excel. I tried it out and it works very well. It gives you a detailed view of how your earnings, CTR, CPM have progressed with time. [...]