How to Export Facebook Analytics

Unlocking the full story of your ad performance often means getting your data out of Facebook’s ecosystem. Only then can you combine it with other channels, build custom reports, and find the insights that Ads Manager alone cannot show you. This guide provides a clear walkthrough for exporting your advertising data from Facebook Ads Manager and your organic post data from Meta Business Suite.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Export Your Facebook Analytics Data?

While Facebook's built-in analytics dashboards are helpful for quick check-ins, they do not give you the complete picture. Exporting your data is the first step toward a more sophisticated and holistic understanding of your marketing efforts. Here’s why it’s worth the effort:

• See the Full Customer Journey: Your customers don’t just exist on Facebook. Exporting your data allows you to merge it with information from Google Analytics, your email platform, Shopify, or a CRM like Salesforce. This helps you connect the dots between an ad click, a website visit, and a final purchase.
• Create Custom Dashboards and Visualizations: Every business has unique KPIs. You might want to visualize cost-per-lead against return on ad spend (ROAS) over time in a way that Facebook's interface doesn't allow. Exporting to a spreadsheet or BI tool gives you complete freedom to build charts that matter to you.
• Back-Up Your Historical Data: Platforms change. An interface update or data retention policy change could make it harder to access your older performance metrics. Saving your own copies ensures you always have a historical record to reference for trend analysis and forecasting.
• Easily Share with Anyone: Sharing performance reports shouldn't require giving your CEO or a client full access to your Ads Manager account. Exported spreadsheets are universal, making it easy to share clean, concise reports with stakeholders who just need the bottom line.

Before You Export: Setting Up Your View

In Facebook Ads Manager, what you see is what you get. The data you configure in your view is exactly what will be included in your exported file. Taking a minute to set this up correctly will save you headaches later.

Step 1: Select the Right Time Frame

First, make sure you're looking at the right period. Near the top-right corner of Ads Manager, you’ll see the date range filter. You can select presets like "Past 7 days" or "Last 30 days," or click to define a specific custom date range. This determines the time period for the data you are about to export.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 2: Customize Your Columns to Show Key Metrics

This is the most important step. The "Columns" dropdown menu lets you choose which metrics you want to see and export. Facebook offers handy presets like:

• Performance: Focuses on top-level results, reach, impressions, and cost.
• Delivery: Shows metrics like reach, frequency, and amount spent.
• Engagement: Highlights page likes, post comments, and other social interactions.

For truly useful analysis, you'll want to click "Customize Columns." A window will pop up where you can search for and select the exact metrics your business cares about. Common metrics to include are:

• Results: The primary outcome of your campaign (e.g., Leads, Website Purchases).
• Cost per Result: How much you paid for each desired action.
• ROAS (Return On Ad Spend): A critical metric for e-commerce.
• CTR (Click-Through Rate): The percentage of people who saw your ad and clicked.
• CPC (Cost Per Click): The average amount you pay for each click.
• Conversion Rate: What percentage of clicks resulted in a conversion.
• Amount Spent: Your total ad spend for the selected period.

Take your time and check off everything you need. You can drag and drop the metrics on the right side of the window to reorder how they'll appear in your columns.

Step 3: Use Breakdowns for Deeper Insights

To really dig into performance, you need to segment your data. The "Breakdown" dropdown lets you slice your data by different variables, providing a more detailed view. Popular breakdowns include:

• By Time: See how your campaigns perform by Day, Week, or Month.
• By Delivery: Analyze performance by Age, Gender, Country, Region, or Placement (e.g., Facebook Feed, Instagram Stories, Messenger).
• By Action: See which devices people converted on (desktop vs. mobile) or a breakdown of specific conversion events.

For example, using the "Placement" breakdown lets you directly compare the effectiveness of your ads running on Instagram Reels versus the Facebook Marketplace – an insight that’s impossible to get without segmentation.

How to Export Data from Facebook Ads Manager

Once your view is set up with the right dates, columns, and breakdowns, you're ready to export. The process is straightforward.

Step 1: Navigate to Ads Manager

Go to your Facebook Ads Manager dashboard.

