Review Shopify sales and ad spend across channels by year

Review Shopify sales and ad spend across channels by year

Hop Designer

Mayank Verma


Revenue, Marketing

This report provides key revenue metrics and marketing spend for a specific time period and its counterpart from the previous year. If you run this report for the last 30 days, you will obtain the key revenue metrics and marketing spend for the last 30 days, as well as the equivalent 30-day period from the previous year. Your marketing spend data is gotten from your social ad channels that are connected ie Facebook, Google, and TikTok.

This report is useful for comparing monthly and quarterly performance year on year. It is important to customize the time period to maximize the usefulness of this report.


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. Performance Trend Analysis: By comparing key revenue metrics such as total sales, orders, products sold, and new customers, users can observe performance trends over a specified time period. Analyzing year-on-year variations provides insights into whether the business is experiencing growth, stabilization, or contraction. The reporting timeframe can be tailored based on their business cycles, marketing campaign durations, or seasonal variations.

  2. Marketing Effectiveness Evaluation: The report analyzes social Ad spend to evaluate advertising channel effectiveness by comparing it with key revenue metrics. It can also provide insights into Customer Acquisition Costs by users comparing social ad spend with the number of new customers. Identifying the most impactful advertising platforms for sales and customer acquisition helps optimize the allocation of the advertising budget.

In This Report


  • Total Sales

  • Orders

  • Average Order Value (AOV)

  • Product Sold

  • New Customers

  • Facebook Ads Spend

  • Google Ads Spend

  • TikTok Ads Spend

Grouped By

  • Current Year Time Period

  • Previous Year Time Period

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.