Summary number freeform table - does not agree with average | Community
Skip to main content
S
sophiegerhard
October 30, 2024
Solved

Summary number freeform table - does not agree with average

  • October 30, 2024
  • 1 reply
  • 506 views

Hi all, 

I have a freeform table with percentages. Adobe Analytics shows an average of 14%. However, if I save all the figures in Excel and calculate the average there, I only get 12%. In the table, I use month as a dimension on one side and the number of users who must have performed certain actions on our site (e.g. watched a video at least once or read an article to the end at least once) on the other side. Why is there a difference of 2% between the value I calculated and the value from Adobe?

Thanks,

Sophie

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Isha__Gupta

Hi @sophiegerhard ,

Adobe Analytics by default will deduplicate the unique visitors for all months. That means, if a user is included in month of Jan & same user appears in March data, Adobe calculation will use that as 1 and not two as your calculation would have done in Excel. Also, when you are looking at longer reporting period, Adobe will count deduplicated vs. counting days. To understand it bit more, you can append raw data metrics along side your calculated metric and you will be able to see the difference for yourself.

If you are looking to report based on user volume, I would say, go with 14%.

 

More info - https://experienceleague.adobe.com/en/docs/analytics/components/metrics/unique-visitors

Hope this helps!

 

Best,

Isha

 

1 reply

Isha__Gupta
Community Advisor and Adobe Champion
Isha__GuptaCommunity Advisor and Adobe ChampionAccepted solution
Community Advisor and Adobe Champion
October 30, 2024

Hi @sophiegerhard ,

Adobe Analytics by default will deduplicate the unique visitors for all months. That means, if a user is included in month of Jan & same user appears in March data, Adobe calculation will use that as 1 and not two as your calculation would have done in Excel. Also, when you are looking at longer reporting period, Adobe will count deduplicated vs. counting days. To understand it bit more, you can append raw data metrics along side your calculated metric and you will be able to see the difference for yourself.

If you are looking to report based on user volume, I would say, go with 14%.

 

More info - https://experienceleague.adobe.com/en/docs/analytics/components/metrics/unique-visitors

Hope this helps!

 

Best,

Isha

 

    Terms & ConditionsAccessibility statement

    Loading footer...