How to Create a Facebook Analytics Report

Creating a Facebook Ads report shouldn’t feel like you’re trying to decode a secret message. Getting straight answers about your performance will help you make smarter decisions, prove your marketing ROI, and stop wasting your budget on what isn't working. This tutorial will walk you through setting clear goals, identifying the metrics that truly matter, and building a comprehensive Facebook analytics report, step by step.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

First Things First: Why Do You Need a Report?

Before you dive into a sea of numbers, it’s vital to know what you’re looking for. A good report isn't a data dump, it’s an answer to a specific business question. Jumping into Ads Manager without a clear goal is the fastest way to get lost in vanity metrics and analysis paralysis.

Start by asking what you need to know. Your goal will define which metrics you pull. For example:

• Goal: Prove campaign profitability. You’ll focus on metrics like Amount Spent, Conversions (Purchases), Cost Per Purchase, and Return on Ad Spend (ROAS).
• Goal: Understand your audience. You’ll use breakdowns to analyze performance by age, gender, location, and placement.
• Goal: Improve your ad creative. You’ll want to compare metrics like Click-Through Rate (CTR) and Cost Per Click (CPC) across different ads and formats.
• Goal: Assess top-of-funnel awareness. You’ll look at Reach, Impressions, and Frequency.

Having a question in mind turns reporting from a chore into a high-value strategic activity. Instead of just saying "let's see how our ads are doing," you’re asking, "which ad creative generated the highest profit last week?"

The Key Metrics for Your Facebook Analytics Report

Facebook offers hundreds of metrics, but you only need a handful to tell a compelling story about your performance. Let’s break them down into practical categories so you can build a report that makes sense for your specific goals.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

General Ad Campaign Performance

This is your 30,000-foot view. These metrics tell you how much you're spending and how many people you're reaching.

• Amount Spent: The total amount you've spent on your campaign or ad set during the selected period. It’s the starting point for calculating all your efficiency metrics.
• Reach: The number of unique people who saw your ads at least once. This metric is about how wide your audience is.
• Impressions: The total number of times your ads were displayed on screen. This number will always be higher than Reach because one person can see your ad multiple times.
• Frequency: The average number of times each person saw your ad (Impressions divided by Reach). If your frequency gets too high (say, above 5-7), it might mean you're annoying your audience, leading to "ad fatigue."

Engagement & Efficiency Metrics

These metrics tell you how well your ads are resonating with your audience and how efficiently you're spending your budget to capture their attention.

• Link Clicks: The number of clicks on links within the ad that led to destinations on or off Facebook. This is more valuable than "Clicks (All)," which includes clicks on your Page profile, likes, or comments.
• CPC (Cost Per Link Click): The average cost for each link click (Amount Spent divided by Link Clicks). This helps you understand the cost-effectiveness of your ads in driving traffic.
• CTR (Click-Through Rate): The percentage of people who saw your ad and clicked the link (Link Clicks divided by Impressions). A higher CTR generally indicates a relevant and compelling ad.
• CPM (Cost Per 1,000 Impressions): The average cost to show your ad 1,000 times. This is a common metric to gauge the cost of advertising in a specific placement or to a particular audience.

Conversion & Revenue Metrics

This is where the rubber meets the road. These metrics connect your ad spending directly to business outcomes like sales, leads, and sign-ups. Your Facebook Pixel must be set up correctly to track these.

• Results / Conversions: The number of times your ad achieved an outcome, based on the objective you selected (e.g., Purchases, Leads, Add to Carts). This metric tells you if your ads are actually driving an action.
• Cost Per Result (CPA): The average cost for each specific result (Amount Spent divided by a Result). If you’re running a lead gen campaign, this would be your Cost Per Lead. If it's an e-commerce campaign, it’s your Cost Per Purchase.
• Conversion Value: The total value of the conversions you've tracked. For an e-commerce store, this will be the total revenue from purchases attributed to your ads.
• ROAS (Return On Ad Spend): The total return you got from your ad spend (Conversion Value divided by Amount Spent). A ROAS of 3.5x means that for every $1 you spent on ads, you generated $3.50 in revenue. This is arguably the most important metric for any e-commerce or B2C advertiser.

How to Build Your Report in Facebook Ads Manager

