# Nieuwe rapportage: E-mail vs. Sociale aanmeldingen

**URL:** https://meta.discourse.org/t/new-reporting-email-vs-social-signups/182821
**Category:** Data & reporting
**Created:** [10 maart 2021 om 22:09 UTC](https://meta.discourse.org/t/new-reporting-email-vs-social-signups/182821 "2021-03-10T22:09:51Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![401Ott](https://avatars.discourse-cdn.com/v4/letter/4/4da419/32.png) [@401Ott](https://meta.discourse.org/u/401Ott)
#### Post date: [10 maart 2021 om 22:09 UTC](https://meta.discourse.org/t/new-reporting-email-vs-social-signups/182821/1 "2021-03-10T22:09:51Z")

</div>

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

---

<div class="post-metadata">

### Author: ![401Ott](https://avatars.discourse-cdn.com/v4/letter/4/4da419/32.png) [@401Ott](https://meta.discourse.org/u/401Ott)
#### Post date: [10 maart 2021 om 22:14 UTC](https://meta.discourse.org/t/new-reporting-email-vs-social-signups/182821/2 "2021-03-10T22:14:44Z")

</div>

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)