Case Study

Leading Child Mobility Tech Company Boosts Marketing Campaign Performance by 3X through Real-time Data Analytics and Visualization

Manufacturing
Data Engineering

About the Client​

Our client is a global leader in child mobility, offering an award-winning range of child car seats, strollers, bike seats, and more. With a mission focused on safety, comfort, sustainability, and user-friendliness, our client engineers, tests, and manufactures travel systems to enable safe and secure travel for children.

Business Needs​

Our client operates on a global scale with a diverse customer base. Their aim was to deliver hyper-personalized product offerings and promotions across multiple touchpoints including web, mobile, social media, in-store, and partner portals.

However, their data – from which they could gain in-depth insights – was in siloes, fragmented and under-utilized. The extensive marketing campaigns they ran across geographies generated a wealth of consumer data across touchpoints including Google Analytics, social media channels such as Instagram, Facebook, YouTube, Twitter, Pinterest, TikTok, LinkedIn, and traditional channels.

Our client wanted to leverage a centralized analytics platform capable of processing and harmonizing data from different regions and departments, Sprout Social, Google Analytics, CSV files, and marketing campaigns.

Most importantly, they aimed to bring their data to life through customizable and intelligent dashboards to holistically represent key marketing KPIs. They also wanted to empower their marketing team to create custom reports on the fly without expert intervention.

Our client chose Trigent as their tech partner to achieve these goals and realize the full potential of data in enabling marketing excellence.

Trigent Solution

Backed by our trusted expertise and data analytics experience, Trigent thoroughly assessed the client’s existing data infrastructure. We identified key pain points, and understood their business objectives and marketing strategies. Based on our diligent evaluation of multiple business intelligence platforms like Tableau and Sisense, we zeroed-in on the best option to execute the solution.

Our team devised a comprehensive solution for integrating, analyzing, and representing data in real-time through interactive and visually appealing dashboards.

We set up data pipelines in Azure Data Factory to streamline and integrate data from various sources. Our team built a custom API to integrate unstructured data from social platforms, captured on Sprout Social. This enabled standardized aggregation of social media metrics alongside structured data from website analytics and unstructured data from marketing campaigns and CSV files.

Integrated data was then loaded onto the Azure SQL data warehouse, where custom database scripts combined, cleansed, enriched, and formatted the data. We removed duplicates, resolved gaps, and aligned data to standard formats essential for report generation.

Next, we leveraged Azure Synapse for data analytics due to its ability to seamlessly integrate with Azure Data Factory and Azure SQL. It also provides powerful analytics capabilities on large datasets offering real-time insights through advanced data processing and machine learning integration.

Trigent’s Ninja teams designed and executed SQL queries, stored procedures, and custom code to perform statistical analysis and data modeling. Structured and unstructured data from across sources was unified and aligned with the Marketing KPIs. Data was organized, analyzed, and fed into Power BI for real-time reporting and visualization.

We built custom dashboards in Power BI to represent both individual datasets and combined data from multiple sources. These dashboards were embedded with slicers, filters and dynamic visuals to provide an interactive experience for decision-makers.

Through these dashboards, marketing leaders were able to apply filters based on criteria such as time periods, regions, product categories, and customer segments, and drill down into specific data points.

Lastly, we set up data refresh schedules, and integrated data sources for live streaming into the dashboards. This enabled real-time or near-real-time data updates in Power BI.

Trigent thus enabled the client to leverage diverse types of data from a wide range of sources. We helped cleanse and harmonize their data, created customizable dashboards to represent their key marketing KPIs, and enabled them to gain valuable consumer and market insights.

Data Integration

Data Transformation

Data Analytics and Reporting

Data Visualization

Client Benefits

With Trigent’s Power BI solution, our client was able to create a well-oiled data ecosystem and achieve the following.

  • Tap into a wide range of data types from across sources and geographies to gain maximum ROI from data.
  • By optimizing data models and data processing workflows, the client improved their overall efficiency in data analysis and reporting.
  • Real-time data updates in Power BI enabled the client’s leadership to continuously monitor key marketing and website metrics, and KPIs.
  • Boosted marketing campaign performance by 3x through hyper-personalized campaigns that were built around emerging trends and customer behavior.

Technology Stack