Skip to main content
Skip table of contents

Brand Media Pacing Datastudio Dashboard

This tools allows you to aggregate brand media flowcharts into one helpful view in Datastudio

If you have any issues, submit a service desk ticket

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

  • 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.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.