Daasity Knowledge Base
Daasity Knowledge Base
  • Start here
    • Daasity Overview
    • Important Concepts
      • Attribution Overview
      • What is a Daasity Valid Order?
      • Customer Householding
      • Timezones in Daasity
      • Ecommerce Glossary
      • Daasity Data Security Overview
    • Retail Analytics 101
      • Understanding the Basics: POS Data 101
      • How to use Syndicated Data
    • Product Changelog
    • Feature Requests
  • 🔌Extract
    • Extract your data with Daasity
    • All Integrations
      • Alchemer
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Algolia
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Amazon Advertising
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Where to Find Your Data
      • Amazon Seller Central
        • Validating Your Amazon Data in Daasity
          • Comparing Your Amazon Seller Central Orders to Daasity
        • Integration Setup
          • Configure Amazon Reports
          • Monitor Amazon Reports
        • Integration Specifications
          • Orders API
          • FBA Customer Concessions Reports
          • FBA Sales Reports
          • FBA Inventory Reports
          • FBA Removals Reports
          • Inventory Reports
          • Order Tracking Reports
          • Performance Reports
          • Returns Reports
          • Settlement Reports
          • Seller Retail Analytics Reports
        • Workflow Configuration Setup
          • Orders API
          • FBA Customer Concession Reports
          • FBA Inventory Reports
          • Performance Reports
          • FBA Sales Reports
          • FBA Removal Reports
          • Inventory Reports
          • Order Tracking Reports
          • Returns Reports
          • Seller Retail Analytics Reports
          • Settlement Reports
        • Transformation Configuration Setup
          • Orders API
          • FBA Customer Concessions Reports
          • FBA Inventory Reports
          • Performance Reports
          • FBA Sales Reports
          • FBA Removals Reports
          • Inventory Reports
          • Order Tracking Reports
          • Returns Reports
          • Seller Retail Analytics Reports
          • Settlement Reports
      • Amazon Vendor Central
        • Integration Setup
        • Integration Specifications
        • How to use
        • ASIN Mapping Configuration Setup
        • Workflow Configuration Setup
        • Transformation Configuration Setup
          • Vendor Sales & Inventory Report
          • Vendor Traffic Report
      • AppLovin
        • Integration Setup
      • Attentive Mobile
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Azure SQL Database
      • Back In Stock
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Big Commerce
        • Integration Setup
          • Connect Daasity From BigCommerce Marketplace
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • BigQuery Datasource
      • Bing Ads
        • Integration Setup
        • Integration Specifications
      • Circana
        • Integration Setup
        • Integration Specifications
        • Data Release Calendar
        • H-E-B Circana
      • Cordial
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Criteo
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • D​ata File (CSV, XLS)
      • Emplifi
        • Integration Specifications
      • Extensiv (Skubana)
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Facebook Ads
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Where to Find Your Data
      • Fairing V2
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Important Notes
      • Google Ads
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Important Notes
      • Google Analytics 4
        • API vs BigQuery
        • API Integration
          • Integration Setup
          • Integration Specifications
          • Workflow Configuration Setup
          • Transformation Configuration Instructions
          • Custom Reports
          • Validating GA4 Data in Daasity
          • Blending Universal Analytics & GA4 Data
        • BigQuery integration
          • Integration Setup
          • Integration Specifications
          • Workflow Configuration Setup
          • Transformation Configuration Instructions
          • Important Notes
          • Creating a Custom Report
      • Google Sheet
      • Gorgias
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Important Notes
      • Impact Radius (Beta)
        • Integration Specifications
      • Iterable
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Klaviyo Summary Statistics
        • Integration Setup
        • Integration Specifications
      • Klaviyo V2
        • Integration Setup
        • Integration Specifications
      • KnoCommerce
        • Integration Setup
        • Integration Specifications
      • Loop Returns
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Microsoft SQL Server Database
      • Mongo Database
      • MySQL Database
      • Narvar
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • NetSuite
      • Newstore
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Northbeam
        • Integration Setup
      • Okendo
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Ometria
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Order Desk
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Pepperjam
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Pinterest
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Postgres Database
      • Postscript (beta)
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Important Notes
      • Recharge
        • Integration Setup
        • Integration Specifications
        • Integration Specifications (2021-11 Beta)
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Recharge Data and Known Discrepancies
      • Retail Next
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Rockerbox
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Salesforce Commerce Cloud
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • SFTP
      • ShipBob
        • Integration Setup
        • Integration Specifications
      • Shipstation
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Shopify
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Shopify B2B Data
      • SKIO
        • Integration Setup
        • Integration Specifications
      • Snapchat
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • SPINS
        • Integration Setup
        • Integration Specifications
        • How to Use
        • Data Release Calendar
      • Stay Ai
        • Integration Setup
        • Integration Specifications
      • Target Plus
        • Integration Setup
      • Thankful
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • TikTok
        • Integration Setup
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Walmart Marketplace
        • Integration Setup
        • Integration Specifications
      • Whole Foods Market
        • Integration Setup
        • Integration Specifications
        • How to use
      • Yotpo
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Zendesk
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
    • Brand Supplied Data (BSD)
      • BSD Overview
      • Monitoring Your BSD Progress
      • Revenue Plan
      • Marketing Budget
      • Marketing Spend
      • RFM Values
      • Shipping & Fulfillment Cost
      • SKU Hierarchy
      • SKU Mapping
      • SKU Cost
      • Discount Code Mapping
      • Other Order Sources
      • Channel Mapping
        • Overview & Setup
        • Filling out Channel Mapping
        • Missing from GA & Missing from BSD
      • Configuration
  • 📊VISUALIZE
    • Dashboards
      • Dashboard Overview
      • Standard Dashboards
        • Daasity 101 Overview Dashboards
          • Flashes
          • Shopify Sales Report
          • Account Health
        • Digital Product & Revenue
          • Orders and Revenue
          • Amazon Settlement Report
          • Product Repurchase Rate
          • Product
            • Product Dimensions
              • Why is a Product Name NULL?
          • Inventory
          • Operations
            • Fulfilment Status Options
        • Retention Marketing Dashboards
          • Notifications (Email/SMS)
          • Retention
          • Customer Performance (Email/SMS)
          • Site Funnels
        • Acquisition Marketing Dashboards
          • Attribution Deep Dive
            • Marketing Attribution
              • Attribution Overview
              • Survey-Based Attribution
              • Discount Code Attribution
              • First Click, Last Click, and Assisted Attribution
              • Custom Attribution
              • Vendor-Reported Attribution
              • CPO, CPA, and CAC
              • Missing from GA & Missing from BSD
          • LTV & RFM
            • RFM
              • RFM in the Daasity App
              • Understanding RFM
              • Time on Books (TOB)
          • Marketing
          • Vendor-Reported Marketing Performance
          • Site Analytics & Attribution
      • Integration Dashboards
        • Amazon All Orders Report
        • Amazon Seller Central Business Reports
        • Gorgias
        • Klaviyo Campaign & Flow Performance
        • Loop Returns
        • Okendo Reviews
        • ShipBob
        • Shipstation
        • Subscription
        • Walmart Marketplace Account Sales Report
        • Yotpo
    • Explores
      • Explore Overview
      • Order Line Revenue vs. Transactional Sales Report
      • How to Access An Explore
      • Standard Daasity Explores
        • Current Inventory Level Explore
        • Customer Details Explore
        • Daily Company Metrics Explore
        • Daily Marketing Plan To Actual Marketing Performance Explore
        • Daily Plan to Actual Explore
        • Lifetime Value Explore
        • Marketing Attribution Explore
        • Multi-Channel Transaction Explore
        • Order and Order Line Revenue Explore
        • Product Page Explore
        • Shopping Stage Explore
        • SKU Level Repurchase Rates Explore
        • Traffic Explore
        • Transactional Sales Report Explore
        • UA vs G4 Explore
      • Integration Explores
        • Algolia
        • Amazon Settlement Explore
        • Fairing Survey Responses Explore
        • Gorgias Tickets Explore
        • Loop Returns Explore
        • Okendo Reviews Explore
        • Subscribers and Subscription Monthly Churn Rates Explores (Recharge)
        • Shipstation Explore
        • Yotpo
        • Zen Desk
    • Looker Guides
      • Building visualizations
      • Working with date dimensions & filters
      • Schedule a Report or Dashboard
      • Exporting Data
    • Looker Guides (Developer)
      • Daasity Hub & Spoke Introduction
      • Hub & Spoke File Structure
      • Working with LookML Dashboards
      • Customizing Base Daasity Code
    • Visualize using other BI tools
  • 🔀Transform
    • Transforming Data with Daasity
    • Daasity Data Models
      • Daasity Data Model Overview
      • Unified Data Schemas
        • Unified Schema Introduction
        • Unified Order Schema (UOS)
        • Unified Notification Schema (UNS)
        • Unified Subscription Schema (USS)
        • Unified Marketing Schema (UMS)
        • Unified Traffic Schema (UTS)
        • Unified Wholesale Schema (UWS)
      • Data Mart Models
        • Data Mart Introduction
        • Data Reporting Platform (DRP)
        • Channel Attribution Data Mart
        • Marketing Data Mart
      • Transform Code
        • Transform Code Introduction
        • Transform Code Sequence - DRP
        • Initialization Code
        • Householding Code
        • Order Status Code
        • Order Channel and Marketing Code
        • Daily Plan Code
        • Order and Order Line Revenue
        • Plan to Actual Code
        • Customer Code
        • Subscription Code
        • Reviews
        • Life-Time Value Code
        • Returns
        • Product and Inventory Code
        • Email & SMS
        • Transform Code Sequence - Data Mart
        • Unified Order Schema (UOS) Code
        • Unified Marketing Schema (UMS) Code
        • Unified Notification Schema (UNS)
        • Channel Attribution Data Mart Code
        • Marketing Data Mart Code
      • Source to Final Destination
    • Code Repository
      • Code Repository Overview
      • Getting Access to Your Code Repository
      • Code Repository Branches
      • Custom SQL Code
      • Custom Script Manifest Files
    • Script Manifest (YAML) Files
  • 🎵Data Orchestration
    • Workflows
      • Getting Started with Workflows
      • Creating Workflows
      • Managing Workflows
      • Workflow Metrics
    • Notifications
      • Introduction to Notifications
      • Enabling Notification Emails
      • Notifications UI
      • Managing Notifications
      • Authorization List
  • Audiences
    • Audiences Overview
    • Pushing Audience Data to Targets
      • Targets Overview
      • Attentive
        • Events Target
        • Subscribers Target
        • Target Endpoint Documentation
      • Facebook Ads
        • Facebook Target
        • Target Endpoint Documentation
      • Google Ads
        • Google Ads Target
        • Target Endpoint Documentation
      • Klaviyo
        • Events Target
        • Profiles Target
        • Target Endpoint Documentation
      • Sailthru
        • Events Target
        • Users Target
        • Target Endpoint Documentation
      • Tiktok Ads
        • TikTok Target
        • Target Endpoint Documentation
    • Building Audiences
  • warehouse
    • BigQuery
    • Redshift
    • Snowflake
    • Test Data Warehouse
      • Test Data Warehouse Overview
      • Create a Snowflake Test Warehouse
      • Create a Redshift Test Warehouse
  • —
    • Go to Daasity App
    • Contact Support
    • ✍️Feature Requests
