X Organic
X is a microblogging and social networking service. Fivetran's X Organic connector provides a history of the settings and a detailed report of your organic tweet data. You can find more information in X documentation.
If you are looking for the paid digital advertising data, see our X Ads connector.
Features
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | ||
| History mode | ACCOUNT_HISTORY, CARD_HISTORY, and SCHEDULED_TWEET_HISTORY tables. | |
| Custom data | ||
| Data blocking | ||
| Column hashing | ||
| Re-sync | ||
| Row filtering | ||
| API configurable | API configuration | |
| Priority-first sync | ORGANIC_TWEET_REPORT table | |
| Fivetran data models | ||
| Private networking | ||
| Authorization via API |
Supported deployment models
We support the SaaS Deployment model for the connector.
Setup guide
Follow our step-by-step X Organic setup guide to connect X 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 X Organic connections.
X Report Tables
There is one reporting table ORGANIC_TWEET_REPORT with ENGAGEMENT and VIDEO metric groups.
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* |
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 X Metrics and Segmentation.