How One Product Manager Unified Analytics Across Four Shopify Brands Without a Data Team
Antelope Pets manages four direct-to-consumer pet brands, each with its own Shopify storefront, ad accounts, and email platform. For two and a half years, Jose, the lone Product Manager overseeing the entire portfolio, pulled data from 16+ separate logins, cleaned it manually, and dumped it into Google Sheets. With Knowi, he replaced all of it with a single centralized dashboard covering revenue, marketing, and retention across every brand, updated automatically, and embeddable directly into team meetings.
"Knowi became my data engineering org without having a data engineering org."Jose, Product Manager, Antelope Pets
Sixteen Logins, Four Brands, and a Spreadsheet That Reset Every Six Months
For two and a half years, getting a single weekly performance number at Antelope Pets meant logging into four Shopify portals, four Klaviyo accounts, four Google Ads dashboards, four Google Analytics properties, four subscription platforms, and more. Everything was exported to CSV, cleaned by hand, and loaded into Google Sheets.
Every six months, that Google Sheets file would hit its memory ceiling. Jose would port everything into a new file and start over. The data they needed to track included:
- Weekly and monthly revenue, orders, and average order value across all four brands
- Customer acquisition cost by channel and brand
- Email and subscription retention metrics
- Social reach and ad performance across Meta and Google
When leadership needed a different definition of gross sales versus net sales, what should have been a one-line change became a multi-hour spreadsheet surgery. Every custom number request meant starting from scratch.
"I was amending all these VLOOKUP formulas and conditional sum statements. I can do it, but it is a system that requires a lot of duct tape and bandages. Very painful to maintain and very easy to make mistakes on."
The Goldilocks Problem, Solved
Jose was not a first-time analytics buyer. He had worked with Snowflake, Tableau, Looker, Mode, and Chartio in prior roles. He understood exactly what a full enterprise analytics stack required, and knew Antelope Pets could not support one. There was no data engineering org. It was just him.
Most tools he evaluated fell into two categories: too much infrastructure for a lean team, or too simplified with no SQL access and no customization. Knowi sat between them. The ease of connecting APIs and building dashboards without engineering support, combined with direct SQL access for custom queries, meant Jose could self-serve everything himself.
"It was a Goldilocks problem. Too much or not enough. Knowi had the ease of using APIs, the ease of building dashboards, the ease of building widgets, and I am fluent in SQL. I knew I could self-serve my own queries and figure out the API connectors."
One Source of Truth for Four Brands and the Whole Marketing Team
Jose set up Knowi as the centralized analytics hub for the entire marketing organization. He is the Super Admin; four teammates consume dashboards and reports. All four Shopify stores, Google Ads, Google Analytics, Klaviyo, Recharge, Meta ads, and social accounts are connected in one place.
Business performance dashboards give the team weekly and monthly revenue, orders, AOV, and traffic across all four brands, updated automatically. Marketing intelligence dashboards join Shopify orders with Google Ads spend to calculate real customer acquisition cost, and compare Shopify traffic against Google Analytics sessions side by side.
For every weekly reporting meeting, Jose loads Knowi widgets embedded into Notion. The data populates automatically when he duplicates the meeting doc. No screenshots, no manual exports, no formatting.
"Embedding widgets into Notion was a huge game changer. Before, it was: pull the data, make a chart, screenshot it, paste it into another thing. All very manual. Now I duplicate the meeting doc and all my data is just there."
3 Hours Back Every Week and a Dashboard That Closes Budget Approvals
3 Hours Per Week Reclaimed
Time previously spent on data cleanup and manual reporting is now fully eliminated. The data pulls and updates automatically.
16+ Logins Collapsed Into One
Four brands, each with its own stack of platforms, now managed from a single dashboard accessible to the whole marketing team.
Weekly Reporting Prep: Zero
Notion-embedded Knowi widgets replaced the screenshot-paste-format cycle for every standing meeting. Duplicate the doc and the data is there.
Executive Buy-In, Faster
Jose walks into board meetings with a live dashboard connecting spend to outcomes. Leadership can check the numbers anytime. Budget approvals follow.
"When I asked for investment into growth, I could say: here is your dashboard. If we hit this number, it is working. If we do not, it is not. You can check it anytime. That completely facilitated buy-in and approvals."
A Team That Builds What You Ask For
Support requests typically resolve within 48 hours. But what stood out to Jose was how directly the Knowi team engaged with customer feedback. As Antelope Pets expanded its reporting needs, Jose regularly shared workflow frustrations and feature requests. Many of those improvements appeared in the platform over time.
When Jose flagged that charts were re-running queries every time instead of caching results, Knowi released cached charts shortly after. When new integrations were needed, Jay, Knowi's founder and CEO, would jump directly into support threads to confirm a connector would be built within days. Jose also follows product updates in Knowi's Slack community and sees the platform evolving alongside his team's needs.
"Knowi is one of those platforms that evolves well with technology over time. You can have your data available and accessible without a ton of investment, and you can self-serve your team without needing a dedicated data org. Super easy to use, and if you ever need anything, the team is always available."
Frequently Asked Questions
See What Knowi Can Do for Your Team
Connect any data source. Build dashboards in minutes. No engineering bottleneck.
Request a Demo Start Free Trial