Analytics Schema - 'Contacts' Table Addition of Email Address

[kmacgregorPR]

Request for contact email address to be available in the Contacts table within DataWarehouse from RPS.

Specification*

Project: Analytics Schema View model: CONTACTS Add new fields: CONTACT EMAIL

[plittlewood-rpt]

Hi @kmacgregorPR please can you provide your use case? We've deliberately kept PII out of the schema to date because it doesn't really serve any analytical purpose. If your use case is to report on contacts with/without this information, it would be more appropriate to add helper fields into the appropriate tables in the schema. Thanks

[kmacgregorPR]

Hi Pete, Thank you for coming back to me so promptly. We need to group emails together for a full tenancy (i.e. all the contacts emails associated with a tenancy) as there is no way on Reapit to report on this. We have requested this as a custom column on the tenancy report on Reapit, but they have said it is not possible, and bringing the email address of the contacts into DataWarehouse is the only way we can work around this. We then use this to link with Power BI and other Power Platform aspects. Any help much appreciated. Thanks

[github-actions[bot]]

The nature of this request requires product direction and therefore we have moved this issue into our ‘Not Ready’ column whilst we obtain the information/direction required. This issue will be updated when a product decision has been made. For more information on our processes, please click here