Forum Discussion

dyingod's avatar
dyingod
Helper 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])

     

     

dyingod's avatar
dyingod
Helper I
9 years ago

Wow! Such a simple solution! Thank you so much for all your help smoupre!! The figures are pretty close to our Excel reports (we're switching from Excel to Power BI). Interesting that instead of a sum, simply switching [Avg. position] to an average does the trick. Neat! Thanks again! :smileyhappy:

luchi505's avatar
luchi505
Regular Visitor
7 years ago

hello 

do you know how this could possibly work with Search Console data 

 

where I have

 

Keyword / total position / clicks / impressions

 

 

 

 

dyingod wrote:

Wow! Such a simple solution! Thank you so much for all your help smoupre!! The figures are pretty close to our Excel reports (we're switching from Excel to Power BI). Interesting that instead of a sum, simply switching [Avg. position] to an average does the trick. Neat! Thanks again! :smileyhappy: