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.
SOLVED

Import data from another source into Adobe Analytics

Avatar

Level 1

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? 

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

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.

View solution in original post

5 Replies

Avatar

Level 10

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. 

Avatar

Correct answer by
Employee Advisor

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.

Avatar

Level 2

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

Avatar

Employee Advisor

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.

Avatar

Level 2

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.