Analytics backend

[oscartbeaumont]

• [x] Fix Tinybird CI
• [x] Restructure using Effect services properly
• [x] Query for dashboard data
• [x] Remove getVideoAnalytics
• [ ] Implement a Tinybird Effect service
• [ ] Tinybird service (for mockability)
• [ ] Functionality
  • [ ] Build out schema
  • [ ] Parse all schema fields properly from the frontend
• [ ] Cleanup code - look into
• [ ] Using user's session_id vs a page load generating a unique session or both???
• [ ] Should we materialise the pipe???
• [x] Capture page views
• [ ] Capture page view metadata - city, country, device, browser, OS, referrer, referrer URL, and UTM source, medium, campaign, term, content
• [ ] Capture watch metrics
• [ ] Restrict to only Pro users
• [ ] Handle self-hosting
• [ ] Restrict who can push events???
• [ ] Check DB when pushing events or not???
• [ ] Env service and use Config in it
• [ ] Add to Cap video embed
• [ ] Handle Tinybird rate limiting
• [ ] Handle Tinybird local dev environment vs sending events to cloud
• [ ] Maybe apply for Json beta or schema better???
• [ ] Migrate views from Dub

Resources:

• https://chatgpt.com/share/690b575a-3004-8009-8131-b87825a77809

[coderabbitai[bot]]

[!IMPORTANT]

Review skipped

Draft detected.

Please check the settings in the CodeRabbit UI or the .coderabbit.yaml file in this repository. To trigger a single review, invoke the @coderabbitai review command.

You can disable this status message by setting the reviews.review_status to false in the CodeRabbit configuration file.

✨ Finishing touches

🧪 Generate unit tests (beta)

• [ ] Create PR with unit tests
• [ ] Post copyable unit tests in a comment
• [ ] Commit unit tests in branch analytics2

---

Thanks for using CodeRabbit! It's free for OSS, and your support helps us grow. If you like it, consider giving us a shout-out.

❤️ Share

• X
• Mastodon
• Reddit
• LinkedIn

_{Comment @coderabbitai help to get the list of available commands and usage tips.}