This article will help you learn about the fields available in the Customer Info view, the field types, descriptions and how the fields are calculated
Key Topics
Click on the links below to take you to the section where you can learn more about this View and where it is used and how it is created
View Definition
This view is linked to the [drp.customers] table which is generated as part of the Daasity transformation process and has the following fields available/visible for use.
Field Name | Field Type | Description | Source / Calculation |
Customer Created Date | Dimension Group | The date in the Order Source system that the customer account was created | created_at |
Address Line 1 | Dimension | Street address provided from Order Source system of Customer | address1 |
Address Line 2 | Dimension | Optional second line of street address provided from Order Source system of Customer | address2 |
City | Dimension | City or town of Customer address provided by Order Source system | city |
Company | Dimension | Company field of Customer address provided by Order Source system | company |
Country | Dimension | Country of Customer address provided by Order Source system | country |
Country Code | Dimension | Country Code of Customer address provided by Order Source system | country_code |
Phone Number | Dimension | Customer phone number provided by Order Source system | phone_number |
State | Dimension | State of Customer address provided by Order Source system | state |
State Code | Dimension | Two letter state code of Customer address provided by Order Source system | state_code |
Zip Code (5 Digits) | Dimension | Zip Code of Customer Address provided by Order Source system | LEFT(zipcode,5) |
Customer Account Status | Dimension | Customer account status from Order Source system. Possible fields are: Enabled, Disabled, Invited, Declined or Null | customer_account_status |
Customer Gender | Dimension | The customer's gender | gender |
Customer Gender Accuracy | Dimension | The probability that the Gender is correct. Gender is determined by matching to public records at the Name/Country level | gender_accuracy |
Customer Notes | Dimension | Notes field related to customer provided by Order Source system | customer_notes |
Customer Tags | Dimension | Tags from Customer Profile of Order Source system | customer_tags |
Email Address | Dimension | email address from Order Source system | |
First Name | Dimension | Customer First Name associated with customer account of Order Source system | first_name |
Has Made Valid Order Flag | Dimension | if the customer has ever made a valid purchase. Valid purchases are orders with statuses:Full Payment,Partially Refunded,Refunded,Partial Gift Card Usage,Gift Card Usage,Partial Gift Card Purchase | has_made_valid_order_flag |
Has Purchased Flag | Dimension | Indicates if the customer has ever made a purchase greater than zero dollars | has_purchased_flag |
Last Name | Dimension | Customer Last Name associated with customer account of Order Source system | last_name |
Store Customer ID | Dimension | The ID of the Customer in the Source System | store_customer_id |
Store Name | Dimension | The store name from the Daasity App integration setup page where the Customer record originated | store_name |
Verified Email Flag | Dimension | Verified Email Flag: F, T or NULL from the Order Source system | verified_email |
Explores
This view is part of the following explores:
- Customer Details
- Lifetime Value
- Email Campaign Performance Details
- Order & Order Line Revenue
- Transactional Sales Report
Transformation Code
This view is a Daasity derived table generated by the following code:
- [4610_CUS_BAS_customers.sql]