I have two data sets:
1) a list, to the minute, of when direct response TV adverts were broadcast. There are several ads running per day over a number of months. Ads don't necessarily run each day and every day.
2) a list of customers who registered on my site to the minute they joined. Along with the date and hour data.
I am looking to do some analysis by highlighting all registrations that were logged within 5 mins after a TV spot.
I am reaching out to ask how I might do this - somehow identify those customer registrations that are 0-5mins after an advert spot vs. that fall outside that spread.
Thanks in advance
1) a list, to the minute, of when direct response TV adverts were broadcast. There are several ads running per day over a number of months. Ads don't necessarily run each day and every day.
2) a list of customers who registered on my site to the minute they joined. Along with the date and hour data.
I am looking to do some analysis by highlighting all registrations that were logged within 5 mins after a TV spot.
I am reaching out to ask how I might do this - somehow identify those customer registrations that are 0-5mins after an advert spot vs. that fall outside that spread.
Thanks in advance