Views
      Back to home
      1. Help Center
      2. Daasity Platform | Business User Analytics
      3. Views

      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]