<h2 style="text-align: center;">{{ num_active_sites }} active sites</h2>

<p style="text-align: center;">{{ utctime }}</p>

<ul>
    <li><strong>active (site)</strong> - has ≥5 DAUs</li>
    <li>sites are listed if ≥1 users active in last 2 weeks</li>
    <li><strong>user</strong> - registered user, not deactivated, not a bot</li>
    <li><strong>active (user)</strong> - sent a message, or advanced the pointer (reading messages doesn't count unless advances the pointer)</li>
    <li><strong>ARR</strong> (Annual recurring revenue) - the number of users they are paying for * annual price/user.</li>
    <li><strong>Rate</strong> - % of full price the customer pays, or will pay, if on a paid plan.</li>
    <li><strong><th><i class="fa fa-envelope"></i></th></strong> - copies realm admin emails to clipboard</li>
    <li><strong>DAU</strong> (daily active users) - users active in last 24hr</li>
    <li><strong>WAU</strong> (weekly active users) - users active in last 7 * 24hr</li>
    <li><strong>DAT</strong> (daily active time) - total user-activity time in last 24hr</li>
    <li><strong>Human message</strong> - message sent by non-bot user, and not with known-bot client</li>
    <li><a href="/stats/installation">Server total /stats style graphs</a></li>
</ul>

<table class="table summary-table sortable table-striped table-bordered">

    <thead class="activity_head">
        <tr>
            <th>Realm</th>
            <th>Created (green if ≤12wk)</th>
            {% if billing_enabled %}
            <th>Plan type</th>
            <th>Org type</th>
            <th>ARR</th>
            <th>Rate (%)</th>
            {% endif %}
            <th></th>
            <th>DAU</th>
            <th>WAU</th>
            <th>Total users</th>
            <th>Bots</th>
            <th>DAT/DAU (hr)</th>
            <th>DAT (hr)</th>
            <th></th>
            <th colspan=8>Human messages sent, last 8 UTC days (today-so-far first)</th>
        </tr>
    </thead>

    <tbody>
        {% for row in rows %}
        <tr>

            <td>
                {{ row.string_id }}
            </td>

            <td {% if row.is_new %}
              class="good" {% else %}
              class="neutral" {% endif %} >
                {{ row.date_created_day }}
            </td>

            {% if billing_enabled %}
            <td>
                {{ row.plan_type_string }}
            </td>
            {% endif %}

            <td>
                {{ row.org_type_string }}
            </td>

            {% if billing_enabled %}
            <td class="number">
                {% if row.arr %}
                {{ row.arr }}
                {% endif %}
            </td>

            <td class="number">
                {% if row.effective_rate != "" %}
                {{ row.effective_rate }}
                {% endif %}
            </td>
            {% endif %}

            <td>
                {% if not loop.first %}
                <a class="envelope-link" data-admin-emails="{{ row.realm_owner_emails }}">
                    <i class="fa fa-envelope"></i>
                </a>
                {% endif %}
                {{ row.stats_link }}
            </td>

            <td class="number">
                {{ row.dau_count }}
            </td>

            <td class="number">
                {{ row.wau_count }}
            </td>

            <td class="number">
                {{ row.user_profile_count }}
            </td>

            <td class="number">
                {{ row.bot_count }}
            </td>

            <td class="number">
                {% if row.hours_per_user %}
                {{ row.hours_per_user }}
                {% endif %}
            </td>

            <td class="number">
                {{ row.hours }}
            </td>

            <td>&nbsp;</td>

            {% if row.history %}
            {{ row.history|safe }}
            {% else %}
            <td colspan=8></td>
            {% endif %}
        </tr>
        {% endfor %}
    </tbody>

</table>
