Twitter Ads
On This Page
Hevo can replicate your Twitter Ads’ data to your data warehouse using Twitter API.
For creating Pipelines using this Source, Hevo provides you a fully managed BigQuery data warehouse as a possible Destination. This option remains available till the time you set up your first BigQuery Destination irrespective of any other Destinations that you may have. With the managed warehouse, you are only charged the cost that Hevo incurs for your project in Google BigQuery. The invoice is generated at the end of each month and payment is recovered as per the payment instrument you have set up. You can now create your Pipeline and directly start analyzing your Source data. Read Hevo Managed Google BigQuery.
Apply for a Developer Account
To connect Twitter Ads to Hevo, you need a Twitter app with access to the Twitter Ads API. If you already have a developer account, skip ahead to Step 2.
-
Go to Twitter’s Apply for access page.
-
Select 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:
We will use Twitter API to pull our advertising data and load it into our data warehouse for internal analytics purposes. My organization is keen to understand our ads' performance on Twitter and also perform comparative analysis with other ads platforms. We will be only pulling data out of Twitter and don't plan to trigger any action on the platform.Note: It may take few days for Twitter to approve your developer account.
Create a Twitter Application
-
If you already have an application that you can use to connect to HEVO, skip to Step 3.
-
After your developer account is approved, go to Twitter’s Create Application page to create a Twitter app.
-
In the Website URL field, fill
https://hevodata.com/. -
In the Tell us how this app will be used field, you can fill the following:
This application will be used to pull analytics on the advertising that I run on the Twitter platform in order to analyse performance.
Submit the Advertising API License Agreement Form
-
Navigate to the Advertising Api License Agreement.
-
Fill and submit the form.
Generate Keys and Tokens for Your Account
-
Go to your Twitter App Dashboard.
-
Select the application that you created in Step 2.
-
Click on the Keys and tokens tab.
-
Create your keys and tokens.
-
Make a note of these keys and tokens. You will need them to configure Twitter Ads source at HEVO.
Configure Twitter as a Source
Perform the following steps to configure AppsFlyer as the Source in your Pipeline:
-
Click PIPELINES in the Asset Palette.
-
Click + CREATE in the Pipelines List View.
-
In the Select Source Type page, select Twitter Ads.
-
In the Configure your Twitter Ads Source page, specify the following:
-
Pipeline Name: A unique name for the Pipeline.
-
Enter the following keys and tokens that you created.
- Consumer API Key
- Consumer API Secret
- Access Token
- Access Token Secret
-
-
Click TEST & CONTINUE.
-
Proceed to configuring the data ingestion and setting up the Destination.
Data Replication
Objects
On the initial setup, Hevo replicates objects’ data once. Subsequently, objects are synced up once on a daily basis.
Reports
On the initial setup, Hevo replicates reports’ data for the last 90 days. Subsequently, reports are synced up on an hourly basis by default.
Reports sync frequency can be adjusted by changing the pipeline’s scheduled frequency.
Schema and Primary Keys
Objects Primary Key
| Object | Primary Key |
|---|---|
| ACCOUNT | AccountId, Id |
| FUNDING_INSTRUMENT | AccountId, Id |
| CAMPAIGN | AccountId, Id |
| LINE_ITEM | AccountId, Id |
| PROMOTED_TWEET | AccountId, Id |
| MEDIA_CREATIVE | AccountId, Id |
Reports Primary Key
| Report | Primary Key |
|---|---|
| ACCOUNT_AGE_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT |
| ACCOUNT_APP_STORE_CATEGORY_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT |
| ACCOUNT_DEVICES_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT, PLATFORM_TARGET_VALUE |
| ACCOUNT_EVENTS_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT |
| ACCOUNT_GENDER_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT |
| ACCOUNT_INTERESTS_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT |
| ACCOUNT_LOCATIONS_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT |
| ACCOUNT_PLATFORMS_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT |
| ACCOUNT_PLATFORM_VERSIONS_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT, PLATFORM_TARGET_VALUE |
| ACCOUNT_POSTAL_CODES_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT, COUNTRY_TARGET_VALUE |
| ACCOUNT_REGIONS_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT, COUNTRY_TARGET_VALUE |
| CAMPAIGN_AGE_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT |
| CAMPAIGN_APP_STORE_CATEGORY_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT |
| CAMPAIGN_CONVERSION_TAGS_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT |
| CAMPAIGN_DEVICES_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT, PLATFORM_TARGET_VALUE |
| CAMPAIGN_EVENTS_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT |
| CAMPAIGN_GENDER_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT |
| CAMPAIGN_INTERESTS_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT |
| CAMPAIGN_KEYWORDS_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT |
| CAMPAIGN_LANGUAGES_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT |
| CAMPAIGN_LOCATIONS_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT |
| CAMPAIGN_PLATFORMS_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT |
| CAMPAIGN_PLATFORM_VERSIONS_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT, PLATFORM_TARGET_VALUE |
| CAMPAIGN_POSTAL_CODES_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT, COUNTRY_TARGET_VALUE |
| CAMPAIGN_REGIONS_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT, COUNTRY_TARGET_VALUE |
| CAMPAIGN_SIMILAR_TO_FOLLOWERS_OF_USER_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT |
| CAMPAIGN_TV_SHOWS_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT |
| FUNDING_INSTRUMENT_AGE_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT |
| FUNDING_INSTRUMENT_APP_STORE_CATEGORY_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT |
| FUNDING_INSTRUMENT_CONVERSION_TAGS_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT |
| FUNDING_INSTRUMENT_DEVICES_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT, PLATFORM_TARGET_VALUE |
| FUNDING_INSTRUMENT_EVENTS_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT |
| FUNDING_INSTRUMENT_GENDER_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT |
| FUNDING_INSTRUMENT_INTERESTS_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT |
| FUNDING_INSTRUMENT_LOCATIONS_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT |
| FUNDING_INSTRUMENT_PLATFORMS_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT |
| FUNDING_INSTRUMENT_PLATFORM_VERSIONS_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT, PLATFORM_TARGET_VALUE |
| FUNDING_INSTRUMENT_REGIONS_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT, COUNTRY_TARGET_VALUE |
| LINE_ITEM_AGE_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT |
| LINE_ITEM_APP_STORE_CATEGORY_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT |
| LINE_ITEM_CONVERSION_TAGS_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT |
| LINE_ITEM_DEVICES_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT, PLATFORM_TARGET_VALUE |
| LINE_ITEM_EVENTS_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT |
| LINE_ITEM_GENDER_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT |
| LINE_ITEM_INTERESTS_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT |
| LINE_ITEM_KEYWORDS_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT |
| LINE_ITEM_LANGUAGES_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT |
| LINE_ITEM_LOCATIONS_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT |
| LINE_ITEM_PLATFORMS_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT |
| LINE_ITEM_PLATFORM_VERSIONS_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT, PLATFORM_TARGET_VALUE |
| LINE_ITEM_POSTAL_CODES_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT, COUNTRY_TARGET_VALUE |
| LINE_ITEM_REGIONS_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT, COUNTRY_TARGET_VALUE |
| LINE_ITEM_SIMILAR_TO_FOLLOWERS_OF_USER_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT |
| LINE_ITEM_TV_SHOWS_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT |
| PROMOTED_TWEET_AGE_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT |
| PROMOTED_TWEET_APP_STORE_CATEGORY_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT |
| PROMOTED_TWEET_CONVERSION_TAGS_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT |
| PROMOTED_TWEET_DEVICES_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT, PLATFORM_TARGET_VALUE |
| PROMOTED_TWEET_EVENTS_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT |
| PROMOTED_TWEET_GENDER_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT |
| PROMOTED_TWEET_INTERESTS_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT |
| PROMOTED_TWEET_KEYWORDS_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT |
| PROMOTED_TWEET_LANGUAGES_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT |
| PROMOTED_TWEET_LOCATIONS_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT |
| PROMOTED_TWEET_PLATFORMS_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT |
| PROMOTED_TWEET_PLATFORM_VERSIONS_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT, PLATFORM_TARGET_VALUE |
| PROMOTED_TWEET_POSTAL_CODES_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT, COUNTRY_TARGET_VALUE |
| PROMOTED_TWEET_REGIONS_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT, COUNTRY_TARGET_VALUE |
| PROMOTED_TWEET_SIMILAR_TO_FOLLOWERS_USER_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT |
| PROMOTED_TWEET_TV_SHOWS_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, SEGMENT_NAME, PLACEMENT |
| MEDIA_CREATIVE_REPORT | ACCOUNT_ID, ENTITY_ID, DATE, PLACEMENT |
Data Model
Hevo ingests the following data from your Twitter Ads account:
Objects
-
ACCOUNT
-
FUNDING_INSTRUMENT
-
CAMPAIGN
-
LINE_ITEM
-
PROMOTED_TWEET
-
MEDIA_CREATIVE
Reports
-
ACCOUNT_AGE_REPORT
-
ACCOUNT_APP_STORE_CATEGORY_REPORT
-
ACCOUNT_DEVICES_REPORT
-
ACCOUNT_EVENTS_REPORT
-
ACCOUNT_GENDER_REPORT
-
ACCOUNT_INTERESTS_REPORT
-
ACCOUNT_LOCATIONS_REPORT
-
ACCOUNT_PLATFORMS_REPORT
-
ACCOUNT_PLATFORM_VERSIONS_REPORT
-
ACCOUNT_POSTAL_CODES_REPORT
-
ACCOUNT_REGIONS_REPORT
-
CAMPAIGN_AGE_REPORT
-
CAMPAIGN_APP_STORE_CATEGORY_REPORT
-
CAMPAIGN_CONVERSION_TAGS_REPORT
-
CAMPAIGN_DEVICES_REPORT
-
CAMPAIGN_EVENTS_REPORT
-
CAMPAIGN_GENDER_REPORT
-
CAMPAIGN_INTERESTS_REPORT
-
CAMPAIGN_KEYWORDS_REPORT
-
CAMPAIGN_LANGUAGES_REPORT
-
CAMPAIGN_LOCATIONS_REPORT
-
CAMPAIGN_PLATFORMS_REPORT
-
CAMPAIGN_PLATFORM_VERSIONS_REPORT
-
CAMPAIGN_POSTAL_CODES_REPORT
-
CAMPAIGN_REGIONS_REPORT
-
CAMPAIGN_SIMILAR_TO_FOLLOWERS_OF_USER_REPORT
-
CAMPAIGN_TV_SHOWS_REPORT
-
FUNDING_INSTRUMENT_AGE_REPORT
-
FUNDING_INSTRUMENT_APP_STORE_CATEGORY_REPORT
-
FUNDING_INSTRUMENT_CONVERSION_TAGS_REPORT
-
FUNDING_INSTRUMENT_DEVICES_REPORT
-
FUNDING_INSTRUMENT_EVENTS_REPORT
-
FUNDING_INSTRUMENT_GENDER_REPORT
-
FUNDING_INSTRUMENT_INTERESTS_REPORT
-
FUNDING_INSTRUMENT_LOCATIONS_REPORT
-
FUNDING_INSTRUMENT_PLATFORMS_REPORT
-
FUNDING_INSTRUMENT_PLATFORM_VERSIONS_REPORT
-
FUNDING_INSTRUMENT_REGIONS_REPORT
-
LINE_ITEM_AGE_REPORT
-
LINE_ITEM_APP_STORE_CATEGORY_REPORT
-
LINE_ITEM_CONVERSION_TAGS_REPORT
-
LINE_ITEM_DEVICES_REPORT
-
LINE_ITEM_EVENTS_REPORT
-
LINE_ITEM_GENDER_REPORT
-
LINE_ITEM_INTERESTS_REPORT
-
LINE_ITEM_KEYWORDS_REPORT
-
LINE_ITEM_LANGUAGES_REPORT
-
LINE_ITEM_LOCATIONS_REPORT
-
LINE_ITEM_PLATFORMS_REPORT
-
LINE_ITEM_PLATFORM_VERSIONS_REPORT
-
LINE_ITEM_POSTAL_CODES_REPORT
-
LINE_ITEM_REGIONS_REPORT
-
LINE_ITEM_SIMILAR_TO_FOLLOWERS_OF_USER_REPORT
-
LINE_ITEM_TV_SHOWS_REPORT
-
PROMOTED_TWEET_AGE_REPORT
-
PROMOTED_TWEET_APP_STORE_CATEGORY_REPORT
-
PROMOTED_TWEET_CONVERSION_TAGS_REPORT
-
PROMOTED_TWEET_DEVICES_REPORT
-
PROMOTED_TWEET_EVENTS_REPORT
-
PROMOTED_TWEET_GENDER_REPORT
-
PROMOTED_TWEET_INTERESTS_REPORT
-
PROMOTED_TWEET_KEYWORDS_REPORT
-
PROMOTED_TWEET_LANGUAGES_REPORT
-
PROMOTED_TWEET_LOCATIONS_REPORT
-
PROMOTED_TWEET_PLATFORMS_REPORT
-
PROMOTED_TWEET_PLATFORM_VERSIONS_REPORT
-
PROMOTED_TWEET_POSTAL_CODES_REPORT
-
PROMOTED_TWEET_REGIONS_REPORT
-
PROMOTED_TWEET_SIMILAR_TO_FOLLOWERS_OF_USER_REPORT
-
PROMOTED_TWEET_TV_SHOWS_REPORT
-
MEDIA_CREATIVE_REPORT
Limitations
None.