How to create relationship in an Email dashboard?

Hi,

---

TomEluscious wrote:

Thank you for your explanation. In this example you are right, but what if I a customer received another target email. Then the email adress is not unique anymore?

 

Email_table:

email_campaign || Email                  || Send_date || Click

target_email_1      || [email protected] || 21-5-2018  || 1

target_email_2      || [email protected] || 24-5-2018  || 1

 

order_table:

Email                 || Ordernummer  || Order_date || order_value

[email protected]|| X108                   || 22-5-2018    || 20

[email protected]|| X120                   || 25-5-2018    || 26

 

End result:

email_campaign || Email                  || Send_date || Click || order_date || order_value

target_email_1      || [email protected] || 21-5-2018  || 1       || 22-5-2018    || 20

target_email_2      || [email protected] || 24-5-2018  || 1       || 25-5-2018    || 26

---

In this case where you will have multiple emails in both the tables, you can add a bridge table between these tables that will have all the unique Emails in it and join the Order and Email table using this bridge table. The Modle would look something like the one in the below screenshot

In the above screenshot, Date column in Table1(2) will have unique dates. In your case, this will be all unique email Ids