Reviews

This page provides detailed instructions on the Reviews 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 code block is dependent on the following upstream code blocks being implemented:

• Initialization

• UOS

• Order Line Revenue

This code block requires Yotpo to be installed as an extractor

Transformation Code Requirements

The following code should be added to the main workflow in the appropriate position, after Subscription and before Life-Time Value per the Transform Code Sequence - DRP page

  #--------------------------------------------------------------------------------------------------------------------
  # SECTION: 4900_REVIEWS
  # DEPENDENCIES:
  #   - Section: 0500_UOS
  #   - Section: 4300_ORDER_LINE_REVENUE
  #   - Integration: Yotpo
  # REQUIRED: No
  # PURPOSE: This code the DRP tables for Reviews / Yopo and should be enabled once the upstream blocks are enabled and
  # the Yotpo integration is enabled
  #--------------------------------------------------------------------------------------------------------------------
  reviews:
    integrations:
      - yotpo
    scripts:
      - "github://platform-sql-shared/scripts/base/4900_reviews/4901_REV_yotpo_v2_daily_sku_measures.sql"

Reviews - Yotpo

Add this code to enable analysis of reviews by creating the following tables:

• [drp.yotpo_daily_sku_measures]

• https://github.com/Daasity/platform-sql-shared/blob/master/scripts/base/4900_reviews/4901_REV_yotpo_v2_daily_sku_measures.sql