Time proximity Measure

[nckpedersen]

I have three tables with the relevant fields highlighted: 

1. Marketing Email Engagement (Clicks) 
   1. Click Date
   2. Recipient Email 
   3. Email Name
2. Contacts
   1. Email
   2. Unique Id
3. Opportunities
   1. Primary Contact
   2. Name
   3. Created Date
   4. Amount

I'm trying to segregate marketing influences on opportunity creation - effectively how many "touches" a contact received before an opportunity was created within a reasonable timeframe (e.g.45 days). 

[v-xiaosun-msft]

Hi @nckpedersen ,

From the fields you provided above, it seems that there is no direct relationship between your three tables. Please tell us the relationship between three tables or provide some sample input data and expected output in order that we can help you further more.

Best Regards,
Community Support Team _ xiaosun

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.