Testimonials

Don't take our word for it, take theirs!

“Justin helped us implement robust product and marketing reporting which has guided our development roadmap, and growth strategy. Justin is a wizard with data and always met the challenge when we needed answers to specific questions. His strategic guidance has helped accelerate our growth and engagement with our customers.”

Daniel Shuman
Founder & CEO at Minta

“Before working with Justin and his team, we were doing very little with our data. Justin's guidance and the systems we've put in place with his help have transformed our business immensely. When needing to make critical business decisions, Justin has provided the necessary reports and analyses to effectively come to the right decision. I can highly recommend Justin & the projectBI team.”

Luca Ferretti
Co-founder & CFO at FitBody

“Justin helped us moving from a full manual process to a semi-automated one, allowing our team to have not only a robust reporting process, but also easily accessible historical data of sales, marketing and other key components. He fulfilled our expectations and was professional in every aspect of his work. With the data pipeline we built with his guidance, we are now able to make faster and more reliable decisions, and we are taking the business to the next level.”

Ondrej Hradec
Head of E-Commerce at Mascot Online B.V.

How projectBI helped Ogee scale its advertising spend to millions a month with custom reporting

Data Sources Integrated
Infrastructure Implemented
Dashboards Launched
Flash Report
Facebook Ads Dashboard
Sales Pacing Dashboard
Coupon Usage Dashboard
*The numbers shown in the dashboards above have been manipulated and do not reflect Ogee's true numbers.

projectBI has been amazing to work with. They have been a crucial element in us growing our business quickly the last couple of years from a low 7-figure brand, to close to a 9-figure brand.

They have helped multiple teams at Ogee break down and visualize our data in an actionable format.

We literally look at the reports they made for us multiple times per day and they are fundamental to our decision making at this point. From ad spend to inventory decisions, we utilize the reports in so many areas of our business.

I highly recommend this team!

Alex Stark

Co-founder & CMO at Ogee

Intoduction

Ogee is a fast-growing direct-to-consumer cosmetics brand based in the USA. Ogee approached projectBI in late 2021 with the goal of improving their business reporting.
Since then the projectBI team has worked with Ogee to build a number of custom business reports, and provide ongoing analytics services.

The Challenge

As Ogee scaled its online advertising spend it became increasingly tougher to track profitability.
The business wasn't sure if it could "put its foot on the gas" without being able to accurately track discounts, conversion rate, return on ad spend, and all the other inputs which make up contribution margin.
Ogee needed automated reporting which clearly showed the performance of its advertising costs in order to track its margins in near real-time.

The Solution

To solve this challenge for Ogee, the projectBI team developed a custom dashboard named The Flash Report.
The Flash Report included over 30 metrics calculated from 8 separate data sources. The data from these 8 sources was extracted via Fivetran. The projectBI team then modelled the data based on Ogee's exact business needs. The final step in the process was to develop the report using Tableau, a best-in-class data visualization solution.
The Flash Report provided Ogee with the confidence to make big bets and significantly grow the business over the last 3 years working with the projectBI team.