Send query results to Roku Audience

Roku Audience is a CTV (connected TV) advertising platform that enables brands to target custom audiences through Roku Ads Manager. Send first-party customer data to Roku for household-based ad targeting across Roku streaming devices.

Note

This destination uses the Roku Ads API .

The steps that are required to send audiences to Roku Audience from Amperity.

Step 1.

Build a query
Step 2.

Add orchestration
Step 3.

Run orchestration

Caution

This destination is available for sending query results to Roku Audience after it is configured by a Datagrid Operator or your Amperity representative.

If this destination cannot be selected for orchestrations ask your Datagrid Operator or Amperity representative to configure a destination for sending query results to Roku Audience.

Build query

Build a query that returns the fields that are required by Roku Audience. The email field is required. You can optionally include phone, maid (mobile advertiser ID), and ip fields to improve match rates.

The following example shows a query that returns email addresses from the Customer 360 table:

SELECT
  email
FROM Customer_360

The following example shows a query that returns email addresses and device identifiers to improve match rates:

SELECT
  email
  ,phone
  ,mobile_advertiser_id AS maid
  ,ip
FROM Customer_360

Note

Roku matches audiences using email as the primary identifier. Phone numbers, mobile advertiser IDs, and IP addresses are optional and can improve match rates when included.

Add orchestration

An orchestration defines the relationship between query results and a destination, including the destination and the frequency at which an orchestration runs.

  1. Open the Activations page, select the Orchestrations tab, and then click the Add orchestration button. This opens the Add orchestration dialog box.

  2. From the Object type dropdown, select Query.

  3. From the Object dropdown, select the query for which results is sent to Roku Audience.

  4. From the Destination dropdown, select a destination that is configured for sending data to Roku Audience.

  5. Verify all settings.

  6. Set the workflow to Manual. You can change this to automatic later, after verifying the end-to-end workflow.

  7. Click Save.

Run orchestration

Run the orchestration manually to validate that it works.

  1. Open the Activations page, select the Orchestrations tab, and then open the menu for the Roku Audience orchestration. Select Run.

  2. The Status column for the orchestration updates to say “Waiting to start”, after which the notifications pane updates to include a notification that shows the current status.

  3. When the orchestration has run successfully, the status is updated to “Completed”.