How to Print Facebook Ad Report

Need a printable copy of your Facebook Ads performance? Getting a clean, shareable report of your campaign results is a common task, whether you're updating a client, informing your boss, or analyzing performance with your team. This article will walk you through creating and printing your Facebook Ads report directly from Ads Manager and explore more efficient, dynamic ways to share your data.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Before You Print: What Your Report Should Include

Before exporting anything, it's smart to decide what you actually need to show. The goal of a report isn't to present every single data point but to tell a story and answer key business questions. Your audience will determine which metrics are most important.

Here’s a quick checklist to consider:

• Key Performance Indicators (KPIs): What defines success for these campaigns? Don't just show numbers, show the right numbers. Common KPIs include:
• Descriptive Information: You'll need context. Always include the Campaign Name and Ad Set Name so everyone knows what they're looking at.
• Breakdowns: This is where the real insights are hiding. Analyzing performance by different segments helps you understand why certain campaigns are successful. Good breakdowns include:
• Timeframe: Are you reporting on last week's performance, the last 30 days, or the entire quarter? Make sure the date range is clearly defined.

Thinking about this first will save you from exporting a cluttered spreadsheet that no one can understand.

How to Export and Print a Report From Facebook Ads Manager

Facebook doesn't have a direct "Print" button in Ads Manager that creates a perfectly formatted page. The standard process involves customizing your view, exporting the data as a spreadsheet file, and then printing that file. It sounds like a few steps, but it gives you full control over what appears in your final report.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step 1: Customize Your Columns

First, you need Ads Manager to show the exact data you want in your report. By default, Facebook shows a "Performance" preset, which might not be exactly what you need.

1. Navigate to the Campaigns, Ad Sets, or Ads tab.
2. Look for the Columns dropdown menu (it's usually located above the results table, on the right).
3. Click on it and select Customize Columns.
4. A pop-up window will appear. Here, you can search for and select the specific metrics you decided on in the checklist above (e.g., ROAS, CTR, Amount Spent). Add, remove, and reorder them until the list on the right-hand side matches your desired report structure.
5. Click Apply to save your view.

Pro Tip: Once you've created a custom column set you like, you can save it as a preset to quickly access it later. After customizing, click the Columns dropdown again and choose Save as preset.

Step 2: Get the Right Timeframe

Next, set the date range for your report. In the top-right corner of Ads Manager, you'll find the date range picker. You can choose from presets like "Last 7 Days" or "Last 30 Days," or set a custom range.

Step 3: Add Breakdowns for More Detail (Optional)

If you want to drill down into your data, use the Breakdown feature. The Breakdown dropdown is located next to the Columns menu. You can segment your data by Time (Day, Week), Delivery (Age, Gender, Placement), or Action (Conversion Device).

For example, selecting Breakdown > By Delivery > Placement will show you separate rows for each campaign's performance on Facebook Feed, Instagram Stories, Reels, etc. This is incredibly useful for spotting optimization opportunities.

Step 4: Export Your Data

Now that your view is set up perfectly, you're ready to export.

1. Click the Reports icon (it looks like a mini chart with a down arrow).
2. From the dropdown, select Export Table Data...
3. You'll see a pop-up. Choose your file format. For printing, Export as .xlsx is usually the best option, as it will open in Excel or Google Sheets with some formatting intact. A .csv works too, but it's just raw, comma-separated data.
4. Click Export. Your report will download to your computer.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Step 5: Format and Print from Your Spreadsheet Program

Open the downloaded .xlsx file in your preferred spreadsheet software (Microsoft Excel, Google Sheets, etc.). The raw export is often not very print-friendly - columns can be too wide and the text too small.

Quick Formatting Tips for Printing:

• Delete Unnecessary Columns: Sometimes Facebook exports extra columns you didn't ask for ("Reporting Starts", "Reporting Ends"). Delete them to clean up the view.
• Adjust Column Widths: Double-click the line between column headers (like between A and B) to automatically fit the width to the content.
• Use Print Preview: Go to File > Print to see a preview of how the document will look printed. This is where you can make crucial adjustments.
• Change Page Orientation: Most ad reports are wide, so switching to Landscape orientation (under Page Setup or Print Settings) is a good idea.
• Scale to Fit: Use the "Scale to Fit" option to shrink the report to fit on a single page width. You can find this in the Print settings dialog, often under a "Scaling" dropdown. Choose "Fit All Columns on One Page."

Once you're happy with the preview, you're ready to print your report or save it as a PDF for easy sharing.

Limitations of This Manual Process

While exporting from Ads Manager works, it has some significant drawbacks, especially if you do this regularly.

• It's a Static Snapshot: The moment you export that file, the data is frozen. If you're looking at the report tomorrow, it's already out of date.
• It Lacks Visual Appeal: A spreadsheet table of numbers isn't the best way to convey performance. Charts and graphs help people absorb information much faster.
• It's Time-Consuming and Repetitive: If this is a weekly task, you know the drill: log in, customize columns, export, format... it becomes a tedious cycle that eats up valuable time you could be spending on strategy. We call that the dreaded Monday reporting scramble: download your CSVs, wrangle them in a spreadsheet for Tuesday’s meeting, and by the time it’s ready, half your week is already gone.
• No Cross-Platform Context: Your Facebook ads don't exist in a vacuum. A standard Facebook export won't show you how that ad spend connects to your Shopify sales data or affects your Google Analytics traffic. You're only seeing one piece of the puzzle.

Better Ways to Report on Facebook Ads Performance

Rather than printing weekly spreadsheets, modern data reporting focuses on live, visual dashboards that provide a holistic view of performance. Here are some alternatives.

1. Use Facebook’s Built-In Reporting Tools

Ads Manager has a built-in custom report builder. You can access it by clicking the same Reports icon and selecting Create Custom Report. This tool lets you create tables and charts inside of Facebook and save them for later. They can be more visual than a spreadsheet, but they are still stuck inside Facebook and share the same limitation of platform isolation.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

2. Build a Connected Dashboard in a BI Tool

Tools like Looker Studio (formerly Google Data Studio) or Microsoft Power BI allow you to connect directly to your Facebook Ads account. You can build dashboards that pull data automatically, updating in near real-time.

The benefits are huge: the reports are always current, you can build beautiful charts, and most importantly, you can pull in data from other sources like Google Analytics, Shopify, and Google Sheets to see your full marketing funnel.

The downside? These tools come with a massive learning curve. It can take dozens of hours to become proficient, and setting up the data connections correctly requires some technical skill.

Final Thoughts

Knowing how to export and print a clear report from Facebook Ads Manager is a useful skill for any marketer. By carefully customizing your columns, date range, and breakdowns, you can create a detailed, static snapshot of your campaign performance. But for a more impactful and efficient workflow, it's worth embracing live, visual dashboards that tell the complete story of your data.

We built Graphed to bypass the headaches of manual exporting and the steep learning curve of traditional BI tools. Instead of spending hours in spreadsheets or learning complex software, you can connect your marketing accounts (like Facebook Ads, Google Ads, and Shopify) in a few clicks. Then, just ask for what you want in plain English - like "create a dashboard showing Facebook ROAS vs. Shopify sales over the last 30 days” - and watch it get built instantly. It gives you live, automated reports so you can spend less time pulling data and more time acting on it.