homepage Welcome to WebmasterWorld Guest from 54.161.202.234
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Home / Forums Index / Advertising / Pay Per Click Engines
Forum Library, Charter, Moderator: open

Pay Per Click Engines Forum

    
PPC Reports - Calculating Total Average Position
Need help with PPC report calculations
Angelfan




msg:3472052
 6:43 pm on Oct 8, 2007 (gmt 0)

I am specifically looking for help on how to calculate the total weighted average position for all of my keywords in excel. From what I understand there isn't a designated formula to use in excel 2000. (yes I know, I need to update it) hehe.

If you know how I could do this, please help! Thanks!

Ex:
Keyword ¦ Average Position
keyword 1 - 2.5
keyword 2 - 3.8
keyword 3 - 1.1
keyword 4 - 5.6
keyword 5 - 3.6
Total Weighted Average: _ _?

 

beesticles




msg:3472575
 9:51 am on Oct 9, 2007 (gmt 0)

Weight it by the number of impressions that each keyword received.

Eg.

KW1: 1000 imps, 2.5 avg pos
KW2: 2000 imps, 3.8 avg pos

Total = ((1000 * 2.5) + (2000 * 3.8)) / 3000 = 3.4

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Advertising / Pay Per Click Engines
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved