Expand my Community achievements bar.

Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!
SOLVED

Number of Visits by minute

Avatar

Level 2

I can get the number of Visits by hour, day, week, month, quarter and year.
Is there a way to get the number of Visits by minute?

Reason:
I want to measure the succes of an TV campaign.
To do so I want to compare the number of visits (by minute) 5 minutes before the TV spot with the number of visits (by minute) 15 minutes after the TV spot.

 

1 Accepted Solution

Avatar

Correct answer by
Level 10

Hi Jeroen, 

Welcome to the Analytics Community! Please take some time out to introduce yourself here

Yes, if you are using workspace you can get visits by Year, quarter, month, week, day, hour and minutes. If you expand the 'Time' dimensions on the sidebar you will see all these options. All you have to do is to breakdown the line item with the time dimension you want. Here is a screengrab for reference: 

Also, in Reports there is an option of Real Time reports but the dimensions available there are limited. You can read about it here - https://marketing.adobe.com/resources/help/en_US/reference/realtime.html

Let me know if this helps.

Thanks,

Tanmay

View solution in original post

3 Replies

Avatar

Correct answer by
Level 10

Hi Jeroen, 

Welcome to the Analytics Community! Please take some time out to introduce yourself here

Yes, if you are using workspace you can get visits by Year, quarter, month, week, day, hour and minutes. If you expand the 'Time' dimensions on the sidebar you will see all these options. All you have to do is to breakdown the line item with the time dimension you want. Here is a screengrab for reference: 

Also, in Reports there is an option of Real Time reports but the dimensions available there are limited. You can read about it here - https://marketing.adobe.com/resources/help/en_US/reference/realtime.html

Let me know if this helps.

Thanks,

Tanmay

Avatar

Level 2

Hi Tanmay,

I looked right away in workspace and it works.
I can see now what I need.
Thank you, you helped me a lot.

When I select 1 day and break it down by minutes, I got 8 pages with 200 rows.
In "Share" I can choose the options "Send file now" and I got an .csv file.
Only thing is that I only got the first 200 rows.

Do you have any suggestions how I can get the complete day in a file?

Jeroen

Avatar

Level 10

I see, so sharing makes it a bit complex as workspace can display maximum of 200 rows in a breakdown and it exports only the part the is displayed on the screen. 

Since your requirement is 5 minutes before and 15 minutes after the TV spot, that would be limited within a particular hour. 

So what you can do is to first breakdown the page by hour and then further breakdown the hour of your TV spot by minutes, that would give you the 60 rows that you are concerned about. Here is a sample screengrab. 

I hope this helps. 

P.S I like the Mercedes G-Wagon in your profile picture.