Results 1 to 1 of 1

Thread: Looking for a Keyword ranking formula on a Data set in excel

  1. #1
    Apr 2009

    Smile Looking for a Keyword ranking formula on a Data set in excel


    I am trying to do keyword comparison based on position ranking in a search pattern over time and create a predictor of a profitability index of which keyword and ad grouping will perform best over time,

    Here is the data that I am given:

    Last position ranked
    top position ranked
    avg position ranked
    and avg number of competitors in this ranking
    total days in the count (TDC)
    total number of times this keyword was found (TDF)
    and a ratio of TDF/TDC
    first day seen
    last day seen

    Here is what I am trying to achieve:
    A Profitability Index number between 0 and 1 that would indicate how well this keyword performed over a time period. with 1 being the best.

    I am including a 500 keyword xls spreadsheet in a zip file for your help. You can see my attempt at ranking. I am not a math whiz, that's why I am asking for your help. Any suggestions would be appreciated and acknowledged on future site designs.

    Attached Files Attached Files
    Last edited by dunrented; Apr 7th 2009 at 09:36 AM. Reason: forgot to attach file
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. Working out a formula from a set of data
    Posted in the Algebra Forum
    Replies: 1
    Last Post: Jun 9th 2010, 03:18 AM
  2. Formula needed, all data available
    Posted in the Advanced Statistics Forum
    Replies: 0
    Last Post: Nov 26th 2009, 08:10 AM
  3. Finding a formula for this data
    Posted in the Algebra Forum
    Replies: 2
    Last Post: Oct 17th 2009, 07:58 AM
  4. need help with excel formula
    Posted in the Business Math Forum
    Replies: 5
    Last Post: Aug 31st 2009, 05:50 AM
  5. Replies: 4
    Last Post: May 18th 2009, 11:16 PM

Search Tags

/mathhelpforum @mathhelpforum