Onboarding

Set up your cross-publisher advertising evaluation platform in a few simple steps.

1

Data Setup

2

Platform Integration

3

Finalize Setup

AWS Clean Room Configuration

Collaboration Title

Collaboration Members

Your Organization (Owner)

Active

Add Publisher

Identity Type

Select the primary identifier type that will be used for data matching

Allowed Columns

Column Name	Data Type	Allowed	Action
user_id	STRING
email_hash	STRING
age_group	STRING

Query Quota (per day)

Set the maximum number of queries allowed per day

Result Row Limit

Maximum number of rows that can be returned in a query result

Data Storage Configuration

S3 Bucket Path

Specify the S3 path where your identity data is stored or should be uploaded

Upload Your Data

Upload your first-party identity data directly to the configured S3 bucket.

Drag and drop files here, or

CSV, JSON, or Parquet files (Max: 5GB)

Connect Ad Platforms

Integrate with your advertising platforms to enable audience overlap analysis.

Dashboard

Cross-publisher audience insights and analytics

Date Range

Publisher

Audience Segment

Identity Type

Total Audience Size: 2.4M

8.2%

Average Overlap Rate: 42.7%

3.1%

Connected Publishers: 4

New!

Query Usage: 42/100

Publisher Audience Overlap

Meta Overlap

48.2%

TikTok Overlap

37.5%

Snapchat Overlap

29.3%

Google Overlap

55.8%

Audience Overlap Trends

Clean Room Status

Active and Running

Last check: 5 mins ago

Storage Usage 45 GB / 100 GB

Query Usage 42 / 100

Connected Publishers 4 / 10

Recent Activity

New audience analysis completed

30 minutes ago
TikTok connection established

2 hours ago
Data refresh completed

Yesterday at 3:45 PM
New data uploaded to S3

Yesterday at 10:30 AM

View all activity

Quick Actions

Publisher	Your Audience Size	Publisher Audience	Overlap	Overlap %
Meta	2.4M	3.8M	1.16M	48.2%
TikTok	2.4M	2.9M	0.9M	37.5%
Snapchat	2.4M	2.2M	0.7M	29.3%
Google	2.4M	4.2M	1.34M	55.8%

Data Integration

Connect your data sources and manage integrations with advertising platforms.

Data Sources

Amazon S3

Direct integration with your S3 buckets
Database

Connect to your database directly
File Upload

Upload CSV, JSON, or other files
API Integration

Connect using REST APIs

Connected Platforms

Meta Ads

Connected on July 15, 2023

Active
Google Ads

Connected on July 18, 2023

Active

Amazon S3 Integration

Primary Data Source

Connect your S3 bucket containing your first-party identity data for audience matching with publisher platforms.

S3 Bucket Name

Prefix Path (Optional)

Data Schema

Column Name	Data Type	Identity Type	Sample
user_id	STRING	Primary ID	usr_12345678
email_hash	STRING	Email SHA-256	e254...3f2
phone_hash	STRING	Phone SHA-256	a721...9d4
segment	STRING	Attribute	high_value

File Format

Delimiter (CSV)

Has Header Row

First row contains headers

AWS Clean Room Settings

Clean Room Name

Glue Database

Analysis Rules

AWS Service Integration Status

AWS Clean Room

Connected

Active

AWS Glue

Data catalog configured

Active

AWS Athena

Query service ready

Active

Important Note

Make sure your AWS IAM permissions are correctly configured for Clean Room, Glue, and Athena services. Our platform requires read/write access to these services.

Identity Mapping

Configure your identity matching rules for cross-publisher audience overlap analysis.

Identity Types

Email (SHA-256)

Primary identity type

Active

Matches email addresses hashed with SHA-256 algorithm.
Phone (SHA-256)

Secondary identity type

Active

Matches phone numbers hashed with SHA-256 algorithm.
User ID

Platform-specific ID

Inactive

