80% reduction in time spent on digital analytics by migrating data to Snowflake

Migrated the customer’s digital media data stored in BigQuery to Snowflake to accelerate the digital marketing efforts by generating real-time
reports on DOMO

Business Challenges

The customer used BigQuery to collate and analyze diverse datasets from multiple countries to track the performance of the website and search engines. However, they followed manual processes to load the datasets, which became difficult to manage with the constant increase in data. The customer wanted to migrate their datasets to Snowflake for a consistent data warehouse, optimize resources, and carry out cost-efficient queries based on data size. They wanted to automate the entire process and visualize the data to analyze market trends, product search ratio, capture customer visits, page hits on sites, and more across regions.

Sigmoid Solution

Sigmoid designed automated data pipelines that ingested data to Snowflake from various external data sources through BigQuery, APIs, and spreadsheets. We preprocessed data to create a single dataset to be fetched into Snowflake. Technologies like Airflow were used for pipeline scheduling and automation to eliminate manual efforts. In addition, Sigmoid built a dashboard in DOMO to compute different metrics and generate reports for the regional heads, marketing teams, sales teams, and media planners to see the sales and digital marketing data.

Download the Complete
Case Study here

Business outcome

Sigmoid’s automated data pipelines enabled the customer to upload clean and relevant datasets in Snowflake without manual processing.

45% reduction in

time spent in creating reports

80% reduction in

time spent on analysis and optimization

Real-time

campaign reporting, optimization, and analysis

Relevant Blogs

Snowflake thumbnail

How to setup Snowflake backup confirmation and alert notifications

Why Is Data Engineering Critical To CPG Marketing Success thumbnail

Why Is Data Engineering Critical To CPG Marketing Success

building data pipelines for CPG

Build a Winning Data Pipeline Architecture on the Cloud for CPG