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

ROI Calculator For PPC vs SEO

Discussion in 'Offline Marketing' started by Dr_Scythe, Jul 22, 2011.

  1. Dr_Scythe

    Dr_Scythe Regular Member

    Joined:
    Jul 4, 2011
    Messages:
    281
    Likes Received:
    210
    Location:
    Australia
    I'm continuing the calculations of utterlyadrift25 from Takticals thread on page 15 (can't post links yet)

    Attached to this post is an Excel Speadsheet that automates the calculations from the post above. Unfortunately I'm not that experienced with making excel documents look all pretty and neat.

    The blue cells are input fields while the red cells are the outputs.

    This can be used to help convince potential offline clients of the benifits in conducting a proper SEO campaign even when PPC can produce faster results.

    If anyone has any recommendations for this spreadsheet or finds an error with the calculations please let me know.
     

    Attached Files:

    • Thanks Thanks x 42
  2. thedon23

    thedon23 Elite Member

    Joined:
    Dec 21, 2009
    Messages:
    1,759
    Likes Received:
    1,268
    Awesome bro! Appreciate it. Rep given.
     
  3. Dr_Scythe

    Dr_Scythe Regular Member

    Joined:
    Jul 4, 2011
    Messages:
    281
    Likes Received:
    210
    Location:
    Australia
    Thanks :)

    Let me know if you have any suggestions for improvements
     
  4. JakeD

    JakeD Newbie

    Joined:
    Mar 22, 2011
    Messages:
    31
    Likes Received:
    3
    Much easier to use than the original formula posted earlier. Thanks, man!
     
  5. utterlyadrift25

    utterlyadrift25 Junior Member

    Joined:
    May 13, 2010
    Messages:
    133
    Likes Received:
    106
    Occupation:
    Strategy Director by day. Internet Shark by night.
    Location:
    London, UK
    Good job Dr_scythe. The only thing is that remember that CTR is not always 0.1 and conversion rate is not always 0.12. So when calculating for a client be sure to work out what the proper ones if you have the data available.
     
  6. alman

    alman Jr. VIP Jr. VIP

    Joined:
    Feb 23, 2011
    Messages:
    1,327
    Likes Received:
    389
    Occupation:
    Crorkservice.com
    Location:
    Crorkservice.com
    Thanks bro! Rep. to you
     
  7. utterlyadrift25

    utterlyadrift25 Junior Member

    Joined:
    May 13, 2010
    Messages:
    133
    Likes Received:
    106
    Occupation:
    Strategy Director by day. Internet Shark by night.
    Location:
    London, UK
    Why have I been neg rep'd when Dr_Scythe has used my own calculation in his Excel sheet? Isn't that a little ridiculous?
     
    • Thanks Thanks x 4
  8. Dr_Scythe

    Dr_Scythe Regular Member

    Joined:
    Jul 4, 2011
    Messages:
    281
    Likes Received:
    210
    Location:
    Australia
    Yea I put the CR and CTR as global parameters that are changeable based on the client.
     
  9. Taktical

    Taktical Elite Member

    Joined:
    May 15, 2011
    Messages:
    1,657
    Likes Received:
    3,254
    Occupation:
    Jr.Executive VIP
    Location:
    USA
    Rep Given :)
     
    • Thanks Thanks x 1
  10. kiits

    kiits Newbie

    Joined:
    Jul 13, 2011
    Messages:
    4
    Likes Received:
    0
    Woo hoo! Thanks/rep given.
     
  11. albaniax

    albaniax Elite Member

    Joined:
    Aug 5, 2008
    Messages:
    1,593
    Likes Received:
    823
    Location:
    GER - ALB
    You saved me a few hours of time =)
     
  12. H2oBoy

    H2oBoy Regular Member

    Joined:
    Mar 26, 2009
    Messages:
    211
    Likes Received:
    421
    Occupation:
    Internet Marketer
    Location:
    Pacific Northwest
    Last edited: Jul 24, 2011
  13. Dr_Scythe

    Dr_Scythe Regular Member

    Joined:
    Jul 4, 2011
    Messages:
    281
    Likes Received:
    210
    Location:
    Australia
    The only functionality that should have been lost by opening in 2003 should be the coloured cells.

    You should still be able to use the mathematical components of the spreadsheet by changing the values in the global parameters and the individual parameters for PPC and SEO at the top of each sections. The bottom numbers should adjust accordingly.

    The colours were just there to help identify inputs from outputs...
     
  14. H2oBoy

    H2oBoy Regular Member

    Joined:
    Mar 26, 2009
    Messages:
    211
    Likes Received:
    421
    Occupation:
    Internet Marketer
    Location:
    Pacific Northwest
    Sweet!

    Guess all is good to go then!

    Thanks for the response!
     
    • Thanks Thanks x 1
  15. Dr_Scythe

    Dr_Scythe Regular Member

    Joined:
    Jul 4, 2011
    Messages:
    281
    Likes Received:
    210
    Location:
    Australia
    No problem H2oBoy.

    If anyone is any good with making excel documents look really fancy I'd be interested in seeing what they can do with document.

    If it looked good enough I'd probably bust this out live in a meeting on a laptop and do the calculations live with them. Would be a pretty good selling point imo.

    Feel free to have a go editing my file just be sure to share it back with the rest of us when you're done! :D
     
  16. salhammers

    salhammers Junior Member

    Joined:
    Jun 29, 2010
    Messages:
    138
    Likes Received:
    15
    Nice share, if anyone can add a pie graph and color code, that too will help the ROI sales process.

    Afraid I'm not an excel whizz. May get someone to do it for me and I'll send to OP to share if he wants.
     
    • Thanks Thanks x 1
  17. Dr_Scythe

    Dr_Scythe Regular Member

    Joined:
    Jul 4, 2011
    Messages:
    281
    Likes Received:
    210
    Location:
    Australia
    That would be awesome if you could do that :)
     
  18. salhammers

    salhammers Junior Member

    Joined:
    Jun 29, 2010
    Messages:
    138
    Likes Received:
    15
    Sent you PM
     
    • Thanks Thanks x 2
  19. Dr_Scythe

    Dr_Scythe Regular Member

    Joined:
    Jul 4, 2011
    Messages:
    281
    Likes Received:
    210
    Location:
    Australia
    salhammers has helped me add a pie chart to the Document. Big thanks to him.

    Originally he added all the stats to a single chart for PPC & SEO.

    I've modified his work again to just show the revenue splits for PPC vs SEO.

    The chart shows the total revenue split into cost and profit. A very Visual way to really emphasize how much better SEO is.

    I'm thinking the main thing that needs to be improved now is just the colours.

    New file is attached to this post but I'll update the original post as well. EDIT: I don't have an edit button for my original post? How strange....
     

    Attached Files:

    • Thanks Thanks x 7
    Last edited: Jul 29, 2011
  20. salhammers

    salhammers Junior Member

    Joined:
    Jun 29, 2010
    Messages:
    138
    Likes Received:
    15
    Looks much cleaner and visually easier on the eyes. Let's start using it to close more appointments we make

    Great work dr scythe!