CJ Wildlife, operating under its main brand Vivara, is a leading international retailer specializing in wildlife and bird food products. The company runs an extensive ecommerce network under the Vivara brand, spanning 15 shops in 11 different countries across the EU and the UK.
Challenge
As part of our collaboration with CJ Wildlife, we managed their paid media efforts and quickly identified the need for a more robust and holistic reporting solution. With a broad international presence and multiple ecommerce platforms, CJ Wildlife faced several challenges in consolidating, managing, and analyzing its marketing and ecommerce data. The primary issues included:
- Manual Excel reporting and inconsistent templates across countries led to inefficiencies and fragmentation.
- Siloed data across social media, paid media, SEO, ecommerce sales, and email marketing.
- Limited real-time insights and inconsistent data quality.
- Challenges in forecasting and making data-driven decisions.
- Difficulty aligning web analytics with actual ecommerce and ERP sales data.
- Scalability limitations with traditional reporting tools.
Our Approach: Step-by-Step Enhancement of Marketing & Ecommerce Reporting
1. Initial Dashboard Development
- Built an international marketing and ecommerce dashboard with semi-automatic data connectors.
- Integrated data from multiple sources, including Google Analytics, Google Ads, Microsoft Ads, Meta Ads.
- Used Looker Studio for visualization to provide initial reporting insights.
2. Transition to Funnel for Data Intelligence
- As CJ Wildlife’s data needs expanded, incorporating additional sources such as affiliate networks, email marketing, SEO rankings, and revenue targets became essential. To address these growing complexities, Funnel’s robust API capabilities enabled the development of fully customized solutions, ensuring seamless data integration and flexibility.
- This advanced integration enhanced data quality, consistency, and significantly reduced errors.
- Funnel’s data hub efficiently connected over 200 data sources, providing a scalable foundation for analytics.
- The unified dashboard allowed CJ Wildlife to effortlessly segment and filter data by shop, data source, campaign type, and other key dimensions, enabling precise performance analysis and more informed decision-making.
3. Scalability and Data Ecosystem Transformation
- CJ Wildlife transitioned from relying solely on Funnel’s data hub to an enterprise-grade solution with Microsoft Azure and Power BI.
- This complete migration ensured a fully scalable and flexible data infrastructure, allowing CJ Wildlife to adapt to evolving business needs effortlessly.
- The transition was seamless, requiring no additional data connections, as Funnel’s robust export capabilities facilitated smooth data transfers.
- This setup now enables CJ Wildlife to integrate and visualize data dynamically, ensuring a tailored approach that aligns with the company’s unique data ecosystem and reporting requirements.
Key Benefits & Results
- Unified Data Management: Consolidated marketing and ecommerce data across multiple regions and platforms.
- Improved Data Accuracy: Reduced inconsistencies and errors with Funnel’s automated data workflows.
- Enhanced Decision-Making: Daily insights available through Looker Studio and Power BI.
- Scalability for Growth: Easily expanded data sources and reporting without technical bottlenecks.
- Seamless Integration: No need for additional data connections when transitioning to a new BI tool.
Conclusion
Through a strategic, step-by-step approach, All Around helped CJ Wildlife transition from fragmented and manual reporting to a scalable, automated BI infrastructure powered by Funnel. The flexibility of Funnel enabled seamless data exports to Microsoft Azure, allowing CJ Wildlife to leverage Power BI for even deeper insights. This transformation has empowered CJ Wildlife with a unified, up-to-date view of its ecommerce performance across multiple international markets, driving smarter decision-making and business growth.