Minute-level visit data

Avatar

Avatar
Validate 1
Level 1
jasond73569343
Level 1

Likes

0 likes

Total Posts

5 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
jasond73569343
Level 1

Likes

0 likes

Total Posts

5 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile
jasond73569343
Level 1

17-09-2018

Hello,

I am trying to find the correct way to obtain minute-level data extracts for session/visit starts. It seems as though this is not a standard option within either Report Builder or Data Warehouse where an hourly breakdown is the most granular level available.

I have been able to achieve this granularity in Workspace but that is not a viable option for regular use over large date ranges. In addition to this, I have also noticed that the sum of the minute-level line items exceeds the hourly totals (and, in turn, the sum of the hour-level line items exceeds the daily totals). Please could someone explain this to me? I can understand such a discrepancy when it comes to individual product totals vs. total complete orders but I can't see how this works in the context of user visits.

I have seen some minute-level data from Data Warehouse where the field 'Time stamp - start of session (eVar67) (evar67)' is included but this data includes quite a few rows where there is no entry for this field. Is there a link between these blank entries and the total vs. sum of line item discrepancy within Workspace?

Apologies if there is an obvious answer to this, I'm just trying to get my head around it all before settling on the best solution.

Jason.

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Coach
Employee
Gigazelle
Employee

Likes

473 likes

Total Posts

1,947 posts

Correct reply

740 solutions
Top badges earned
Coach
Contributor 2
Validate 1
Ignite 80
Ignite 70
View profile

Avatar
Coach
Employee
Gigazelle
Employee

Likes

473 likes

Total Posts

1,947 posts

Correct reply

740 solutions
Top badges earned
Coach
Contributor 2
Validate 1
Ignite 80
Ignite 70
View profile
Gigazelle
Employee

01-10-2018

So I've done a bit more research, and the existing answers here are pretty complete. Between a new dimension, minute level data in workspace, and data warehouse, you'll want to weigh your options and pick the best route for your organization.

The only thing that hasn't been mentioned is that workspace will allow the download of up to 50k rows sometime in the next year or so. While this doesn't help immediately, this improvement may be helpful down the road.

Another alternative would be to schedule a workspace project that contains multiple tables, enough for all minutes in the day. Have it scheduled every day, then you can use the spreadsheet data however you'd like. Over time, you'd have the data from each day in it's respective spreadsheet.

Answers (14)

Answers (14)

Avatar

Avatar
Shape 1
Level 4
fsakjlfdsakljfd
Level 4

Likes

48 likes

Total Posts

88 posts

Correct reply

14 solutions
Top badges earned
Shape 1
Give Back 5
Give Back 3
Give Back
Boost 5
View profile

Avatar
Shape 1
Level 4
fsakjlfdsakljfd
Level 4

Likes

48 likes

Total Posts

88 posts

Correct reply

14 solutions
Top badges earned
Shape 1
Give Back 5
Give Back 3
Give Back
Boost 5
View profile
fsakjlfdsakljfd
Level 4

31-10-2019

You need to set up an integration in Adobe.io.  You can do this if you are an admin.

These are two pretty good videos on getting going.
Using Analysis Workspace to Build API 2.0 Requests

Using Postman to Make Adobe Analytics 2.0 API Requests - YouTube

Avatar

Avatar
Shape 25
MVP
Andrey_Osadchuk
MVP

Likes

539 likes

Total Posts

973 posts

Correct reply

266 solutions
Top badges earned
Shape 25
Bedrock
Coach
Boost 500
Affirm 250
View profile

Avatar
Shape 25
MVP
Andrey_Osadchuk
MVP

Likes

539 likes

Total Posts

973 posts

Correct reply

266 solutions
Top badges earned
Shape 25
Bedrock
Coach
Boost 500
Affirm 250
View profile
Andrey_Osadchuk
MVP

18-09-2018

jasond73569343​, I would advise to implement a variable to store the time value in the format HH:mm:ss. Ideally, the value should be returned by the CMS. Then apply a classification to group all values in the desired buckets. This should help you reach the desired goal.

Use the Entry metric since you are interested in analysing response from TV ads.

Avatar

Avatar
Level 1
allanag86485492
Level 1

Likes

0 likes

Total Posts

3 posts

Correct reply

0 solutions
View profile

Avatar
Level 1
allanag86485492
Level 1

Likes

0 likes

Total Posts

3 posts

Correct reply

0 solutions
View profile
allanag86485492
Level 1

31-10-2019

How can I check if I have API 2.0 in my analytics account?

Avatar

Avatar
Shape 1
Level 4
fsakjlfdsakljfd
Level 4

Likes

48 likes

Total Posts

88 posts

Correct reply

14 solutions
Top badges earned
Shape 1
Give Back 5
Give Back 3
Give Back
Boost 5
View profile

Avatar
Shape 1
Level 4
fsakjlfdsakljfd
Level 4

Likes

48 likes

Total Posts

88 posts

Correct reply

14 solutions
Top badges earned
Shape 1
Give Back 5
Give Back 3
Give Back
Boost 5
View profile
fsakjlfdsakljfd
Level 4

31-10-2019

Analysis Workspace is limited to 400 rows per freeform table; the api 2.0 is not limited to 400 rows per request. Further more if you are using an api you automate the process to say grab rows 1-50k, then 50001 to 100k etc.