Once you know your goals and metrics, it’s time to pull the data. Facebook's Ads Manager has a powerful but sometimes confusing reporting tool. Here’s a simple, step-by-step process to get exactly what you need.

Step 1: Navigate to the Right View

Go to your Ads Manager dashboard. You’ll see a table with your campaigns, ad sets, and ads. You can create a report at any of these levels, but the Campaign or Ad Set view is often the most useful for strategic analysis.

Step 2: Select Your Date Range

In the top-right corner, there's a date range filter. This is the first thing you should always check! Is your report for last week? The last 30 days? This Quarter? Make sure you select the correct period before you start analyzing the data.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Step 3: Customize Your Columns

The default columns Facebook shows are rarely what you need. This is the most crucial step.

1. Click the "Columns: Performance" dropdown menu, located above your data table on the right.
2. Scroll down and select "Customize Columns..." at the bottom.
3. A window will pop up. In here, you can search for and select all the metrics we discussed above (ROAS, CTR, CPC, Frequency, etc.). As you check them, they’ll appear on the right side. You can drag and drop them to reorder your report.

Pro Tip: Once you've arranged your columns perfectly, click the checkbox at the bottom that says "Save as preset" and give your report a name like "Weekly E-commerce Report" or "Monthly Lead Gen Report." Now, next time, you can just select this preset from the "Columns" dropdown instead of rebuilding it every time.

Step 4: Use "Breakdowns" to Get Deeper Insights

To the right of the "Columns" button is the "Breakdown" button. This is your secret weapon for finding out who is responding to your ads.

You can break your report down by:

• Delivery: Such as Age, Gender, Country, or Region. This helps you identify your most valuable demographic segments.
• Action: Such as Conversion Device. Are mobile users converting better than desktop users?
• Placement: Such as "Platform" or "Placement." Is Facebook Feed outperforming Instagram Stories? Is your money being wasted on the Audience Network?

For example, you could break down your data by "Age" to discover that the 35-44 age bracket has a ROAS of 5.0x while the 18-24 bracket is only at 1.2x. That’s an immediate, actionable insight to adjust your targeting.

Step 5: Export Your Report

Now that your data is perfectly customized and broken down, you need to get it out of Ads Manager. Look for the "Reports" icon in the top right (it looks like a little export arrow).

From here, you can:

• Export Table Data: This allows you to download your current view as a .csv or .xlsx file. You can then use Google Sheets or Excel to format it, add charts, and write up your analysis.
• Create Custom Report: This takes you to a more advanced report builder where you can save reports and schedule them to be emailed to you or other stakeholders automatically on a daily, weekly, or monthly basis.

Using the regular "Export" is quick for one-off analyses, while scheduling reports is great for routine weekly or monthly check-ins.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Transforming Data into Actionable Insights

A spreadsheet full of numbers isn't a report, it's just raw data. The real value comes from adding analysis and context.

For every report you create, include a quick executive summary with three key sections:

1. What Worked (The Good): Highlight the wins. "Our video creative in the 'Testimonial' campaign generated a 4.2x ROAS, significantly outperforming our static image ads at 2.1x ROAS."
2. What Didn’t Work (The Bad): Be honest about underperforming areas. "The 'Broad Audience' ad set in the US had a Cost Per Purchase of $95, which is well above our target of $40."
3. Recommendations & Next Steps: Propose what to do next based on the data. "We recommend reallocating 50% of the 'Broad Audience' budget to the 'Lookalike (1% - Purchasers)' ad set and pausing the underperforming ad variants."

This simple narrative structure transforms your data from a retrospective look at the past into a strategic roadmap for the future.

Final Thoughts

Building a useful Facebook Analytics report is a repeatable process. It starts with asking a clear question, choosing the right metrics to answer it, and adding a simple analysis that explains what the numbers mean for your business. Consistently following these steps will empower you to optimize campaigns, allocate budget more intelligently, and drive better results over time.

While extracting data from Ads Manager is powerful, we know that manually exporting CSVs and wrestling with spreadsheets every week can quickly consume all of your time. This is why we built Graphed. We automate the entire process by connecting directly to your Facebook Ads account (along with Google Analytics, Shopify, and more), so you can create live dashboards and get instant answers simply by asking questions in plain English. Instead of spending an hour building a report, you can just ask, "Show me my campaign performance with ROAS and CPA for last week," and get a live, sharable dashboard in seconds.