Twitter Organic
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.
Features
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | ||
| History mode | check | ACCOUNT_HISTORY, CARD_HISTORY, and SCHEDULED_TWEET_HISTORY tables. |
| Custom data | ||
| Data blocking | check | |
| Column hashing | check | |
| Re-sync | check | |
| API configurable | check | API configuration |
| Priority-first sync | check | ORGANIC_TWEET_REPORT table |
| Fivetran data models | check | |
| Private networking | ||
| Authorization via API | check |
Setup guide
Follow our step-by-step Twitter Organic setup guide to connect Twitter with your destination using Fivetran connectors.
Sync overview
To capture updates and deletes, we re-import the TWEETS table and its child tables during each sync.
Rollback sync
A rollback sync is a sync that automatically runs once a day. Rollback syncs capture the changes that happen outside the incremental sync time frame. To calculate the rollback window, we define a rollback sync range. The rollback window is always no more than 15 days since the last sync.
Schema information
This schema applies to all Twitter Organic connectors.
To zoom, open the ERD in a new window.Twitter Report Tables
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_REPORT
| 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 conversion
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.