AI analysis starts with trustworthy numbers, not a polished summary. If Meta Ads, Google Ads, the tracker and the affiliate network define conversions differently, a language model can confidently describe an accounting mistake. Align events and reporting windows before looking for patterns.
Build a clean dataset
Include date, source, campaign type, GEO, spend, impressions, clicks, submitted leads, approved events, payout and approval date. For Meta Ads, preserve ad-set and Facebook/Instagram placement breakdowns. For Google Search, add ad groups and query categories; Display and Performance Max need different fields.
Separate attribution from revenue
Meta Pixel and Conversions API may report Lead events, Google Ads reports configured conversion actions, and the network validates only eligible events. Both platforms can also take credit for the same person. Calculate financial revenue using deduplicated advertiser-approved events and retain platform-attributed metrics for diagnostics.