Hi all,
Was looking for some help!
I'm looking to find out how much money was taken when a link was clicked on an email within 8 hours, for a particular user.
The tables are:
1. Orders Table = Contains the details of the Order & Money Taken
2. Email table = Where the tracking of the email happens. So in actionID, 0 is email sent, 1 is email opened and 2 is link clicked.
I was looking to get a column in the email table with a sum of the revenue in the orders table where the UserID matches, the actionID is 2 and the date and time are within 8 hours.
What would be the best approach for this?
Thanks!
| Orders Table | | |
| | | | |
| UserID | Date | Time | Revenue |
| XXX | XX/XX/XX | XX:XX | £XX.XX |
| YYY | YY/YY/YY | YY:YY | £YY.YY |
| Email Table | | | |
| | | | | |
| EmailID | UserID | actionid | date | time |
| XX | XXX | 2 | XX/XX/XX | XX/XX/XX |
| YY | YYY | 2 | YY/YY/YY | YY/YY/YY |
