Shopify Analytics for the Last 30 Days in a Spreadsheet App
Sales data, such as revenue, quantity sold, refunds, and discounts, are key metrics for every online store, and tracking them ensures staying up-to-date with the store’s performance. Below, we will show you how you can have all this data in real-time in an online spreadsheet app, which gets updates from Shopify automatically.
Net sales / Gross sales dynamically for the last 30 days
Here is how you can pull Net sales / Gross sales data in a spreadsheet:
- After installing the Mixtable Analytics app, click the Create a Workbook button.
- In the Blank workbook, click the (+) button at the bottom of the spreadsheet.
- Choose Shopify data worksheet > Products (with variants).
- In the new worksheet, choose an empty column and click the Link button from the column's header.
- Select Analytics > Net sales / Gross sales
- From the Select the time period for which to calculate the metric, choose Dynamic Date Range > Last 30 Days.
Once you set up this column, it will be automatically updated with every new sale generated in your Shopify store—you won't need to run reports each time you want to see the latest data.
Net / Gross quantity sold dynamically for the last 30 days
Here is how you can pull Net / Gross quantity sold data in a spreadsheet:
- After installing the Mixtable Analytics app, click the Create a Workbook button.
- In the Blank workbook, click the (+) button at the bottom of the spreadsheet.
- Choose Shopify data worksheet > Products (with variants).
- In the new worksheet, choose an empty column and click the Link button from the column's header.
- Select Analytics > Net / Gross quantity sold
- From the Select the time period for which to calculate the metric, choose Dynamic Date Range > Last 30 Days.
Once you set up this column, it will be automatically updated with every new sale generated in your Shopify store—you won't need to run reports each time you want to see the latest data.
Order count analytics dynamically for the last 30 days
Here is how you can pull Order count analytics data in a spreadsheet:
- After installing the Mixtable Analytics app, click the Create a Workbook button.
- In the Blank workbook, click the (+) button at the bottom of the spreadsheet.
- Choose Shopify data worksheet > Products (with variants).
- In the new worksheet, choose an empty column and click the Link button from the column's header.
- Select Analytics > Order count analytics
- From the Select the time period for which to calculate the metric, choose Dynamic Date Range > Last 30 Days.
Once you set up this column, it will be automatically updated with every new sale generated in your Shopify store—you won't need to run reports each time you want to see the latest data.
Refunds analytics dynamically for the last 30 days
Here is how you can pull Refunds analytics data in a spreadsheet:
- After installing the Mixtable Analytics app, click the Create a Workbook button.
- In the Blank workbook, click the (+) button at the bottom of the spreadsheet.
- Choose Shopify data worksheet > Products (with variants).
- In the new worksheet, choose an empty column and click the Link button from the column's header.
- Select Analytics > Refunds analytics
- From the Select the time period for which to calculate the metric, choose Dynamic Date Range > Last 30 Days.
Once you set up this column, it will be automatically updated with every new sale generated in your Shopify store—you won't need to run reports each time you want to see the latest data.
Discounts analytics dynamically for the last 30 days
Here is how you can pull Discounts analytics data in a spreadsheet:
- After installing the Mixtable Analytics app, click the Create a Workbook button.
- In the Blank workbook, click the (+) button at the bottom of the spreadsheet.
- Choose Shopify data worksheet > Products (with variants).
- In the new worksheet, choose an empty column and click the Link button from the column's header.
- Select Analytics > Discounts analytics
- From the Select the time period for which to calculate the metric, choose Dynamic Date Range > Last 30 Days.
Once you set up this column, it will be automatically updated with every new sale generated in your Shopify store—you won't need to run reports each time you want to see the latest data.
You are ready!
Well done! Now that you have analytics data in an online spreadsheet, you can use any Excel function to analyze the data, such as:
Find out more about the Mixtable suite of products here.
