Review your sales compared to ad spend over time

Review your sales compared to ad spend over time

Hop Designer

Mayank Verma


Marketing, Revenue

This report provides a clear view of the amount spent on Ads across your Ad channels (Google, Facebook, and TikTok) compared to your sales (sales, orders, and sessions—based on Shopify attribution) on a daily basis. It also shows all metrics contained in the report for the same day in the previous year, allowing you to track and be aware of year-over-year changes in sales and marketing performance.


How to use this Hop.

Simply create an Airboxr account and connect your Shopify store to automatically run this export/analysis for your store. If you already have an account, click on the Add to my Collection button above.

  1. Real-time Strategy Adjustments: Monitor daily ad spend and sales data closely. By making swift adjustments to advertising strategies in response to daily fluctuations, businesses can capitalize on emerging opportunities and mitigate challenges promptly.

  2. Seasonal Campaign Optimization: Recognize seasonal sales patterns through historical data analysis. Optimize ad strategies based on these patterns, ensuring timely and relevant campaigns during peak seasons. Tailoring marketing efforts to specific seasons enhances overall revenue potential.

  3. Budget Allocation for High-Performing Days: Identify days with significant sales growth. Allocate increased ad budgets on these days to capitalize on heightened consumer demand. Strategic budget allocation on high-performing days maximizes revenue opportunities.

  4. Long-term Strategic Planning: Analyze performance trends over an extended period, considering multiple factors such as seasonality and market changes. Formulate comprehensive, data-driven marketing and sales strategies to ensure consistent growth and adaptability in the evolving market landscape.

In This Report


  • Daily Total Spend

  • Google Ads Spend

  • Facebook Ads Spend

  • TikTok Ads Spend

  • Sessions

  • Orders

  • Sales

Grouped By

  • Date

Try this report for your own store.

Connect your Shopify store and automate this report. You will never have to manually work with data again.