Volume differential in Freeform Table Adobe Analytics Workspace | Community
Skip to main content
D
DylanAm75
October 7, 2020
Solved

Volume differential in Freeform Table Adobe Analytics Workspace

  • October 7, 2020
  • 2 replies
  • 2877 views

Hello,

Here the thing, when I created my Freeform Table in the workspace I selected my segments, then a metric & a dimension.
The table shows me the sum of the volume of my metric (on the first line of my dimension). Then there is all the rows just under. When I extracted the table in CSV and in Excel, I do myself the sum, it appears that there is a huge gap of volume, with much more volume in my Excel...

I tried to understand, but it appears that the more specific is my metrics (Day -> hour -> minute) the more raws I have & the bigger is the difference.

You will the see concretely in the screens associated, that I have 25972 "visits" on the 15 of June and when I did my Excel extract I finally get 107 824 "visits" !

Does someone had the same issue or is it specific to my data ?

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 yuhuisg

You can't add up Visits (not Visitors) across time just by summing up the row numbers.

Remember that a Visit comprises a series of hits over a span of time. So in your report, the same Visit could be reported at 00:00 and 00:01 and 00:02 etc. The same logic applies to Visitors.

AA conveniently deduplicates these in its header sum. You can't do that deduplication in Excel.

2 replies

yuhuisg
Community Advisor
yuhuisgCommunity AdvisorAccepted solution
Community Advisor
October 7, 2020

You can't add up Visits (not Visitors) across time just by summing up the row numbers.

Remember that a Visit comprises a series of hits over a span of time. So in your report, the same Visit could be reported at 00:00 and 00:01 and 00:02 etc. The same logic applies to Visitors.

AA conveniently deduplicates these in its header sum. You can't do that deduplication in Excel.

D
DylanAm75Author
October 8, 2020
Unfortunately, in AA's Report Builder we can't select a "minute" view, the deeper you have is "hour"...
jantzen_b
Adobe Employee
jantzen_bAdobe Employee
Adobe Employee
December 3, 2020
Do any of the answers below answer your initial question? If so, can you select one of them as the correct answer? If none of the answers already provided answer your question, can you provide additional information to better help the community solve your question?
Terms & ConditionsAccessibility statement

Loading footer...