Facebook Ads Reporting: Custom Reports & Breakdowns

Why Custom Reporting Matters

Facebook Ads Manager gives you access to hundreds of metrics and dimensions. But raw data isn't insights. The difference between advertisers who struggle and those who scale profitably often comes down to how well they report and analyze performance.

The problem with default reporting:

• Shows too many irrelevant metrics
• Doesn't align with your specific business goals
• Makes it hard to spot trends and anomalies
• Wastes time scrolling and searching for data

Custom reports solve this by surfacing only the metrics that matter, broken down the way you need to see them, and delivered automatically so you can make faster, better decisions.

Key Insight: Advertisers who use custom reports and breakdowns make 3-5x more optimizations per week than those relying on default views, leading to 20-40% better performance over time.

Whether you're managing a small business ad account or a multi-million dollar budget, mastering Facebook Ads reporting is essential. Let's dive into how to build a reporting system that drives results.

Ads Manager Reporting Basics

Before building custom reports, you need to understand the foundation: how Facebook Ads Manager organizes and displays data.

The Reporting Interface

Facebook Ads Manager provides reporting at three levels:

You can view each level by clicking the corresponding tab at the top of Ads Manager.

Key Metric Categories

Facebook organizes hundreds of metrics into categories:

• Performance: Results, cost per result, ROAS, conversion value
• Delivery: Impressions, reach, frequency
• Engagement: Clicks, CTR, post engagement, video views
• Settings: Budget, bid, schedule, optimization goal
• Attribution: Results by attribution window, conversion event

Pro tip: Don't try to track everything. Start with 5-8 core metrics that directly tie to your business goals, then expand as needed.

Date Range and Comparison

Always check your date range before analyzing data:

• Click the date selector in the top right
• Choose preset ranges (Today, Yesterday, Last 7/14/30 days) or custom dates
• Use "Compare" to view performance against previous periods
• Account for day-of-week effects by comparing week-over-week, not day-to-day

Filtering Your Data

Filters help you focus on specific campaigns, statuses, or performance levels:

• Use the search bar to find specific campaigns by name
• Filter by delivery status (Active, Paused, In Review, etc.)
• Create custom filters based on metrics (e.g., "CPA > $50" or "ROAS < 2")
• Save frequently used filter combinations for quick access

Build Custom Column Sets

The default column view in Ads Manager shows basic metrics like reach, impressions, and spend. But you probably need different metrics depending on what you're analyzing.

Creating Your First Custom Column Set

Here's how to build a custom column preset:

In Ads Manager, click "Columns: Performance" dropdown

Select "Customize Columns..."

Browse available metrics or search for specific ones

Drag metrics to "Selected Columns" on the right

Reorder columns by dragging up or down

Click "Save as Preset" and name it

Click "Apply"

Now you can switch between your custom presets instantly without reconfiguring columns each time.

Recommended Column Sets by Goal

E-commerce Performance:

• Campaign/Ad Set/Ad Name
• Delivery Status
• Amount Spent
• Purchases
• Cost Per Purchase
• Purchase Conversion Value
• ROAS (Return on Ad Spend)
• Add to Cart
• Initiate Checkout
• CTR (Link Click-Through Rate)
• Frequency

Lead Generation:

• Campaign/Ad Set/Ad Name
• Amount Spent
• Leads
• Cost Per Lead
• Form Submit Rate
• Landing Page Views
• Link Clicks
• CPC (Cost Per Link Click)
• CTR
• Quality Score (if using lead ads)

Brand Awareness & Reach:

• Campaign/Ad Set/Ad Name
• Amount Spent
• Reach
• Impressions
• Frequency
• CPM (Cost Per 1,000 Impressions)
• ThruPlay (Video Views)
• Video Plays at 25%, 50%, 75%, 100%
• Post Engagement
• Engagement Rate

Conversion Optimization (Deep Funnel):

• Campaign/Ad Set/Ad Name
• Amount Spent
• Purchases (or Key Conversion)
• CPA
• Landing Page Views
• Add to Cart
• Initiate Checkout
• Conversion Rate (Landing Page View → Purchase)
• ROAS
• Outbound Clicks
• CTR

Custom Metrics and Calculations

Facebook allows you to create custom metrics using formulas:

Examples:

