View: Customer Info

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 email
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]