Results 1 to 2 of 2

Thread: Correlation of customer registrations plotted against TV advertising spots

  1. #1

    Correlation of customer registrations plotted against TV advertising spots



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,481
    Articles
    0
    Excel Version
    365
    Some sample data to play with perhaps?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •