Integrations

.CSV

Unify customer history, inventory or any kind of data from a .CSV file on your Datagran dashboard to leverage it with our tools to visualize, analyze, predict, collaborate and much more.

A comma-separated values (CSV) file is a delimited text file that uses a comma to separate values. It is used to store tabular data (numbers and text) in plain text. Each line of the file is a data record. Each record consists of one or more fields, separated by commas

From the main dashboard

  • Go to Menu.
  • Each order records a Head over to Integrations.
  • Choose Data Sources and then click on .CSV File as the data source to integrate.
  • Once ready to upload a .CSV file, follow the instructions on the form.

Watch the step by step process

Fields Supported for Processing:

FIELD NAME

DESCRIPTION

1. Invoice

Unique ID for each order

2. Channel

Where was the purchase made. Offline or online channel

3. Name

Customer name

4. Email

Customer email

5. Gender

Customer gender

6. Product ID

ID of purchased product

7. Product vertical

Vertical of purchased product

8. Product subcategory

Subcategory of purchased product

9. Product price

Price of purchased product

FIELD NAME

DESCRIPTION

10. Date*

Date of purchase

11. Customer ID*

Unique ID for each customer

12. Last name

Customer last name

13. Phone**

Customer phone

14. Birth

Customer date of birth

15. Product name

Name of purchased product

16. Product category

Category of purchased product

17. Product brand

Brand of purchased product

18. Product Qty

Quality of purchased product

FIELD NAME

DESCRIPTION

19. Total product

Purchase price value. Usually, Price by Qty

20. Country

Purchase country

21. State

Purchase state

22. City

Purchase city

23. Neighborhood

Purchase neighborhood

24. Postal code

Purchase postal code

25. Latitude

Purchased latitude

26. Longitude

Purchased longitude

* Required
    
** At least one of both (phone and email) is required