Twitter Ads Setup Guide

Follow our setup guide to connect Twitter Ads to Fivetran.

Fivetran supports two authorization modes: standard OAuth 1 and custom API credentials. How we connect to Twitter Ads depends on the authorization mode you are using. Follow the setup instructions for your authorization mode:

• Standard OAuth 1
• Custom API credentials

Setup instructions for standard OAuth 1

Prerequisites

To connect Twitter Ads to Fivetran, you need:

• A Twitter account with access to at least one active Twitter Ads account with ACCOUNT_ADMIN, AD_MANAGER, or CAMPAIGN_ANALYST permissions. Learn more in Twitter Ads' Multi-user login FAQs. Multi-user login differs from the delegate feature.
• At least one campaign and one promotable user in the Twitter Ads account.

Configure Fivetran

1. In the connection setup form, enter the Destination schema name of your choice. This is used as the connection name and cannot be modified once the connection is created.
2. Click Authorize. You will be redirected to Twitter.
3. Click Authorize app to grant access. You'll return to Fivetran.
4. Choose your Sync Mode: Sync All Accounts or Sync Specific Accounts. If you select Sync Specific Accounts, a list of available accounts will appear for you to choose from.
5. Select how many months of reporting data you want to include in your initial sync.
6. Click Save & Test. Fivetran will verify the connection and begin syncing your Twitter Ads data.

Setup instructions for custom API credentials

Prerequisites

To connect Twitter Ads to Fivetran, you need:

• A Twitter account with access to at least one active Twitter Ads account with ACCOUNT_ADMIN, AD_MANAGER, or CAMPAIGN_ANALYST permissions.
• At least one campaign and one promotable user in the Twitter Ads account.
• A Twitter app with access to the Twitter Ads API.

Apply for a developer account

1. Go to Twitter's Apply for access page.

2. Click Apply for a developer account.

3. Select Build customized solutions in-house.

4. Input your organization details and explain how you intend to use the Twitter data in subsequent application screens. We recommend adding the following paragraph to the use case description field:

    I will use the data from the Twitter API to pull my advertising data and load it into my destination for internal analytics. The types of questions that I will answer using this data are as follows: 1) What types of ads are performing best? 2) What ads are resonating most with my audience? 3) How are my ads on Twitter performing relative to the other publishers? This type of analysis is essential to optimizing my ad spend. I am only planning to use the data for the advertising campaigns that I run on the platform and will not be using the API to trigger actions on the platform, such as Tweets or liking content. I am not planning to use any of the data that I pull externally.
   

Create Twitter application

1. After your developer account is approved, log in to the Twitter Developer Portal.

2. On the Overview page, go to the Standalone Apps section.

3. Click Create App.

4. Enter the name of your app, then click Complete.

5. Make a note of the API key and API secret key. You will need them to configure Fivetran.

Submit Ads API application form

1. Go to the Twitter Ads API application form.

2. Fill out and submit the form.

Set permissions for your app

1. Go to your Twitter app dashboard.

2. Select the app that you want to connect to Fivetran. It is either the app you created in the Create Twitter application step or an existing app.

3. In the app dashboard, go to the Settings tab.

4. In the App permissions section, click Edit.

5. Set the permissions to Read, then click Save.

Generate access token and secret

1. In the app dashboard, go to the Keys and tokens tab.

2. In the Authentication Tokens section, generate your access token and secret.

3. Make a note of the access token and access token secret. You will need them to configure Fivetran.

Finish Fivetran configuration

1. In the connection setup form, enter the Destination schema name of your choice. This is used as the connection name and cannot be modified once the connection is created.

2. Set the Custom API credentials toggle to ON.

3. Enter your Twitter application's Consumer Key and Consumer Secret.

4. Enter the Access Token and the Access Token Secret you created in the Generate access token and secret step.

5. Choose your Sync Mode: Sync All Accounts or Sync Specific Accounts. If you select Sync Specific Accounts, then select the accounts you want to sync.

6. Select how many months of reporting data you want to include in your initial sync.

7. Click Save & Test. Fivetran will verify the connection and sync your Twitter Ads data.

Related articles

description Connector Overview

account_tree Schema Information

assignment Release Notes

settings API Connection Configuration

home Documentation Home