• Conversion Rate: (Purchases ÷ Link Clicks) × 100
• Revenue Per Click: Purchase Conversion Value ÷ Link Clicks
• Effective CPM: (Amount Spent ÷ Impressions) × 1,000
• Engagement Score: (Post Reactions + Comments + Shares) ÷ Reach

To create custom metrics:

Open "Customize Columns"

Click "Create Custom Metric" at the bottom

Name your metric and build the formula

Add it to your column sets

Key Insight: Custom metrics let you track the exact ratios and KPIs your business cares about, even if Facebook doesn't show them by default.

Master Breakdowns for Deep Analysis

Breakdowns are where reporting becomes powerful. They let you slice your data by demographics, placements, devices, time, and more to uncover hidden insights.

Types of Breakdowns

Facebook offers four main breakdown categories:

1. By Delivery (Where ads appear):

• Placement: Feed, Stories, Reels, Audience Network, etc.
• Platform: Facebook, Instagram, Messenger, Audience Network
• Platform & Device: iOS vs Android, mobile vs desktop

2. By Action (What happened):

• Action Type: Which conversion events fired
• Destination: Where users went after clicking
• Carousel Card: Performance of individual carousel elements

3. By Time:

• Day, Week, Month: Performance trends over time
• Hour: Best times to show ads

4. By Demographics & Attributes:

• Age, Gender, Country, Region
• DMA (Designated Market Area)
• Impression Device
• Product ID (for Dynamic Ads)

How to Apply Breakdowns

To apply a breakdown:

Click the "Breakdown" dropdown above your data table

Select a breakdown category

Choose the specific breakdown

Data will refresh showing performance split by that dimension

You can combine breakdowns by selecting one, then adding another from a different category. For example: Age + Placement shows which age groups perform best on which placements.

High-Impact Breakdown Use Cases

Optimize audience targeting:

• Break down by Age and Gender to find your best-converting demographics
• Identify which segments have high spend but low performance
• Reallocate budget or exclude underperforming segments

Optimize placements:

• Break down by Placement to see if Feed, Stories, or Reels drive better results
• Identify placements with high impressions but low conversions
• Exclude low-performing placements or create placement-specific creative

Optimize timing:

• Break down by Hour to find when your audience is most active and converts best
• Use ad scheduling to run only during peak performance windows
• Account for time zone differences in multi-region campaigns

Optimize devices:

• Break down by Platform & Device to compare iOS vs Android, mobile vs desktop
• Adjust mobile vs desktop bidding based on performance
• Create device-specific landing pages if conversion rates differ significantly

Optimize creative:

• Break down by Dynamic Creative Element to see which headlines, images, or CTAs win
• For carousel ads, break down by Carousel Card to identify top performers
• Use insights to inform future creative production

Breakdown Best Practices

• Don't over-segment: More breakdowns = smaller sample sizes. Wait for statistical significance (usually 30+ conversions per segment).
• Compare apples to apples: Make sure you're comparing the same date ranges and attribution settings.
• Look for patterns, not outliers: One high-performing day doesn't mean you've found gold; look for consistent trends.
• Take action on insights: Breakdowns are useless if you don't use them to optimize. Set aside time weekly to review and implement changes.

Automated Reports & Dashboards

Manual reporting is time-consuming and prone to errors. Automation ensures you and your stakeholders always have current data without the busy work.

Built-In Scheduled Reports

Facebook Ads Manager has native report scheduling:

Set up your desired column view and filters

Click "Reports" in the top navigation

Select "Create Custom Report"

Configure your report:
- Choose level (Campaign, Ad Set, Ad)
- Select columns
- Apply filters and breakdowns
- Set date range

Click "Schedule Email"

Choose frequency (daily, weekly, monthly)

Add recipients

Click "Schedule"

You'll receive reports automatically at your chosen frequency.

Recommended automated reports:

• Daily Performance Snapshot: High-level metrics for active campaigns
• Weekly Breakdown Analysis: Performance by demographics, placements, devices
• Monthly Summary: Month-over-month trends and goal tracking

Export Options

For deeper analysis or stakeholder presentations, export your data:

• Excel: Click "Export Table Data" → "Export to Excel" for raw data
• CSV: Similar to Excel but lighter format
• Chart Image: Export specific visualizations for presentations

Building Live Dashboards

For real-time reporting, connect Facebook Ads to dashboard tools:

Google Data Studio (Looker Studio):

