Forum Discussion

dyingod's avatar
dyingod
Icon for Helper I rankHelper I
9 years ago
Solved

AdWords avg. position calculation

Hello,   Super newbie here... so this might be a really easy one.   Regardless of whether or not you know AdWords, to calculate Average position in Excel, one can just do the following formula: ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    9 years ago

    Perfect, I created a column using this formula:

     

     

    WeightedAverage = ([Impressions] * [Avg. position]) / [Impressions]
     

    I also created a measure like this:

     

    mWeightedAverage = (SUM(Sheet2[Impressions]) * AVERAGE(Sheet2[Avg. position])) / SUM(Sheet2[Impressions])

     

     

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
9 years ago

Perfect, I created a column using this formula:

 

 

WeightedAverage = ([Impressions] * [Avg. position]) / [Impressions]
 

I also created a measure like this:

 

mWeightedAverage = (SUM(Sheet2[Impressions]) * AVERAGE(Sheet2[Avg. position])) / SUM(Sheet2[Impressions])