Loading...

Private and Confidential
← Back to Guides

Portfolio Analysis Process

A structured approach to analyzing game performance data. This guide explains each step, what data your team needs to provide, and how the analysis produces actionable insights.

🔬
Product Review
"Is the product improving?"
Data: Single geo, single ad network (isolates product signal from mix effects)
Method: Mathematical modeling of revenue growth patterns over time
Output: Product quality assessment, release impact analysis
📈
Marketing Report
"Where should we spend budget?"
Data: All geos, all networks (full picture)
Method: Extrapolation based on observed revenue curves and industry benchmarks
Output: Kill/scale decisions, budget allocation

Why Two Tracks?

Product quality and marketing efficiency are different questions requiring different data. Mixing all channels masks whether a ROAS change is due to product improvements or just a shift in ad network mix. By isolating a single geo and network for Product Review, we see pure product signal. The Marketing Report then uses the full dataset to answer "where should we scale?"

1
Gather
Data Sources
2
Prepare
Safe Cuts
3
Analyze
ROAS Projection
4
Report
Deliverables
5
Learn
Iterate

The Five Phases

1
Data Gathering
What we need from you

Marketing Data (from MMP)

Your attribution platform (AppsFlyer, Adjust, Singular, etc.) tracks where users came from and how they monetize:

  • Cohort Export with these dimensions:
    • Install Date — Groups users into cohorts
    • Cohort Day — Days since install (D0, D1, D7, D30, D60, D90...)
    • Revenue — Cumulative revenue per cohort day
    • Cost/Spend — UA spend attributed to that cohort
    • Media Source — Ad network (for channel analysis)
    • Country — Geo for regional analysis
    • Platform — iOS vs Android
  • Version History: App release dates with version numbers (App Store Connect / Google Play Console).

Game Data (from your analytics)

Internal game telemetry tells us what users do in the game:

  • Retention curves — D1, D7, D30 retention by cohort
  • Progression data — Where users get stuck or churn
  • Session metrics — Sessions per day, session length
  • Economy data — Currency sinks/sources, IAP conversion
⚠️ Marketing ≠ Game Data: MMPs track where users came from and revenue. Game analytics tracks what users do. You need both—marketing data for ROAS analysis, game data for diagnosing why ROAS changed.
💡 Tip: Daily cohort granularity > weekly. Daily lets us pinpoint version impact. Export with Cohort Day as a dimension, not just totals.
2
Data Preparation
Safe data cuts

Raw data mixes product quality, network performance, geo economics, and platform differences. We isolate signals through:

  • Geo Isolation: Single geography removes currency/regional effects
  • Network Isolation: Single ad network removes algorithm differences
  • TTR Filtering: Exclude buggy versions hotfixed within days
  • Maturity Filters: Exclude cohorts too young to project reliably
⚠️ Simpson's Paradox: Blended data can hide or reverse trends. A product improving might look like it's declining if network mix shifted. Always analyze channels separately first.
3
Analysis
Projecting long-term performance

Regime Detection

Performance shifts in "regimes"—structural breaks caused by game updates, economy rebalances, or creative refreshes. We analyze periods separately rather than averaging across them.

Long-Term Projection

We project from observed data (D7, D30, D60) out to D365 to estimate lifetime value:

  • D7-D30: High confidence—many mature cohorts
  • D60-D90: Moderate confidence—extrapolation begins
  • D180-D365: Projection zone—confidence depends on mature data available
💡 Tip: More D90+ cohorts = tighter projections. New games have wider ranges—that's expected.
📊 Related: Control Chart Diagnostics 🎯 Related: Statistical Significance Guide
4
Report Generation
What you receive

Product Review

"Is the product improving?" ROAS trends, regime-by-regime analysis, version impact. Use for evaluating whether updates move metrics correctly.

Marketing Report

"Where should we spend?" Performance by geo/network/platform with kill/scale recommendations. Use for budget allocation.

What's Included

  • Charts: ROAS curves over time
  • Projections: D365 ROAS with confidence ranges
  • Recommendations: Clear next steps
  • Methodology: Data used, filters applied, and why
📈 Try it yourself: ROAS Analytics Tool
5
Meta-Analysis
Learning and iteration

Document Findings

Each analysis generates insights: what we learned, what surprised us, hypotheses confirmed or rejected.

Version Attribution

When ROAS changes, we identify which version(s) caused it. A regime might span multiple versions—usually 1-2 specific releases are responsible.

Hypothesis Updating

Patterns emerge over time: which features improve monetization, which markets respond to which creatives, optimal update cadence. This compounds into strategic advantage.

💡 Tip: Keep notes on what changed in each version. Better context = better attribution.
📊 Related: Ongoing Monitoring with Control Charts

Founder Checklist

Before your first analysis, ensure your team has:

Ready to Start?

Contact your Transcend partner to schedule your first analysis. We'll walk through the data requirements together and help you set up the export process from your MMP.

✍️ Select text to comment
➕ Add Comment

💬 Comments

💬

No comments yet.

Select text to add the first comment.

Add Comment