DataSource only insert rows that has a match on transaction ID

Avatar

Avatar
Validate 1
Level 1
M_Schoenmakers
Level 1

Like

1 like

Total Posts

2 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 1
Applaud 5
View profile

Avatar
Validate 1
Level 1
M_Schoenmakers
Level 1

Like

1 like

Total Posts

2 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 1
Applaud 5
View profile
M_Schoenmakers
Level 1

23-04-2018

We would like to setup a DataSource import using transactionID to import offline transaction into a reportsuite.

But the import file also contains records of transaction on products that belong to a different business unit which uses their own reportsuite.

Therefore we would like to import ONLY those rules from the file that have an transactionid that is also recorded during a visit in the reportsuite.

Is this possible directly from within Adobe Analytics?


Or is the only option to build a script that first retrieves all transactionid values from Adobe using the API and filters the original import file based on these before uploading it to the data source import?

Glad to hear what's possible

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Coach
Employee
Gigazelle
Employee

Likes

473 likes

Total Posts

1,947 posts

Correct reply

740 solutions
Top badges earned
Coach
Contributor 2
Validate 1
Ignite 80
Ignite 70
View profile

Avatar
Coach
Employee
Gigazelle
Employee

Likes

473 likes

Total Posts

1,947 posts

Correct reply

740 solutions
Top badges earned
Coach
Contributor 2
Validate 1
Ignite 80
Ignite 70
View profile
Gigazelle
Employee

30-04-2018

This most definitely isn't possible using Analytics alone. Adobe takes all the values in the file and attempts to process them, so you're going to get everything if you upload the file as-is.

If you're able to sanitize the file yourself using an automated process, that could work. Adobe also offers professional services that could certainly help establish an ideal workflow for you. If you'd like to pursue that route, you'd want to get in touch with your account manager.

Answers (0)