Expand my Community achievements bar.

Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!
SOLVED

Create a segment to filter out false data

Avatar

Level 3

We have been seeing orders and revenue recorded in our Adobe Analytics production environment that were completed in a staging environment. The IT team thinks they have narrowed it down to a change in the DTM tag and is fixing it. But now I'd like to filter out any transactions in workspaces that came from these environments. 

 

The only idea I came up with was to use our Order ID variable as it seems all the erroneous transactions have an order ID of 5 digits instead of 6. Is there a way to say Order ID DOES NOT MATCH 5 digits?  I tried ##### and *****

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi @e30powar,

Couple of options -

1. If you are tracking page url or domain or report suite id in any variable (prop/eVar) to differentiate stg vs production environment than create a exclude segment based on available options. If not start tracking it.

2. If you using virtual report suite, use segment created through step #1 to exclude data from virtual report suite.

3. As you can't directly use regular expression to count "order id" characters in segments in that case use auto classification rule builder to create a rule for order id having 5 digits vs all others and use that classification in segment to exclude data by either using #1 or #2 method.

Thanks,

Asheesh

 

View solution in original post

2 Replies

Avatar

Level 4
Do you have the ability to segment using the url?

Avatar

Correct answer by
Community Advisor

Hi @e30powar,

Couple of options -

1. If you are tracking page url or domain or report suite id in any variable (prop/eVar) to differentiate stg vs production environment than create a exclude segment based on available options. If not start tracking it.

2. If you using virtual report suite, use segment created through step #1 to exclude data from virtual report suite.

3. As you can't directly use regular expression to count "order id" characters in segments in that case use auto classification rule builder to create a rule for order id having 5 digits vs all others and use that classification in segment to exclude data by either using #1 or #2 method.

Thanks,

Asheesh