MDW CRM Table Spec: crm_user_rollup_v2
crm_user_rollup_v2
Term | Definition | Datatype |
brand_id | Brand ID for the client | int4 |
source | Represents the source of data | varchar(1000) |
conversion_type | Conversion type defined when while onboarding client | varchar(500) |
transaction_funnel | Indicates where the user belongs | varchar(500) |
city | User city from the transaction data | varchar(1000) |
state | User state from the transaction data | varchar(500) |
zip | User zip from the transaction data | varchar(200) |
country | User country from the transaction data | varchar(500) |
email_optin | Map user email data if opted in | bool |
sms_optin | Map user phone number data if opted in | bool |
users | Total number of users for the client | int4 |
conversions | Total number of conversions for the client | float8 |
revenue | Total revenue | float8 |
induction_recency | Calculated based on first order date | varchar(500) |
recency | The most recent purchase band for that user | varchar(500) |
frequency | The frequency band based on the conversions for the user | varchar(500) |
average_monetary | The monetary band based on the average order value for the user | varchar(500) |
total_monetary | Total monetary band based on the total revenue for the user | varchar(500) |
has_mailing_address | Indicates if the user has a mailing address | bool |
has_email | Indicates if the user has an email | bool |
has_phone | Indicates if the user has a phone | bool |
custom_dimen_1 | Used to pull in custom data sources for experiments | varchar(5000) |
custom_dimen_2 | Used to pull in custom data sources for experiments | varchar(5000) |
custom_dimen_3 | Used to pull in custom data sources for experiments | varchar(5000) |
custom_dimen_4 | Used to pull in custom data sources for experiments | varchar(5000) |
custom_dimen_5 | Used to pull in custom data sources for experiments | varchar(5000) |
