Import data from another source into Adobe Analytics | Community
Skip to main content
dougr58854540
dougr58854540
March 7, 2017
Solved

Import data from another source into Adobe Analytics

  • March 7, 2017
  • 5 replies
  • 6866 views

I’m trying to tie data from another product with my data inside of Adobe Analytics. 
We have Adobe Analytics javascript on our website collecting data and we use a third party tool to track how users interact with certain parts of the website. We’re trying to use the Adobe API to tie the data together.

So far we’ve gone down the path of using the Data Insertion API, but it wasn’t quite right as it’s meant to be used as a replacement for the JS, from what I can tell. 

We also explored using the Data Sources API. Now the documentation for this suggests you can use a transaction ID to tie offline data with the data collected from the JS, we’ve tried this and it doesn’t match the data up. We’re now exploring using Visitor ID to tie the sessions together but we’re having problems uploading any rows with the Visitor ID column, Adobe just returns the error “Column header: ‘visitorid’ is not a valid column header”. We’ve tried several different variations of visitor id, such as “visitor_id”, “visitor-id”, “vistor id”, etc and still no luck.

The end goal is for us to be able to upload data to Adobe that will update/add eVars for already existing sessions earlier that day. How would I go about doing this? Is there something I'm missing or doing wrong? 

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 Gigazelle

Hi Doug,

Ultimately what you'll want to do is use standard data sources (not the API) and transactionID.

Data Sources documentation can be found here: https://marketing.adobe.com/resources/help/en_US/sc/datasources/

Information on transactionID can be found here: https://marketing.adobe.com/resources/help/en_US/sc/datasources/datasrc_tid_visitor_profile.html

Basically the workflow is the following:

  1. User comes to your site, reaches a point where you want to tie online/offline data together
  2. At this point you define the transactionID variable.
  3. In your third party system, you use that transactionID variable to identify that same user with their actions outside the site
  4. Once that data is collected, use Data Sources to upload the file to an FTP site, where Adobe Analytics pulls the data, processes it into your report suite, and ties matching transactionID data together into the same visit.

5 replies

TanmayMathur
Adobe Employee
TanmayMathurAdobe Employee
Adobe Employee
March 27, 2017

Hi Doug,

Welcome to the Analytics Community. It would be great if you could introduce yourself here.

I asked internally about this and got the information that for Visitor ID in Data Sources, Visitor ID Data Sources type doesn't work. If the you want to use Visitor ID, either select *Generic > Full Processing*  type or *Leads and Quotes > Call Center Data*.

I have also asked an expert to look into your clientcare ticket about the same as well. Feel free to ask further questions.

Thanks. 

Gigazelle
Adobe Employee
GigazelleAdobe EmployeeAccepted solution
Adobe Employee
March 27, 2017

Hi Doug,

Ultimately what you'll want to do is use standard data sources (not the API) and transactionID.

Data Sources documentation can be found here: https://marketing.adobe.com/resources/help/en_US/sc/datasources/

Information on transactionID can be found here: https://marketing.adobe.com/resources/help/en_US/sc/datasources/datasrc_tid_visitor_profile.html

Basically the workflow is the following:

  1. User comes to your site, reaches a point where you want to tie online/offline data together
  2. At this point you define the transactionID variable.
  3. In your third party system, you use that transactionID variable to identify that same user with their actions outside the site
  4. Once that data is collected, use Data Sources to upload the file to an FTP site, where Adobe Analytics pulls the data, processes it into your report suite, and ties matching transactionID data together into the same visit.
samfono
samfono
Level 3
January 28, 2019

Any luck going down this path? I created a "Leads and Quotes > Call Center Data" data source and have not been able to get this to work. Here is what I have done:

1) Created an Evar for the offline conversion

2) Created an Event for the offline conversion metric

3) Included the Evar and Event in the data source

4) Uploaded data to the data source using legacy visitor id

5) Uploaded data to the data source using MCMID

Gigazelle
Adobe Employee
GigazelleAdobe Employee
Adobe Employee
January 28, 2019

Hi Sam, have you gone the transaction ID route? If you intend to directly tie online/offline data together, you will want to use transaction ID's. If you don't need online/offline directly tied to the same visitors, you can simply use data sources without transaction ID's.

samfono
samfono
Level 3
January 29, 2019

Thanks Gigazelle - I ended up writing the MCMID into the s.visitorID variable and this did the trick. Still ended up using the "Leads and Quotes > Call Center Data" data source type.

Terms & ConditionsAccessibility statement

Loading footer...