Correlation of customer registrations plotted against TV advertising spots

tomtom25

New member
Joined
May 31, 2014
Messages
1
Reaction score
0
Points
0
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
 

p45cal

Super Moderator
Staff member
Joined
Dec 16, 2012
Messages
2,168
Reaction score
10
Points
38
Excel Version(s)
365
Some sample data to play with perhaps?
 
Top