Skip to main content

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?

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.  :)

​@Kenneth R ah yeah, i figured the workaround would be a combo of user export + some vlookups -- thank you! hoping i also have fun haha 

Terms & ConditionsCookie settingsAccessibility statement