Hi FlyFisher,
Is this how you meant the post to look?
I needed to reformat it to be able to read it and thought others might benefit.
Enjoy,
Brian
Apologies for prior post, not sure why it posted before I finished.
Wanted to provide some additional context on the CTV numbers from a triangulation I did after Q4. These still can’t be entirely pinned down, but I think when you consider all the
information provided since the start of CTV you have a pretty tight range (which is a bit above what has been quoted so far on the thread).
First, last conference call Jeff said "In Q4, we had record spend in CTV. Over 160 advertisers spent at least $100,000 each in CTV, with a double-digit number of them spending in
the millions." Based on this I assumed:
"The over $1M club is “double-digit” so theoretically could be 10-99; I agree it is likely much closer to 10 given the phrasing and that only 160 customers are over $100K. I also
agree that the spend over $1M likely stays pretty close to $1M, but say a reasonable guess is 15 customers with average of $1.5M spend and you are at $22.5M for this group.
The remaining customers (in my example ~145 customer) are somewhere between $100K-$999K. In this case, I think the average is likely well above $100K. Maybe still tilted toward
the lower end, but I don’t see why ~$400K would be a bad guess on average for this subset. 145 customer with average of $400K spend is $58M.
Combine those two and we are at $58M + $22M = $80M spend x 20% conversion to revenue = $16M CTV revenue in Q4’18. So maybe the range is $5M-$20M but I think it is a very
reasonable estimate that is is double digit millions in Q4’18 and approaching 10% of revenue."
Second, below are the data points we have been given on CTV the last 10 quarters:
Q4'16 2X+ Q/Q
Q1'17 3X+ Y/Y
Q2'17 167% Y/Y
Q3'17 159% Y/Y
Q4'17 535% Y/Y
Q1'18 2000%+ Y/Y (WOW)
Q2'18 2X+ Q/Q (DOUBLE WOW given Q1'18 growth)
Q3'18 10X+ Y/Y
Q4'18 525% Y/Y (9X+ full year 2018)
Q1'19 200% Y/Y
If we triangulate the ~$16M estimate with all these data points aboveit would indicate a base of roughly $750K in full year 2016 which is less than 0.5% of total revenue that
year. At some point you cant get much smaller than that in the base period which I believe helps validate the number being in this range.
Continuing this exercise into Q1’19 would indicate CTV revenue of ~$14M in Q1’19 which is ~12% of TTD’s revenue. Below is a chart with my estimates:
Qtr Yr CTV CTV TTM CTV Q/Q CTV Y/Y TTM Y/Y CTV Mix Rest Rest TTM Rest Q/Q Rest Y/Y TTM Y/Y
Q1 2016 0.1 0.1 0% 30.3 126.2 -29% 69% 125%
Q2 2016 0.1 0.2 33% 0% 47.1 148.8 55% 93% 106%
Q3 2016 0.2 0.4 100% 0% 52.8 172.8 12% 84% 93%
Q4 2016 0.4 0.8 100% 1% 72.0 202.2 36% 69% 78%
Q1 2017 0.2 0.9 -44% 200% 1133% 0% 53.2 225.1 -26% 75% 78%
Q2 2017 0.3 1.1 19% 167% 524% 0% 72.5 250.5 36% 54% 68%
Q3 2017 0.5 1.4 94% 159% 276% 1% 78.9 276.6 9% 49% 60%
Q4 2017 2.5 3.6 390% 535% 358% 2% 100.1 304.7 27% 39% 51%
Q1 2018 4.7 8.1 86% 2000% 770% 6% 80.9 332.5 -19% 52% 48%
Q2 2018 9.5 17.2 100% 3439% 1478% 8% 102.9 362.8 27% 42% 45%
Q3 2018 6.0 22.7 -37% 1050% 1508% 5% 112.9 396.8 10% 43% 43%
Q4 2018 15.9 36.0 166% 525% 914% 10% 144.6 441.3 28% 44% 45%
Q1 2019 14.2 45.5 -11% 200% 465% 12% 106.8 467.2 -26% 32% 41%
Again this is triangulated data based on data points provided + assumptions… but looking at the data in this fashion leads to a few conclusions.
Growth in non-CTV business was lowest on record in Q1’19 at ~32% Y/Y… however it also had the toughest comparable (growth in Q1’18 in non-CTV was ~52% Y/Y)
Compares will be easier in non-CTV the remainder of the year… but can they grow it 40%+ given bigger base?
Tough CTV compare in Q2’19 as CTV in Q2’18 was almost $10M… how will street react if CTV “only” doubles Y/Y Q2’19?
To beat their guidance by ~7% Y/Y in Q2’19 I estimate they need to do ~100% Y/Y growth in CTV (lower because of tough compare, this is still +$4M Q/Q) and +41% Y/Y in the
rest of the business.