Expand my Community achievements bar.

SOLVED

Classification rules for campaign stacking with unknow length (xxx>yyy>zzz)

Avatar

Level 1

Hi,

I need to classifiy campaign stacking strings and I have the logic but I don't find how to create rules for unknow length.

If I use the rules below I can extract the values and 

example of campaign stacking values : 

1. "string1>string2>string3>string4"
2. "string1"
3. "string1>string2>string3>string4>string5>string6>string7>string8>string9>string10"

real case :
RegEx : ([^\>]+)\>([^\>]+)\>([^\>]+)

Key to test : 752747d53fce0e1d>3224749ae671f8e7>752747d53fce0e1d

Groups

$0752747d53fce0e1d>3224749ae671f8e7>752747d53fce0e1d
$1752747d53fce0e1d
$23224749ae671f8e7
$3752747d53fce0e1d

 

But if I need to process more than 3 codes it doesn't work again becasue I need to integrate a conditional test to manage the separator ">".

1. Do you have an idea of how to write this rule?

2. The other point to fix, is apply my campaign codes SAINT classification on the campaign codes included in the stacking.

I think I can do it but it's not so easy.

Thanks for feedback,

Laurent

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi Laurent,

 

Good news smiley the list var should fix your issue. It will fix your issue because the delimited list of values passed in this variable are considered as separate key values. So just set up a listvar and send your concatenated list of campaign ideas in this variable. It will automatically split the values for you :) 

Here is the doc for it.

 

Best regards.

 

Alexis Cazes

View solution in original post

8 Replies

Avatar

Community Advisor

Hi Laurent,

Per the screenshot attached I would expect the 3 reports : tracking code, campaign names and campaigns categories to have the same data/values in each report.

Classification rule builder is useful when you your variable always follow the same pattern and/or you can identify specific values in the string. 

I think instead of using rule builder, you should use classification importer (which is the new name for saint classification).

So if you go to Star >> Admin tools >> Classification importer >> export, then export all the tracking code that you want. Then you will have the file with all the keys.

You can then populate each column for each raw manually with the value that you need.

Best regards.

 

Alexis

Avatar

Community Advisor

Hi Laurent,

 

What is the maximum length of you campaign, by length I mean separate value in the tracking code ?

Does each level goes under a separate classified report or the same classified report ? 

 

Best regards.

 

Alexis Cazes

Avatar

Level 1

Hi Alexis,

each campaign code is alpha 16 but it's not a problem is the codes don't have the same number of characters.

The campaign stacking could have 1 to 16 codes for example (3 cases although I have less than 12 codes) :

752747d53fce0e1d

752747d53fce0e1d>3224749ae671f8e7>752747d53fce0e1d

752747d53fce0e1d>3224749ae671f8e7>752747d53fce0e1d>752747d53fce0e1d>3224749ae671f8e7>752747d53fce0e1d>752747d53fce0e1d>3224749ae671f8e7>752747d53fce0e1d>752747d53fce0e1d>3224749ae671f8e7>752747d53fce0e1d>752747d53fce0e1d>3224749ae671f8e7>752747d53fce0e1d>752747d53fce0e1d>3224749ae671f8e7>752747d53fce0e1d

the main poitn is to create a rule to split wit hthe separator > if there is only one code or several codes.

I almost found but the conditional rule is not easy to add when you don't know ho many codes we will find.

The classified values are linked on the eVar Campaign Stacking (the plugin insert the codes in a stack stores in the evar).

Campaign stacking -- Campaign codes (x>y>z)

                             -- Campaign name (I would like to classify from my campaign Saint files)

                             -- Campaign category (I would like to classify from my campaign Saint files)

                             -- Campaign sub-category (I would like to classify from my campaign Saint files)

Best,
Laurent

Avatar

Level 1

Hi,

yes I started to test this.

I  need to check if I could avoid to classify all the stacking as 1 new long string when I have a campaign code classification  SAINT file because there are a huge number of combinations.

I don't know if it's possible (in my case) to use it to classify as a second file each campaig ncode in the campaign code stacking. 

Best,

Laurent

Avatar

Community Advisor

Hi Laurent,

 

I think what you are trying to obtain might not work for the following reason. The initial string campaign stacking is your key.

Lets take the following example that you provided 

752747d53fce0e1d>3224749ae671f8e7>752747d53fce0e1d

The key that will be used to tie your saint classification data is 

752747d53fce0e1d>3224749ae671f8e7>752747d53fce0e1d

So we create a regex to split the different campaign id and we obtain the following

$0 752747d53fce0e1d>3224749ae671f8e7>752747d53fce0e1d
$1 752747d53fce0e1d
$2 3224749ae671f8e7
$3 752747d53fce0e1d

When we have that we can put the value of $1 $2 and $3 in different classified report 

-- Campaign name (I would like to classify from my campaign Saint files)

-- Campaign category (I would like to classify from my campaign Saint files)

-- Campaign sub-category (I would like to classify from my campaign Saint files)

 

BUT it will not create 3 separate unique key that we would be able to classify independently, meaning that we can only specify one campaign name, one campaign category and one campaign sub-category for the key 

752747d53fce0e1d>3224749ae671f8e7>752747d53fce0e1d

So you will not be able to classify a different campaign name, campaign category and campaign sub category.

 

I need to check if sending your data in a listvar variable will allow the classification that you desire

Avatar

Community Advisor

I believe each combination of code will be a unique key. 

Avatar

Correct answer by
Community Advisor

Hi Laurent,

 

Good news smiley the list var should fix your issue. It will fix your issue because the delimited list of values passed in this variable are considered as separate key values. So just set up a listvar and send your concatenated list of campaign ideas in this variable. It will automatically split the values for you :) 

Here is the doc for it.

 

Best regards.

 

Alexis Cazes