Setting up custom reporting is expensive. My agency charges new clients between $20k and $30k to implement the required infrastructure and build 3 - 7 custom reports. Ongoing support is $8.5k - 10k a month. Its a niche offering for DTC brands that check the following boxes: 1. Generating at least $25M a year in revenue --> A brand that's generating less than $25M can get away with using a combination of native reports, Excel and dedicated SaaS like Triple Whale or Polar Analytics. The ROI of custom reporting for sub-$25M brands is just not there. 2. A team size of at least 40 individuals --> The real pain of not having robust, custom-built reports is really felt once the team hits around 40 individuals. At this point there is typically individuals or small teams dedicated to different areas of performance such as CRM, email marketing, paid acquisition, SEO, operations, etc. Everyone is doing their own reporting and analytics which leads to a ton of friction and disorganization. 3. A desire to become more data-driven --> Bringing the data in-house and having full ownership over ones data and reporting is a resource intensive project. It takes roughly 60 days and cost $20k - $30k to set everything up. Most DTC businesses are focused on new custom acquisition and rolling out new products and aren't motivated to improve their analytics and reporting. Once there is enough pain, the motivation to make a change comes about. So why would a brand go through with such an expensive project? Well, the short answer is they get the following benefits once the work is done: 1. Automated, custom reportings --> No more manually work in Excel saves a ton of man-hours and significantly improves the accuracy of your reports. 2. The business owns all its data --> A well constructed data warehouse holding the company's business data is an asset that raises the valuation of the company, and provides high leverage on its data. 3. Speed to insight goes down from days to minutes --> Since the reports are automated and built to serve the exact needs of the decision makers, the speed to gain insights on the data is dramatically reduced. The faster a business can move, the better it will perform. 4. Easier to track the performance of the team and understand what's working and what's not --> A robust BI setup will allow managers to easily track performance KPIs of individuals and teams, and create more accountability in the organization. Setting up custom reporting is expensive and resource intensive, but the benefits far outway the costs. If your business checks the boxes above, then we should chat. Send me a DM here on LinkedIn, or visit https://www.projectbi.net and contact me via the website.
Justin Butlion, I think you are underplaying what you are delivering here - this isn't just setting up some reports but building out a whole data pipeline!
Ben Glynn, this whole report data stack can be done with Mixpanel + Vendo + Ad integrations.
That is a great offer.
Justin Butlion I'm curious as to your thoughts regarding BigQuery > Tableau instead of BigQuery > Looker/Looker Studio?
Solid structure Justin
hi Justin Butlion very cool summary and post + offering for ECOM :) more than happy to help you and your clients to cut down time to insights even further with a new product we developed on top of dbt for sources >> data modelling >> embedded analytics will DM you thanks! cc Hussain Halaj
This tech stack will definitely do that. Would advise CPG brands to trim the fat here.
Insightful post, Justin Butlion ! Custom reporting truly empowers data-driven growth. 💡 Curious about your experience integrating email marketing data for holistic analytics? Personalized newsletters can unlock new revenue streams. 💌
Helping businesses to turn data and BI from cost centers to profit drivers.
5moA truly modern data stack. Have you tested alternatives to Fivetran to possibly cut costs?