X Ads (formerly Twitter Ads)

This page describes how to use Census with X Ads.

Getting started

This guide shows you how to use Census to connect your X Ads account to your data warehouse and create your first sync.

Prerequisites

Before you begin, you'll need the following:

• Census account: If you don't have this already, start with a free trial.

• X Ads account

• Credentials for your data warehouse: For details, see the guide for your specific data source technology.

To sync audiences, X requires a manual approval step. Details can be found in X docs.

For access to the Audience endpoint, you will need to be added to an allowlist. Please fill this form and accept the new Twitter Ads Products and Services Agreement if initially accepted prior to 2018-08-01.

Step 1: Connect X Ads Account

1. Log into Census and navigate to Destinations.

2. Click New Destination.

3. Select X Ads from the dropdown list.

4. Follow the X Ads authentication flow.

Your end state should look something like this: 👇

Destinations page after setting up connection to X Ads

Step 2: Connect your data warehouse

The steps for connecting your data warehouse will depend on your technology. See the following guides:

• Databricks

• Google BigQuery

• Google Sheets

• Postgres

• Redshift

• Snowflake

After setting up your warehouse, your Destinations page should look something like this: 👇

Destinations page after setting up a data source

Step 3: Create your model

When defining models, you'll write SQL queries to select the data you want to see in X Ads. This can be as simple as selecting everything in a specific database table or as complex as creating new calculated values.

1. From inside your Census account, navigate to the Models page.

2. Enter a name for your model. You'll use this to select the model later.

3. Enter your SQL query. If you want to test the query, use the Preview button.

4. Click Save Model.

Basic SQL query for a new model

Step 4: Create your first sync

The sync will move data from your warehouse to X Ads. In this step, you'll define how that will work.

1. From inside your Census account, navigate to the Syncs page and click Add Sync.

2. Under What data do you want to sync?, choose your data warehouse as the Connection and your model as the Source.

3. Under Where do you want to sync data to?, choose X Ads as the Connection and an Object in X Ads. Based on the selected object, your sync options will vary. See Supported Objects

4. (When syncing conversion events) Under How do you want to update the destination?, choose Send. See Supported sync behaviors.

5. (When syncing conversion events) Under How are source records identified?, select a column from the model that serves as a unique ID for each record. If needed, turn on the Use timestamp column setting and select a property from the model. This setting allows the sync to skip records that have not changed (according to the timestamp) since the last sync.

6. (When syncing audiences) Under How should we identify audience members?, specify how Census should match audience members in X Ads to records in the model.

7. (When syncing audiences) Under Audience Sync, select an existing X Ads audience or create a new audience list in X Ads. If the audience list includes members that don't have matching records in your model, Census will remove those members from the list.

8. Under Which properties should be updated?, select the fields you want to update by mapping a field in X Ads to a column in your model.

9. (When syncing conversion events) Under Should existing data be synced?, choose whether to sync existing records (Backfill All Records) or only sync new records going forward (Skip Current Records).

10. Click Next. This will open the Confirm Details page where you can see a recap of your setup.

11. If you want to start a sync immediately, set the Run a sync now? checkbox.

12. Click Create Sync.

When configuring your sync, the page should look something like this: 👇

Setting up a X Ads sync with a new audience list

Step 5: Confirm the synced data in X Ads

Once your sync is complete, it's time to check your data. Open X Ads and check that the records updated correctly.

If everything went well, that's it! You've started syncing data from your warehouse to X Ads! 🥳️

And if anything went wrong, contact the Census support team to get some help.

Sync speed & limits

Rate limits affect how many records you can sync in a specific period of time. X Ads API has a rate limit of 1,500 calls per minute. Calls to sync audience data and conversion event data share the same rate limit.

Conversion Events: Use timestamp setting

When syncing data to conversion events, the Use timestamp column to identify new data setting can help limit the number of API calls. With this setting, Census will check if the record has changed since the last sync occurred and skip syncing for the record if there have been no changes.

To use this setting, you'll also need to include a column in your database/data source that tracks the latest sync for each record.

Supported Objects and Sync Behaviors

Object Name	Supported?	Sync Keys	Behaviors
Audience	✅	Hashed or Unhashed Email, Hashed or Unhashed Handle, Hashed or Unhashed Device ID	Mirror
Mobile Conversion Event	✅	App ID, Conversion Time, Conversion Type, Hashed Device ID, OS Type	Send
Web Conversion Event	✅	Click ID, Hashed or Unhashed Email, Hashed or Unhashed Phone Number	Send

Learn more about all of our sync behaviors in our Syncs documentation.

Contact us if you want Census to support more X Ads objects and/or behaviors.

Need help connecting to X Ads?

You can send our support team an email at [e-mail] or start a conversation from the in-app chat.