How-To: Set Up Brand Media Pacing Datastudio Dashboard

Get Started

This setup is reliant on a Alli Data report set up by the PMG analytics team.

Alli Marketplace App Setup

• The Marketplace App is called Brand Media Pacing Datastudio Dashboard

• There are five fields to fill out:

  • dcm_datasource

    • this is where you will put the analytics DCM datasource

    • i.e. public.al_{clientname}__display_dcm_placement_on_revenue

  • email_datasource_cost

    • This is where you will input the datasource that includes the emailed cost files

    • i.e. al_{clientname}.display_email_partner_cost

  • email_datasource_impressions

    • This is where you will input the datasource that includes the emailed impressions files

    • i.e. al_{clientname}.display_email_partner_impressions

  • flowchart

    • This is where you will upload your brand’s flowchart, following the same column structure in the following google sheet: https://docs.google.com/spreadsheets/d/1MQTpVcGLHHZARrawt-G-L-ko3wRbrK91XyXxSkp7BIc/edit?usp=sharing

• project_name

  • This is where you will name the file you’re uploading

  • ie.) {clientname}_Flowchart_(Current Date)

Alli Data data source setup

Once you save & run the Alli Marketplace App, the aggregated data gets sent to an s3 bucket. In order to access the aggregated data in Alli Data, complete the following:

• Create a new s3 datasource in Alli Data

• Input the following fields accordingly:

  • 

• Run the following SQL in Alli Data Reporting → Explorer using the “Custom Redshift” report type to download the csv file, and drag it into the “Define Your Data” section:

  • SELECT * FROM {clientname}.brand_media_pacing

• Finally, save the datasource, and click on load data.