AppsFlyer + Snapchat Ads reporting automation

Two sources, one number

Snapchat Ads reports its own spend and results. AppsFlyer attributes installs and events its own way. Reconciling them by hand — week after week — is where reporting time goes. Opera pulls both, lines them up, and computes blended CAC and ROAS in the report you already use.

Why the numbers never match (and how Opera handles it)

On the Snapchat Ads side: Snapchat is swipe-driven and reports view-through conversions generously, and its self-reported installs overlap with MMP attribution. For iOS app campaigns, SKAN delays and caps what's available. Treat Snapchat's figures as platform-reported and reconcile them to your MMP before rolling them into blended metrics.

On the AppsFlyer side: AppsFlyer reports standard attribution and SKAN (SKAdNetwork) conversions, and they rarely agree: SKAN postbacks arrive delayed and coarsely bucketed, so iOS installs lag and look lower than reality for a day or two. Separately, cohort metrics (revenue and retention tied to the install date) behave differently from activity metrics (events that happened during the period). A report that mixes them will double-count or undercount. The fix is to keep SKAN and attributed columns side by side and label cohort vs activity explicitly.

Opera doesn't force a false single truth — it keeps both series side by side and surfaces the gap.

The reconciliation columns

Updated in your existing Sheet

Opera reads your report's structure and appends the reconciled numbers to the right rows. Formulas are preserved; writes are append-only.

Safe enough for production

Opera is built to touch production reports and live ad accounts without breaking anything:

• No destructive writes. Updates are append-only by default — your existing data and formulas are never overwritten.
• Preview before execution. You see exactly what Opera will change before a single cell is written.
• Campaigns paused by default. New campaigns are created paused, with approvals required before any spend.
• Full audit logs and client-level isolation. Every action is logged, and each client's data and rules stay separate.