Matches user IDs across platforms when available.

Resolution Algorithm

Matching Algorithm

Identity Priority

Match Threshold

90%

Higher threshold means more precise matching.

Identity Schema Mapping

Your Identity Columns

Column Name	Data Type	Identity Type	Transformation	Status
email_hash	STRING	Email (SHA-256)	None	Mapped
phone_hash	STRING	Phone (SHA-256)	None	Mapped
user_id	STRING	User ID	None	Not Mapped
device_id	STRING	Device ID	None	Pending

Identity Resolution Rules

Match Rule

Custom Rule (SQL)

Deduplicate results (count unique matches only)

Identity Transformation

Transformation Type

Email Format

Phone Format

Publisher Mapping Status

Publisher	Identity Types	Status
Meta Facebook, Instagram	Email, Phone	Mapped
TikTok TikTok For Business	Email, Phone, Device ID	Mapped
Snapchat Snap Ads	Email, Phone	In Progress
Google Google Ads	Email	Mapped

Clean Room Setup

Configure your AWS Clean Room collaboration settings for secure data sharing and analysis.

Secure Data Environment

All data is processed in AWS Clean Room with privacy-preserving analytics. No raw data is shared between parties.

Setup Steps

Setup Progress

60%

AWS Services Status

AWS Clean Room
Active
AWS Glue
Active
AWS Athena
Active
AWS S3
Active

Clean Room Configuration

Draft

Basic Information

Collaboration Name

Description

Collaboration Members

Your Organization

(Creator)

yourcompany@example.com

Active
Meta

(Member)

meta-ads@facebook.com

Invited
TikTok

(Member)

ads-api@tiktok.com

Pending

Analysis Tables

Table Name	Owner	Schema	Status
customer_identities	Your Organization	user_id, email_hash, phone_hash	Active
meta_audience	Meta	id, email_hash, phone_hash	Pending
tiktok_audience	TikTok	id, email_hash, device_id	Not Started

Quota & Analysis Rules

Daily Query Quota

queries

Maximum number of queries that can be executed per day

Result Row Limit

rows

Maximum number of rows that can be returned in a query result

Allowed Analysis Types

Audience Overlap Count

Count matches between customer identities and publisher audiences

Segment Analysis

Analyze overlap by customer segments or attributes

Aggregate Statistics

Compute aggregate metrics without revealing individual records

Custom SQL Queries

Allow members to write custom SQL queries (requires approval)

Analysis Template

This is the SQL template that will be used for audience overlap analysis:

SELECT 
  COUNT(DISTINCT a.user_id) as overlap_count,
  COUNT(DISTINCT a.user_id) / (SELECT COUNT(*) FROM ${advertiser_table}) * 100 as overlap_percentage
FROM 
  ${advertiser_table} a
JOIN 
  ${publisher_table} p
ON 
  a.email_hash = p.email_hash 
  OR a.phone_hash = p.phone_hash
WHERE 
  /* Additional filtering criteria can be added here */
  1=1

Variables like ${advertiser_table} and ${publisher_table} will be automatically replaced with the actual table names during analysis.

Platform Connections

Connect your advertising platform accounts to enable audience overlap analysis.

Connected Platforms

2 of 6

Authorize platforms to securely access audience data.

Meta

Manage ads on Facebook and Instagram

Connected

Connected on May 15, 2023
Google Ads

Reach audiences across Google network

Connected

Connected on May 12, 2023
TikTok

Engage with TikTok's global audience

Not Connected
Snapchat

Connect with Snapchat's younger audience

Not Connected
Pinterest

Reach users in discovery mode

Not Connected
Twitter

Engage with users in real-time

Not Connected

Meta Ads Integration

Connection Status

Status

Active

Connected Since

May 15, 2023

Last Sync

Today, 2:30 PM

OAuth Access

Valid

OAuth token valid for 60 more days. Will auto-refresh if needed.

