Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Week 4 Day 1 Lab Missing data - Funnel Analysis #222

Open
sciencemath opened this issue Dec 27, 2024 · 0 comments
Open

Week 4 Day 1 Lab Missing data - Funnel Analysis #222

sciencemath opened this issue Dec 27, 2024 · 0 comments

Comments

@sciencemath
Copy link

sciencemath commented Dec 27, 2024

I re-downloaded the data.dump just in case mine mismatched the repo but when following along I don't get the same data.

WITH deduped_events AS (
	SELECT
		user_id,
		url,
		event_time,
		DATE(event_time) AS event_date
	FROM events
	WHERE user_id IS NOT NULL
	AND url IN ('/signup', '/api/v1/users')
	GROUP BY user_id, url, event_time, DATE(event_time)
)

SELECT d1.user_id, d1.url, d2.url, d1.event_time, d2.event_time
	FROM deduped_events d1
	JOIN deduped_events d2
		ON d1.user_id = d2.user_id
		AND d1.event_date = d2.event_date
		AND d2.event_time > d1.event_time
	WHERE d1.url = '/signup' AND d2.url = '/api/v1/users'

returns no data

I do get a bunch of data for /signup
/api/v1/users does not match

I do have /api/v1/login

Screenshot 2024-12-27 at 11 20 56 AM Screenshot 2024-12-27 at 11 21 08 AM

Not a blocker, continuing with replacing/api/v1/users with /api/v1/login for now

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant