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:
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 about access levels and setting up multi-user login in Twitter Ads' Multi-user login FAQs. Multi-user login is not the same as the delegate feature.
- At least one campaign and one promotable user in the Twitter Ads account.
Configure Fivetran
In the connector setup form, enter the Destination schema name of your choice.
Click Authorize. You will be redirected to Twitter, which will ask permission for Fivetran to access your account. Click Authorize app. You will be redirected back to Fivetran.
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.
Select how many months' worth of reporting data you'd like to include in your initial sync.
Click Save & Test. Fivetran will take it from here and sync 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. Learn more about access levels and setting up multi-user login in Twitter Ads' Multi-user login FAQs. Multi-user login is not the same as the delegate feature.
- At least one campaign and one promotable user in Twitter Ads account.
- A Twitter app with access to the Twitter Ads API.
Apply for a developer account
IMPORTANT: If you already have a developer account, skip ahead to Step 2.
Click Apply for a developer account.
Select Build customized solutions in-house.
Input your organization details and explain how you intend to use the Twitter data in subsequent application screens. For the use case description field, we recommend using the following paragraph:
"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."
NOTE: Twitter may take a few days to approve your developer account.
Create Twitter application
IMPORTANT: If you already have an application that you want to use to connect to Fivetran, skip ahead to Step 3.
After your developer account is approved, log in to the Developer Portal.
On the Overview page, go to the Standalone Apps section.
Click Create App.
Enter the name of your app, then click Complete.
Make a note of the API key and API secret key. You will need them to configure Fivetran.
TIP: You can also find the keys in the Keys and tokens tab of your app dashboard.
Submit Ads API application form
Go to the Twitter Ads API application form.
Fill out and submit the form.
Set permissions for your app
Go to your Twitter app dashboard.
Select the app that you created in Step 2. If you already have an app that you want to use to connect to Fivetran, select that app.
In the app dashboard, go to the Settings tab.
In the App permissions section, click Edit.
Set the permissions to Read and click Save.
Generate access token and secret
In the app dashboard, go to the Keys and tokens tab.
In the Authentication Tokens section, generate your access token and secret.
Make a note of the Access Token and Access Token Secret. You will need them to configure Fivetran.
Finish Fivetran configuration
In the connector setup form, enter the Destination schema name of your choice.
Set the Custom API credentials toggle to ON
Enter the Consumer Key and the Consumer Secret you found in Step 2.
Enter the Access Token and the Access Token Secret you created in 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.
Select how many months' worth of reporting data you'd like to include in your initial sync.
Click Save & Test. Fivetran will take it from here and sync your Twitter Ads data.
Related articles
description Connector Overview
account_tree Schema Information
settings API Connector Configuration