Summary number freeform table - does not agree with average | Community
Skip to main content
sophiegerhard
New Participant
Oct 30, 2024 9:37 AM UTC
Solved

Summary number freeform table - does not agree with average

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.
Isha__Gupta
Isha__GuptaAccepted solution
Level 1
Oct 30, 2024 12:20 PM UTC

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

 

View reply

1 reply

Isha__Gupta
Isha__GuptaAccepted solution
Level 1
Oct 30, 2024 12:20 PM UTC

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

 

Translate
    Terms & ConditionsAccessibility statement

    Loading footer...