Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Issue with creating segments that contain User IDs

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

20-11-2018

ursbollerGigazelle

Hi there,

I am having difficulty creating a segment that holds User IDs.

For example, I have a list of User IDs that registered on our Website in the last week i.e. Over 1000 IDs.

I wish to create a segment that contains all these User IDs, however when I try to do so the app freezes.

How can I create a segment to contain these people? I wish then to use this segment in Workspace to find out more on the users within this segment's online behavior i.e. Where they are from, device type, page views etc.

The Segment I created used the following criteria:

User ID > contains > *Pasted in the User IDs

How should ID's be pasted in? x,y,z OR xyz OR x|y|z OR an alternative way?

Can someone please advise?

Thanks in advance.

Kind regards,

Emmet

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Coach
MVP
ursboller
MVP

Likes

512 likes

Total Posts

1,012 posts

Correct Reply

254 solutions
Top badges earned
Coach
Contributor
Bedrock
View profile

Avatar
Coach
MVP
ursboller
MVP

Likes

512 likes

Total Posts

1,012 posts

Correct Reply

254 solutions
Top badges earned
Coach
Contributor
Bedrock
View profile
ursboller
MVP

20-11-2018

I once had problems with segments "contains" when I pasted too many strings. Don't know rhe limit but your number might be above.

some work-arounds

1) add several conditions and split the IDs

2) upload segment by API

3) use classification

If I have the desired information in an eVar, I would head for 3) in such a case ...

Answers (3)

Answers (3)

Avatar

Avatar
Coach
Employee
Gigazelle
Employee

Likes

468 likes

Total Posts

1,947 posts

Correct Reply

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

Avatar
Coach
Employee
Gigazelle
Employee

Likes

468 likes

Total Posts

1,947 posts

Correct Reply

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

03-12-2018

Urs's bullet 3 would be my recommendation.

  1. Create a classification for the user ID custom variable.
  2. In the classification template, find the 1000 user ID's you want to focus on, and give them the same classification value
  3. Upload that file back into the classification importer, then wait for it to process
  4. Create a segment where "eVar classification" equals "classified value".
  5. Revel in this ultra-simple and well-performing segment as you have all your reporting needs met. If you need to change the user ID's in the segment, you can do so by uploading another classification file.

Avatar

Avatar
Validate 1
Employee
AdobeCraig
Employee

Like

1 like

Total Posts

6 posts

Correct Reply

3 solutions
Top badges earned
Validate 1
Boost 1
Affirm 3
Affirm 1
View profile

Avatar
Validate 1
Employee
AdobeCraig
Employee

Like

1 like

Total Posts

6 posts

Correct Reply

3 solutions
Top badges earned
Validate 1
Boost 1
Affirm 3
Affirm 1
View profile
AdobeCraig
Employee

28-11-2018

It may be possible to use a slightly different approach.  for example, if you are putting the ID's into an evar, there is a metric created for that evar called, "evar instance"... for example, if the evar is cust ID, then there is a metric called cust ID Instance.  you can create a segment that simply has "custom id instance exists" and that will capture all of the instances where there is a customer ID. 

Similarly, if you have a Classification file, you can select those items that do not have "unspecified".

If you are trying to get a subset of the user ID's then the classification could work by having one column that indicates whether or not to include them in the segment. 

Avatar

Avatar
Give Back 50
Level 6
pabloc82923542
Level 6

Likes

76 likes

Total Posts

358 posts

Correct Reply

81 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

76 likes

Total Posts

358 posts

Correct Reply

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

20-11-2018

Don't waste your time using workspace with large volumes of data, it is terrible for that freezing is typical on large data sets ...

I would use workspace to get a summary style of data pull you want then run the data pull in data warehouse. Caveat if the data file is going to be large run it ftp(try first you will be warned if that is the case)

GLTU