Why Do Custom Columns Matter?
Default Ads Manager columns weren't designed for your business. They show generic metrics that may not match your goals. Top media buyers customize their view to surface exactly what drives decisions.
The right column setup eliminates mental math, surfaces problems faster, and creates consistency across team members. Here's how elite buyers configure their workspace.
What's the Foundation Column Set?
Every media buyer needs a core set of columns that work across all campaign types. Start here before adding specialized metrics.
Identification Columns
- Campaign Name: Always first for orientation
- Delivery: Active, learning, limited status
- Ad Set Budget: Daily or lifetime budget
- Bid Strategy: Lowest cost, cost cap, bid cap
Spend and Reach Columns
- Amount Spent: Total spend in date range
- Impressions: Total ad impressions
- Reach: Unique people reached
- Frequency: Average impressions per person
Engagement Columns
- Link Clicks: Clicks to destination
- CTR (Link Click-Through Rate): Clicks divided by impressions
- CPC (Cost Per Link Click): Spend divided by clicks
- CPM (Cost Per 1,000 Impressions): Auction efficiency indicator
What Columns Do E-Commerce Buyers Use?
E-commerce campaigns optimize for purchases and revenue. These columns surface the metrics that matter for online sales.
Primary E-Commerce Columns
- Purchases: Total purchases attributed
- Purchase Conversion Value: Revenue generated
- Cost Per Purchase: CPA for purchases
- ROAS (Purchase): Return on ad spend for purchases
Funnel Columns
- Add to Cart: Cart additions attributed
- Cost Per Add to Cart: Upper funnel efficiency
- Initiate Checkout: Checkout starts
- Cost Per Initiate Checkout: Mid-funnel efficiency
Calculated Columns (Custom Metrics)
- Cart to Purchase Rate: Purchases / Add to Cart (shows checkout efficiency)
- AOV (Average Order Value): Revenue / Purchases
- Profit Per Purchase: (Revenue - Spend) / Purchases
What Columns Do Lead Gen Buyers Use?
Lead generation campaigns focus on lead volume, quality, and cost. Column setup should reflect the full lead lifecycle.
Primary Lead Gen Columns
- Leads: Total leads captured
- Cost Per Lead: Spend per lead acquired
- Lead Form Opens: Form view count
- Lead Form Completion Rate: Leads / Form Opens
Quality Indicator Columns
- Messaging Conversations Started: If using Messenger
- Page Engagement: Broader interest signals
- Video Views (75%): Deep engagement before lead
- Outbound Clicks: Website traffic quality
What Video-Specific Columns Should You Add?
Video campaigns need engagement depth metrics beyond clicks. These columns reveal creative performance nuances.
View Duration Columns
- 3-Second Video Views: Initial hook performance
- ThruPlay (15s+): Deeper engagement
- Video Watches at 25%/50%/75%/100%: Completion funnel
- Average Video Play Time: Engagement depth
Cost Per View Columns
- Cost Per ThruPlay: Efficiency for engaged views
- Hook Rate: 3-second views / Impressions (custom metric)
- Cost Per 3-Second View: Top-funnel video efficiency
How Do You Set Up Creative-Level Columns?
Creative analysis requires different columns than campaign management. Understanding creative fatigue detection informs which metrics to display.
Essential Creative Columns
- Ad Name: For identification
- Ad Preview: Visual thumbnail
- Impressions: Delivery volume
- Frequency: Saturation indicator
- CTR: Engagement rate
- Primary Conversion: ROAS or CPA
Fatigue Indicator Columns
- Frequency: Critical fatigue signal
- CTR trend: Compare to 7-day prior
- CPM trend: Rising CPM suggests fatigue
- Days Active: Lifespan tracking
What Breakdown Columns Add Context?
Breakdowns add another dimension to your data. Use them strategically rather than applying them by default.
Time Breakdowns
- Day: For trend analysis and day-of-week patterns
- Week: For longer-term performance patterns
- Month: For strategic reviews and planning
Delivery Breakdowns
- Platform: Facebook vs. Instagram vs. Audience Network
- Placement: Feed vs. Stories vs. Reels
- Device: Mobile vs. desktop performance
Demographic Breakdowns
- Age: Performance by age bracket
- Gender: Performance by gender
- Region: Geographic performance variation
How Do You Create Custom Metrics?
Meta allows custom metric formulas. These calculated columns surface insights standard metrics miss.
Efficiency Metrics
- Profit: Purchase Conversion Value - Amount Spent
- MER (Marketing Efficiency Ratio): Total Revenue / Total Ad Spend
- Breakeven ROAS: 1 / Profit Margin (set as constant for comparison)
Quality Metrics
- Hook Rate: 3-Second Video Views / Impressions
- Engagement Rate: (Reactions + Comments + Shares) / Reach
- Click Quality: Purchases / Link Clicks
Attribution Metrics
- View-Through Purchases: Total Purchases - Click Purchases
- Click Attribution %: Click Purchases / Total Purchases
- Attribution Lag: Custom tracking of conversion timing
What Column Presets Should You Save?
Save different column configurations for different analysis types. Quick switching accelerates workflow.
Recommended Presets
- Daily Monitoring: Spend, delivery, CPA, ROAS, frequency
- Creative Analysis: Ad-level metrics with fatigue indicators
- Funnel Analysis: Full conversion funnel with drop-off rates
- Client Reporting: Clean presentation metrics
- Placement Deep Dive: Platform and placement breakdowns
How ROASPIG Helps
ROASPIG enhances your Meta reporting with purpose-built analytics:
- Pre-configured column sets: Industry-specific setups ready to use
- Custom metric builder: Create calculated columns without formulas
- Creative-specific views: Thumbnail-based analysis with fatigue tracking
- Exportable presets: Share column configurations across team members
- Trend visualization: See performance changes over time automatically
Conclusion
Custom columns transform Ads Manager from data display to decision tool. The right setup surfaces problems before they compound and opportunities before competitors find them.
Start with the foundation columns, add industry-specific metrics, then layer in custom calculations that match your business model. Save presets for different analysis types. For connecting columns to testing insights, review the scientific method for creative testing. To ensure your metrics track what matters for returns, see how to improve ROAS with optimized creatives.
Additional Resources
For more on customizing Meta Ads Manager, visit the Meta Custom Columns Guide and learn about custom metrics formulas.
Frequently Asked Questions About Custom Columns Meta Ads
Foundation columns include: Campaign Name, Delivery Status, Amount Spent, Impressions, Reach, Frequency, Link Clicks, CTR, CPC, and CPM. Then add your primary conversion metric (purchases, leads) with cost per conversion and ROAS.
Key custom metrics: Cart to Purchase Rate (shows checkout efficiency), Average Order Value (revenue/purchases), Profit Per Purchase (revenue - spend / purchases), and Hook Rate for video ads (3-second views / impressions).
Include Frequency, CTR, CPM, and Days Active in your creative-level view. Watch for frequency above 3.0 combined with declining CTR and rising CPM. These patterns indicate creative fatigue before performance crashes.
Save five presets: Daily Monitoring (quick health check), Creative Analysis (ad-level with fatigue indicators), Funnel Analysis (conversion steps with drop-off rates), Client Reporting (clean presentation metrics), and Placement Deep Dive (platform/placement breakdowns).
Go to Columns → Customize Columns → Create Custom Metric. Use formulas like 'Purchase Conversion Value - Amount Spent' for Profit or '3-Second Video Views / Impressions' for Hook Rate. Save and add to your column presets.