Image Added

Select an existing OAuth connection for Twitter, or

select the link under OAuth connection to create a new one.

Image Added

After you're redirected back

to Treasure Data Connections

, repeat the first step (Create a new connection) and choose your new OAuth connection.

Image Added

Name your newly created connection and save it for later use.

Image Added

Configure

Output Results
The Output result needs to follow the Twitter Custom List data specifications here. We support single column, single type.

• TWITTER_ID: Twitter user IDs

• DEVICE_ID: IDFA, AdID or Android ID of Twitter users

• EMAIL: Email addresses

• TWITTER_HANDLE: Twitter users name aka. Screen names

Check Output results at the top of your query editor and select your Twitter

Custom Audience connection as follows:

Image Modified

Edit the following parameters:

• Twitter Ad Account ID (required): This is your Twitter Ad Account ID. See Appendix C for getting account id.

• Custom Audience Name

• (required): Name of

• Custom Audience list to create.

  • Important note: If you have many Tailored Audience lists with similar names as this input, the latest

• • Custom Audience Name will be used. We recommend that you give your

• • Custom Audience list a unique name.

  • Important note: You cannot use audience names that are associated with deleted audiences. When creating a new audience, you will receive an error message if you attempt to reuse a name that is associated with a deleted audience.

• Audience type

• (require): Type of entry in the list. It is one of email, id, device id, or handle.

• No need to normalize and hash records (default false): Indicates whether the data has already been normalized and hashed. If not, TD automatically normalizes and hashes the records.

• Skip on invalid records (default false): Indicates whether invalid records should be ignored.
• Mode (Default Update):Operation type being performed (Update or Delete)

• Retry limit (optional, default 6): Number of retries before it gives up.

• Initial intervals in milliseconds between retries (optional, default 10000): Interval to retry if a recoverable error happens (in millisecond).

• Maximum intervals in milliseconds between retries

• (optional, default to 32000) : Maximum time in milliseconds between retrying attempts.
  

• Sample Configuration

Image Added

Custom Audience list.

On the Treasure Data console, run the following query

with Output results into a connection of Twitter

Custom Audience (see Appendix A for more details of column naming):

SELECT email FROM (
  VALUES ('demo1@example.com'),
         ('demo2@example.com'),
         ('demo3@example.com')
)  tbl (email)

The preceding query will not match any real users as

it is for demo purposes only.

Further, it requires no source table (for the ease of testing out this feature), but you still need to choose your database, so pick “sample_datasets” or any other arbitrary table.

The query

completes in a few seconds.

Check the Twitter Audience Manager for your new list

.

Twitter takes up to 24 hours to validate your newly created list. Therefore, the list will show the status as “Processing”.

Image Added

You can see the status change to “Ready” (or an error if the list is not valid) within the next 6 to 8 hours.

Image Modified