Analytics Custom Building: eCom Sales by day of week

josephmckeownjosephmckeown Moderator, Lightspeed Staff Posts: 68 moderator
edited November 2019 in Reporting & Analytics

This report is one in a series of five discussing ways to measure performance of your eCom shop. To see other ideas, check out 5 Lightspeed Analytics eCom Reports for Optimizing Online Sales

How does your eCom store's daily performance compare to your brick and mortar store? We could find this out using Analytics to see what both platforms' performance looks like day by day.

To begin, launch the Recent Sales report, which will show you daily totals for this week. Instead of leaving the totals for just this week though, let's open the filters to go back over the past 3 months...

image.png

Let's remove the Dimension of Sale Date...

image.png


...and add the Dimension of Sale Day of Week

image.png


And let's also pivot on the Sale Dimension of "Is Ecom (Yes/No)"

image.png

Then let's run the report!

image.png


So our table looks like

image.png

and when we visualize the data, we can also see what this looks like

image.png


Next Report: eCom Sales by Zip Code

Go back to Blog post: 5 Lightspeed Analytics eCom Reports for Optimizing Online Sales

Analytics Calculations Home

Post edited by josephmckeown on
Joseph McKeown
Lightspeed Analytics and reporting consultant
Lightspeed HQ
Tags:
· Share on Google+
Sign In or Register to comment.