How to Export CSV Data from Sprout Social and Import It into clariBI

Sprout Social offers robust reporting and analytics for social media management. Exporting your data into clariBI enables you to combine social performance metrics with other business data for comprehensive cross-channel analysis.

What You Can Export from Sprout Social

• Profile performance data (followers, impressions, engagements per network)
• Post performance with individual metrics (reach, impressions, engagement rate)
• Sent message performance across all connected profiles
• Tag performance reports (if you use Sprout's tagging system)
• Competitor analysis data
• Team and productivity reports (task completion, response times)
• Paid performance data (if ad accounts are connected)
• Custom date range metrics across any report type

Export CSV Data from Sprout Social

1. Log in to your Sprout Social account at sproutsocial.com
2. Click Reports in the left sidebar navigation
3. Select the report type you want to export — common options include:
   - Profile Performance for channel-level metrics
   - Post Performance for individual post data
   - Tag Performance for campaign-specific tracking
   - Competitor Reports for benchmarking
   - Cross-Network Reports for multi-platform summaries
4. Set your desired date range using the date selector at the top of the report
5. Select the social profiles to include using the profile filter
6. Once the report has loaded with your data, click the Export button (top right area of the report)
7. Choose CSV as the export format (export options are CSV for data and PDF for presentation reports)
8. The CSV file will download with all visible report data

Exporting Custom Reports

1. Navigate to Reports > Custom Reports (requires Professional plan or above)
2. Select or create a custom report with the metrics you need
3. Apply your date range and profile filters
4. Click Export > CSV

Note: Premium Analytics CSV customization (selecting specific columns and metrics for export) requires the Advanced plan.

Tips for Clean Exports

• The Post Performance report is ideal for clariBI import because it provides granular per-post data with timestamps and engagement metrics
• Use Sprout's tagging feature to categorize posts before export — the tags column in the CSV makes it easy to filter and analyze campaigns in clariBI
• Export separate reports for organic and paid performance to keep your analysis clean

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., "Sprout Social - Post Performance Report Feb 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 tagged campaigns had the highest engagement rate across all social channels?"
- "How does our organic reach on Instagram compare to Facebook over the last quarter?"
- "What is the average engagement rate by post type and publishing time?"

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