Creating filters with High-cardinality values | Community
Skip to main content
M
Mcsyang-5k3qAe
New Participant
June 19, 2017
Solved

Creating filters with High-cardinality values

  • June 19, 2017
  • 13 replies
  • 4612 views

Hello everyone,

I don't believe this is possible, but wanted to ask before I gave up .

Is there a way to create a filter/segment within the Adobe Analytics reporting suite that allows you to filter by a specific set of values, but one that is potentially very large, and with a very high level of cardinality. For example, say I have a list of 500 ID's thatt I want to create a filter/segment for, but I do not want to manually paste in each ID, line by line, to create my segment. Due to the nature of the data, regular expressions simply would not work.

Is this something that is possible? for the record, what I am trying to do here is take a customer evar (client ID) and run it against various tools within Adobe Analytics (such as the pathing analysis).

*fingers crossed*

Mike

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Hyder_Ziaee

You can use API to create large size segments quickly.


Example if you have evar1 as Customer ID and want to create a segment for all visits containing specific Customer IDs:

{
     "definition":{
          "container":{
               "type":"hits",
               "operator":"and",
               "rules":[
                    {"element":"evar1","operator":"equals","value":"12345"},
                    {"element":"evar1","operator":"equals","value":"23456"},
                    {"element":"evar1","operator":"equals","value":"34567"},
                    {"element":"evar1","operator":"equals","value":"45678"},
                    {"element":"evar1","operator":"equals","value":"56789"}
               ]
          }
     },
     "description":"creating Segment through API",
     "name":"Segment Name",
     "owner":"account_username",
     "reportSuiteID":"insertReportSuiteID",
}

You need to repeat the line 7 as many times as you have the Customer IDs. Notice the last line in rules (line 11) doesn't have a comma in the end.

You can run the API here: Developer Connection | Adobe Developer Connection

Your username and shared secret for the connection can be retrieved from your account. (let me know if you need more details)

I would recommend starting with a few values and checking the segment in the UI,

-Hyder

13 replies

Show previous replies
Hyder_Ziaee
Hyder_Ziaee
Employee
June 20, 2017

I was not referring to regular expressions.

If you are able to run the get these values in a column in report builder, you can run a dependent request on these values.

Anyway, you can create a segment using API as well quickly for the values you have. what variable are these values stored in?

-Hyder

M
Mcsyang-5k3qAeAuthor
New Participant
June 20, 2017

Hey Hyder,

Thanks for your reply. I don't think report builder would work for my requirements—let me try to explain it better.

Let's say that I have 500 unique customer ID's that look like this XXXXXXXXXXXXXXXXXXX, with several different alphanumeric characters that are completely randomized with no patterns. There is no way for a regular expression to cover all of the values.

Is there a way to bulk upload these values, or to somehow create a filter/segment by pasting in all of these values at once? (assuming i have them in a 500-row spreadsheet) Is the only way to filter by these values manually pasting in each individual value?

Mike

Hyder_Ziaee
Hyder_Ziaee
Employee
June 20, 2017

Hi Mike,

There is a workaround (maybe). If your segment is going to be based on hits (such that a filter would do the job as well), then you can use report builder to create the reports.

The first request one would be to get the high cardinality values. The second,a  dependent request based on the first, to get the actual data.

This can only work for a limited set of reports and scenarios. May or may not work for you.

-Hyder

Terms & ConditionsAccessibility statement

Loading footer...