How to Export CSV Data from Meta Ads Manager and Import It into clariBI

Meta Ads Manager is the central platform for managing Facebook and Instagram advertising campaigns. Exporting your ad data into clariBI allows you to analyze campaign ROI, audience performance, and creative effectiveness with AI-powered insights.

What You Can Export from Meta Ads Manager

• Campaign, ad set, and ad-level performance metrics
• Impressions, reach, frequency, clicks, and CTR
• Cost data (spend, CPC, CPM, cost per result)
• Conversion metrics (leads, purchases, add to carts, custom conversions)
• Audience breakdown data (age, gender, placement, device, region)
• Ad creative performance (which images and copy perform best)
• ROAS (return on ad spend) and purchase value data
• Video performance metrics (views, watch time, ThruPlays)

Export CSV Data from Meta Ads Manager

Method 1: Export Table Data

1. Go to adsmanager.facebook.com and log in with your Meta account
2. Select the correct ad account from the account dropdown (top left)
3. Choose the level of data you want: Campaigns, Ad sets, or Ads tabs
4. Set your desired date range using the date picker in the top right
5. Customize your columns by clicking Columns and selecting a preset (e.g., Performance, Engagement, Conversions) or create custom columns
6. Apply any filters you need (e.g., campaign objective, delivery status)
7. Click the Reports dropdown button (or the export/download icon at the right side of the toolbar)
8. Select Export Table Data > CSV (or .csv)
9. The CSV file will download with all visible campaign/ad set/ad data

Method 2: Export from Ads Reporting

1. Click Reports in the left sidebar or from the Ads Manager toolbar select Ads Reporting
2. Build a custom report by selecting your metrics, breakdowns, and filters
3. Add dimensions like age, gender, placement, or country for breakdown analysis
4. Set your date range and date granularity (day, week, month)
5. Click the Export button (top right of the report view)
6. Choose CSV as the format
7. Ads Reporting gives you more flexibility than the standard table export for custom analysis

Tips for Clean Exports

• Use the Breakdown feature (age, gender, placement, time) before exporting to get segmented data in your CSV — this is extremely useful for audience analysis in clariBI
• Custom column presets help you export consistent data each time — save a column preset for your regular clariBI imports
• If you manage multiple ad accounts, export each account separately for cleaner data organization

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 Ads - Campaign Performance 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 ad sets have the lowest cost per acquisition this month?"
- "How does ad performance differ between Facebook and Instagram placements?"
- "What age and gender demographics produce the highest ROAS for our campaigns?"

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