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

emmetc2018 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)

pabloc82923542 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)

pabloc82923542 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...

pabloc82923542 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

emmetc2018 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