• Free tool from Google
• Connects to Facebook Ads via native connector
• Build custom charts, tables, and scorecards
• Share live dashboards with stakeholders
• Auto-refreshes data

Supermetrics:

• Paid tool ($99+/month)
• Connects Facebook Ads to Google Sheets, Data Studio, Excel
• More robust than native connectors
• Supports advanced filtering and transformations

Custom Solutions:

• Use Facebook Marketing API to pull data programmatically
• Build custom dashboards in your BI tool (Tableau, Power BI)
• Combine Facebook data with other marketing and business data

Key Insight: Automated dashboards reduce reporting time by 70-90% while providing stakeholders with real-time access to performance data, improving decision-making speed.

What to Include in Stakeholder Dashboards

Keep stakeholder reports focused on outcomes, not activities:

Executive Dashboard (CEO, CMO):

• Total ad spend vs budget
• Revenue/Leads generated
• ROAS or CPA vs target
• Month-over-month trends

Marketing Team Dashboard:

• Campaign-level performance
• Top and bottom performers
• Creative performance rankings
• A/B test results

Account Management Dashboard:

• Active campaigns status
• Daily budget pacing
• Learning phase status
• Account health alerts (disapprovals, payment issues)

Advanced Analytics & Attribution

Once you've mastered basic reporting, dive into advanced analytics to understand the full customer journey and optimize holistically.

Attribution Windows

Facebook offers multiple attribution windows to measure how long after seeing or clicking an ad a conversion occurs:

Default: 7-day click or 1-day view Why it matters: Longer windows show more conversions but may over-attribute. Shorter windows under-attribute but show more immediate impact. Best practice: Use 7-day click for most e-commerce and lead gen. Use 1-day click for short sales cycles or flash sales.

Cross-Campaign Analysis

Don't optimize campaigns in isolation. Analyze how they work together:

• Compare prospecting vs retargeting performance
• Identify if awareness campaigns improve conversion campaign efficiency
• Look for audience overlap and cannibalization
• Measure incremental lift from adding new campaign types

Tools for cross-campaign analysis:

• Ads Manager filters and comparison views
• Exported data analyzed in Excel or Google Sheets
• Facebook Analytics (if still available in your region)
• Third-party attribution platforms

Facebook Attribution Tool

Facebook's Attribution tool (available to some accounts) shows multi-touch attribution across:

• Facebook and Instagram ads
• Organic social
• Website traffic
• Email campaigns (with proper setup)

It helps answer: "Which touchpoints contributed to conversions, not just the last click?"

How to access:

• Visit facebook.com/attribution
• Set up pixel and conversion events
• Connect external data sources
• Analyze attribution models (last click, first click, linear, time decay)

Cohort Analysis

For subscription or repeat-purchase businesses, analyze customer cohorts:

• Track customers acquired in specific time periods
• Measure LTV (lifetime value) over time
• Compare CPA to LTV to determine profitability
• Identify which campaigns drive highest LTV customers

This requires exporting Facebook data and joining it with your customer data in a database or spreadsheet.

Incrementality Testing

To measure true impact (not just correlation), run incrementality tests:

Conversion Lift Studies:

• Facebook shows ads to a test group and withholds from a control group
• Measures actual lift in conversions caused by ads
• Requires minimum spend and conversions

Geographic Holdout Tests:

• Exclude certain regions from advertising
• Compare conversion rates in advertised vs non-advertised regions
• Determine what percentage of results are incremental vs would have happened anyway

These advanced tests help justify ad spend and optimize for true incremental impact.

Build Your Reporting System Today

Facebook Ads reporting isn't about drowning in data. It's about surfacing the right insights at the right time to make better decisions faster.

Start with these steps:

Create 2-3 custom column presets for your core goals

Set up one automated weekly report with key metrics

Schedule 30 minutes every Friday to review breakdowns by demographics and placements

Document your findings and optimizations in a simple log

As you get comfortable, expand into automated dashboards, advanced attribution, and cross-channel analysis. The goal is building a reporting rhythm that drives continuous improvement.

Even small optimizations from better reporting compound into major performance gains. A 10% improvement per month becomes 3x performance in a year.

Ready to automate your Facebook Ads analysis? Sign up for AdsMAA and get AI-powered audit reports, custom dashboards, and automated insights delivered to your inbox so you can focus on strategy, not spreadsheets.