Soul

Most recent activity

• Home DIY

  in Miscellaneous and Meaningless • 46 minutes

  

  Anyone got a track / plunge saw I can borrow? need at least 2.5m track...

  Can collect and return from Cambridge area / north east London.

  Cheers.

• Car appreciation... the aesthetics, the engineering, etc

  in Miscellaneous and Meaningless • 20 hours, 59 minutes

  

  Nice! Near the river or closer to Milton?

  We're in Royston now but i grew up in Cambridge hence why we're up here out of London...

• Car appreciation... the aesthetics, the engineering, etc

  in Miscellaneous and Meaningless • 1 day, 1 hour

  

  Welcome to Cambridge...

  Which part?

• MS Excel / VBA help thread

  in Miscellaneous and Meaningless • 1 day, 3 hours

  

  Of course - I'd love full in-market brand tracking or proper control / exposed measurement but the audiences, budgets, etc for this client make it impossible. As we're not selling anything, econometrics isn't possible without the brand tracking so...

  Let me know if you think of anything.

  At the moment, I'm using z-score to determine the deviation from the mean and then pro-rata that across the different measurements based on a priority percentage but that just gives me a load of positive or negative numbers which are sums of the z-scores.

  Combining them into a repeatable score system means i have to work out how to rank those results then score them against the group and translate that figure into a consistent range (score of 1-10 or something).

  I'll play around again today.

• MS Excel / VBA help thread

  in Miscellaneous and Meaningless • 2 days

  

  I'm trying to change the way we measure success for some of our clients ad activity. Currently it's reported using lots of different metrics (Reach, frequency, impressions, clicks blah blah) and number blindness is real.

  I want to combine them all into a health score; a single number which takes into account the relative performance of each metric.

  Essentially, let's assume we measure reach, frequency & click through rate...

  We've got 30 different publishers all with their own performance against these metrics.

  For reach, i want to rank the publishers performance against the whole data set (the one with the most reach wins etc).
  For frequency & CTR %, i want to measure their performance against a set benchmark (say 6 for frequency & 2.5% for CTR).

  I then want to combine all three results into a score (say out of 10) which can be compared with all other publishers. That score should be weighted based on our chosen priority of each metric (e.g Reach60:Freq20:CTR20)

  Any ideas how best to go about this?

  I started down the z-score and standard deviation route but I'm having issues working out how to get it back to a worthwhile number / measure.

• Football

  in Miscellaneous and Meaningless • 2 days, 7 hours

  

  So glad I bothered last night.

  Back at midnight and up for the 6.54 train into London for work.

  We didn't even try.

  p.s Fuck Stoke.

• Films

  in Miscellaneous and Meaningless • 3 days, 2 hours

  

  https://www.theverge.com/2020/1/20/21073­635/studio-ghibli-netflix-streaming-righ­ts-acquired-global

  !!

• Epic win

  in Miscellaneous and Meaningless • 3 days, 3 hours

  

  Glorious work.

  Can't have cost them more than £5k to place that but it'll generate so much additional PR etc.

• American football

  in Miscellaneous and Meaningless • 3 days, 7 hours

  

  Glad I went to bed at half time. Bit of a kicking that.

• American football

  in Miscellaneous and Meaningless • 3 days, 15 hours

  

  Tough start from the 49ers. Really don’t think we’ll get past them tonight