This is what needs to be done:
Go to Shopify Admin → Analytics → Reports.
Search for the “Sales by customer name” report and click on it.
Click on the Query field to open it.
Replace the existing query content with the text below.
- FROM sales SHOW order_utm_source, orders, total_sales, gross_sales, net_sales
GROUP BY order_utm_source WITH CURRENCY 'USD', TOTALS
SINCE startOfDay(-7d) UNTIL today
ORDER BY total_sales DESC
LIMIT 1000
VISUALIZE total_sales TYPE horizontal_bar Once you’ve made the change, click the Run ▶ button (see below).
You’ll see the updated report.
In the top bar, click Save as to give your report a new name.
Once saved, it will appear in your list of reports.
0 Comments