# Data Schema Reference

This document provides a detailed reference for the data schema used by the ConversionFlow library. The data is sourced from two main files: `backend_all_leads.csv` and `ga4_selected_events_leads.csv`.

## `backend_all_leads.csv`

This file contains data from the lead database.

| Column                      | Type      | Description                                                                                             |
| --------------------------- | --------- | ------------------------------------------------------------------------------------------------------- |
| `USER_PSEUDO_ID`            | `string`  | Unique user identifier, used to link to GA4 data.                                                       |
| `SID`                       | `string`  | Internal session ID of the backend.                                                                     |
| `BRAND`                     | `string`  | The brand of the car.                                                                                   |
| `MODELNAME`                 | `string`  | The model name of the car.                                                                              |
| `MODELCODE`                 | `string`  | Internal abbreviation for the model name.                                                               |
| `SALES_FUNNEL`              | `string`  | Lead status selected by the retailer (`In Progress`, `Lost`, `ClosedSuccessfully`).                     |
| `MAINLEADTYPE`              | `string`  | The type of lead (e.g., `OfferRequest`, `Testdrive`).                                                   |
| `LEADCATEGORY`              | `string`  | The category of the lead (e.g., `Newcar`, `Usedcar`).                                                   |
| `LEAD_JOURNEY_START`        | `datetime`| The timestamp when the user accessed the website with the forms.                                        |
| `LEAD_TRANSFERRED`          | `datetime`| The timestamp when the lead was transferred to the retailer system.                                     |
| `GA4_EVENT_TIMESTAMP`       | `datetime`| The timestamp of the GA4 session in which the user submitted a form.                                    |
| `GA4_HOSTNAME`              | `string`  | The hostname of the GA4 session.                                                                        |
| `GA4_DEVICE_CATEGORY`       | `string`  | The device category of the GA4 session.                                                                 |
| `GA4_SOURCE`                | `string`  | The session source of the GA4 session.                                                                  |
| `GA4_MEDIUM`                | `string`  | The session medium of the GA4 session.                                                                  |
| `GA4_SESSION_CHANNEL_GROUP` | `string`  | The session default channel group of the GA4 session.                                                   |

## `ga4_selected_events_leads.csv`

This file contains Google Analytics 4 (GA4) data for users who submitted a lead form.

| Column                | Type      | Description                                                                                             |
| --------------------- | --------- | ------------------------------------------------------------------------------------------------------- |
| `EVENT_TIMESTAMP`     | `datetime`| The timestamp of the event.                                                                             |
| `USER_PSEUDO_ID`      | `string`  | Unique user identifier, used to link to the lead data.                                                  |
| `SESSION_ID`          | `string`  | A unique session identifier, composed of `USER_PSEUDO_ID` and `GA_SESSION_ID`.                          |
| `GA_SESSION_ID`       | `string`  | The original GA4 session ID.                                                                            |
| `EVENT_NAME`          | `string`  | The name of the GA4 event (e.g., `session_start`, `car_configuration`).                                 |
| `PAGE_LOCATION`       | `string`  | The URL of the page where the event occurred.                                                           |
| `MODEL_NAME`          | `string`  | The model name of the car associated with the event.                                                    |
| `MODEL_ID`            | `string`  | Internal abbreviation for the model name.                                                               |
| `FORM_NAME`           | `string`  | The name of the form associated with the event.                                                         |
| `FORM_STEP`           | `string`  | The step in the form associated with the event.                                                         |
| `FORM_CONVERSION`     | `int`     | A binary flag (0 or 1) indicating if the form was converted.                                            |
| `FLOW_NAME`           | `string`  | The name of the flow associated with the event.                                                         |
| `FLOW_STEP`           | `string`  | The step in the flow associated with the event.                                                         |
| `FLOW_CONVERSION`     | `int`     | A binary flag (0 or 1) indicating if the flow was converted.                                            |
| `CAMPAIGN_NAME`       | `string`  | The name of the marketing campaign.                                                                     |
| `MEDIUM`              | `string`  | The marketing medium.                                                                                   |
| `SOURCE`              | `string`  | The marketing source.                                                                                   |
| `HOSTNAME`            | `string`  | The hostname where the event occurred.                                                                  |
| `DEVICE_CATEGORY`     | `string`  | The category of the device used.                                                                        |
| `SESSION_CHANNEL_GROUP` | `string`  | The default channel group for the session.                                                              |