Summer Splash
Case Study
About
This project delivers an automated data ingestion solution for Urban Apparel’s “Summer Splash 2025” digital marketing campaign using Microsoft Fabric. The solution replaces a manual, error-prone CSV download process with a fully scheduled, reliable pipeline that loads daily campaign performance data into a Fabric Lakehouse. The outcome enables the marketing analytics team to access fresh, trustworthy data every morning, accelerating insight generation and decision-making
Challenge
Marketing performance data for the Summer Splash 2025 campaign was delivered through a manual daily CSV download process. This approach was time-consuming and error-prone, relied heavily on human availability, and introduced delays in accessing campaign metrics. As a result, timely visibility into performance was limited, directly impacting the ability to make informed and responsive business decisions.
Objective
Eliminate manual intervention
Automate daily ingestion of campaign data
Ensure reliable, on-time data availability in Microsoft Fabric Lakehouse
Solution
The solution implements a fully automated data ingestion pipeline using Microsoft Fabric to reliably load daily campaign performance data for Urban Apparel’s Summer Splash 2025 campaign.
A Fabric Data Pipeline orchestrates the end-to-end ingestion process, using a Copy Data activity to read the daily CSV file and load it directly into a Fabric Lakehouse table. The pipeline is configured with a scheduled trigger, ensuring the ingestion runs automatically every morning without any manual intervention.
Pipeline execution is continuously monitored through run history and execution status, providing operational visibility and confidence in daily data availability. Multiple successful runs confirm the stability and reliability of the ingestion process, demonstrating that the solution is production-ready and resilient to day-to-day operations.
Once ingested, the data is immediately available in the Lakehouse with schema consistency preserved, enabling the marketing analytics team to access fresh, trustworthy campaign metrics for timely analysis and decision-making.
Business impact
100% Automation – Eliminated manual CSV downloads
Faster Insights – Analysts receive data every morning without delay
Reduced Risk – Removed human error from data ingestion
Foundation for Analytics – Lakehouse now serves as a trusted source for downstream reporting and dashboards
Automated Pipeline
This pipeline automates the daily ingestion of Summer Splash campaign performance data into a Microsoft Fabric Lakehouse, eliminating manual CSV downloads and reducing the risk of data delays and human error. The solution ensures marketing data is consistently available each morning for timely analysis and reporting. A scheduled trigger enforces reliable execution, providing a production-ready foundation for downstream analytics and dashboards.
Scheduled Trigger
A scheduled trigger is configured to run the pipeline automatically at 10:00 AM every morning, aligning with the marketing team’s daily reporting cycle. This ensures the latest campaign performance data is ingested before business users begin analysis, eliminating dependency on manual execution and guaranteeing consistent, on-time data availability for downstream reporting and dashboards.The repeated successful runs confirm that the scheduled trigger is correctly configured and consistently executing the pipeline without manual intervention
