Skip to main content
Skip table of contents

Onboarding InnovidXP to Alli

Prerequisites

  • User creds with access to client InnovidXP account with reporting and export access

  • Follow steps here to create Alli SFTP user for client

  • Ensure the SFTP credentials and path created are set up as the Remote SFTP location in InnovidXP UI

A shared [client]_reporting@pmg.com account is preferred over a personal account

Example SFTP credentials:

  1. Server: sftp.alliplatform.com

  2. Port: 22

  3. Path: /writeable/

  4. User Name: {client}.innovidxp

  5. Password: Save in 1Pass


Creating the InnovidXP Reports

InnovidXP DMA Delivery Report

  1. Reach out to your respective InnovidXP reporting team representatives to set up a base delivery report from the Studio analytics with the following details:

    1. File Name Convention: {Client}_DMA_Reporting_YYYYMMDD (where YYYYMMDD is the last data date in the file)

    2. SFTP creds: Provide the SFTP credentials (share password via 1Pass or another password manager) created in Prerequisites section

    3. Delivery Cadence: 7 day rolling look-back window delivered daily

    4. List of Columns to be included (and column order: all dimensions then metrics):

Dimensions/Attributes

Metrics

Date

Total Spend

Client ID

Impressions

Client Name

Click-throughs

Campaign Name

Click-through Rate

Campaign ID

25% video completions

Format

50% video completions

Publisher

75% video completions

Placement Name

100% video completions

Placements Group ID

Video Completion Rate

DCM Placement ID

Creative Name

Creative ID

DMA ID

DMA Name

Cost Rate

Cost Type


InnovidXP Outcomes Report

  1. Log into the InnovidXP UI using the user creds that has access to the client’s InnovidXP portal

  2. If it is a shared multi-account login, select the appropriate portal:

image-20240719-164653.png

  1. After successful login to the expected client portal, navigate to the Exports section:

image-20240718-182352.png
  1. Click on CONFIGURE EXPORTS > CREATE NEW CONFIGURATION to create a new outcome export:

image-20240718-182740.png
  1. Build out the report export with the following criteria:

    1. Dimensions - Date, Innovid Client ID, Camapign Name, Creative ID, Creative Name, DMA, Placement Group ID, Placement Group, Enriched Publisher Name, Publisher, ivctappname, ivctaudience, ivctpublisher

    2. Metrics - Response + any of the desired custom conversion events (i.e. registration, purchase, purchase revenue, etc

    3. Data Groups - Leave Default

    4. Publishers: Leave blank to pull all publishers OR Specify publisher(s)

    5. File Name: {Client}_XP_Outcomes_YYYY-MM-DD (where YYYY-MM-DD is the last data date in the file)

    6. Enabled Automation: Checked

    7. When Would Like The Export Automatically Delivered: Day of the week

    8. Choose a Day: Select every day

    9. Choose a Frequency: Weekly

    10. Select a Time for your export (UTC): 12:00 (7AM CST; can change to your preference)

    11. Delivery Method: Remote SFTP

    12. Select A Duration For The Report: Previous 2 weeks

    13. Select How Many Days To Offset Your Data By: 0

image-20240719-164945.png

  1. Click Save


Creating and Backfilling the datasource

  1. Open the Alli Data Library 2.0 - Onboard Platform app in Alli UI or install it if it is not already available for your client in Alli Data (follow this section Onboarding a platform to Data Library | Creating your datasources using Alli Marketplace for detailed instructions)

  2. Create the InnovidXP datasources by selecting the Innovid option under platform dropdown and execute the Alli Data Library 2.0 - Onboard Platform app.

image-20240719-172436.png
  1. Locate the datasources (innovid_insights_dma & innovid_insights_outcomes_conversion)that were created on the Data > Sources page

  2. Configure the datasources:

    1. Additional Configuration Needed:

      1. CLIENT FILE LOCATION: Custom

      2. FILE NAME: the file name that comes through in the SFTP - Example: {Client}_XP_Outcomes_YYYY-MM-DDfor the specific file. If you want to dynamically load the latest file each time, try: {Client}_XP_Outcomes_[^.]+.csv

      3. DIRECTORY: source=sftp/sftp={sftp_username}/

    2. Click Next

    3. Define your data:

      1. innovid_insights_dma - The data should already be defined for you with a set schema with appropriate columns and metrics defined. Your file from Innovid team should match this order. If not, they will need to recreate it using the specified column order

      2. image-20240718-205548.png

        Screenshot of Define Your Data section of the innovid_insights_dma datasource

      3. innovid_insights_outcomes_conversion:

        1. Define your schema based on the file that came through the SFTP 

          1. This can be done by dragging a copy of the csv file into the window for which Alli will generate the schema for you OR manually adding each column in order shown in csv file if Alli cannot parse the csv.

          2. Ensure the right data types are defined for each column

          3. Define your PRIMARY KEY used to update and load the datasource correctly by defining the key fields as Dimensions. Non-key dimensions and metrics should be defined as Attribute/Metric

          4. Click Next/Save

          5. image-20240718-210708.png

            Example screenshot of Define Your Data section for a innovid_insights_outcomes_conversion datasource with a primary key defined (darker colored cells)

  3. To backfill, you can use the Load Data by clicking Load Data button to auto-load a file from the SFTP folder OR you can manually upload a file by selecting Choose File then Upload File:

    image-20240718-205900.png


References:

JavaScript errors detected

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

If this problem persists, please contact our support.