Import your Twitter Ads data into your data warehouse

How to setup Twitter Ads Integration

This integration will allow you to connect with Twitter Ads and start collecting your data. It is a matter of minutes to send your billing data to feed your BI, your data warehouse, or your custom analytics stack.

Here are the steps involved:

  1. Connecting Twitter Ads
  2. Set the Replication Frequency
  3. Load your Twitter Ads data into your data warehouse
  4. Twitter Ads expected Data Model and schema
  5. Twitter Ads Integration FAQ

Getting Started – Setup Twitter Ads integration at Blendo

1. To add this integration, go to Blendo dashboard. Click Add a Source.

2. Click on Twitter Ads icon.

Settings you need from Twitter Ads

3.1. Connect to your Twitter Ads Account with your Credentials in the pop-up window.

3.2 In the new Setup your Twitter Ads source screen there are some data required that you will need to get from Twitter Ads. More specifically you will need the: Twitter Ads Account ID and your Twitter Ads’ Countries & Platforms from your campaigns.

 

 

3.3. Choose your Account ID from the drop-down menu.

3.4. Then from the drop-down menus, insert your campaign’s countries & platforms.

 

3.5. Add a Table Prefix if you want and click Next

 

4. In the next screen, you may select the resources you need to sync from Twitter Ads. After finishing click Save.

5. Then you will return back to the home dashboard. Click on your new Twitter Ads data source.

Set the Replication Frequency

This configuration controls how often Blendo will pull data from your Twitter Ads integration. Loading to your data warehouse could take a little bit longer.

6. If you want to change the replication schedule go to the Schedule section and click on Reschedule.

7. In the next pop-up select one of the options available and click Apply.

Load your Twitter Ads data into your data warehouse

Blendo will queue your sync request and start syncing on its schedule. If you want to trigger it on your own here is how to start loading your Twitter Ads data into your data warehouse:

Twitter Ads Data Model & Schema Information

Blendo will now connect to your Twitter Ads data source. It will sync your historical data and all the future updates into your destination data warehouse. You will get analytics ready tables and syncs that make sure you will get recent and consistent data.

Let’s see:

  1. How Blendo syncs Twitter Ads data
  2. The tables with Twitter Ads data that we create in your destination data warehouse

How Blendo syncs Twitter Ads data

Historical Data

When Blendo first connects to Twitter Ads Data source, will pull all your historical data.

Sync Schedule

Blendo syncs Twitter Ads data based on the schedule and frequency you choose. The default setting is every 1 hour but is configurable from inside the app.

Replication Process

The first time Blendo syncs your Twitter Ads data performs a full replication. Then your Twitter Ads data is replicated incrementally. Note that Blendo will only read your data.

Twitter Ads API Limits & Replication Frequency

Twitter Ads’ API does not support any filtering to a date that we could use to fetch incremental data for any of their endpoints. The only exception to that rule is the Deals resource which supports fetching incremental data. For more information visit Twitter Ads doc here.

After you finish the integration with Twitter Ads, you might see its status as Importing from source, Exporting to the destination, or Completed.

What Twitter Ads data do I have available?

Blendo creates analytics ready tables with recent and consistent data. Bellow is a diagram of the schema and you may also find a CSV with all the columns and fields in more detail.

Expected Twitter Ads Data Model & Schema Information >>

Twitter Ads Data Model & Schema

Questions? Contact us!

in Connecting SaaS Data Sources