New Reporting: Email vs. Social Signups

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

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)