Skip to content
Workflow · Track and forecast · Opening soon

PostHog weekly active users by company

Export the weekly active users by company data from PostHog, then use the week starting 9 November as the latest week. Mammoth groups the rows by company, adds company names, and flags companies with more than a 50 percent drop from their four week average, no activity in the last two weeks, or users with no company attached.

Early access opens shortly. Check back soon.

Someone typed

“from our posthog weekly active users by company export, take the week starting 9 november as the latest week and show one row per company, flagging companies whose active users dropped by more than half from their four week average, companies with no activity in the last two weeks, and users with no company attached”

The agent read it as

From PostHog weekly active users by company export, using Companies, take the week starting 9 november as the latest week and show one row per company, flagging companies whose active users dropped by more than half from their four week average, companies with no activity in the last two weeks, and users with no company attached.

What the agent built

3 steps, each one an ordinary Mammoth step you can open and change.

  1. File
    PostHog weekly active users by company export
    CSV export · 40 rows
  2. File
    Companies
    CSV export · 5 rows
  3. Step
    Summarize recent weekly activity
    Step 1
  4. Join
    Add company names
    5 of 6 paired
  5. Step
    Flag companies to review
    Step 3
  6. Result
    Company activity flags
    6 rows
  7. Schedule
    Runs when you say
    Proposed

On the sample files, every step runs and the result has 6 rows.

What you get back

The result of that run, the rows to look at first.

Company activity flagsSample data6 rows
CompanyCompany IDLatest active usersFour-week averageDrop flagActivity flagCompany flag
Aster Laneco_118412Dropped by more than half··
BrightOrbitco_20408.25Dropped by more than halfNo activity in the last two weeks·
No company attached(none)81.75··No company attached
Copperfield Opsco_4421311.25···
Morrow Peakco_559109.25···
Northstar Ledgerco_3171110···
6 rows in the result. Sample data: illustrative figures, not business results.

How it works

How to use the Company activity flags workflow

  1. 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and working on sample files.
  2. 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
  3. 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.

Company activity flags: questions

How do you review weekly active users by company in PostHog?
Export the weekly active users by company data from PostHog, then use the week starting 9 November as the latest week. Mammoth groups the rows by company, adds company names, and flags companies with more than a 50 percent drop from their four week average, no activity in the last two weeks, or users with no company attached.
What export should you use for this workflow?
Use the PostHog weekly active users by company export. A spreadsheet-style workflow tool needs the exported file, not the live dashboard.
What happens to rows that do not match a company?
They are kept for review and flagged separately, so you can see users with no company attached. The company-level summary still shows one row per company for matched rows.
How do you change the review rules?
Change the rule wording in the workflow steps, then rerun it on a new export. You can adjust the latest week, the lookback period, or the threshold for a drop in activity.

Get early access to this workflow

It opens already built and working on sample files. Swap in your own exports to see your result.

Early access opens shortly. Check back soon.

Workflows like this

The number you report every month, rebuilt from the latest export, plus the forecast that follows from it.

All track and forecast workflows →