Pulling in external data to Analytics Workspace | Community
Skip to main content
Level 2
March 31, 2023
Solved

Pulling in external data to Analytics Workspace

  • March 31, 2023
  • 3 replies
  • 1078 views

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. 

 

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 franzli

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?lang=en

Here's an example of how you can upload data files: https://experienceleague.adobe.com/docs/analytics/components/classifications/classifications-importer/c-saint-data-files.html?lang=en

 

3 replies

franzli
franzliAccepted solution
Level 4
March 31, 2023

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?lang=en

Here's an example of how you can upload data files: https://experienceleague.adobe.com/docs/analytics/components/classifications/classifications-importer/c-saint-data-files.html?lang=en

 

Jennifer_Dungan
Community Advisor and Adobe Champion
Community Advisor and Adobe Champion
April 2, 2023

You could also look into Customer Attributes:

 

https://experienceleague.adobe.com/docs/core-services/interface/services/customer-attributes/attributes.html?lang=en

 

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.

JasonTr7Author
Level 2
April 3, 2023

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