Powered by GitBook
On this page
  • Overview
  • Unified Subscription Schema Tables
  • Order Line Items
  • Orders
  • Subscription Lines
  • Subscriptions

Was this helpful?

  1. Transform
  2. Daasity Data Models
  3. Unified Data Schemas

Unified Subscription Schema (USS)

This page provides a detailed description of the Unified Subscription Schema (USS) within the Daasity Data Model and defines each table and column in this schema

PreviousUnified Notification Schema (UNS)NextUnified Marketing Schema (UMS)

Last updated 9 months ago

Was this helpful?

Overview

The purpose of the Unified Subscription Schema is to normalize and load data from various subscription platforms into a single set of tables. From USS, other scripts will push that data down into other tables that can be used for analyzing your subscription business.

Unified Subscription Schema Tables

Order Line Items

Purpose: Normalizes order-line-level data from multiple subscription platforms into a single table

Table Name: uss.order_line_items

Related transform code:

Column
Description

SUBSCRIPTION_ORDER_LINE_ID🔑

MD5 of platform identifier, order ID, and line ID

SOURCE_ORDER_LINE_ID

Line ID from the source

SUBSCRIPTION_ORDER_ID

MD5 of the platform identifier and order ID

SUBSCRIPTION_ID

MD5 of the platform identifier and subscription ID

