Twitter API Connector via Fivetran

Twitter API

Would you like to track your Twitter ad spend and analyze your return on ad spend on the platform? This article will walk you through the steps to set up your Twitter connector with CaliberMind. The Twitter connector will help you track your Twitter ad spend and allow you to view it in your ROAS reports. You will first need to apply for access to the Twitter API and then you may complete the connector setup. The article is outlined as follows:

  • Applying for Twitter API
  • Custom API Credentials Setup
  • Standard OAuth 1 Setup
  • Viewing Your Twitter Ad Spend in CaliberMind

There are two versions of Twitter's API available (OAuth and Custom Credentials). You only need to follow the setup steps for the version you are using.

Applying for Twitter API Access

You will first need to sign up for the Twitter API at: https://developer.twitter.com/en/docs/twitter-api

Sign up for Twitter API access to connect with CaliberMind

Click on Sign Up and answer the basic questions

Click on the signup button and answer the basic questions to sync with CaliberMind

Read and agree to the Developer agreement & policy

Read and agree to the developer agreement & policy before integrating with CaliberMind

Fill out the Twitter Ads API application form at: https://developer.twitter.com/en/docs/twitter-ads-api/apply

Fill out the Twitter Ads API application form before syncing with CaliberMind

Now create a Project and an associated developer App. Record the API key and API secret key in a safe place.

Set the App Permissions: From your developer dashboard https://developer.twitter.com/en/apps select the app you created, from Settings, locate the App Permissions section, click Edit, set the permissions to Read and click Save.

Get the access token and secret: From your developer dashboard https://developer.twitter.com/en/apps select the Keys and Tokens tab, locate the Authentication Tokens and click on Generate your access token and secret.

Generate your access token and secret before integrating with CaliberMind

Your API Developer account is now setup.

To continue creating the connection follow the Instructions to Setup Twitter Marketing/Ads API Custom API credentials

Custom API credential Setup

Open CaliberMind and go to Settings 

Head to CaliberMind and navigate to Settings option

From the left dropdown menu choose the Connectors Menu and select Create New Pull Connector

Navigate to CaliberMind Connectors menu and click on New Pull Connector

From the list of choices find the Twitter Ads and select Add Connector

Select Twitter Ads and click on CaliberMind Add Connector option

Agree to the Terms and Conditions and Privacy Policy for using Fivetran by clicking on I Understand

Agree to Fivetranterms & conditions and privacy policy to sync with CaliberMind

Your new connection will be created and will need to be authorized. Click on the check next to Custom API credentials to setup your connection.

Click on CaliberMind Custom API Credentials to setup the connection

Enter your authentication credentials from Twitter, choose to Sync All Accounts or Specific Accounts then click on Save & Test.

Enter your Twitter aunthentication data, select sync all accounts/specific account to sync with CaliberMind

Standard OAuth 1 Setup

Open CaliberMind and go to Settings 

Head to CaliberMind and navigate to the Settings cog

From the left dropdown menu choose the Connectors Menu and select Create New Pull Connector

Select Create New Pull Connector from CaliberMind Connector menu

From the list of choices find the Twitter Ads and select Add Connector

Pick Twitter Ads to sync with CaliberMind

Agree to the Terms and Conditions and Privacy Policy for using Fivetran by clicking on I Understand

Agree to Fivetran terms & conditions and privacy policy to connect with CaliberMind

Your new connection will be created and will need to be authorized. Click on AUTHORIZE to begin the process.

Your CaliberMind connection is created. Click Authorize to start the authorization process

You will be taken to the Twitter API site where you can sign in with your username and password and select Authorize App to authorize.

Complete the CaliberMind connection by signing in with your Twitter username and password

Once authorized you will complete the setup process at Fivetran.

Choose to Sync All Accounts or Specific Accounts and the amount of months in your initial reports then click on Save & Test.

Select Sync All Accounts/Specific account and input the number of months in your initial CaliberMind report

Viewing Your Twitter Ad Spend in CaliberMind

Once your configuration is complete you will start to see you Twitter ad spend data populate within your CaliberMind instance on your ROAS reports. For more information on Return-on-Ad-Spend reports, check out the links below!

ROAS Overview

ROAS Campaigns

How did we do?

CaliberMind Data Access FAQs

Microsoft Bing Connector

Contact