Account Details

Ads Account	Brand Marketing (ID: 384950384)
Business Manager	YourBusiness Inc. (ID: 4839201948)
Connected By	john.smith@example.com
Permissions	Read audience insights Read ad account data Access custom audiences

Identity Mapping Configuration

Your Identity Type	Maps To Platform	Transformation	Status
Email (SHA-256)	Email Hash	Lowercase + SHA-256	Active
Phone (SHA-256)	Phone Hash	E.164 Format + SHA-256	Active
User ID	External ID	None	Inactive

Available Features

Audience Overlap Analysis

Compare your audience with Meta's user base

Segment Analysis

Analyze audience segments across platforms

Reach & Frequency Insights

Understand potential audience reach

Conversion Attribution

Coming soon - Requires additional permission

Reports

View and manage your audience overlap analysis reports across publishers.

Date Range

Platform

Report Type

Status

Report Name	Type	Platform	Created On	Status
Q2 Meta Audience Overlap High-value customer segment	Audience Overlap	Meta	May 15, 2023 9:30 AM	Completed
TikTok Overlap Trend Analysis All customer segments	Trend Analysis	TikTok	May 12, 2023 2:15 PM	Completed
Multi-Platform Segment Analysis New customer cohort	Segment Analysis	Multiple	May 17, 2023 11:45 AM	Running
Snapchat Weekly Overlap Report Gen Z segment	Audience Overlap	Snapchat	May 18, 2023 8:20 AM	Scheduled
Google Ads Overlap Analysis Premium customer segment	Audience Overlap	Google	May 16, 2023 1:10 PM	Failed

Showing 1 to 5 of 12 results

Meta High-value customer segment Completed Created May 15, 2023

Total Audience Size

2.4M

Your first-party data

Publisher Audience

8.7M

Meta platforms

Overlap Rate

48.2%

+5.3% vs previous period

Audience Overlap Visualization

Chart showing overlap between your data and Meta platforms

Identity Mapping Used

Your Identity	Platform Identity	Match %
Email (SHA-256)	Email Hash	42.8%
Phone (SHA-256)	Phone Hash	5.4%

Key Insights

48.2% of your high-value customers can be reached on Meta platforms
Highest overlap is with Facebook (42.7%), followed by Instagram (34.2%)
Email identity provides better match rate than phone numbers
5.3% increase in overlap compared to previous quarter

Onboarding

AWS Clean Room Configuration

Upload Your Data

Connect Ad Platforms

Connect to Meta Ads

Dashboard

Publisher Audience Overlap

Audience Overlap Trends

Clean Room Status

Active and Running

Recent Activity

Quick Actions

Data Integration

Data Sources

Amazon S3

Database

File Upload

API Integration

Connected Platforms

Meta Ads

Google Ads

Amazon S3 Integration

Data Schema

File Format

AWS Clean Room Settings

AWS Service Integration Status

AWS Clean Room

AWS Glue

AWS Athena

Important Note

Identity Mapping

Identity Types

Email (SHA-256)

Phone (SHA-256)

User ID

Resolution Algorithm

Identity Schema Mapping

Your Identity Columns

Identity Resolution Rules

Identity Transformation

Publisher Mapping Status

Clean Room Setup

Secure Data Environment

Setup Steps

Setup Progress

AWS Services Status

Clean Room Configuration

Basic Information

Collaboration Members

Analysis Tables

Quota & Analysis Rules

Analysis Template

Platform Connections

Connected Platforms

Meta

Google Ads

TikTok

Snapchat

Pinterest

Twitter

Meta Ads Integration

Connection Status

Account Details

Identity Mapping Configuration

Available Features

Audience Overlap Analysis

Segment Analysis

Reach & Frequency Insights

Conversion Attribution

Reports

Settings

Profile Information

Organization Details

Subscription & Billing

Basic

Pro

Enterprise

Payment Method

API Credentials

API Key