The Challenge
Crochetease struggled to accurately track marketing costs and sales performance at the product level. Their Meta Ads campaigns were set up with product names included in the campaign names, and revenue attribution was already in place using UTM parameters.
The problem? Despite this setup, they couldn’t clearly see how much they were spending on each product daily — nor calculate ROI per product. The lack of centralized, product-level reporting made it difficult to assess marketing efficiency and make data-driven budget decisions.
The Solution
We integrated their campaign data (from Meta) and sales data (from Shopify) into a centralized location — a data warehouse. There, we extracted product names from campaign names and applied matching logic to align them with Shopify product data.
With the matched data, we built a simple yet effective reporting system that allows them to track product and revenue performance by country.
Bonus: This entire process is fully automated and runs daily, keeping them consistently up to date on their performance.
Results
Product-Level ROI Visibility: Gained clear insight into daily spend, revenue, and ROI per product across campaigns.
Time Efficiency: Eliminated manual matching and spreadsheet work, saving several hours per week.
Smarter Budget Allocation: Enabled more accurate campaign optimization and budget decisions at the product level.
Geographic Insights: Dashboards revealed revenue and performance by country, helping guide localized marketing strategies.
Foundations for Scale: The centralized system now supports scalable reporting as their product catalog and ad spend grow.
Tech Stack
Data Integration: Airbyte
Data Warehouse: BigQuery
Dashboarding: Looker Studio
Communication: Slack
Implementation Time
The entire project was completed in 3 weeks, from initial assessment to full deployment.