Volume differential in Freeform Table Adobe Analytics Workspace

Avatar

Avatar

DylanAm75

Avatar

DylanAm75

DylanAm75

07-10-2020

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 ?Freeform table Adobe Analytics.PNGExcel Extract from Freeform table Adobe Analytics.PNG

Accepted Solutions (0)

Answers (1)

Answers (1)

Avatar

Avatar

yuhuisg

Avatar

yuhuisg

yuhuisg

07-10-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.