1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

How To Monitor ROI On Each & Every keyword

Discussion in 'Adwords' started by sugarwillis, Jul 10, 2008.

  1. sugarwillis

    sugarwillis BANNED BANNED

    Joined:
    Apr 29, 2008
    Messages:
    147
    Likes Received:
    21
    Hi there people, finally its time for me to leap into paid advertising utilizing the passive income from videos and articles.

    Can someone please shed some light on the best methods for tracking ROI on each and every keyword from withing PPC campaigns.

    To date my income is generated using articles & to generate traffic to presale/review sites that sell clickbank products. I have been having a decent level of success with this so i think its time to jump into PPC campaigns & CPA.

    What are the most ideal methods everyone can think of for keeping and eye on your ROI @ Keyword level. I currently use TIDS in clickbank but this doesnt seem to enable me to track sales down to the keyword.... unless ofcoarse i made a unique TID for each and every keyword, which naturally will end up being a task and a half.

    Also another question, are tracking methods different depending on SE your using... ?

    Your Help is much appreciated.....
     
    Last edited: Jul 10, 2008
  2. goawayplease

    goawayplease Regular Member

    Joined:
    Apr 10, 2008
    Messages:
    299
    Likes Received:
    67
    Using Google Analytics, you can tag your links to track things like keyword, source, etc. This works with PPC, Mailing, Paid Links, Banner Ads, etc.

    PHP:
    http://www.google.com/support/googleanalytics/bin/answer.py?hl=en&answer=55578
    That tool will show you how to properly tag your links. Different engines have different shortcuts for the keyword, so you'll have to do a little more digging.

    Here are some other resources to check out:
    PHP:
    http://www.semvironment.com/nude-adwords-keyword-data-exposed-with-google-analytics/
    http://groups.google.com/group/adwords-help-basics/browse_thread/thread/c8e0c53fd8ca03de/
    http://www.roscripts.com/snippets/show/74
    http://www.tellinya.com/read/2007/07/11/34.html
     
    • Thanks Thanks x 1
  3. Lanx

    Lanx Regular Member

    Joined:
    Jan 15, 2008
    Messages:
    317
    Likes Received:
    93
    google analytics, xtreme conversions, those type of things, i personal don't use any keyword tracking software or solution, and i have thousands of campaigns, i do just make a report, through google editor(good download and free) and just track it through excel which they all do in the end.
     
  4. Cohen

    Cohen Newbie

    Joined:
    Jan 23, 2008
    Messages:
    31
    Likes Received:
    14
    I just started using ppc myself and I am using Xtr*eme Conv*ersons for tracking.

    This tracking software woks very well and you can download it from this forum.

    One added benefit of XC is that you can see the search term typed into the search engine before arriving at your landing page.
     
  5. oscarslater

    oscarslater Regular Member

    Joined:
    Mar 13, 2008
    Messages:
    401
    Likes Received:
    152
    get used to XC cause you can not only track at keyword level, but when it forwards the link the url has been appended to it so anyone 'spying' only sees that number but only you know what keyword it relates to.

    Also it now tracks sales and optins so there is no need to manipulate the data to find out what is working

    If you do really want to automate things, use it with speedPPC as well, integrates well.

    os....
     
  6. scubaslick

    scubaslick Regular Member

    Joined:
    Aug 23, 2007
    Messages:
    392
    Likes Received:
    512
    Actually just using good old excel isn't that hard. The problem is the number of characters allowed in the tracking ID with the network, and the number of tracking IDs they allow. But taking CB for example you can have up to x characters in your tracking number TID.

    Without getting into algebra, that gives you hundreds of thousands of possible keywords if you work it right. The trick is in assigning a unique code to a keyword.

    Piece of cake.

    Worksheet 1 col A: list of keywords. I do broad, empty row, exact, empty row, phrase if I'm using it at all.

    col b tracking code. I like to use a basic cypher. Something like this (and you can use this one exactly if you want; without the spreadsheet with the keyword list, it's just gibberish no matter what they do): possible 6 digit code.

    First letter represents search engine. So for example, A = google. The other 5 digits give me 1-99,999 words in my list. So col b would be a1, a2, a3 etc. each row therefore has a keyword and an ID unique to that keyword and traffic source.

    With a little creative use of pivot tables, you can download your stats from your network, cross reference the keywords responsible for sales, then backtrack to your adwords/adcenter etc interface and check your results.

    why do it this way instead of google analytics or some other 3rd party system?

    1) I don't want google or anybody else to have my conversion data. Fuck them. It's none of their business how my business runs.

    2) I don't want the networks having my keywords. Fuck them too. It's none of their business either.

    Don't forget to mask/redirect so your referrer strings from the search engines aren't passed to the networks.

    Hope that helps.
     
  7. MontyzPython

    MontyzPython BANNED BANNED

    Joined:
    Nov 3, 2007
    Messages:
    1,317
    Likes Received:
    315
    Holy cow, scubaslick is back from the dead!
     
  8. unknown_zero

    unknown_zero Jr. VIP Jr. VIP Premium Member

    Joined:
    May 15, 2008
    Messages:
    1,969
    Likes Received:
    574
  9. NOLEGSORBRAINS

    NOLEGSORBRAINS BANNED BANNED

    Joined:
    Feb 25, 2008
    Messages:
    7
    Likes Received:
    3
    Careful on prosper202 and tracking202.The owner of the site can see all your keywords.
     
  10. dashndash

    dashndash Jr. VIP Jr. VIP Premium Member

    Joined:
    Jan 18, 2008
    Messages:
    408
    Likes Received:
    70
    Location:
    Depends on the proxy



    Use STATCOUNTER.COM it is very good! And it is updated as soon as a visitor visits your page... It's really good to track all your pages and visitors... Give it a try if you want... :)
     
  11. BlackBeret

    BlackBeret Regular Member

    Joined:
    Jul 12, 2008
    Messages:
    257
    Likes Received:
    61
    Location:
    Transexual, Transylvania
    KE*YWORD*VIS*ION is a good program for auto generating trackable ClickBank TID's.
     
  12. unknown_zero

    unknown_zero Jr. VIP Jr. VIP Premium Member

    Joined:
    May 15, 2008
    Messages:
    1,969
    Likes Received:
    574
    True,
    if you are a volume marketer, then the best choice is to make your own tracking tools :cool:
     
  13. vinku

    vinku Regular Member

    Joined:
    Jan 22, 2008
    Messages:
    331
    Likes Received:
    1,054
    i m using prosper202 . how they can see our data as it's self hosted script.
     
  14. frostbyte

    frostbyte Registered Member

    Joined:
    Nov 7, 2007
    Messages:
    56
    Likes Received:
    19
    You are quite right there. Prosper202 is a clean script which is hosted on your own server, and the data collected stays only on your server.
     
  15. crizk

    crizk BANNED BANNED

    Joined:
    Oct 29, 2008
    Messages:
    48
    Likes Received:
    23
    True that... prosper202 is a great, free tool that does the job. Also check out Affiliate Prophet which is in the dl section.