since ‎06-10-2020
‎09-10-2020
DylanAm75
Level 1
Re: Volume differential in Freeform Table Adobe Analytics...
Avatar

DylanAm75

DylanAm75
- Adobe Analytics
We need a per-minute visits deduplication to be able to our system to scroll & recover the website traffic. Then we have many small periods of time where our algorithm will work.The only solution I see is to apply in my Excel file a division, calulated from the header sum vs all my Excel raws. To keep a consistency in numbers.In that case the division will be : (107 824 / 25952 = 4,15...).Even if we don't really know for each minute the weight of new vs "old" visits.

Views

113

Likes

0

Replies

0
Re: Volume differential in Freeform Table Adobe Analytics...
Avatar

DylanAm75

DylanAm75
- Adobe Analytics
Or maybe you know how to select "minute" in Report Builder space ?

Views

136

Likes

0

Replies

0
Re: Volume differential in Freeform Table Adobe Analytics...
Avatar

DylanAm75

DylanAm75
- Adobe Analytics
Unfortunately, in AA's Report Builder we can't select a "minute" view, the deeper you have is "hour"...

Views

150

Likes

0

Replies

0
Re: Volume differential in Freeform Table Adobe Analytics...
Avatar

DylanAm75

DylanAm75
- Adobe Analytics
Thank you yuhuisg, that's a problem for me... How can I isolate like AA in Excel ? Is there any solutions ?

Views

184

Likes

0

Replies

0
Volume differential in Freeform Table Adobe Analytics Workspace
Avatar

DylanAm75

DylanAm75
- Adobe Analytics
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 -> min...

Views

210

Likes

0

Replies

8
Can we extract (CSV) more than 400 rows in Adobe Analytics "Workspace" ?
Avatar

DylanAm75

DylanAm75
- Adobe Analytics
Hello everyone,I tried to figure how to extract to CSV excel, more than the 400 rows broadcasted in the Workspace display tables in Adobe Analytics. The thing is, I can't go more than 400 rows...Concretly, I need to extract data (it's web traffic per minute) from past 3 months. So, that represents a huge numbers of raws. 3 600 minutes per day (400 rows per extract), that's 4 extracts per day, multiplicate per 90 days = 360 extracts... knowing I have to grouped them in one unique file.Does someon...

Views

91

Likes

0

Replies

1