CUSTOMER_ID

MD5 of the platform identifier and customer ID

SOURCE_PRODUCT_ID

Product ID from the source

PRODUCT_TITLE

Product title from the source

SOURCE_VARIANT_ID

Variant ID from the source

VARIANT_TITLE

Variant title from the source

SKU

SKU value from the source

UNIT_PRICE

Unit price from the source. May be a calculation, depending on source

QUANTITY

Quantity ordered from the source

IS_ONETIME

Flag indicating if the product is a recurring product purchase or a one-time add-on

CUSTOM_ATTRIBUTES

Custom attributes from the source system

PLATFORM

Identifier for the source platform

__LOADED_AT

UTC timestamp of when this data was transformed from the source table into this table

__SYNCED_AT

UTC timestamp of when this data was loaded from the external source into the database

Orders

Purpose: Normalizes order metadata from multiple subscription platforms into a single table

Table Name: uss.orders

Related transform code:

Column
Description

SUBSCRIPTION_ORDER_ID🔑

MD5 of the platform identifier and order ID

SOURCE_ORDER_ID

Order ID from the source

SUBSCRIPTION_ID

MD5 of the platform identifier and subscription ID

CREATED_AT

Timestamp of when the order was created. This is converted into the Daasity account timezone

UPDATED_AT

