Meta Ads Manager is the primary source of prospecting and retargeting data for direct-to-consumer brands. PaceCast ingests daily campaign-level CSV exports from Meta Ads Manager, automatically parsing messy formatted currency values, percentage signs, and platform column name variations.
Ingestion Architecture
When you upload a Meta Ads CSV into a client workspace or transmit it via the /api/campaign-diagnostics endpoint, the parser performs five normalization steps:
- BOM & Encoding Cleanup: Strips UTF-8 Byte Order Marks (BOM) and normalizes CRLF/LF line breaks.
- Header Fuzzy Matching: Maps localized and varied header strings to standard dimensions.
- Currency & Numeric Scrubbing:Strips currency symbols ($, €, £, ¥), removes thousand-separator commas (“1,250.50” → 1250.50), and parses scientific notation.
- Date Normalization: Parses ISO timestamps (YYYY-MM-DD), slash dates (MM/DD/YYYY), or European formats (DD/MM/YYYY) into standardized UTC day strings.
- Attribution Lag Embargo: Automatically prunes trailing 7 calendar days to prevent immature attribution bias.
Recognized Meta Ads Headers & Aliases
| Standard Field | Type | Recognized Meta Ads Header Variations |
|---|---|---|
daterequired | YYYY-MM-DD | Matches: 'Day', 'Reporting starts', 'Reporting Ends', 'Date', 'Time Period'. |
campaignrequired | string | Matches: 'Campaign name', 'Campaign Name', 'Campaign ID', 'Campaign'. |
spendrequired | float | Matches: 'Amount spent (USD)', 'Amount spent', 'Amount Spent', 'Cost'. |
impressionsrequired | integer | Matches: 'Impressions', 'Total Impressions'. |
clicksrequired | integer | Matches: 'Link clicks', 'Link Clicks', 'Clicks (all)', 'Clicks'. |
conversionsrequired | float | Matches: 'Purchases', 'Website purchases', 'Results', 'Conversions', 'Orders'. |
conversion_valueoptional | float | Matches: 'Purchase conversion value', 'Website purchase conversion value', 'Conversion value'. |
Step-by-Step Meta Ads Manager Export
- Log into Meta Ads Manager and select the Campaigns tab.
- Set your date range in the upper right to Last 90 Days (or up to 365 days). Always set the end date to yesterday.
- Click Breakdown → Time → Day. (Critical: Omitting daily breakdown will cause ingestion to fail).
- Click Columns: Performance and ensure Amount spent, Impressions, Link clicks, and Purchases are checked.
- Click the Export button (download icon) and select Export as .csv.
Attribution Windows & 7-Day Embargo
Meta defaults to a 7-day click / 1-day view attribution setting. If a user clicks an ad on Monday and purchases on Thursday, Meta reports that conversion on Monday.
Because of this attribution delay, the most recent 7 calendar days always undercount total purchases. PaceCast automatically trims this trailing window before training time-series models, protecting you against false downward efficiency projections.