Connect Twitter Ads to your Definite lakehouse in minutes.
Native sync with row-level security, CDC where supported, and hourly-or-faster freshness. Query it with SQL, build dashboards, or ask Fi.
Have multiple Twitter Ads accounts? Analytics across multiple Twitter Ads accounts →
Everything Twitter Ads exposes, modeled and queryable.
Connects to the Twitter Ads API to extract advertising account and campaign objects, targeting catalogs, creatives, promoted content, and account-scoped tweets, plus asynchronous analytics reports. This enables analysis of campaign performance and spend, engagement and video metrics, web and mobile conversions, creative effectiveness, targeting coverage, and comparisons across placements and time granularities.
Tables & streams
Top-level advertiser container that scopes campaigns, billing, and permissions; enables account-level spend and performance rollups and cross-account benchmarking.
Marketing initiative controlling budget and flighting; supports analysis of pacing, spend, goal attainment, and performance across time and placements.
Execution unit under a campaign with objective, bid type, and placement; enables analysis of delivery, cost efficiency (e.g., CPA/CPE), frequency, and A/B strategy tests.
Audience and context selections applied to line items; supports performance breakdowns by geo, device, interests, language, events/TV, and platform, plus reach coverage analyses.
Reusable creative elements used in ads—media, cards, and video CTAs; enables creative effectiveness analysis, format comparisons, and message testing.
Ad-deliverable entities such as promoted tweets and promoted accounts; supports analysis of reach, engagement, and cost by specific content, including scheduled units.
Account-scoped tweets (organic and scheduled) that serve as creative; enables content inventory mapping and organic-versus-paid comparisons when joined to ad metrics.
First-party audience lists for targeting or exclusion; supports segmentation, match-rate monitoring, and performance comparison versus broad or interest-based targets.
Website and app tags used for attribution; enables CPA/ROAS reporting, funnel analysis, and optimization toward downstream conversions.
Asynchronous analytics delivering metrics by entity, placement, and time granularity; powers KPI dashboards, time series, and cohort analyses.
Billing sources linked to the account; supports spend allocation, budget availability, and pacing analysis by payment source.
Authenticates via OAuth 1.0a using your Twitter Ads app’s consumer key/secret and access token/secret
Requires a Twitter Ads account to connect.
Operational data, performance metrics, and business insights.
Three steps. One afternoon.
Authenticate Twitter Ads in a few clicks. OAuth, API key, or IAM role — we handle secrets and rotation.
We pull every stream into your lakehouse. CDC where the API supports it; full + incremental otherwise. Hourly-or-faster, row-level secure.
SQL, dashboards, or ask Fi in plain English. Your Twitter Ads data lives next to every other source — ready to join.
Build your own with the Definite SDK, or ask us — we add new connectors every week.
Pair Twitter Ads with the rest of your data.
Cross-source joins, one governed semantic layer, AI answers across everything.
