Good day
I have a TV Plan of shows where people SMS leads to be contacted back.
There may be TV shows on the same day at the same time but on different stations.
Each TV channel has it's own keyword (e.g. S1 - Justice, S2 - Law etc)
Depending on what time the person SMS's in that lead (with the Keyword) should be allocated to the TV show that showed directly before the lead came in with the same keyword.
I have managed to use interval match and the results totals are correct but the detail sometimes duplicates leads as I have interval matched the date and time the lead is received with the date and time the TV show aired but I am not sure how to check for the same keyword.
I have attached the script and result.
Can anyone assist please?
