Pink Lily unlocks data-driven decision making with Precog

Pink Lily, a rapidly growing online women’s fashion retailer, experienced explosive growth over a decade, scaling from a home operation to a 200,000 ft² facility. With this company growth came an expansion of their tech stack–adopting Shopify, ShipHero, and several marketing, advertising and analytics tools like Meta Ads, TikTok, Google Analytics and Google Ads.

‍

Data fragmentation prevents actionable insights

‍

As Pink Lily adopted more applications, business leaders needed reports combining data sources to analyze and optimize the return on ad spend. This fragmentation created significant operational bottlenecks:

• No Unified View: Consolidating data from multiple sources into Snowflake for reliable reporting was critical but difficult.
• Manual Processes: Employees manually downloaded and combined reports from each application — a slow and error-prone process.
• Reporting Gaps: Business users struggled to link marketing spend to sales revenue across multiple ad channels.

‍

This inability to easily integrate combined data prevented the optimization of ad spend and made it difficult to make agile, data-informed decisions. “[The problem] we ran into is, you’ve got all of these apps, and then you have to download the information, and then you have to put it in something to combine all of it?” says Chad Gilleland, IT Manager for Pink Lily. “It was like, this is tedious work. It’s manual and inefficient, and there’s a lot of room for error.“

‍

Transforming data analytics with Precog

‍

Recognizing the need for centralized data, Pink Lily sought a solution to consolidate data from all sources into Snowflake for unified analytics. The search hit a critical roadblock when ShipHero, their warehouse management system (WMS), updated its API from REST to GraphQL. This change proved insurmountable for other vendors evaluated.

‍

Precog emerged as the only solution that could handle ShipHero and the rest of Pink Lily’s applications and load the data to Snowflake. “It left Precog being the only choice that we had… Precog could handle it.”

‍

Precog delivered and empowered significant benefits, including:

• Unified Reporting: Achieved a consolidated view linking ad spend from Google, Meta, TikTok and more to Shopify and ShipHero, showing Return on Ad Spend (ROAS).
• Significant Time Savings: Eliminated manual report extraction and loading, saving an estimated 8 hours of employee time daily.
• Data Democratization: Empowered users across Finance, Demand Planning, and Merchandising with direct access to data, enabling confident decision making.

‍

“Once you add this information together, it opens up a whole new level of reporting that gives [the business teams] insight… you could see all of the transactional data and where that root dollar came from.” – Chad Gilleland, Pink Lily

‍

Ready to unify your data and power data-driven decision making? Request a demo of Precog today.

‍