Minute-level visit data | Community
Skip to main content
J
jasond73569343
September 17, 2018
Solved

Minute-level visit data

  • September 17, 2018
  • 15 replies
  • 7260 views

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.

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 Gigazelle

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.

15 replies

Show previous replies
fsakjlfdsakljfd
fsakjlfdsakljfd
Level 5
October 31, 2019

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

A
Anonymous
October 31, 2019

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

fsakjlfdsakljfd
fsakjlfdsakljfd
Level 5
October 31, 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.

A
Anonymous
October 31, 2019

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

fsakjlfdsakljfd
fsakjlfdsakljfd
Level 5
October 31, 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

Terms & ConditionsAccessibility statement

Loading footer...