{% extends "core/base.html" %}{% load cohortly %}
{% block title %}Cohorts{% endblock %}
{% block content %}
<div class="head"><h1>Cohort retention</h1>
<div class="actions"><a class="btn" href="?{{ filter_qs }}{% if filter_qs %}&{% endif %}metric={{ metric }}&basis={{ basis }}&format=csv">Export CSV</a></div></div>
<div class="tabs">
  <a class="{% if metric == 'logo' %}on{% endif %}" href="?{{ filter_qs }}{% if filter_qs %}&{% endif %}metric=logo&basis={{ basis }}">Logo retention</a>
  <a class="{% if metric == 'revenue' %}on{% endif %}" href="?{{ filter_qs }}{% if filter_qs %}&{% endif %}metric=revenue&basis={{ basis }}">Revenue retention (NRR)</a>
  <a class="{% if metric == 'grr' %}on{% endif %}" href="?{{ filter_qs }}{% if filter_qs %}&{% endif %}metric=grr&basis={{ basis }}">Gross revenue retention (GRR)</a>
  <span class="sp"></span>
  <a class="{% if basis == 'first_revenue' %}on{% endif %}" href="?{{ filter_qs }}{% if filter_qs %}&{% endif %}metric={{ metric }}&basis=first_revenue">First-revenue cohorts</a>
  <a class="{% if basis == 'signup' %}on{% endif %}" href="?{{ filter_qs }}{% if filter_qs %}&{% endif %}metric={{ metric }}&basis=signup">Signup cohorts</a>
</div>
<section class="strip"><span>Trailing-12-month NRR <b>{{ latest.nrr|pct }}</b></span><span>Trailing-12-month GRR <b>{{ latest.grr|pct }}</b></span><span>Quick ratio <b>{{ latest.quick_ratio|num:2 }}</b></span></section>
<section class="card"><div class="scroll"><table class="heat">
<thead><tr><th>Cohort</th><th class="r">Customers</th><th class="r">Start MRR</th>{% for k in offsets %}<th class="r">M{{ k }}</th>{% endfor %}</tr></thead>
<tbody>{% for r in table.rows %}<tr><td>{{ r.cohort|date:"Y-m" }}</td><td class="r">{{ r.customers }}</td><td class="r">{{ r.base_mrr|money }}</td>
{% for c in r.cells %}<td class="r hc" style="{{ c|heat }}">{{ c|pct:0 }}</td>{% endfor %}</tr>{% endfor %}
<tr class="avg"><td>Weighted avg</td><td></td><td></td>{% for c in table.average %}<td class="r hc" style="{{ c|heat }}">{{ c|pct:0 }}</td>{% endfor %}</tr></tbody></table></div></section>
<section class="card"><h2>Cohort summary at month 12</h2><table>
<thead><tr><th>Cohort</th><th class="r">Customers</th><th class="r">Start MRR</th><th class="r">Logo</th><th class="r">NRR</th><th class="r">GRR</th></tr></thead>
<tbody>{% for s in summary %}<tr><td>{{ s.cohort|date:"Y-m" }}</td><td class="r">{{ s.customers }}</td><td class="r">{{ s.base|money }}</td><td class="r">{{ s.logo12|pct }}</td><td class="r">{{ s.nrr12|pct }}</td><td class="r">{{ s.grr12|pct }}</td></tr>{% endfor %}</tbody></table>
<p class="muted">Cohorts younger than 12 months show a dash. Customers that never paid are excluded from every triangle.</p></section>
{% endblock %}