Segment to filter URL contains sku = 7{*******} alphanumeric value | Community
Skip to main content
Level 4
April 7, 2020
Solved

Segment to filter URL contains sku = 7{*******} alphanumeric value

  • April 7, 2020
  • 2 replies
  • 2975 views

Hi Team,

 

I am trying to build a visit level segment based on pageURL contains sku={*******}.We are passing the 7 digit alphanumeric value(for instance: T6L04AA) in the product page URL. I am trying to use these 7 digit alphanumeric value as condition. But I am not able to create it as we have huge number of sku's. Can you please help me here to create segment using regular expression?

 

for instance: https://b2b.hp.com/productDetails/details?a1ustri3=KyWOhEs4RFAAAAYEtQExQ0R_&sku=T6L04AA&productType=catalog&a1ortri2=ppurKnessyhT%20

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 Agustin_Suarez

Hi Dinesh,


@dinesh_kumar_r wrote:

...But I am not able to create it as we have huge number of sku's...


It sounds that maybe you are going to reach the 500K value limit per dimension. In any case, you cannot use regexp while working with segments. The most  you can do is to use wildcards, and wildcards only work for whole values in the dimension. For instance:

  • Your dimension matches 10_*_000 delivers:
    • 10_20495_000
    • 10_219432_000
    • 10_32_000
    • ...

For your requeriments, it looks like that the best approach would be, imho, to capture SKU parameter in a new eVar. From here, you can use the Classification Rule Builder with any desired regexp to create the segments as you need. I hope it helps.

 

Cheers,

Agustin

2 replies

Agustin_Suarez
Agustin_SuarezAccepted solution
Level 2
April 7, 2020

Hi Dinesh,


@dinesh_kumar_r wrote:

...But I am not able to create it as we have huge number of sku's...


It sounds that maybe you are going to reach the 500K value limit per dimension. In any case, you cannot use regexp while working with segments. The most  you can do is to use wildcards, and wildcards only work for whole values in the dimension. For instance:

  • Your dimension matches 10_*_000 delivers:
    • 10_20495_000
    • 10_219432_000
    • 10_32_000
    • ...

For your requeriments, it looks like that the best approach would be, imho, to capture SKU parameter in a new eVar. From here, you can use the Classification Rule Builder with any desired regexp to create the segments as you need. I hope it helps.

 

Cheers,

Agustin

May 29, 2020

Does this mean I can use * to replace the values i'm not looking to segment on?