How to Export Your Report from Meta Ads Manager
To use this tracker, you need to export a daily breakdown report from Meta Ads Manager. Follow these steps to get the correct format:
Step 1: Navigate to Ads Manager
Open Meta Ads Manager and select the ad account you want to analyze. Make sure you're viewing the Campaigns, Ad Sets, or Ads tab depending on the level of detail you need.
Step 2: Set Your Date Range
Click the date picker in the top right and select the current month (or the period you want to track). For accurate monthly projections, include all days from the 1st to today's date.
Step 3: Configure Breakdown
Click the "Breakdown" dropdown and select By Time → Day. This is critical for the tracker to calculate daily rates and projections correctly.
Important: Remove any other groupings or breakdowns. The export should only be broken down by Day, not by age, gender, placement, or other dimensions.
Step 4: Customize Columns
Click "Columns" and then "Customize Columns" to ensure you have all the required metrics. Add or verify the following columns are included in your view.
Step 5: Export as CSV
Click the "Export" button (download icon) and select "Export Table Data" → CSV format. The file will download to your computer, ready to upload to this tracker.
Required Export Columns
Your CSV export must include these specific columns for the tracker to work correctly. The column names must match exactly as they appear in Meta Ads Manager exports.
Column Name
Purpose
Required
Campaign name
Identifies which campaign generated each result
Yes
Day
Date of each data point (YYYY-MM-DD format)
Yes
Amount spent (AED)
Daily ad spend in your account currency
Yes
Purchases
Number of purchase conversions tracked
Yes
Purchases conversion value
Revenue value of purchases for ROAS calculation
Recommended
Purchase ROAS
Return on ad spend ratio from Meta
Optional
Currency conversion: If your ad spend currency differs from your LTV currency (e.g., spending in AED but measuring LTV in USD), enable the "Convert currency" toggle and set your exchange rate. If both are in the same currency, leave it off.
Understanding the Dashboard Metrics
The tracker displays several key performance indicators to help you understand your campaign performance and likelihood of hitting monthly targets.
Daily Rate
Your average number of purchases per day, calculated by dividing total purchases by days elapsed. This is the foundation for all projections.
Projected Total
Where you'll end up if your current daily rate continues for the rest of the month. Calculated as: Daily Rate × Days in Month.
Required Rate
The daily purchase rate you need to maintain for the remaining days to hit your target. If this is significantly higher than your current rate, you may need to increase spend or optimize campaigns.
CPA (Cost Per Acquisition)
How much you're spending on average to acquire each purchase. Lower is generally better, but must be balanced against volume. Displayed in USD for easier comparison.
ROAS (Return on Ad Spend)
The immediate return calculated from purchase conversion value divided by ad spend. A ROAS of 2.0x means you're generating $2 in tracked revenue for every $1 spent. This reflects what Meta reports based on your pixel data.
LTV ROAS
The true return when factoring in customer lifetime value. Calculated as (total purchases × LTV) ÷ ad spend. For subscription businesses, this is often the more meaningful metric since first-purchase value rarely reflects true customer worth. An LTV ROAS of 3-5x is typically healthy for subscription models.
Setting Realistic Monthly Targets
Your monthly target should be ambitious but achievable based on your budget, historical performance, and market conditions.
Consider Your Budget
If your average CPA is $50 and you have a $10,000 monthly budget, your maximum theoretical purchases is 200. Set your target below this ceiling to account for fluctuations and testing.
Account for Seasonality
Performance varies throughout the year. Q4 typically sees higher CPAs due to competition, while January may see lower engagement. Adjust targets based on historical seasonal patterns.
Build in Growth
If you hit your target easily every month, it's time to increase it. Aim for targets that push your team to optimize while remaining achievable 70-80% of the time.
Interpreting Projections and Taking Action
The trajectory chart and projections help you identify problems early and course-correct before month-end.
When You're Ahead of Pace
- Consider whether to maintain spend or reallocate to testing
- Document what's working for future campaigns
- Evaluate if you can increase targets next month
When You're Behind Pace
- Review campaign performance by individual campaign
- Check for budget caps that might be limiting delivery
- Consider increasing spend on top performers
- Evaluate creative fatigue and refresh if needed
- Review audience targeting for optimization opportunities
Early Month vs. Late Month
Projections in the first week have high uncertainty. Don't overreact to early data. By mid-month, projections become more reliable and action should be taken if you're significantly off pace.
Optimizing Campaign Performance
Use the campaign breakdown table to identify optimization opportunities across your portfolio.
Identify Winners and Losers
Sort campaigns by CPA to find your most and least efficient performers. Consider reallocating budget from high-CPA campaigns to proven winners.
ROAS Thresholds
For subscription businesses, a ROAS of 1.0x might still be profitable when accounting for LTV. Calculate your break-even ROAS based on first-purchase margin and expected customer lifetime.
Scaling Strategies
- Vertical scaling: Increase budget on existing winners by 15-20% every 3-4 days
- Horizontal scaling: Duplicate winning campaigns with new audiences
- Creative scaling: Test new creatives within winning campaign structures
Frequently Asked Questions
The tracker accepts CSV files exported from Meta Ads Manager. Make sure to export with the 'Day' breakdown enabled and include all required columns listed above. The file should be in standard CSV format with comma separators.
This usually means the 'Purchases' column is missing from your export or has a different name. Check that you've added the Purchases metric to your Ads Manager columns before exporting. Also verify you have the Meta Pixel or Conversions API properly tracking purchase events.
Projections assume your current daily rate continues unchanged. In reality, performance varies due to day-of-week patterns, budget changes, and creative fatigue. Projections become more accurate as you gather more days of data. By mid-month, they're typically within 10-15% of actual outcomes.
Currently, the tracker handles one CSV upload at a time. To track multiple accounts, export and analyze them separately. You can clear the data and upload a new file at any time. Each upload replaces the previous data.
No. All data processing happens in your browser. Your CSV data is never sent to any server. Settings (target, LTV, exchange rate) are stored in your browser's local storage for convenience, but can be cleared at any time.
The tracker calculates blended ROAS across all campaigns in your upload. If you're comparing to a single campaign's ROAS in Ads Manager, the numbers will differ. Also, attribution windows and reporting delays can cause temporary discrepancies.
Start with your historical performance as a baseline. Consider your budget, average CPA, and any planned campaign changes. A good target is ambitious but achievable—something you'd hit 70-80% of the time with solid execution. Adjust monthly based on actual results.
