Prerequisites

You must be collecting hashed user emails on-site using our identify framework to follow this guide.
You must be collecting the user's hashed email under the tag name email_sha256.

Providing Decentriq the required audience data

Decentriq needs certain audience data and cohort information to build a model. This data includes:

The Permutive user ID and their sha256 hashed email
The human readable Cohort names a given user is apart of
(optional) The Permutive user ID and their age range and/or gender

Retrieving your users

The query below will output all your user's Permutive IDs and, if available, their corresponding hashed emails from the last 90 days.

WITH
  identities AS (
  SELECT
    permutive_id,
    id,
    tag
  FROM
    `#Identity_Table#`
  WHERE
    TIMESTAMP_TRUNC(_PARTITIONTIME, DAY) >= TIMESTAMP(DATE_SUB(CURRENT_DATE(), INTERVAL 3 MONTH))
    -- AND workspace_id IN ('#workspace ids') -- [Enterprise workspace clients only] uncomment if you want only a single workspace's data.
    )
SELECT
  I1.permutive_id AS userId,
  I2.id AS matchingId,
FROM
  identities AS I1
LEFT JOIN (
  SELECT
    *
  FROM
    identities
  WHERE
    tag = 'email_sha256') AS I2
ON
  I1.permutive_id = I2.permutive_id

Please download or store this data in a safe location for the "upload" step.

Retrieving the cohort data

The query below will output all the permutive ids and their corresponding cohorts from the last 30 days in the correct format:

SELECT
  pv.user_id AS userId,
  sm.name AS segment
FROM
  `#Pageview Table` AS pv
CROSS JOIN
  UNNEST(pv.segments) AS segment_number
LEFT OUTER JOIN
  `#Segment Metadata Table#` sm
ON
  segment_number = sm.number
WHERE
  pv._PARTITIONTIME >= TIMESTAMP(DATE_SUB(CURRENT_DATE(), INTERVAL 1 MONTH))
  -- AND pv.workspace_id IN ('#workspace ids') -- [Enterprise workspace clients only] uncomment if you want only a single workspace's data.

Please download or store this data in a safe location for the "upload" step.

Retrieving the additional demographic data (optional)

You will need to generate a query that pulls the demographic data for a given user, if you are collecting it. Permutive may be able to help you generate this query but you must be collecting this as part of an event.

Decentric would like this data exported in the format below:

userId	Age	Gender
1234	18-25	M
5678	46-55	NB

Please note, userId is the Permtuive ID.

Uploading the data files into the Decentriq platform

Provide Decentric this data. There are multiple methods to do this but Permutive is not able to help with this step. Some include:

Logging into their platform and adding the storage location you saved the exported data to as a data source.
Sending these data files programmatically via their Python SDK.
Logging into their platform and manually uploading the data files using their UI. (Max file size of 1GB)

If you have any questions about this step, please reach out to your Decentriq representative or reference their Support articles.

Target Cohorts for Decentriq campaigns

1) Navigate to the "imports" section of the dashboard and select "Create Import"

Step 1
- Import name: Decentriq
- Identifier(s): permutive_id
- Import Source: GCS
Step 2
- GCS Bucket: <blank>
- Upload Access Accounts: Add Decentriq's service account as a "user"
- Read Access Accounts (optional): <blank>
- Advanced Options: Please ensure the "Create new GCS Bucket" option is selected.
Step 3 (Review)
- Confirm the details match the above and select "finalize" to create the Bucket.

2) Provision Decentriq a "Private Key" in the Permutive dashboard so Decentriq can automatically create a taxonomy for you.

3) Send Decentriq the GCP Bucket details

Send your Decentriq representative the "GS PATH". This can be found in the "Decentriq" import under "Information"

4) Create the Decentriq targeting cohort(s)

Navigate to the "cohorts" section of the dashboard
Select the "+ Add Cohort" button
- Name: Anything you would like!
- Tags: Anything you would like!
- Description: Anything you would like!
- Behavior: This cohort should be targeting the correct advertiser segment Decentriq specifies.
- Activation syncs: Please ensure this cohort is activated to the correct adserver(s) for targeting

4) Log into your ad server and target the cohort code(s) as you normally would

Questions or Concerns?

If you have any questions, please contact Technical Services by emailing technical-services@permutive.com.

Search

Publisher Support

Working with Decentriq

Prerequisites

Providing Decentriq the required audience data

Target Cohorts for Decentriq campaigns

Questions or Concerns?

Comments