Monthly active users

Overview

The get_monthly_active_users function provides monthly active user (MAU) counts. Use this endpoint to:

• Track unique user engagement month over month
• Monitor user growth and retention trends
• Generate MAU reports for billing or analytics

Quick start

query GetMonthlyActiveUsers(
  $accountId: uuid
  $startDate: timestamp
  $endDate: timestamp
) {
  rows: get_monthly_active_users(
    args: { account_id: $accountId, start_time: $startDate, end_time: $endDate }
  ) {
    month_year
    unique_users
  }
}

Variables:

{
  "accountId": "a1b2c3d4-5678-90ab-cdef-1234567890ab",
  "startDate": "2024-01-01",
  "endDate": "2024-01-01"
}

Try it

Loading GraphQL Playground...

Parameters

Parameter	Type	Description
accountId	uuid	Account identifier
startDate	timestamp	Start date (format: yyyy-mm-dd)
endDate	timestamp	End date (format: yyyy-mm-dd)

Response fields

Field	Type	Description
month_year	String	Month and year (format: yyyy-mm)
unique_users	Int	Number of unique users for the month

Common use cases

Single month

Get MAU for a single month:

{
  "accountId": "a1b2c3d4-5678-90ab-cdef-1234567890ab",
  "startDate": "2024-01-01",
  "endDate": "2024-01-01"
}

Multiple months

Get MAU for multiple months:

{
  "accountId": "a1b2c3d4-5678-90ab-cdef-1234567890ab",
  "startDate": "2024-01-01",
  "endDate": "2024-03-01"
}

Example response

{
  "data": {
    "rows": [
      {
        "month_year": "2024-01",
        "unique_users": 3016
      },
      {
        "month_year": "2024-02",
        "unique_users": 1248
      }
    ]
  }
}