Timestamp of when the order was last updated. This is converted into the Daasity account timezone

CUSTOMER_ID

MD5 of the platform identifier and customer ID

CHARGE_STATUS

Status of the charge for this order

CURRENCY

Currency code from the source system

STATUS

Status from the source system

TYPE

Indicates whether the order is recurring or placed on the site

TAGS

Order tags

TOTAL_PRICE

Total price of the order

TOTAL_DISCOUNTS

Total discount amount for the order

TOTAL_SHIPPING_PRICE

Total shipping amount for the order

TOTAL_TAX

Total tax amount for the order

ADDRESS_CITY

Billing/delivery address city

ADDRESS_COUNTRY

Billing/delivery address country

ADDRESS_COUNTRY_CODE

Billing/delivery address country code

ADDRESS_FIRST_NAME

Billing/delivery address first name

ADDRESS_LAST_NAME

Billing/delivery address last name

ADDRESS_LINE_1

Billing/delivery address line 1

ADDRESS_LINE_2

Billing/delivery address line 2

ADDRESS_PROVINCE_CODE

Billing/delivery address province code

ADDRESS_ZIP

Billing/delivery address ZIP code

PLATFORM

Identifier for the source platform

__LOADED_AT

UTC timestamp of when this data was transformed from the source table into this table

__SYNCED_AT

UTC timestamp of when this data was loaded from the external source into the database

Subscription Lines

Purpose: Normalizes subscription-line-level data from multiple subscription platforms into a single table

Table Name: uss.subscription_lines

Related transform code:

Column
Description

SUBSCRIPTION_LINE_ID🔑

MD5 of the platform identifier and the source subscription line ID

SOURCE_SUBSCRIPTION_LINE_ID

Subscription line ID from the source system

SUBSCRIPTION_ID

MD5 of the platform identifier and the source subscription ID

CUSTOMER_ID

MD5 of the platform identifier and the source customer ID

IS_PREPAID

Indicates whether the subscription line is prepaid

SOURCE_PRODUCT_ID

Product ID from the source system

PRODUCT_TITLE

Product title from the source system

QUANTITY

Quantity for the subscription line

SKU

SKU from the source system

UNIT_PRICE

Unit price for the subscription line

SUBTOTAL_PRICE

Subtotal for the subscription line

SOURCE_VARIANT_ID

Variant ID from the source system

VARIANT_TITLE

Variant title from the source system

PLATFORM

Identifier for the source platform

