Is email address available in Canvas Data?

Jump to solution
John_Lowe
Community Champion

Is the email address of users available anywhere within Canvas Data?  I've recently been asked to generate a contact list of people based on the output of a Canvas Data report, but I can't seem to locate a field for email address in the user_dim or the pseudonym_dim.

1 Solution
James
Community Champion

Use the communication_channel_dim table.

You're looking for address with type='email'.

You can use user_id as a foreign key to the user_dim table to get other information.

View solution in original post