Import information in Adobe Analytics using eVar as Key | Community
Skip to main content
Level 2
June 4, 2024
Solved

Import information in Adobe Analytics using eVar as Key

  • June 4, 2024
  • 2 replies
  • 1482 views

Hi everyone,

 

I have been capturing unique IDs for campaigns that drive traffic to the site in an eVar. Obviously, these IDs don't provide much information about the campaigns. I have a mapping file that provides the campaign information mapped to the IDs in a key-value format, with the unique ID being the key. Is there a way to manually import the values into another eVar, or even better, is there a way to automate this process?

 

Thanks,

Suchindra

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 Jennifer_Dungan

Hi, this sounds like a perfect job for the Classification Importer.

 

Basically you would create classifications on your eVar for the information that you need to map in, then you would create mapping files based on the needed Adobe structure and import that into Adobe... every time the ID is captures the classifications will be processed (there may be some delay on the actual processing). When new IDs are created, you can upload new mapping files:

 

https://experienceleague.adobe.com/en/docs/analytics/components/classifications/classifications-importer/c-working-with-saint

2 replies

Jennifer_Dungan
Community Advisor and Adobe Champion
Jennifer_DunganCommunity Advisor and Adobe ChampionAccepted solution
Community Advisor and Adobe Champion
June 4, 2024

Hi, this sounds like a perfect job for the Classification Importer.

 

Basically you would create classifications on your eVar for the information that you need to map in, then you would create mapping files based on the needed Adobe structure and import that into Adobe... every time the ID is captures the classifications will be processed (there may be some delay on the actual processing). When new IDs are created, you can upload new mapping files:

 

https://experienceleague.adobe.com/en/docs/analytics/components/classifications/classifications-importer/c-working-with-saint

suchindraAuthor
Level 2
June 12, 2024

Hi Jennifer,

 

Thank you for your response as always.

 

I would like to use the classified value (campaign name) to map additional information about the campaign. If I use classification to obtain the campaign names, can I then use the campaign names to create further classifications? Are there options for sub-classification, or should I consider importing the values into a new eVar? 

 

Example: Campaign ID: RRT0612112 - Campaign Name: AMS_FB_AW_Q3. As you can see, the campaign name is a _ separated string of values. I have the mapping of these values as well that I want to bring into AA. In this case, AMS is the region, FB is the media platform, AW is campaign type and Q3 is the time.

 

Hope this helps explain the issue.

 

 

Jennifer_Dungan
Community Advisor and Adobe Champion
Community Advisor and Adobe Champion
June 12, 2024

Hi, so I am guessing you have 1 eVar (let's just say eVarX) for Campaign ID, and 1 eVar (let's say eVarY) for Campaign Name.

 

You can set up classifications on 1 or both of these with different rules, but it seems like the Campaign Name is where you are thinking... 

 

So in your format, you basically have [region]_[platform]_[type]_[quarter]

 

So depending on how many values you have for these, you might be able to use the Classification Rule Builder (as opposed to the Importer).

 

Basically you can set up 4 classifications on eVarY (one each for "region", "platform", "type" and "quarter").

 

Using a regex like:
/([a-zA-Z0-9]*)_(FB)_([a-zA-Z0-9]*)_([a-zA-Z0-9]*)/g

 

Then in the Rule Builder, you would map "Facebook" to your platform classification... you would need to set up a specific regex rule for each known value...

 

Or, if you just want to split your values as is, you simply use something like:
([a-zA-Z0-9]*)_([a-zA-Z0-9]*)_([a-zA-Z0-9]*)_([a-zA-Z0-9]*)

And pass group 1 ($1) into the region classification, and group 2 ($2) into the platform classification, etc....

 

 

But if you need additional information (that may not be in any of the above values, you could create a classification import on your IDs, and map each individual campaign in your eVarX classifications such as:

RRT0612112  mapped to "summer promotion" or "black friday sale" or other values that you know about your campaigns that aren't actually in the parameters that are captured, but could be useful for reporting.

gkalyan
Community Advisor and Adobe Champion
Community Advisor and Adobe Champion
June 4, 2024

@suchindra 

Try using the Adobe Analytics SAINT API to programmatically import the campaign information and map it to existing eVar values (unique campaign IDs)