SitePoint Sponsor

User Tag List

Page 1 of 5 12345 LastLast
Results 1 to 25 of 123
  1. #1
    Follow Me On Twitter: @djg gold trophysilver trophybronze trophy Dan Grossman's Avatar
    Join Date
    Aug 2000
    Location
    Philadephia, PA
    Posts
    20,578
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Release of an adsense tracking script (free)

    I've released an adsense tracking script at http://www.adsensetracker.info.

    It is free to use on any site, personal or commercial, with PHP and mySQL access. It enables you to analyze the performance of AdSense on multiple websites down to the per-advertiser level -- you'll know which sites, sections of sites, ad styles/sizes, and even individual pages are performing best over any time range. All you need to do is set up this set of PHP scripts and insert the javascript code it provides below your adsense code.

    Since the javascript does not modify the adsense code in any way, it's been given the OK by "AdSense Advisor" on WMW, and since it's hosted on your site, there should be no conflict with any of Google's terms.

    Enjoy!
    Last edited by Dan Grossman; Mar 3, 2004 at 15:14.

  2. #2
    l 0 l silver trophybronze trophy lo0ol's Avatar
    Join Date
    Aug 2002
    Location
    Palo Alto
    Posts
    5,329
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Nice work, Dan. The backend looks rather pretty. I actually don't think I'll download it (I don't have too much need for it right now), but I'm sure plenty of people will love it. I'll probably download it eventually.

    I was going to mention your "live stats" migth be against TOS, but perhaps not:

    Quote Originally Posted by Google TOS
    It does not include information that has become publicly known through no breach by You or Google, or information that has been (i) independently developed without access to Google Confidential Information

  3. #3
    Follow Me On Twitter: @djg gold trophysilver trophybronze trophy Dan Grossman's Avatar
    Join Date
    Aug 2000
    Location
    Philadephia, PA
    Posts
    20,578
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    It's not my adsense ads running on the page, they're the adsense test ads (client=ca-test/adtest=on), not my account. I don't profit off any test clicks you make on the site.

  4. #4
    l 0 l silver trophybronze trophy lo0ol's Avatar
    Join Date
    Aug 2002
    Location
    Palo Alto
    Posts
    5,329
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Ah, I guess I never looked closely at 'em, I see now though.

  5. #5
    SitePoint Enthusiast
    Join Date
    Nov 2003
    Location
    DK
    Posts
    51
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thank you Dan for this great tool.

  6. #6
    Follow Me On Twitter: @djg gold trophysilver trophybronze trophy Dan Grossman's Avatar
    Join Date
    Aug 2000
    Location
    Philadephia, PA
    Posts
    20,578
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by ToddW
    Dan in the JS it points to - tracker.php
    However there is no tracker.php int he downloaded file??
    I re-uploaded the zip file incase an older copy was there somehow.

  7. #7
    SitePoint Addict
    Join Date
    Jan 2004
    Location
    Madrid, Spain
    Posts
    257
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    It looks great but adsense works way too good for me. So I won't risk it. Good job Dan! I'm just a little bit precaucious.

  8. #8
    Follow Me On Twitter: @djg gold trophysilver trophybronze trophy Dan Grossman's Avatar
    Join Date
    Aug 2000
    Location
    Philadephia, PA
    Posts
    20,578
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    AdSense Advisor who works for Google gave the javascript that makes it work the OK:

    I think that the initial request has been buried behind all these great improvements to the code, but I wanted to confirm that this concept is indeed in line with the Terms and Conditions. I would suggest that, if you're passing your confidential information to a third party for logging, you make sure to use due diligence in selecting and trusting such a party.

    This forum really is a great place for cooperation and information transfer!

    ASA.
    The part about the third party doesn't apply here, as I've made the source code available so you run this on your own site; it's not hosted or logged by myself.

  9. #9
    SitePoint Wizard davidjmedlock's Avatar
    Join Date
    Dec 2002
    Location
    Nashville, TN USA
    Posts
    1,688
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    That wouldn't help his post count, now would it Dan?

    PHP Code:
      $postcount++; 

  10. #10
    Serial Site Creator ToddW's Avatar
    Join Date
    Feb 2004
    Posts
    791
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by davidjmedlock
    That wouldn't help his post count, now would it Dan?

    PHP Code:
      $postcount++; 
    ? Whatever, I deleted all 3, no big deal to me.

    Dan, script is working awesome! I plan to hax0r it up and add some nice reporting features.. I`ll keep ya`ll updated for the mod-releases.

    Awesome script dude!

  11. #11
    Follow Me On Twitter: @djg gold trophysilver trophybronze trophy Dan Grossman's Avatar
    Join Date
    Aug 2000
    Location
    Philadephia, PA
    Posts
    20,578
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    If you write your updates so that it continues to work for all sites, I can update the download on adsensetracker.info as necessary Up to you.

  12. #12
    SitePoint Wizard davidjmedlock's Avatar
    Join Date
    Dec 2002
    Location
    Nashville, TN USA
    Posts
    1,688
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by ToddW
    ? Whatever, I deleted all 3, no big deal to me.

    Dan, script is working awesome! I plan to hax0r it up and add some nice reporting features.. I`ll keep ya`ll updated for the mod-releases.

    Awesome script dude!
    I'm just messing with ya, Todd.

  13. #13
    chown linux:users\ /world Hartmann's Avatar
    Join Date
    Aug 2000
    Location
    Houston, TX, USA
    Posts
    6,455
    Mentioned
    11 Post(s)
    Tagged
    0 Thread(s)
    Looks like a very promising script! Great work!

    The JavaScript is extremely nifty!!!!

  14. #14
    Follow Me On Twitter: @djg gold trophysilver trophybronze trophy Dan Grossman's Avatar
    Join Date
    Aug 2000
    Location
    Philadephia, PA
    Posts
    20,578
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Just got around to installing it on my own network of sites. Now I'll actually know if the leaderboard on top or bottom of my page is more effective.

  15. #15
    SitePoint Member
    Join Date
    Mar 2003
    Location
    Stockholm
    Posts
    23
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks Dan, you really put meaning to the phrase "Dan The Man" - excellent work =)

    Thanks a bunch.
    OcPrices.com - Computer hardware and gaming reviews and news
    PlanetPrices UK - Computer hardware price comparisons in the UK
    LensIndex.com - Your source for the lowest priced contact lenses

  16. #16
    SitePoint Enthusiast
    Join Date
    Nov 2003
    Location
    DK
    Posts
    51
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Nice mod.

    After 30 minutes my pages list was over 1000.
    :-(

    Anyway, works like a charm.

  17. #17
    Serial Site Creator ToddW's Avatar
    Join Date
    Feb 2004
    Posts
    791
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by xper
    Nice mod.

    After 30 minutes my pages list was over 1000.
    :-(

    Anyway, works like a charm.
    Yeah, I decided to hold-off rom using the code on my other sites until I get the mod working 100%..

  18. #18
    Unauthorized Web Theologian emmzee's Avatar
    Join Date
    Jan 2004
    Location
    Mississauga, Ontario, Canada
    Posts
    738
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Wow this looks like a great tool! A big thanks goes to Dan for releasing this ... and also to ToddW when that hack is released

    One caution, just in case anyone is using this without passwording it, using a htaccess file or something to protect your stats would be an excellent idea

  19. #19
    Serial Site Creator ToddW's Avatar
    Join Date
    Feb 2004
    Posts
    791
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    If a couple people would test that and let me know that it's working for them that'd be great... Don't forget to modify your Table if you don't it wont work..

  20. #20
    Follow Me On Twitter: @djg gold trophysilver trophybronze trophy Dan Grossman's Avatar
    Join Date
    Aug 2000
    Location
    Philadephia, PA
    Posts
    20,578
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    I'll be editing this to only show information for the time period specified like the rest of the reports, and integrate it into reports.php with some other updates and update the site. Thanks for the idea.

  21. #21
    Serial Site Creator ToddW's Avatar
    Join Date
    Feb 2004
    Posts
    791
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Ok, guys new release soon that requires less mods, and requires no 'fresh' start.

    Gimme a lil time.

  22. #22
    Follow Me On Twitter: @djg gold trophysilver trophybronze trophy Dan Grossman's Avatar
    Join Date
    Aug 2000
    Location
    Philadephia, PA
    Posts
    20,578
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Adsensetracker.info has been updated with a new version of the script that only shows page details for the specific site clicked (in the timeperiod selected). It also adds a menu for which data to view.

    The live sample shows the new code.

  23. #23
    Serial Site Creator ToddW's Avatar
    Join Date
    Feb 2004
    Posts
    791
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Jeee Thanks For Tellen Me

    LOL

    A lot easier when you know all the code 100% and how it works, i was re-working it to use your tracker table and eliminate the need for any more columns.. looks like ya beat me to it.

  24. #24
    Follow Me On Twitter: @djg gold trophysilver trophybronze trophy Dan Grossman's Avatar
    Join Date
    Aug 2000
    Location
    Philadephia, PA
    Posts
    20,578
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    It does require the new column. There's no 100% reliable way to determine what site a page is from without adding another column somewhere.

  25. #25
    Serial Site Creator ToddW's Avatar
    Join Date
    Feb 2004
    Posts
    791
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by Dan Grossman
    It does require the new column. There's no 100% reliable way to determine what site a page is from without adding another column somewhere.
    Using your tracker table you wouldn't need a new column.
    You could use the tracker table which has the PageID, and shows if the ad was clicked on that page or not. Then you just grab all entrys from tracker table, which also have the PageID, made a lil function to convert page_id into the URL, shows all URLS for SiteID, and then shows which were clicked, thus not needing another column.

    Or is something wrong wtiht hat?


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •