Import store sales in Adobe Analytics | Community
Skip to main content
Benoit_Augard
Benoit_Augard
Level 2
February 12, 2020
Solved

Import store sales in Adobe Analytics

  • February 12, 2020
  • 1 reply
  • 6454 views

Hi everybody,

 

I'm working for a retail company and I would like to import store sales from our customer whose have bought with their fidelity card but without any real actions on our website except visits. 

I'm actually following visitor whose have a loyality card on our website (with a cookie) and I could easily export sales form our stores with this same ID as a key.

I know the customer journey and I want to associate this journey with sales by using a data import but I don't know how to do this because a same ID could make more than on transaction in store.

 

Do you have any ideas to do this ? How sore sales could be incrementals ? 

 

Thanks for you help

 

Best regards

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 Pablo_Childe

you will need to handle in 2 parts.

 

1 make a variable like an evar for the user ID maybe also transaction ID.

 

then use SAINT uploads to make secondary categorizations of such users. very very powerful and allows all sorts of down stream reporting.

 

https://docs.adobe.com/content/help/en/analytics/components/classifications/classifications-importer/c-saint-data-files.html

1 reply

Pablo_Childe
Community Advisor
Pablo_ChildeCommunity AdvisorAccepted solution
Community Advisor
February 12, 2020

you will need to handle in 2 parts.

 

1 make a variable like an evar for the user ID maybe also transaction ID.

 

then use SAINT uploads to make secondary categorizations of such users. very very powerful and allows all sorts of down stream reporting.

 

https://docs.adobe.com/content/help/en/analytics/components/classifications/classifications-importer/c-saint-data-files.html

Benoit_Augard
Benoit_AugardAuthor
Level 2
February 13, 2020

Hi pabloc82923542,

 

Thank you for your answer

 

I've already put the key (email in SHA 256) in an evar.

 

The principal issue is that il my classification, which will be send every day, I could have severals lines with the same key and also severals lines with the same key in differents files

 

The data inside the file will be :

Email | date | amount_excl_tax | Amount_incl_tax | store_id

 

So my question is, how to be sure that all my data will be aggregated per every key.

 

For exemple if a customer has bough in store on differents date (01/12/2019, 10/12/2019, 31/12/2019)
I want to see on Analytics for an specific key:

from 01/12 to 09/12 : 1 sale and 10 €

from 01 to 15 : 2 sales and 30€

for decembre 2019 : 3 sales and 100€

 


Best regards

 

And sorry for my english 🙂

Terms & ConditionsAccessibility statement

Loading footer...