How to Export CSV Data from X (Twitter) Analytics and Import It into clariBI

X (formerly Twitter) provides analytics on post performance including impressions, engagements, and profile visits. Note that the legacy analytics.twitter.com dashboard has been discontinued for most users. This guide covers the current methods for exporting your X data for analysis in clariBI.

What You Can Export from X (Twitter) Analytics

• Post impressions and reach
• Engagements (likes, reposts, replies, link clicks, profile clicks)
• Engagement rate per post
• Media views and media engagements
• Post text and posting timestamps
• Follower growth trends
• Monthly summary data (impressions, profile visits, follower changes)

Export CSV Data from X (Twitter) Analytics

Method 1: Export via Third-Party Social Media Tools (Recommended)

The most reliable way to export X analytics as CSV is through a connected social media management tool such as Hootsuite, Buffer, or Sprout Social. If you already use one of these tools to manage your X account:

1. Log in to your social media management platform
2. Navigate to the Analytics or Reports section
3. Select your X (Twitter) account from the channel selector
4. Set your desired date range
5. Click Export and choose CSV as the format
6. The CSV will include per-post metrics such as impressions, engagements, clicks, and engagement rate

Method 2: X Premium Analytics

If you have an X Premium subscription, you can access enhanced analytics:

1. Log in to X at x.com
2. Click on any of your posts, then tap the View Analytics bar chart icon below the post
3. View detailed metrics for that post including impressions, engagements, profile visits, and link clicks
4. For bulk data, use the X API v2 (see Method 3) or a third-party tool, as X does not currently offer a built-in bulk CSV export from the platform interface

Method 3: X API Export (Technical)

For users comfortable with APIs or developer tools:

1. Apply for access to the X API v2 at developer.x.com
2. Use the Tweet Metrics endpoint to retrieve engagement data for your posts
3. Export the API response data to CSV using a script or a tool like Postman
4. This method provides the most complete and customizable data export

Tips for Clean Exports

• Third-party tools (Hootsuite, Buffer, Sprout Social) are the easiest path to a CSV export of your X analytics — most paid plans include this feature
• If using the API, request data in batches of 7-30 days for manageable file sizes
• X analytics data may take 24-48 hours to fully populate, so avoid exporting data from the current or previous day

Import Your Data into clariBI

1. Log in to your clariBI account at claribi.com
2. Click Data Sources in the left sidebar
3. Click the + Add Source button (top right)
4. Under Direct Upload, select CSV File
5. Enter a descriptive name (e.g., "X Analytics - Tweet Performance Jan 2025")
6. Click the upload area or drag and drop your CSV file
7. Click Create Data Source

Once imported, you can ask clariBI questions like:
- "Which tweets had the highest engagement rate this month?"
- "What time of day do my posts get the most impressions?"
- "How do tweets with images compare to text-only tweets in engagement?"

clariBI's AI will automatically analyze your data and suggest relevant insights.