Step 2: Select Your Campaign, Ad Set, or Ad

Choose the level of detail you want to export. By clicking on the "Campaigns," "Ad Sets," or "Ads" tab, you'll filter your view. If you select a specific campaign first, your export will contain data only for the ad sets and ads within that campaign.

Step 3: Review Your Columns, Date Range, and Breakdowns

Give your setup one final check. Is the date range correct? Are all the metrics you need present in the columns? Is the breakdown applied correctly? Doing this now prevents you from having to repeat the whole process.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 4: Find and Click the 'Reports' Button

Look for an icon that looks like a box with an arrow pointing out of it, located just above your data table near the search bar. This is the "Reports" button. Click it, and you'll see a dropdown menu.

Step 5: Choose "Export Table Data..."

From the dropdown menu, select "Export Table Data...". A pop-up will appear, giving you formatting options. You can leave the "Report name" as the default or give it a custom name for your records.

Next, you’ll choose a file format:

• Export as .csv: CSV (Comma Separated Values) is a plain-text format that is universally compatible with almost any spreadsheet program or data tool. Choose this if you're importing the data into another system.
• Export as .xlsx: This is a standard Microsoft Excel file. Choose this option if you plan to work directly in Excel, as it preserves some formatting and is often easier to open directly.

Step 6: Click 'Export' and Download Your File

After clicking "Export," Facebook will prepare your file. A notification will appear when it's ready, and the file will download to your computer. Now you can open it in Excel, Google Sheets, or your business intelligence tool of choice to start your analysis.

What About Organic Posts? Exporting from Meta Business Suite

Paid ads are only part of the story. You might also want to analyze the performance of your organic Facebook and Instagram posts. This data lives in Meta Business Suite.

Step 1: Go to Meta Business Suite

Navigate to business.facebook.com and select the correct account.

Step 2: Navigate to 'Insights'

In the left-hand navigation menu, click on "Insights." You'll see several sections here for overall performance. For post-specific data, click on the "Content" tab at the top.

Step 3: Review Your Published Posts and Select a Date Range

You’ll see a list of your recently published organic content. In the top right, find the date range picker to select the period you want data for.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 4: Click 'Export data'

Just above the list of your posts, you'll find a button labeled "Export data."

Step 5: Choose Your Export Settings

A window will pop up with a few options. You can choose to export data at the "post level," which gives you one row for each post and summarizes reach, likes, comments, etc., or dive deeper. You can select Facebook, Instagram, or both, and choose your file format (.csv or .xlsx). Once configured, click "Export data" to download your file.

Practical Tips for Working With Your Exported Data

Getting the data out is just the beginning. Here are a few things to keep in mind as you start working with your files.

• Be Prepared for Large Files: If you're managing big campaigns with long date ranges and lots of breakdowns, your export file can become quite large. Be patient while it downloads, and know that it might run slowly in older versions of Excel.
• Clean Your Data: Raw data exports can feel messy. You’ll likely want to hide unnecessary columns, filter out test campaigns, or create new calculated columns (like Conversion Rate) from the metrics you exported.
• Leverage Pivot Tables: For those working in Excel or Google Sheets, pivot tables are your best friend. They allow you to quickly summarize, group, and analyze your raw data to spot trends you might otherwise miss.
• Recognize the Manual Grind: This process works, but it’s time-consuming. If you find yourself exporting the same report every Monday morning, you're spending precious time on manual data wrangling instead of strategic analysis.

Final Thoughts

Exporting analytics from Facebook is a necessary skill for any data-driven marketer, opening the door to deeper performance analysis, custom reporting, and a clearer view of your entire sales funnel. Following the steps for Ads Manager and Meta Business Suite gives you the raw materials you need to build a comprehensive picture of what’s working and what isn’t.

But the weekly routine of downloading CSVs, cleaning them up in spreadsheets, and manually building charts burns hours you could use to strategize and act on insights. We believe data shouldn't be that hard to work with. That’s why we built Graphed to automate this entire process for you. Instead of manual exports, just connect your Facebook Ads account and other data sources once, and use plain English to build real-time, auto-updating dashboards that answer your questions in seconds, not hours.