How to Export CSV Data from Meta Business Suite and Import It into clariBI

Meta Business Suite is the central hub for managing your Facebook and Instagram business accounts. You can export performance insights, content data, and ad reports as CSV files and analyze them in clariBI for AI-driven social media insights.

What You Can Export from Meta Business Suite

• Page insights (reach, engagement, followers, impressions)
• Post-level performance metrics (likes, comments, shares, clicks)
• Content publishing history with engagement data
• Ad campaign performance from Ads Manager (impressions, clicks, spend, conversions)
• Audience demographics and location data
• Instagram account insights (reach, interactions, profile visits)
• Video performance metrics (views, watch time, retention)
• Scheduled and published content reports

Export CSV Data from Meta Business Suite

Method 1: Export Page Insights

1. Log in to Meta Business Suite at business.facebook.com
2. Click on Insights in the left sidebar
3. Select the date range you want to analyze using the date picker at the top
4. Navigate to the Overview, Results, Audience, or Benchmarking tab
5. Click the Export Data button (typically in the top right of the insights section)
6. Select the date range, data format (CSV), and the metrics you want to include
7. Click Export and download the CSV file

Method 2: Export Content Performance

1. In Meta Business Suite, click on Content in the left sidebar
2. Select Published to see your posted content
3. Set the date range filter at the top
4. Click the Export button to download content performance data
5. Choose CSV format
6. The export will include post type, reach, engagement, clicks, and reactions for each piece of content

Method 3: Export Ad Reports from Ads Manager

1. From Meta Business Suite, click on Ads or navigate directly to Ads Manager at adsmanager.facebook.com
2. Select the ad account and set the date range
3. Choose the reporting level: Campaign, Ad Set, or Ad
4. Customize columns to include the metrics you want (impressions, reach, clicks, CTR, spend, CPC, conversions, ROAS)
5. Click the Reports dropdown or the Export button in the toolbar
6. Select Export Table Data > CSV
7. Download the CSV file with your ad performance data

Method 4: Export Audience Data

1. Go to Insights > Audience in Meta Business Suite
2. Review the available audience breakdown (age, gender, location, active times) — note that audience demographic data has become more limited since Meta deprecated the standalone Audience Insights tool
3. Click the Export Data button if available
4. Select CSV and the date range
5. Download the file containing your audience data. If direct export is not available for all demographics, use the Ads Manager audience reporting for more detailed breakdowns

Method 5: Export from the Insights API (Advanced)

1. For automated or large-scale exports, use the Meta Graph API
2. Access the Page Insights endpoint: `GET /{page-id}/insights`
3. Specify the metrics and date range in your API request
4. Parse the JSON response and convert to CSV format
5. Save the CSV file for import into clariBI

Tips for Clean Exports

• Export insights and ad data for the same date range to correlate organic and paid performance in clariBI
• Use Ads Manager for granular ad performance data rather than the simplified view in Meta Business Suite
• Export weekly or monthly to build a time series dataset for long-term trend analysis

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., "Meta Business Suite - Page Insights Q1 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:
- "What is the engagement rate trend for my Facebook page over the last 6 months?"
- "Which ad campaigns had the best return on ad spend (ROAS) this quarter?"
- "Show me the top 10 posts by reach and their corresponding engagement rates."

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