I really like the honesty about how he lost money buying youtube ads...feels like there's definitely a market for an self-serve "pay x amount a month" for "y results" app if you will.
That doesn't exist because it's impossible. Advertising doesn't work like that and anyone who could actually guarantee results would become bigger than Google overnight.
They don't have to guarantee results - Companies are becoming disillusioned about Ads as it is (since they don't understand technology and/or can't compete with companies that do)...we need a platform where such companies go back doing their core-services if you will and leave the rest to experts - As an example - a B2B company making some airplane part does not need to host it's own marketing site (for it's sales pipeline), measure KPIs on this site etc. - Instead, it could pay $X to an self-serve app, and let them manage everything about said content (maybe even help with the content creation as well) to achieve measurable results Y (KPIs).
That's called a marketing agency, and they come in all shapes and sizes. If you're a very small company then there are plenty of freelancer marketers that can help you out, even if it's just to setup a basic framework for running campaigns.
An "app" would not be sufficient to handle any of the complexity here.