Daily Plan Code

This page provides detailed instructions on the Householding Code transform code block and what should be added to the Script Manifest file in order to execute the code

Script Manifest File (YML)

Upstream Transformation Dependencies

This block is dependent on the following blocks being implemented:

• Initialization

• UOS

• Google Analytics

Transformation Code Requirements

The following code should be added to the main workflow in the appropriate position, after Order Channel and Marketing and before Order and Order Line Revenue per the Transform Code Sequence - DRP page

  #--------------------------------------------------------------------------------------------------------------------
  # SECTION: 3500_DAILY_PLAN
  # DEPENDENCIES:
  #   - Section: 0500_UOS
  #   - Section: 2600_GA
  # REQUIRED: No
  # PURPOSE: This code creates the DRP tables for daily plans and should be turned on once UOS and GA are turned on
  #--------------------------------------------------------------------------------------------------------------------
  performance_trends:
    integrations:
      - google_analytics
    scripts:
      - "github://platform-sql-shared/scripts/base/3500_performance_trends/3540_PFT_BAS_daily_plan.sql"
      - "github://platform-sql-shared/scripts/base/3500_performance_trends/3541_PFT_BAS_daily_marketing_plan.sql"

Daily Plan

Add this code to ingest data from the Brand Supplied Data (BSD) in the Daasity App to populate the following table:

• [drp.daily_plan]

• [drp.daily_marketing_plan]

• https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/3500_performance_trends/3540_PFT_BAS_daily_plan.sql
• https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/3500_performance_trends/3541_PFT_BAS_daily_marketing_plan.sql