The large advantage of an API is that it will allow you to address this programmatically, while still getting the underlying data you require.

Avatar

Avatar
Level 1
allanag86485492
Level 1

Likes

0 likes

Total Posts

3 posts

Correct reply

0 solutions
View profile

Avatar
Level 1
allanag86485492
Level 1

Likes

0 likes

Total Posts

3 posts

Correct reply

0 solutions
View profile
allanag86485492
Level 1

31-10-2019

Workspace only has 400 rows for downloads, this is not enough when you want to download a half year.

Avatar

Avatar
Shape 1
Level 4
fsakjlfdsakljfd
Level 4

Likes

48 likes

Total Posts

88 posts

Correct reply

14 solutions
Top badges earned
Shape 1
Give Back 5
Give Back 3
Give Back
Boost 5
View profile

Avatar
Shape 1
Level 4
fsakjlfdsakljfd
Level 4

Likes

48 likes

Total Posts

88 posts

Correct reply

14 solutions
Top badges earned
Shape 1
Give Back 5
Give Back 3
Give Back
Boost 5
View profile
fsakjlfdsakljfd
Level 4

30-10-2019

What about using API 2.0?  I'd imagine it is an option as it powers analysis workspace.

Avatar

Avatar
Level 1
jadonwellman
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
View profile

Avatar
Level 1
jadonwellman
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
View profile
jadonwellman
Level 1

30-10-2019

Hi Jason,

Data Warehouse does not have the ability to report at the minute level. You need to use the Data Feed.

Best,

Jadon

Avatar

Avatar
Level 1
allanag86485492
Level 1

Likes

0 likes

Total Posts

3 posts

Correct reply

0 solutions
View profile

Avatar
Level 1
allanag86485492
Level 1

Likes

0 likes

Total Posts

3 posts

Correct reply

0 solutions
View profile
allanag86485492
Level 1

29-10-2019

Hi Jason,

I wonder if you find it the solution for downloading data from Adobe analytics by the minute? I am also looking for this solution but in report builder the minute granularity does not exist.

I hoop someone knows if this is possible,

Avatar

Avatar
Validate 1
Level 1
jasond73569343
Level 1

Likes

0 likes

Total Posts

5 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
jasond73569343
Level 1

Likes

0 likes

Total Posts

5 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile
jasond73569343
Level 1

02-10-2018

Thanks. I appreciate your help with this. I just wanted to ensure that there wasn't a solution that I was unaware of.

That's useful information regarding the future developments too.

Avatar

Avatar
Validate 1
Level 1
jasond73569343
Level 1

Likes

0 likes

Total Posts

5 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
jasond73569343
Level 1

Likes

0 likes

Total Posts

5 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile
jasond73569343
Level 1

26-09-2018

I think it is possible in Workspace but not a practical solution given that it can only be done one day at a time and it takes a very long time to break the data down by the three categories that I need plus the hour and minute. The prospect of doing this for even a week's worth of data is very daunting, let alone for several months.

Avatar

Avatar
Coach
Employee
Gigazelle
Employee

Likes

473 likes

Total Posts

1,947 posts

Correct reply

740 solutions
Top badges earned
Coach
Contributor 2
Validate 1
Ignite 80
Ignite 70
View profile

Avatar
Coach
Employee
Gigazelle
Employee

Likes

473 likes

Total Posts

1,947 posts

Correct reply

740 solutions
Top badges earned
Coach
Contributor 2
Validate 1
Ignite 80
Ignite 70
View profile
Gigazelle
Employee

21-09-2018

Analysis Workspace has minute-level breakdowns. Would this work in your favor?

Avatar

Avatar
Validate 1
Level 1
jasond73569343
Level 1

Likes

0 likes

Total Posts

5 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
jasond73569343
Level 1

Likes

0 likes

Total Posts

5 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile
jasond73569343
Level 1

18-09-2018

Thanks Andrey. I'm looking at this from a reporting perspective - would the existing 'Time stamp - start of session' custom breakdown from Data Warehouse be a valid variable for this purpose?

Having done some more testing today, I can see that the sum of visits per minute (using this 'Time stamp - start of session' field) from Data Warehouse is almost identical to the sum of entries per minute when broken-down to the required granularity from within Workspace. I'm just concerned by the number of rows where there is no timestamp included in the Data Warehouse exports.

Avatar

Avatar
Validate 1
Level 1
jasond73569343
Level 1

Likes

0 likes

Total Posts

5 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
jasond73569343
Level 1

Likes

0 likes

Total Posts

5 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile
jasond73569343
Level 1

18-09-2018

I'm looking at session (visit) starts by minute in order to analyse immediate response to TV ads.

Avatar

Avatar
Give Back 50
Level 6
pabloc82923542
Level 6

Likes

78 likes

Total Posts

358 posts

Correct reply

82 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 10
View profile

Avatar
Give Back 50
Level 6
pabloc82923542
Level 6

Likes

78 likes

Total Posts

358 posts

Correct reply

82 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 10
View profile
pabloc82923542
Level 6

17-09-2018

I understand the desire to tag minute level data, just curious what is Business strategy her you are trying to quantify/measure? Can you expand on that?