Meta Ads Ingestion

Specifications for exporting and ingesting performance data from Meta Ads Manager (Facebook & Instagram). Covers column aliasing, currency normalization, and attribution lag trimming.

Last updated: October 2026

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:

  1. BOM & Encoding Cleanup: Strips UTF-8 Byte Order Marks (BOM) and normalizes CRLF/LF line breaks.
  2. Header Fuzzy Matching: Maps localized and varied header strings to standard dimensions.
  3. Currency & Numeric Scrubbing:Strips currency symbols ($, €, £, ¥), removes thousand-separator commas (“1,250.50” → 1250.50), and parses scientific notation.
  4. Date Normalization: Parses ISO timestamps (YYYY-MM-DD), slash dates (MM/DD/YYYY), or European formats (DD/MM/YYYY) into standardized UTC day strings.
  5. Attribution Lag Embargo: Automatically prunes trailing 7 calendar days to prevent immature attribution bias.

Recognized Meta Ads Headers & Aliases

Standard FieldTypeRecognized 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

  1. Log into Meta Ads Manager and select the Campaigns tab.
  2. Set your date range in the upper right to Last 90 Days (or up to 365 days). Always set the end date to yesterday.
  3. Click Breakdown → Time → Day. (Critical: Omitting daily breakdown will cause ingestion to fail).
  4. Click Columns: Performance and ensure Amount spent, Impressions, Link clicks, and Purchases are checked.
  5. 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.