Expand my Community achievements bar.

Join us at Adobe Summit 2024 for the Coffee Break Q&A Live series, a unique opportunity to network with and learn from expert users, the Adobe product team, and Adobe partners in a small group, 30 minute AMA conversations.

Pulling in external data to Analytics Workspace

Avatar

Level 2

Question.
We are currently feeding some data into Adobe Analytics from website activity.

Our stakeholders are using Adobe Analytics Workspace to view that activity results.

They would like to see some 'related (linked) data' within the Analytics Workspace reports.

 

With the above being said - is it possible to 'link' external data (ie: from say a SQL Server database) within some of the workspace reports w/o having that data initially injected into Adobe Analytics?

For example.
If we have a separate database of the following:
ID: {value 1,2,3,etc}
User: {values of 'Jim','Jon','Jane',etc}

And we are tracking the ID value within Adobe Analytics from the website.. (ie: 1).
Within the reports, could we map the AA values and link/map those to the external database so that we can show that ID 1 'Jim' was accessing the site?
(or do we need to also inject 'Jim' along with his ID value into AA upfront?)

Any info appreciated. 

 

3 Replies

Avatar

Level 4

Yes you can use Adobe SAINT Classifications if you are passing a key and just need values to attach to it.

 

You can learn more about it here: https://experienceleague.adobe.com/docs/analytics/components/classifications/c-classifications.html?...

Here's an example of how you can upload data files: https://experienceleague.adobe.com/docs/analytics/components/classifications/classifications-importe...

 

Avatar

Community Advisor

You could also look into Customer Attributes:

 

https://experienceleague.adobe.com/docs/core-services/interface/services/customer-attributes/attribu...

 

This existed long before Target, where if you are tracking a user ID, you can map external user information into the attributes and use it in your reporting.

Avatar

Level 2

Thank you both.  We will look into each of these options!