New Reporting: Email vs. Social Signups

data & reporting
1

Hi there,
There’s a large discrepancy of signups in Google Analytics vs. Discourse. One aspect that will help troubleshoot is being able to export when a user created an account and if it was social signup vs. email in bulk. Social signup/login and email signup are 2 goals we have in GA so this bulk export would help us troubleshoot where the tracking breaks.

Thanks,
Jesse

2

Working with this query but it’s not returning any users as having signed up via email nor has created_at column

WITH target_user_ids AS (

SELECT id

FROM users

WHERE staged = false

    AND active = true

    AND last_seen_at IS NOT NULL)

SELECT

provider_name,

user_id,

info->>'name' AS name,

info->>'email' AS email,

info->>'image' AS image

FROM user_associated_accounts ua

WHERE user_id IN (SELECT id FROM target_user_ids)