'Unexpected Error' when trying to load page visits for a segment

Avatar

Avatar
Validate 1
Level 2
emmetc2018
Level 2

Likes

5 likes

Total Posts

17 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Applaud 5
View profile

Avatar
Validate 1
Level 2
emmetc2018
Level 2

Likes

5 likes

Total Posts

17 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Applaud 5
View profile
emmetc2018
Level 2

27-08-2018

Hi there,

I am trying to get the user ID's of all user who have read a specific article type in the last 30 days.

When I run the query I get a count of 8,719. This result is over 175 pages of 50 rows, see screenshot 1.

When I try to add 'Visits' (screenshot 2) as a metric or skip through the pages i.e. from page 1 to 2 or page 4 to 5, I get an error message in red, see screenshot 3.

This has happened numerous times. I have tried logging in and out and also turning off my machine but there has been no resolve.

Does anyone has some advise on what I can do to resolve this?

Thanks in advance!

Kind regards,
Emmet

Screenshot 1:

1558007_pastedImage_0.png

Screenshot 2:

1558008_pastedImage_2.png

Screenshot 3:

1558009_pastedImage_3.png

Accepted Solutions (1)

Accepted Solutions (1)

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

29-08-2018

This is the power of Adobe analytics...

In Analytics create a segment for that userID variable...

Then use regex to isolate your list of 3000 IDs. If you then have that segment you could then run reports in analytics isolating just those users by adding lets say a visit component to it... In data warehouse you then pick segment and run it.

OR

Run report for all IDs and in excel match the 3000 and filter them...

Answers (3)

Answers (3)

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

29-08-2018

Sadly its pretty much any data set type...

Workspace is great for like top 25 examples of a reporting breakout... as soon as you hit it with large numbers you see what its like...

I like to use it to visualize segmentation reporting I need then apply the logic to a data warehouse query...

A typical workflow for me:

In 30 mins i can run through dozens of reporting options, refine til I get a set I like.

Then I build final pull in data warehouse..

I now get usable data files in my case for millions of lines of data...

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

27-08-2018

I recommend this type of larger data query and filtering you run in data warehouse. Workspace is notoriously bad(ie.slow and buggy) for working with larger datasets in the hundreds let alone thousands...

regards

Avatar

Avatar
Validate 1
Level 2
emmetc2018
Level 2

Likes

5 likes

Total Posts

17 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Applaud 5
View profile

Avatar
Validate 1
Level 2
emmetc2018
Level 2

Likes

5 likes

Total Posts

17 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Applaud 5
View profile
emmetc2018
Level 2

29-08-2018

Is it possible to make a custom request in the Warehouse so that it will return a report of an input?

For example, return a count of User ID's in a Segment that contains 'X' . In this case 'X' being the 3,000 user IDs I manually paste into an input bar?

I cannot seem to find any such way to do this in Warehouse so far.

Thanks and kind regards,

Emmet