livepeer / livepeer/livepeer-data-mcp

[Feedback] :pencil2: correction — Scope WAU using cloud events

Open
#31 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

feedback-correction mcp-feedback
Dominant language
TypeScript
Stars
0
Forks
1
PR merge metrics
No merged PRs in 30d

Description

## Feedback (correction)

**Question:** Scope WAU using cloud events
**Tool:** `query`
**Dataset:** `scope_cloud_events`

### Corrected SQL
```sql
SELECT toStartOfWeek(activity_date) AS week_start, uniqIf(person_id, has_scope_streaming = 1) AS scope_wau FROM semantic.user_daily_engagement WHERE activity_date >= toDate('2026-01-12') AND is_active = 1 GROUP BY week_start ORDER BY week_start
```

### Corrected answer
Canonical Scope WAU query uses user_daily_engagement with has_scope_streaming flag. Do NOT use scope_cloud_events for WAU — it includes internal users and unresolved identities. External filter is already baked into user_daily_engagement (model-level). No additional WHERE clause needed to exclude internals.

### Notes
Original query used scope_cloud_events uniq(user_id) which (1) included internal @livepeer.org users inflating numbers, (2) included unresolved person identities not present in user_daily_engagement, (3) was inconsistent with all other platform WAU metrics. Correct query is user_daily_engagement with has_scope_streaming flag.

---
_Feedback ID: `a8aeab8f-0f66-40a2-8db7-a08d73fd4c4a` | Recorded at 2026-03-11T00:43:54.863Z_

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

The issue names the `query` tool, `scope_cloud_events` dataset, and `semantic.user_daily_engagement` table, but no implementation file. Start by tracing how the query tool defines Scope WAU and compare it with the corrected SQL. Done means the canonical query uses `has_scope_streaming` and matches the stated external-user behavior.

Written by the indexing model from the issue text.

Assessment

Tech stack
sql
Domain
data, databases
Issue type
Bug
Difficulty
2/5
Estimated time
1-3 hours
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
45/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.