How to Export Facebook Ad Data

Pulling your advertising data out of Facebook Ads Manager is the critical first step to understanding what’s really working. Instead of endlessly clicking around inside the platform, exporting your data lets you slice, dice, and analyze it however you want. This article gives you a step-by-step walkthrough for exporting your Facebook Ads data and offers some practical tips for what to do with it afterward.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Why Bother Exporting Your Facebook Ads Data?

You might wonder why you can't just analyze everything within Ads Manager itself. While its interface has improved over the years, it still primarily offers a surface-level view of your campaigns. The real insights often come from digging deeper and, most importantly, combining that data with other sources.

Here are the biggest reasons to make data exports a regular part of your routine:

• Deeper, Custom Analysis: Once your data is in a spreadsheet like Excel or Google Sheets, your analytical power expands dramatically. You can create pivot tables, write custom formulas (like a unique Cost-Per-Lead calculation that includes ad spend and team costs), and filter your data in ways Facebook’s interface doesn’t allow. This is how you move from just seeing metrics to actually modeling your business.
• Connecting Data Across Platforms: Your Facebook ads are just one piece of the customer journey. True performance analysis happens when you combine that ad data with information from other tools. How do Facebook leads convert in your Salesforce pipeline? Did that high-ROAS campaign on Facebook result in high-value customers in Shopify, or just a lot of one-off purchases? You can’t answer these crucial questions inside Ads Manager. Exporting is the first step to creating that complete picture.
• Custom Dashboards and Stakeholder Reports: Let's be honest, the built-in dashboards in Ads Manager are rigid. Exporting the raw data gives you complete control over building your own visualizations. You can create branded reports for clients, build internal dashboards that track your team's specific KPIs, and tell a visual story that is impossible to craft using Facebook's standard charts.
• Data Archiving and Backup: Platforms change, and sometimes data can become corrupted or inaccessible. Regularly exporting your performance data acts as a reliable backup. It allows you to build a historical record of your account’s performance that you own and control, independent of Meta’s platform.

A Step-by-Step Guide to Exporting Data from Ads Manager

Fortunately, Facebook makes it relatively straightforward to export your data once you know where to look. Let's walk through the process from start to finish.

Step 1: Navigate to the Correct View in Ads Manager

Log in to your Facebook Ads Manager account. Your default view will usually show a list of your campaigns. You can use the tabs at the top of the table to switch between Campaigns, Ad Sets, or Ads. Your export will be based on the level of detail you’ve chosen here. If you want to analyze individual ads, click the Ads tab. If you prefer to see performance by targeting audience, stay on the Ad Sets tab.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 2: Set Your Date Range

This is a simple but crucial step. In the top-right corner of the Ads Manager screen, you'll see a date range filter (e.g., "Last 7 Days"). Click on it to open the calendar view. You can choose from presets like "Today," "Yesterday," "Last 30 Days," or set a custom range. Make sure you select the exact period you want to analyze before moving on.

Step 3: Customize Your Columns to Select Key Metrics

This is the most important part of the process. The "columns" are the metrics you want to export. By default, Facebook shows a standard "Performance" set, but you'll almost always want to customize this.

1. Find the "Columns" dropdown button above the right side of the performance table.
2. Click it and hover over the presets to see what they contain. For most analyses, you'll want to click "Customize Columns..." at the bottom of the list.
3. A new pop-up window will appear, showing dozens of available metrics. Check the boxes next to the ones you need.

Not sure what to choose? Here is a solid starting list for most marketing performance analyses:

• Delivery & Spend: Impressions, Reach, Frequency, Amount Spent
• Engagement: Link Clicks, Post Engagements, All Clicks
• Performance Metrics: Cost per Result, Result Rate, Quality Ranking
• Conversion & Sales Metrics: Adds to Cart, Checkouts Initiated, Purchases, Purchase ROAS (Return On Ad Spend), Website Leads
• Key Ratios: CTR (Link Click-Through Rate), CPC (Cost per Link Click), CPM (Cost per 1,000 Impressions)

