Initializing...
| App | Metric | Alarm Type | Current Value | 7-Day Avg | Ratio | Description | Detected At |
|---|---|---|---|---|---|---|---|
| Loading alarms... | |||||||
Current metrics for each app compared to 7-day average. Alarms trigger when value is >2x or <0.5x of baseline.
| App | CTR | CPM | CPC | CVR | CPP | |||||
|---|---|---|---|---|---|---|---|---|---|---|
| Current | vs Avg | Current | vs Avg | Current | vs Avg | Current | vs Avg | Current | vs Avg | |
| Click "Load App Overview" to view current health status | ||||||||||
Compare Solidgate orders vs Meta (pixel) purchases
Meta Ads API via /insights endpoint - Fetches ad-level creative performance (thumbnails, titles, copy, spend, impressions, clicks) for the last 7 days
Meta Ads API via /insights endpoint - App-level aggregated metrics (spend, impressions, clicks) filtered by configured ad account IDs per app
Google Sheets API - Reads ticket data populated by Zendesk integration (date, app, tag/label, ticket count, resolution time)
AI-powered support ticket metrics and performance
Google Sheets API, Revenue from Solidgate Orders - Shows cost/revenue ratio per app
Backend cost / revenue ratio analysis and monitoring
Select a sheet to view cost percentages over time
ai-backend.pixerylabsapi.com - Paid user app usage rates tracking
Track paid user app usage rates across all apps
Gemini-powered analysis of Support and Backend analytics across all apps
purchase_comparison_log table - Compares Solidgate, Facebook (omni_purchase), and AI-Backend purchase counts every 4 hours
Purchase comparison between Solidgate, Facebook, and Backend sources
funnel_campaign_analytics_daily table - Synced from FunnelFox API daily via syncFunnelCampaignAnalytics.js - Campaign-attributed funnel metrics by country.
Analytics data from FunnelFox API - campaign-attributed traffic only
| Funnel | Paywall Open | Subscriptions | Start to Purchase | Start to 2nd Screen | Start to Paywall | Paywall to Purchase |
|---|
Orders that could not be mapped to any funnel
solidgate_fraud_daily, solidgate_disputes, solidgate_fraud_alerts, solidgate_prevention_alerts - Pre-aggregated monthly data from analyze-disputes-and-fraud.js script
Historical disputes, fraud alerts, and prevention alerts from database
meta_campaign_daily (historical spend), solidgate_orders (historical revenue), and Google Sheets (backend costs) - Applies incremental ROAS (D0, D7, D30, D60, D90) to historical spend to project future revenue and profit for next 30 days
Estimate future revenue based on historical spend and ROAS metrics
meta_campaign_daily_by_country + solidgate_orders for country-level ROAS
product_ltv_estimates - Predicted LTV values per product, country, and type (calculated from D70 cohort data)
solidgate_subscriptions - Cohort-based subscription cancellation analysis with cancel codes and timing breakdown
Cohort-based cancellation analysis showing when subscriptions get cancelled relative to creation date
solidgate_orders + FunnelFox API - D10/D40/D70 LTV broken down by product, country, gender, age, device OS, and image upload
Calculate realized LTV broken down by all segments at once for a cohort date range
solidgate_orders - Product LTV cohort analysis tracking ALL revenue from customers who first purchased a specific product, grouped by product, country, and first purchase date. Shows cumulative LTV at D0, D7, D30, D37, D60, D67, D90, D97.
Cohort-based LTV analysis by subscription product with country breakdown
Compare revenue per customer across apps and products within a selected country
This may take 5-10 seconds
Select apps first
Meta Ads API for recent data OR Database meta_campaign_daily & meta_campaign_daily_by_country for historical data - Synced daily at 3:00 AM UTC via syncMetaData.js (fetches last 90 days of campaign data with country breakdown)
Loading breakdown data...
Uses same cohort definition as Investment Analytics: Cohort = first purchase (payment_type NULL/empty) on test date.
D0 Revenue = ALL orders from cohort customers on their cohort date, split by campaign attribution.
Running live attribution test...
This may take 30-60 seconds depending on date range
solidgate_orders + FunnelFox API metadata - A/B test assignments from funnel_ab_test and funnel_ab_test_group fields
Define A/B tests matching FunnelFox test names. Groups are auto-discovered from metadata.
No A/B tests yet
Click "+ New Test" to create your first A/B test
Running full analysis...
Computing D40 & D70 revenue, significance tests, and segment breakdowns
Manual exploration: enter date range and app to discover A/B tests from FunnelFox metadata.
Loading A/B testing data...
Fetching cohort data and FunnelFox metadata
Running full analysis...
Computing D40 & D70 revenue, significance tests, and segment breakdowns
solidgate_orders | Mobile: RevenueCat API | Spend: meta_campaign_daily
Monthly cohort revenue progression. Each row is a cohort (customers who made their first purchase that month).
M1 = revenue in their 1st month, M2 = revenue in their 2nd month, etc. Spend is total Meta spend for that month.
Loading cumulative ROAS data...
Calculating cohort revenue progression
meta_campaign_daily | Predicted LTV: solidgate_orders + product_ltv_estimates
Daily marketing spend vs Predicted D70 ROAS. Track how your spend translates to predicted revenue.
ROAS = (Predicted D70 LTV / Spend) Ã 100%
Loading daily spend & ROAS data...
Fetching spend and predicted LTV
Comprehensive daily and weekly campaign performance metrics with placement and device breakdown.
Analyzes Meta advertising data alongside Solidgate revenue for ALL/US/Non-US markets.
Loading detailed campaign report...
Aggregating Meta and Solidgate data
solidgate_subscriptions - Invoice retry data from raw_data JSON field
Analyze payment recovery rates from Solidgate's smart retry system.
Shows how many failed payments were recovered through automatic retries.
Loading recovery data...
Analyzing invoice retry history
meta_campaign_daily_by_country |
product_ltv_estimates |
solidgate_orders |
solidgate_subscriptions |
app_mobile_uplift |
backend_costs_daily
Project monthly cash inflows and outflows. Accounts for country mix, scale effects, churn, predicted LTV, mobile uplift, and backend costs.
The model projects monthly cash flows by estimating revenue from two sources: (A) new customers acquired during the projection period, and (B) existing subscribers who were already paying before the projection starts. Revenue is calculated separately for web (direct payments via Solidgate) and mobile (app store purchases).
| Multiplier | Value | Meaning |
|---|---|---|
| Web Revenue Multiplier | 0.82 (82%) | Gross web revenue × 0.82 = net revenue after Solidgate payment processing fees, taxes, chargebacks (~18% deduction) |
| Store Commission Multiplier | 0.692 (69.2%) | Applied to mobile revenue: app store takes a 30.8% commission |
| Mobile Uplift | Per-app (e.g. 20%) | Ratio of mobile revenue to web revenue, stored in app_mobile_uplift table. E.g. 0.20 means mobile generates 20% of the revenue that web does. |
The LTV (Lifetime Value) curve represents the average cumulative revenue per customer over time. It is built using 6 milestone days: D10, D40, D70, D100, D130, D160.
product_ltv_estimates table, weighted by each country's share of spend (country mix)
and each product's share of purchases (product mix). This prevents summing LTVs across products.
solidgate_orders cohort data using tiered cohort windows:
D10 uses cohorts 11+ days old (freshest), D40 uses 41+ days, D70 uses 71+, D100 uses 101+, D130 uses 131+, D160 uses 161+.
This ensures each milestone uses the freshest possible data while having sufficient maturity.
Each projection month, a new cohort of users is acquired. The number of users = monthly_spend / CPA,
where CPA is the 90-day average cost per acquisition. Each cohort generates incremental revenue each month based on their
age along the ROAS curve (M1, M2, M3, M4, etc.).
Revenue from pre-existing subscribers is based on the 28-day total scaled to monthly of recurring and 1-click payments
(from solidgate_orders where payment_type IN ('recurring', '1-click')).
This base revenue decays each month using a churn rate derived from the D40→D70 incremental churn
from solidgate_subscriptions. The monthly churn rate is capped at 30% to prevent aggressive decay.
D10 churn is not used because it includes trial cancellations which overstate churn for active subscribers.
The country distribution is based on the last 30 days of ad spend by country from meta_campaign_daily_by_country.
Each country's percentage of total spend determines its weight when blending LTV values.
LTV is computed per-country from observed cohort data, then weighted by the country mix to produce a blended LTV curve.
After running a projection, the base ROAS anchors (M1, M2, M3, M4) are shown as editable fields per app. You can adjust these values and click Re-calculate to re-run the projection with your custom anchors. This replaces the computed anchor values from cohort data while keeping the same curve interpolation and extrapolation logic.
Ad Spend: monthly_spend per month (constant, as entered).
Backend Cost: ~8% of total revenue (computed from historical backend costs / total revenue).
mobile_uplift ratio, not from actual app store data.Validated via walk-forward backtesting (simulating the model on past cutoff dates and comparing to actuals). Total web revenue prediction error: ±2–6% across multiple cutoff dates. Per-app errors vary: stable apps (Fling, Impresso) typically ±5%, high-growth apps (CloneAI) up to ±20%.
Computing cash flow projection...
Revenue from existing subscribers and historical cohorts only, with $0 future ad spend.
Net inflow per cohort per projected month (spend × incremental ROAS × fee/uplift multipliers, summed across apps).
solidgate_orders |
campaign_order_mapping |
meta_campaign_daily |
FunnelFox API (segmentation)
Define pricing tests by grouping campaigns into control/variant groups. Analyze per-customer revenue with statistical significance testing.
No pricing tests yet
Click "+ New Test" to create your first pricing test
Running full analysis...
Computing D40 & D70 revenue, significance tests, and segment breakdowns
solidgate_orders | FunnelFox Customer API
Fetching customer segments from FunnelFox...
This may take a minute for large date ranges