Twitter Organic link
Twitter is a microblogging and social networking service. Fivetran's Twitter Organic connector provides a history of the settings and a detailed report of your organic tweet data. You can find more information in Twitter's documentation.
If you are looking for the paid digital advertising data, see our Twitter Ads connector.
Featureslink
Feature Name | Supported | Notes |
---|---|---|
Capture deletes | ||
Custom data | ||
Data blocking | check | Column level and table level |
Column hashing | check | |
Re-sync | check | Connector level |
History | check | ACCOUNT_HISTORY,CARD_HISTORY and SCHEDULED_TWEET_HISTORY |
API configurable | check | API configuration |
Priority-first sync | check | ORGANIC_TWEET_REPORT table |
Fivetran data models | check | Get the models: source / transform; Get the social media reporting model ; Supports Quickstart data models |
Private networking |
Setup guidelink
Follow our step-by-step Twitter Organic setup guide to connect Twitter with your destination using Fivetran connectors.
Schema informationlink
This schema applies to all Twitter Organic connectors.
To zoom, open the ERD in a new window.Twitter Report Tableslink
There is one reporting table ORGANIC_TWEET_REPORT
with ENGAGEMENT and VIDEO metric groups.
NOTE: All the columns in the report, except the metrics, are primary keys by default.
ORGANIC_TWEET_REPORTlink
COLUMN | REFERENCE |
---|---|
date 🔑 | |
account_id 🔑 | ACCOUNT_HISTORY |
organic_tweet_id 🔑 | TWEET_HISTORY |
engagements metrics* | |
video metrics* |
NOTE: A
*
suffix in the column name indicates multiple metrics of the same type. For example,engagements metrics*
includes the following columns:
- engagements
- impressions
- retweets
- replies
- likes
- follows
- card_engagements
- clicks
- app_clicks
- qualified_impressions
For more details regarding metric groups, refer to Twitter Metrics and Segmentation.
UTC conversionlink
We don't convert source timestamps to Universal Time Coordinated (UTC) but use the Twitter account's time zone to store the data in your destination.