Once you’ve selected your desired metrics, you can drag and drop them on the far-right panel to reorder how they'll appear in your exported file. Click the blue "Apply" button to save your column set.

Step 4: Use Breakdowns for More Granular Data

Breakdowns allow you to segment your data even further. You can slice your chosen metrics by variables like age, gender, country, or placement. This is how you discover powerful insights, such as "my ROAS is highest among 35-44 year old women in Instagram Stories."

• Click the "Breakdown" dropdown menu, located next to the Columns button.
• You can choose breakdowns "By Time" (Day, Week, Month), "By Delivery" (Age, Gender, Country, Placement), or "By Action" (Conversion Device, Destination).

Fair warning: Using multiple breakdowns can make your export file very large and complex. It's often best to start with one breakdown at a time (e.g., export one file broken down by Placement, and another file broken down by Age).

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 5: Exporting Your Final Report

With your date range, columns, and breakdowns set, your table in Ads Manager now shows exactly the data you want. It's time to export it.

• Look for the "Share" icon in the top right, usually depicted as a box with an arrow pointing out. Sometimes this may be labeled "Export."
• Click it, and select "Export Table Data."
• A small dialogue box will give you a choice between file formats. You can choose to export as a .csv or .xlsx file. For maximum compatibility with other tools and spreadsheets, CSV (Comma-Separated Values) is almost always the best option.
• Click the blue "Export" button. Your file will start downloading immediately.

Common Pitfalls and Pro Tips

Exporting seems easy, but a few small mistakes can lead to meaningless data. Here are some things to watch out for and some tips to make the process smoother.

Tip #1: Save Your Column Sets as Presets

Tired of manually selecting the same 20 metrics every single time? You don't have to. After you've customized your columns and clicked "Apply," go back to the "Columns" dropdown and look for a "Save" or "Save as preset" option. Give your set a descriptive name like "Weekly Ecom Performance" or "Lead Gen KPI Report." Now, it will appear in the dropdown menu for one-click access next time.

Pitfall #1: Messy Breakdowns

As mentioned before, avoid applying too many breakdowns at once. A report broken down by Age, Gender, and Placement will result in hundreds or thousands of rows for a single ad, making analysis in a spreadsheet a nightmare. Stick to one, maybe two, breakdowns per export.

Pitfall #2: Forgetting to Check Your Attribution Setting

Before you export, look for your account's attribution setting (often under a "Compare attribution settings" dropdown or in your account's main settings). Are you looking at conversions based on a "7-day click or 1-day view" window, or something else? Inconsistent attribution settings are a huge source of confusion when comparing data over time or across platforms.

Graphed

Still Building Reports Manually?

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

Watch the Demo

What to Do After You Export: The Manual Reporting Cycle

You’ve got your CSV file. You open it in Google Sheets or Excel. Now what?

For most marketers and business owners, this is where the real work begins. Your raw data needs to be cleaned up, cells need formatting, and you'll likely start building pivot tables to summarize campaign performance. Then, you create charts and graphs to visualize the results, copy them into a presentation, and prepare your talking points.

This whole cycle is time-consuming and tedious, especially because it's rarely a one-time task. Most teams repeat this exact process every single week. On Monday, they download the CSVs. On Tuesday, they wrangle the data into a report. By Wednesday, follow-up questions from the team send them back into the spreadsheets all over again, and half the week is gone just preparing reports.

Final Thoughts

In this article, we've walked through how to take control of your advertising data by exporting it directly from Facebook Ads Manager. Mastering this process is a huge step up from only using the in-platform reports, allowing you to combine it with other business data and uncover deeper, more meaningful insights about your performance.

This manual process of downloading CSVs and building reports week after week is exactly the friction we built Graphed to eliminate. Instead of spending hours in spreadsheets, we connect directly to your Facebook Ads, Google Analytics, Shopify, and Salesforce accounts. You can then ask for the dashboard you need in plain English - like "create a dashboard comparing Facebook spend vs. Shopify revenue by campaign for the last 90 days" - and get a live, real-time dashboard built for you in seconds. We help you skip the repetitive downloads and get straight to the insights so you can get back to growing your business.