When uploading a CSV file in Revlitix, you’ll need to map each column to a corresponding data type. Choosing the correct type ensures accurate reporting and data analysis.

Below are the data types for CSV Integration, and when you can use them:

Use when: The column contains positive or negative numeric values.

Examples: 1, 5, 100, -2

Use cases: Number of Clicks, Page Views

Use when: The column contains numbers with decimal points.

Examples: 2.5, 99.99, 0.75, -3.75

Use cases: Conversion Rate, Cost per Click

Use when: The column contains text values.

Examples: Campaign Name, Facebook Ads, March Launch

Use cases: Campaign Type, Platform Name

Use when: The column contains true/false values.

Examples: true, false

Use cases: Is Campaign Active?, Is Converted?

Note: Values must be lowercase string versions: true or false.

Use when: The column contains date values.

Supported formats:

Use cases: Campaign Start Date, Reported On

Make sure all entries in the column follow the same date format.

Use when: The column contains time durations.

Supported formats:

Use cases: Time Spent on Page, Average Session Duration

Only use this data type if all values match one of the above formats.