Daily

Get yesterday's Mixpanel KPIs by email

Every morning you see daily active users and sign-ups next to the same day last week.

Runs: Daily
Apps: Mixpanel
AI: Not needed
Access: service account (project read)

Send this to your assistant

Create a ClickRuntime automation: every day at 8am, pull yesterday's daily active users and sign-ups from Mixpanel and email them to me with the change from the same day last week.

Paste it into your assistant. It tells you what it will send or change before it runs live.

Add to ChatGPT Add to Claude

First time? Adding ClickRuntime to your assistant takes about two minutes.

Why use it

Why teams use this automation

On a product or growth team, someone opens Mixpanel first thing, loads the daily active users chart, flips to sign-ups, and compares the line against last Tuesday. When that person is out, or the dashboard filters were left on a different cohort, the check simply does not happen. A drop in activation after a release can then sit unnoticed for days, and the first mention is in the weekly meeting.

Each morning ClickRuntime runs Mixpanel segmentation queries for yesterday's daily active users, sign-ups and your top events, compares each figure with the same weekday a week earlier, and emails one table to the people on your list. The prior values are kept between runs so the comparison is always against a stored baseline.

It is a good fit for small teams that have no BI analyst and want the numbers to arrive without a dashboard login.

What you get out of it

Same numbers, same time, every day
Metrics land in the inbox before standup, calculated by the same queries each time. Nobody argues about which filters were applied, because the definition of an active user lives in the automation rather than in someone's saved chart.
Week-over-week context beside each figure
A DAU of 4,200 means little alone. Showing the same weekday last week next to it makes a 12 percent dip or a launch-day spike obvious at a glance, without opening a second chart to compare.
Release regressions found the next morning
If sign-ups halve after Thursday's deploy, the Friday digest shows it. Engineering gets the signal while the diff is fresh and the fix is a small rollback instead of a forensic exercise.
Top events show what people really use
Listing your highest-volume events each day reveals feature adoption trends, like a new export button gaining use or an old flow fading. Roadmap conversations then start from observed behavior, not from the loudest opinion in the room.
A reading list that survives vacations
The digest keeps arriving when the usual analyst is away, so the team keeps a continuous record. Months later you can scroll back through the emails to date exactly when a trend started.

How it works

What happens, step by step

Every morning, ClickRuntime asks Mixpanel for yesterday's daily active users and sign-ups.
It looks up the same numbers for the same weekday last week.
You get an email with each number and the percentage change against last week.

Before it runs live

Connect Mixpanel

What you get

RunsDaily

Get yesterday's Mixpanel KPIs by emailtoday, 9:00Succeeded

Email · Mixpanel KPIs for 2026-10-18Daily active users: 8,412 (+6% vs Sat 11 Oct) Sign-ups: 214 (-3% vs Sat 11 Oct)

Build your own

Need it to work differently?

This template is a starting point. Copy the prompt and change it, or describe a different automation from scratch, with your own conditions, more apps or an AI step. Your assistant writes it, tests it and runs it on ClickRuntime.

Your own rules
Conditions, thresholds, filters and exceptions, written the way you'd explain them to a colleague.
Any number of apps
One automation can read from one app and update several others. Over 248 apps are ready, and anything with an API works too.
AI where it helps
Summaries, classification, extraction and drafts use ClickRuntime's built-in AI, with no extra key.
On a schedule or on each event
Runs as often as every 5 minutes, or the moment an app sends an event, and keeps track of what it already handled.

Changes you can ask for

Run it at a different time, more or less often, or only on weekdays
Add an AI step, for example to summarize, sort or draft a reply
Add another app, for example also send it to Slack
Combine it with other Mixpanel steps into one automation

Under the hood

The code that runs this automation

This is the Python script that runs each time the automation starts. Your AI assistant writes it for you when you send the prompt, and you allow each step in your assistant. To change how the automation works, describe the change to your assistant and it updates the script for you. For every function it can use, see the script reference.

daily_kpi_digest_dau_signups_top_events.pyexample

from datetime import date, timedelta
from clickruntime import on_trigger, credentials, http, notify

PROJECT_ID = 2195193

def AUTH():
    return ("ops-reader.mp-service-account", credentials.secret("MIXPANEL_SERVICE_SECRET"))

def total(event_name, day, kind="general"):
    data = http.get("https://mixpanel.com/api/query/segmentation", auth=AUTH(), params={
        "project_id": PROJECT_ID, "event": event_name, "from_date": day, "to_date": day, "type": kind}).json()
    return sum(data["data"]["values"].get(event_name, {}).values())

@on_trigger
def run(event):
    y, wk = date.today() - timedelta(days=1), date.today() - timedelta(days=8)
    lines = []
    for label, ev, kind in [("Daily active users", "$session_start", "unique"), ("Sign-ups", "Sign Up", "general")]:
        now, before = total(ev, str(y), kind), total(ev, str(wk), kind)
        change = f"{(now - before) / before:+.0%}" if before else "n/a"
        lines.append(f"{label}: {now:,} ({change} vs {wk:%a %d %b})")
    notify.email_me(f"Mixpanel KPIs for {y}", "\n".join(lines))
    return {"lines": lines}

FAQ

Common questions

Which Mixpanel plan or credentials are needed?

The automation uses Mixpanel's query API, which needs a service account or project credentials with read access to the project. You store the secret in ClickRuntime. It only reads data and cannot change your Mixpanel project.

Can it report on a specific cohort or country?

Yes. Segmentation queries can filter by any event or user property, so you can report DAU for paying accounts only or sign-ups from one country. Tell your AI assistant the filter and which events count as the top events.

What counts as a daily active user here?

It follows the event definition you choose, such as any event, or one key action like Project Created. Mixpanel counts unique users who fired it on the calendar day in your project's timezone, so pick the event that matches real engagement.

What permissions does it need?

service account (project read). Nothing else in your accounts is used.

Does it need AI?

No. It runs without AI, so it doesn't use your plan's AI allowance.

How many runs does it use?

One run each time it runs (daily). Checks that find nothing to do and stop right away aren't counted.

Can I change how it works?

Yes. Describe the change to your AI assistant, for example a different schedule, channel or filter. It updates the automation, tests it and tells you what changed.

Hourly