Solved

Getting emails from "Login" export?

Forum|Forum|6 months ago
May 14, 2025
2 replies
16 views

kristineo
Contributor ⭐️⭐️⭐️

I'm currently trying to do an export of users/user emails of folks in my community who have logged in in Q1 2024 (for an email survey that we’re sending through my org’s marketing/email platform). The "Login" export that I got via the "Export" tab only shows usernames and not emails, even though the "Users" export shows emails.

Is there a way to get the emails of the users from the "Login" export?

Best answer by Kenneth R

Hi @kristineo - The easiest thing to do is probably to also grab an all-time User export and then do a VLOOKUP (e.g. create an extra column in your login sheet and add a formula that does a ‘lookup’ in your User export to match usernames and pull the related email address). Have you ever done that before? If not, with a bit of help from Google or GPT it’s pretty straightforward and (this might just be me) is kind of fun and satisfying to do. :)

+5

Kenneth R
Expert ⭐️⭐️
Answer
Forum|Forum|6 months ago
May 15, 2025

Hi @kristineo - The easiest thing to do is probably to also grab an all-time User export and then do a VLOOKUP (e.g. create an extra column in your login sheet and add a formula that does a ‘lookup’ in your User export to match usernames and pull the related email address). Have you ever done that before? If not, with a bit of help from Google or GPT it’s pretty straightforward and (this might just be me) is kind of fun and satisfying to do. :)