Send query results to Pinterest Ads

Use a query to build an audience that meets the criteria for how your brand wants to advertise on Pinterest. Send the list of email addresses associated with that audience to Pinterest using an orchestration, after which that list of email addresses will be available in Pinterest Ads as a customer list.

A customer list is associated with an audience in Pinterest, after which your brand may use that audience to advertise on Pinterest.

Amperity will create the customer list (if it does not already exist), and then add email addresses to that customer list OR Amperity will update the customer list (if it already exists) so that it matches the list of email addresses that were sent from Amperity.

Note

An existing customer list should be empty the first time Amperity sends a list of email addresses.

When a customer list is not associated with an audience in Pinterest, Amperity will create an audience using the same name as the list name that was used in Amperity, and then attach the customer list that is managed by Amperity to that audience list.

Note

A customer list must contain at least 100 email addresses that are associated with a Pinterest account before it can be associated with an audience.

About Pinterest API endpoints

Amperity uses a combination of endpoints in the Pinterest API:

• The create audience endpoint to create an audience that can be used to reach specific groups of users in Pinterest. This converts a customer list into the CUSTOMER_LIST audience type.

• The create customer list endpoint to create a customer list from a list of SHA-256 hashed email addresses sent to Pinterest from Amperity.

• The update customer list endpoint to manage the list of email addresses in a customer list.

Pinterest applies standard access rate limits ; Amperity can read from existing customer lists at up to 1000 calls per minute and can write to customer lists at up to 400 calls per minute.

Changes to audiences are not immediately available in Pinterest. Allow for up to 48 hours after the point at which Amperity has finished sending audience updates for them to be available.

Caution

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

If this destintion cannot be selected from the campaigns editor or activations canvas ask your Datagrid Operator or Amperity representative to configure a destination for sending sending query results to Pinterest.

Build query

Build a query that returns a list of email addresses. Use additional filters in a WHERE clause to scope your audience for your use cases and goals for marketing to your customers within Pinterest.

Tip

Be sure to exclude the following from query results:

1. Users who have opted out of targeted advertising on Pinterest

2. User activity from an app and/or website

3. Additional profile information, such as names, phone numbers, or physical addresses

Example

The following query returns a list of hashed email addresses for customers who are engaged with your brand, have opted in to receiving email communication, have made at least 4 purchases within the previous year, and have spent at least $400.

SELECT
  TO_HEX(
    SHA256(
      TO_UTF8(
        UPPER(
          TRIM(email)
        )
      )
    )
  ) AS email
  FROM Merged_Customers mc
  INNER JOIN Customer_Attributes ca
  ON mc.amperity_id = ca.amperity_id
  INNER JOIN Transaction_Attributes_Extended tae
  ON mc.amperity_id = tae.amperity_id
  WHERE (
    LOWER(mc.email) IS NOT NULL
    AND pin.contactable_pinterest = TRUE
    AND tae.L12M_order_frequency >= 4
    AND tae.L12M_order_revenue >= 400
  )

Add orchestration

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

To add an orchestration

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 will be sent to Pinterest.

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

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.

To run the orchestration

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

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

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

Product catalogs

end-before: