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
    • 🎉 Community Forum
    • ✍️ Feature Requests
  • 🔌Extract
    • Extract your data with Daasity
    • All Integrations
      • AppLovin (Beta)
        • Integration Setup
      • 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
      • Aspire IQ
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration 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)
      • Duoplane
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Elevar
      • 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
      • Hype Auditor
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Impact Radius (Beta)
        • Integration Specifications
      • Inventory Planner
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Iterable
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Junip (beta)
        • Integration Specifications
      • Klaviyo V2
        • Integration Setup
        • Integration Specifications
      • KnoCommerce
        • Integration Setup
        • Integration Specifications
      • KWI
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Lightspeed
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • 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
      • 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
      • Retention Science
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Returnly
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Rockerbox
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Sailthru
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Sailthru Mobile
        • 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
      • Shipwire
        • 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
      • SnapFulfil
        • 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
        • Survey Monkey
          • Integration Setup
          • Integration Specifications
          • Workflow Configuration Setup
          • Transformation Configuration Setup
        • 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
        • Deprecated integrations
          • Fairing
            • Integration Setup
            • Integration Specifications
            • Transformation Configuration Setup
          • Google Analytics (Universal Analytics)
            • Integration Setup
            • Integration Specifications
            • Workflow Configuration Setup
            • Transformation Configuration Setup
          • Google Analytic First Click Data (Universal Analytics)
            • Integration Setup
            • Integration Specifications
            • Workflow Configuration Setup
            • Transformation Configuration Instructions
            • Where to Find Your Data
          • Klaviyo
            • Integration Setup
            • 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
          • 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 a Report
        • Working with Date Dimensions
        • 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
        • Add-on Dashboards and Explores
      • 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

    Was this helpful?

    1. 🔀Transform

    Code Repository

    PreviousSource to Final DestinationNextCode Repository Overview

    Last updated 7 months ago

    Code Repository Overview
    Getting Access to Your Code Repository
    Code Repository Branches
    Custom SQL Code
    Custom Script Manifest Files