Track daily Shopify sales against traffic from GA4

Track daily Shopify sales against traffic from GA4

Hop Designer

Mayank Verma



This is a daily report of your store’s performance in terms of sales, traffic, Ad spend, and customer retention. This report enables tracking of your daily sales, orders, sessions, total spend, returning customers, and total customers.

It is important to note Total Spend is the sum of your daily ad spend across your ad channels and traffic data (sessions) is gotten from Google Analytics 4. You can also filter this report by sales and traffic data to identify dates that store activity was high or low.


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. Sales Analysis and Revenue Optimization: E-commerce businesses can analyze daily sales, orders, and returning customers to quickly identify trends, understand customer behavior, and evaluate promotional impact.

  2. Traffic Analysis: With the provided data on daily sessions on your store, you can calculate your session-to-customer conversion rate. To go a step further, you can combine this report with our Traffic Over Time Hop to better understand conversion/drop-off rates at different stages of your customer order journey.

  3. Ad Spend Evaluation and ROI Assessment: The report includes the total daily ad spend across your social advertising channels allowing you to evaluate the effectiveness of your advertising campaigns by correlating ad spend data with sales and traffic metrics. You can also take a closer look at your daily ad channel performance with the DTC Marketing KPIs over Time Hop.

  4. Customer Retention Strategies: Monitoring the number of returning customers on a daily basis provides valuable insights into customer loyalty and retention. To analyze the daily sales generated by returning customers, use the Returning Customer Sale Hop.

In This Report


  • Total Sales

  • Orders

  • Sessions

  • Total Spend

  • Returning Customers

  • Total Customers

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.