Connector: Twitter Organic (the same applies to Twitter Ads)

What Please add the post-level metrics that X API v2 returns on GET /2/tweets with tweet.fields=public_metrics,non_public_metrics,organic_metrics,promoted_metrics:

• public_metrics.impression_count (lifetime, organic + promoted; the "views" number shown under every post)
• organic_metrics.impression_count and promoted_metrics.impression_count (lifetime split; X returns these only for posts created within the last 30 days, with user-context auth)
• the other counts in the same objects (like_count, retweet_count, reply_count, quote_count, url_link_clicks, user_profile_clicks)

A table keyed by tweet id with one row per post, upserted on each sync, would be ideal. A history-mode option that keeps each sync's values would let users retain the organic/promoted split after the 30-day window closes.

Why

• The connector currently exposes only the Ads API stats reports (organic_tweet_report, promoted_tweet_report), which are one row per post per day. Reporting a post's cumulative impressions means summing a very large number of daily rows, and the result still does not match the view count X shows under the post, because X computes that number per post.
• For promoted posts, the public view count is noticeably higher than organic + promoted impressions from the stats reports, and there is no API-based number in the connector that matches what users see on X.
• A lifetime metric fetched together with the posts would also be more robust than the daily stats job, which depends on the Ads API stats endpoint.

Reference X API v2 metrics: https://docs.x.com/x-api/fundamentals/metrics (public impression_count is the combined organic + promoted total; organic, promoted and non-public metrics are available only for posts created in the last 30 days)

If user-context auth is not feasible for the connector, adding public_metrics alone (app-only auth) would already cover the main need.