Where every number comes from
| Column | Meta | Backend | Formula |
|---|---|---|---|
| Spend | ✓ | — | ad_spend_daily.spend (paise) |
| Impressions | ✓ | — | ad_spend_daily.impressions |
| Clicks | ✓ | — | ad_spend_daily.clicks |
| Reach | ✓ | — | ad_spend_daily.reach |
| Frequency | ✓ | — | ad_spend_daily.frequency |
| Budget | ✓ | — | ad_budget_current.currentBudget, with CBO/ABO read from the row's level |
| Meta Actions | ✓ | — | sum(ad_spend_daily.actions) |
| Installsboth | ✓ | ✓ | Meta: actions.mobile_app_install · Ours: count of install rows |
| Usersboth | ✓ | ✓ | Meta: actions.complete_registration · Ours: distinct firstRealUserId |
| Cohort Revenueboth | ✓ | ✓ | Meta: action_values.omni_purchase · Ours: completed topups by users acquired in this window |
| New Payer Revenue | — | ✓ | Cohort Revenue where purchaseOrdinal = 1 |
| Attributed Revenue | — | ✓ | window topups of EVERY user the campaign ever acquired |
| Overall Gross Revenue | — | ✓ | every completed topup for the app in the window |
| ROASboth | ✓ | ✓ | Cohort Revenue ÷ spend |
| CPIboth | ✓ | ✓ | spend ÷ installs |
| Reinstalls | — | ✓ | installType = REINSTALL |
| Refunds | — | ✓ | transactions.refund.status = completed |
| Transactions | — | ✓ | count of completed topups in window |
| Paying Users | — | ✓ | distinct users with a completed topup |
| FRU (all time) / Second / 3rd Recharge Users | — | ✓ | topup ordinal per user |
| Lifetime Recharge Users | — | ✓ | user_monetization.topupCount ≥ 1 |
| Lifetime Revenue / Transactions | — | ✓ | user_monetization, all time |
| Max LTV | — | ✓ | highest single-user lifetime revenue |
| D7 / D30 Revenue | — | ✓ | revenue within 7/30 days of that user's install |
| Engaged Users | — | ✓ | connected call, sent message, or topup |
| Attribution Mix (click / view / organic) | — | ✓ | derived from install-referrer timestamps |
| Cohort Matrix (D1/D3/D7/D14/D30) | — | ✓ | cohort = install date (IST) |
| ARPU | — | ✓ | Cohort Revenue ÷ attributed users |
| Video Completion | ✓ | — | video_p100_watched ÷ video_p25_watched |
| Video Plays / 25% / 50% / 75% / 100% | ✓ | — | video_play_actions · video_p25..p100_watched_actions |
| Link Clicks | ✓ | — | inline_link_clicks |
| Creative (thumbnail) | ✓ | — | ad.creative{thumbnail_url, instagram_permalink_url, effective_status} |
| CTR | ✓ | — | clicks ÷ impressions |
| CPM | ✓ | — | (spend × 1000) ÷ impressions |
| CPC | ✓ | — | spend ÷ clicks |
| CPFR / CACboth | ✓ | ✓ | spend ÷ firstRechargeUsers |
| CPPboth | ✓ | ✓ | spend ÷ all purchases |
| CP2Rboth | ✓ | ✓ | spend ÷ secondRechargeUsers |
| CPTPboth | ✓ | ✓ | spend ÷ thirdRechargeUsers |
| Avg CPRboth | ✓ | ✓ | spend ÷ (first + second recharge users) |
| LTV | — | ✓ | lifetime revenue of these users ÷ attributed users |
| ARPPU | — | ✓ | netRevenue ÷ firstRechargeUsers |
| AOV | — | ✓ | grossRevenue ÷ transactions |
| D7 / D30 LTV | — | ✓ | dNRevenue ÷ users |
| First / Second Recharge Rate | — | ✓ | firstRecharge ÷ users · secondRecharge ÷ firstRecharge |
| Conversion Rate | — | ✓ | firstRechargeUsers ÷ users |
| Engagement Rate | — | ✓ | engagedUsers ÷ users |
| Attribution Coverage | — | ✓ | installs with a campaign ÷ all installs |
| App | — | ✓ | packageId |