__LOADED_AT

UTC timestamp of when this data was transformed from the source table into this table

__SYNCED_AT

UTC timestamp of when this data was loaded from the external source into the database

Subscriptions

Purpose: Normalizes subscription metadata from multiple subscription platforms into a single table

Table Name: uss.subscriptions

Related transform code:

Column
Description

SUBSCRIPTION_ID🔑

MD5 of the platform identifier and the source subscription ID

SOURCE_SUBSCRIPTION_ID

Subscription ID from the source system

CREATED_AT

Timestamp of when the subscription was created. This is converted into your Daasity account timezone

UPDATED_AT

Timestamp of when the subscription was last updated. This is converted into your Daasity account timezone

PAUSED_AT

Timestamp of when the subscription was paused. This is converted into your Daasity account timezone

PAUSED_UNTIL

Timestamp of when the subscription is paused until. This is converted into your Daasity account timezone

CHURNED_AT

Timestamp of when the subscription was cancelled. This is converted into your Daasity account timezone

CANCELLED_AT

Timestamp of when the subscription was cancelled. This is converted into your Daasity account timezone

CANCELLATION_REASON

Reason from the source system of why the subscription was cancelled

CANCELLATION_REASON_COMMENTS

Additional information from the source system of why the subscription was cancelled

CUSTOMER_ID

MD5 of the platform identifier and the customer ID from the source system

SOURCE_CUSTOMER_ID

Customer ID from the source system

EMAIL_ADDRESS

Email address of the subscriber

FIRST_NAME

First name of the subscriber

LAST_NAME

Last name of the subscriber

DELIVERY_ADDRESS_LINE_1

Delivery address line 1 from the source system

DELIVERY_ADDRESS_LINE_2

Delivery address line 2 from the source system

DELIVERY_ADDRESS_ID

Address ID from the source system

DELIVERY_ADDRESS_CITY

Delivery address city from the source system

DELIVERY_ADDRESS_COMPANY

Delivery address company from the source system

DELIVERY_ADDRESS_COUNTRY_CODE

Delivery address country code from the source system

DELIVERY_ADDRESS_PHONE

Delivery phone number from the source system

DELIVERY_ADDRESS_PROVINCE

Delivery address province from the source system

DELIVERY_ADDRESS_ZIP

Delivery address ZIP Code from the source system

DELIVERY_PRICE

Cost to the consumer for delivering the order

DUNNING_STARTED_AT

Timestamp of when the subscription entered dunning. This is converted into your Daasity account timezone

DUNNING_STORY_ID

Dunning story ID from the source system

DUNNING_EXITED_AT

Timestamp of when the subscription exited dunning. This is converted into your Daasity account timezone

LAST_CHARGE_DATE

Timestamp of when the last charge was made related to the subscription. This is converted into your Daasity account timezone

NEXT_CHARGE_DATE

Timestamp of when the next charge will be made for this subscription. This is converted into your Daasity account timezone

IS_SKIPPABLE

Indicates whether the subscription can be skipped

IS_SWAPPABLE

Indicates whether products in the subscription can be swapped out

CURRENCY

Currency for the dollar values for this order

PRICE

Price of the subscription

NOTE

Note for the subscription

ORDER_DAY_OF_MONTH

Scheduled day of the month for this order

ORDER_DAY_OF_WEEK

Scheduled day of the week for this order

ORDER_INTERVAL_FREQUENCY

How often the subscription is fulfilled

ORDER_INTERVAL_UNIT

How often the subscription is fulfilled

STATUS

Indicates whether the subscription is cancelled, paused, or active

STATUS_CONTEXT

Additional context for the status

PLATFORM

Identifier for the source platform

__LOADED_AT

UTC timestamp of when this data was transformed from the source table into this table

__SYNCED_AT

UTC timestamp of when this data was loaded from the external source into the database

[uss.order_line_items]

[uss.orders]

[uss.subscription_lines]

[uss.subscriptions]

🔀
Amazon
SKIO
Stay Ai
Amazon
SKIO
Stay Ai
SKIO
Stay Ai
SKIO
Stay Ai
Order Line Items
Orders
Subscription Lines
Subscriptions