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

Allow us to paste a long list into filters and segments

Avatar

Avatar
Boost 50
Level 5
dreisch-wiley
Level 5

Likes

101 likes

Total Posts

61 posts

Correct Reply

1 solution
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 100
View profile

Avatar
Boost 50
Level 5
dreisch-wiley
Level 5

Likes

101 likes

Total Posts

61 posts

Correct Reply

1 solution
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 100
View profile
dreisch-wiley
Level 5

16-08-2018

My company has tens of thousands of products, and millions of articles. Here's a pretty common request:

  • I've attached a list of 100 products with their IDs. We think we can bundle them into a new sellable thing. Can you tell me how many unique visitors looked at them?
  • I've attached a list of 1,000 article IDs affected by this issue. Can you tell me how many visits they had?

My workflow varies:

  • If I need user/visit deduplication as in the above questions:
    • Go into Ad Hoc Analysis (or Workspace), create a segment, filter hits where the product ID "contains any of" and paste the whole list. Cross fingers that the IDs are well-formed and not contained in other ids (e.g. abc not matching on abcde). Run report I need.
    • Go into Ad Hoc Analysis (or Workspace), pull up the dimension, filter, and paste the list under "Any of these words". Hope for the same.
    • If the list is very long or I need exact matches on IDs, create a classification and upload this list. This becomes very slow and adds a lot of junk to our report suite that others don't need and doesn't have long-term use.
  • If the metric I need is already de-duplicated against the dimension (e.g. pageviews, only one product ever per pageview), I might just export the list and do a VLOOKUP in Excel. Doesn't work well when we're talking hundreds of thousands or more values.
  • If I'm really crunched for time, write a python script that reads a CSV and builds a segment with that many rules. This works fine for me but not others.

Ideally, what I'd like is for Adobe to recognize that I am pasting in newline characters, and create a long array of inputs with those values in it. So, if in the advanced filter/search, I focused on the first value field, and I pasted my list, I'd actually get N rows with each row filled out.

Here's an example of how another tool I use handles it. I have entered the first two, but pasted a list after. Each becomes its own line item.

Category Overview.webm - Google Drive

2 Comments

Avatar

Avatar
Boost 50
Level 5
dreisch-wiley
Level 5

Likes

101 likes

Total Posts

61 posts

Correct Reply

1 solution
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 100
View profile

Avatar
Boost 50
Level 5
dreisch-wiley
Level 5

Likes

101 likes

Total Posts

61 posts

Correct Reply

1 solution
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 100
View profile
dreisch-wiley
Level 5

14-06-2019

This is halfway solved by "equals any of" which I am super happy about. Thanks for delivering that feature.    

Avatar

Avatar
Ignite 3
Moderator
jen_lasser
Moderator

Likes

116 likes

Total Posts

314 posts

Correct Reply

8 solutions
Top badges earned
Ignite 3
Ignite 1
Give Back 5
Give Back 3
Give Back 10
View profile

Avatar
Ignite 3
Moderator
jen_lasser
Moderator

Likes

116 likes

Total Posts

314 posts

Correct Reply

8 solutions
Top badges earned
Ignite 3
Ignite 1
Give Back 5
Give Back 3
Give Back 10
View profile
jen_lasser
Moderator

28-10-2020

Equals any of is what we are able to provide right now! https://www.youtube.com/watch?v=GI_Bxetcfko

Status changed to: Delivered