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

SOLVED

How to use Regular Expression to build Classification Rule Builder in Adobe Analytics

vijayakumar_raj
Level 5
Level 5

Hi All,

Just want to understand, how it is possible to make a proper logic using Regular Expression (Classification Rule Builder) in Adobe Analytics to make structured data like the screenshot below from first screenshot to second screenshot.

Before - Its look like

Sc2.png

After -

Screenshot.png

Could you please help me to provide the regular expression (logics)!

Thanks,

Vijay

1 Accepted Solution
PratheepArunRaj
Correct answer by
Moderator
Moderator

Dear Vijay,

Don't have time to work on the above bucket since it need more effort.

Below the buckets with few modifications and i hope even the below is good to go for you.

Also, i believe that captured numbers are in Milliseconds. If not, logic will also change.

More than 50 Sec : \d

Less than 10 Sec : ^([0-9]|[0-9][0-9]|[0-9][0-9][0-9]|[0-9][0-9][0-9][0-9])$

10 to 19 Sec : ^([1][0-9][0-9][0-9][0-9])$

20 to 29 Sec : ^([2][0-9][0-9][0-9][0-9])$

30 to 39 Sec : ^([3][0-9][0-9][0-9][0-9])$

40 to 49 Sec : : ^([4][0-9][0-9][0-9][0-9])$

The rules must be placed in the same order.

Thank You!

Arun

View solution in original post

4 Replies
PratheepArunRaj
Moderator
Moderator

Dear Vijay,

I have grouped it based on Milliseconds itself. But you can edit the below to create your own!

> 600 ms : \d

Less Than 30 ms : ^([0-9]|[1][0-9]|[2][0-9]|30)$

>30 And <=60 ms : ^([3][1-9]|[4][0-9]|[5][0-9]|60)$

>60 And <=120 ms : ^([6][1-9]|[7][0-9]|[8][0-9]|[9][0-9]|[1][0-1][0-9]|120)$

>120 And <=300 ms : ^([1][2][1-9]|[1][3-9][0-9]|[2][0-9][0-9]|300)$

>300 And <=600 ms : ^([3][0][1-9]|[3][1-9][0-9]|[4-5][0-9][0-9]|600)$

Thank You

Arun

vijayakumar_raj
Level 5
Level 5

Thank you so much for your help Pratheep!

I am not fully technical guy to create regular expression like this.

It would be great if you can help me to provide the below scenario as well (If possible), I tried on my own but it doesn't work .

  • Less than 10 Sec
  • 10 to 20 Sec
  • 21 to 30 Sec
  • 31 to 40 Sec
  • 41 to 50 Sec
  • More than 50 Sec

Thanks again for the wonderful insights that you have provided earlier.

Regards,

Vijay

PratheepArunRaj
Correct answer by
Moderator
Moderator

Dear Vijay,

Don't have time to work on the above bucket since it need more effort.

Below the buckets with few modifications and i hope even the below is good to go for you.

Also, i believe that captured numbers are in Milliseconds. If not, logic will also change.

More than 50 Sec : \d

Less than 10 Sec : ^([0-9]|[0-9][0-9]|[0-9][0-9][0-9]|[0-9][0-9][0-9][0-9])$

10 to 19 Sec : ^([1][0-9][0-9][0-9][0-9])$

20 to 29 Sec : ^([2][0-9][0-9][0-9][0-9])$

30 to 39 Sec : ^([3][0-9][0-9][0-9][0-9])$

40 to 49 Sec : : ^([4][0-9][0-9][0-9][0-9])$

The rules must be placed in the same order.

Thank You!

Arun

View solution in original post

vijayakumar_raj
Level 5
Level 5

Thank you so much Pratheep for your help!

I appreciate it!

Regards,
Vijay