Expand my Community achievements bar.

Analytics workspace - evars

Avatar

Level 2

Hi ,

I am on workspace dashboard. For one of my evar, the value i get is in this format (abcdef|01071||||||35603|serra abcdef of decatur||al|| 1056 0), as these are concatenated with the classifications rule.

so the value i have here consists of 6 fields like brand name, zipcode,dealer code, dealer name, country etc etc. now here i have to set an alert for set of dealers, who are having zero orders daily. Here i have to set this for around 66 dealers. how can i break down this data with dealer names and create the alerts, can anyone explain me please.

 

 

 

1 Reply

Avatar

Community Advisor

One of the problems here is that Classifications are processed every 4 to 6 hours... so depending on the granularity of your alerts, you may alerted on data that hasn't yet processed (if basing it on a classification)

 

Can you clarify the format of your base eVar?

[brand name]|[zipcode]|...

 

Looking at your data through, it looks like you have a lot more pipes (|) then I would expect if you only have 6 fields (I see 12 pipes... if you are using || as a delimiter instead of just |, then the usage is inconsistent - I clearly see one pipe between values  -unless "toyota|01071" is all part of the brand name... this is why I am asking for clarity around the format)

 

 

Now, I can see that there is data there much older than a few hours... and that your "Brand" classification is still unspecified... so are you asking for help to fix the Classification rules first (before even starting with alerts?)

 

In order to help with a regex, we really need to know the exact format the data should be expected to be provided in, and if there are expected to be special characters with the data (i.e. pipe in the values, double pipe is delimiter, etc)