# Reviews

## Script Manifest File (YML)

### Upstream Transformation Dependencies

{% hint style="warning" %}
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
{% endhint %}

### 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](https://help.daasity.com/technical-docs/transform-code/transform-code/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

{% hint style="success" %}
Add this code to enable analysis of reviews by creating the following tables:

* \[`drp.yotpo_daily_sku_measures`]
  {% endhint %}

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