customer_property_primary
- Sylvain Paillard
Description
This table contains information about the performance of each customer property and value for each month.
The month column is a date field always set with the first day of the month.
Granularity
one row per:
month
customer property name
customer property value
Columns
Field name | Type | Mode | Description |
|---|---|---|---|
property_name | STRING | NULLABLE | PRIMARY DIMENSION - MUST BE SET TO AVOID OVERCOUNT - the customer property name |
property_label | STRING | NULLABLE | the customer property label (property_label should have easy to read values while property_name might have technical values) |
property_value | STRING | NULLABLE | PRIMARY DIMENSION - MUST BE SET TO AVOID OVERCOUNT - the customer property value |
property_value_label | STRING | NULLABLE | the customer property value label (property_value should have easy to read values while property_value_label might have technical values) |
day | DATE | NULLABLE | PRIMARY DIMENSION - first day of the month |
customers | INTEGER | NULLABLE | the number of customers who made a purchase that month and have that customer property name and value |
user_personas | INTEGER | NULLABLE | the number of user personas (2 in case the same customer used 2 different accounts) |
visitor_personas | INTEGER | NULLABLE | the number of visitor personas (correspond to the number of identified visitors (identification based on a login / tagged url in any of the visitor’s sessions), (e.g.: two sessions with flushing the cookies in between, or from two different devices will count as 2) |
orders | INTEGER | NULLABLE | the number of orders for these customers that month |
order_products | INTEGER | NULLABLE | the number of product in the orders for these customers that month |
order_qty | INTEGER | NULLABLE | the total quantity of products in the orders for these customers that month |
list_crncy_amt | FLOAT | NULLABLE | the total value of the products list price (product price before discounts) for these customers that month |
discount_crncy_amt | FLOAT | NULLABLE | the total value of the products final price (product price after discounts) for these customers that month |
total_crncy_amt | FLOAT | NULLABLE | the total value of the orders for these customers that month |
total_margin_crncy_amt | FLOAT | NULLABLE | the total margin value of the orders for these customers that month |
sessions | INTEGER | NULLABLE | the number of identified sessions (identification based on a login / tagged url in any of the visitor’s sessions) |
customer_owners | STRING | REPEATED | the customers owners (not active by default, you can define filter rules to connect products to customer owners (e.g.: suppliers) which you want to be able to select independently or in combination to the selection of any product or product property). The customer owners are a derived form of the product owners. A product might belong to a product owner, but a specific purchase of this product might not be connected to the related customer owner, as, an additional rule applies (e.g.: the customer must have bought at least twice in the last 6 months a product of this product owners to be considered connected to the related customer owner). |
account | STRING | NULLABLE | the account name (typically same for all orders with the value ‘main’) |
parameters | RECORD | REPEATED | general structure of parameters and values (in this table, it will mainly contain the key order properties) |
parameters. name | STRING | NULLABLE | Name of the property |
parameters. value | STRING | NULLABLE | Value of the property |