golocal - 12:01 am on Jun 5, 2009 (gmt 0)
Since you originally brought it up, I have been simplifying the spreadsheet I sent you. Basically I started from scratch.
Reason: I used to work for an engineering company. Engineers think like engineers, Google has a lot of engineers.
The CTR and eCPM numbers remind me of me, a non-engineer working with a bunch of engineers.
Frequencies and Ratios make perfect sense in their world. To a business man it can be considered jiberish. Bottom Line is what we understand. Am I making improvements over Last Year, Last Month,last week etc.
If I am making improvements then I should be making more revenue etc.
I guess what I am looking for is some sort of a macro that can be run from within Excel that will open up the downloaded Google CSV file and import the into a sheet, and perhaps break it out into separate columns by day. Or more.
My new sheet does that except for the CSV Macro,
You sill have to copy and paste from the CSV to Excel.
I will send you the new one tomorrow.