3Ds Script Section

[Xavier_3D]

Get AdSense Stats on your Site.

1. Login to adsense and click on "advanced reports". Create channels if you don't have any yet, because this script shows stats for separate channels.
2. This part might be the most complicated, but still very easy. "View source" for the page and search for select name="reportId". Scroll further out on that row in the source and look for your channel names. You will find something similar to this Cholesterol-week . Write down the number and the name on a paper or somewhere. Do this for every channel you want to track.
3. Create a database and assign a user with a password for that.
4. Run this sql code: CREATE TABLE `adsense` (
   `id` int(11) NOT NULL auto_increment,
   `channel` varchar(50) NOT NULL,
   `reportedWhen` datetime NOT NULL,
   `impressions` int(11) NOT NULL,
   `clicks` int(11) NOT NULL,
   `rate` decimal(10,3) NOT NULL,
   `cpm` decimal(10,3) NOT NULL,
   `earnings` decimal(10,3) NOT NULL,
   PRIMARY KEY (`id`)
   )
5. Save the file you see in the blue box below as adsense.php or similar. Look at the first lines where you need to fill in your details. Both for your adsense account and your db details.
6. In the file you need to enter all channelId's and channelNames in the array. Just increase that array if you have more channels!

[st1905]

Ohh thats an awesome information, thanks a lot.

[thegrrl]

omg all these are advance and I'd be so lost. But i think a lot of other more advanced people would be happy to see this.