How to Export CSV Data from Hootsuite and Import It into clariBI

Hootsuite provides comprehensive social media management and analytics across multiple platforms. Exporting this data into clariBI allows you to perform advanced analysis on post performance, audience engagement, and cross-channel trends.

What You Can Export from Hootsuite

• Post performance metrics (impressions, reach, engagement, clicks)
• Audience growth and follower trends per channel
• Engagement breakdown (likes, comments, shares, reactions)
• Team performance data (posts published, response times)
• Best time to publish recommendations data
• Content performance by type and format
• Custom report data with selected metrics and date ranges
• Competitor comparison data (if configured)

Export CSV Data from Hootsuite

Method 1: Export from Analytics Reports

1. Log in to your Hootsuite account at hootsuite.com
2. Click Analytics in the left sidebar navigation
3. Select the report you want to export — choose from templates like Post Performance, Overview, Profile Performance, or create a custom report
4. Set your desired date range and social profiles using the filters at the top
5. Click the Export button (download icon, usually at the top right of the report)
6. Select CSV from the export format options (CSV/PDF available)
7. The report data will download as a CSV file

Method 2: Export Post Performance Data

1. Navigate to Analytics > Posts in the left sidebar
2. Select the social profiles and date range you want to analyze
3. Review the post-level data table showing each published post with metrics
4. Click Export (top right) > CSV
5. The file includes individual post text, publish time, and all engagement metrics

Method 3: Export Custom Reports

1. Go to Analytics > My Reports or create a new custom report
2. Add the metrics and widgets you need
3. After the report loads, click the Export button
4. Choose CSV for data-friendly output

Tips for Clean Exports

• Custom reports give you the most control over which metrics are included in your CSV export
• The Post Performance export is the most useful for content analysis in clariBI since it includes per-post granular data
• When exporting from multi-profile reports, the CSV will include a column indicating which social profile each row belongs to

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., "Hootsuite - Social Media 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 social media posts generated the most clicks this month?"
- "What is the engagement trend across all my social channels over the past quarter?"
- "How does my team's posting frequency correlate with follower growth?"

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