Sign in

Data Sources

Where every number comes from

ColumnMetaBackendFormula
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