Magic Mind and Preql: Simplifying complex data into an easy-to-use source of truth

Magic Mind and Preql:
‍

Simplifying complex data into an easy-to-use source of truth

Magic Mind is the world’s first productivity shot: it’s scientifically designed to improve focus and decrease stress. The brand has grown exponentially and is committed to making data-driven decisions, which is why they partnered with Preql.

‍

The challenge:

Magic Mind leadership needed a complete view of the business to make informed sales, marketing, and inventory decisions.

Magic Mind launched on Shopify and initially relied on out-of-the-box metrics from their platform to power key financial models. The business quickly outgrew this functionality and was constrained by Shopify’s lack of reporting flexibility. CEO and Founder William Hicks spent hours each week downloading manual CSVs and massaging data in Excel before he felt comfortable making critical company decisions.

In addition to the limitations of Shopify data, Magic Mind needed to report on metrics from paid marketing platforms. These platforms were even more rigid and siloed in their reporting capabilities. It became unmanageable to pull data from each source system, and the platforms didn’t always agree. When numbers seemed off, it was hard to understand why. Pulling data from multiple sources and trying to make sense of it was time intensive and did not scale with the business.

‍

“I needed something that allowed me to build customer segments based on any data point in a secure, governed way,” explained William Hicks, CEO at Magic Mind.

‍

Data sources:

• Shopify
• Amazon Seller Central
• Amazon Ads
• Facebook Ads
• Google Analytics

The solution:

Preql’s metrics layer to standardize all business data points

Magic Mind needed faster time to insights and reporting they could trust. Given the pace of growth of the business, they also needed to create and customize metrics as the business expanded into new distribution channels and launched new products.

Magic Mind’s CEO customized their metric definitions in a no code, flexible UI. Preql’s reporting functionality and Google Sheets integration is now powering Magic Mind’s financial model on an hourly basis. This robust financial model helps inform decision making around ad channel ROI, cohort analysis, sales and marketing forecasting, subscriber retention rates, and more. Preql simplified the process of getting value out of data quickly.

Magic Mind started with Preql’s autogenerated metrics, then customized the definitions to suit the nuances of their business.

After leveraging Preql, Magic Mind was able to:

• Reduced time to insights from 1 month to 1 day
• Improved accuracy of revenue and sales forecasting with advanced metrics
• Reduced developer expenses by empowering the C-Suite to slice data as needed
• Company-wide access to reliable and governed metrics

To learn how Preql’s no-code solution can help you accelerate your time to insights, sign up for a demo today. We’re finalizing our initial pilot programs to a handful of customers.

‍