Monthly Active Users

Access monthly active users (MAUs) by executing:

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
  }
}

Below are some examples of how GetMonthlyActiveUsers can be called.

Single Month

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

---

Example Result:

{
  "data": {
    "rows": [
      {
        "month_year": "2025-01",
        "unique_users": 3016
      }
    ]
  }
}

Multiple Months

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

---

Example Result:

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