# Shopify Sales by Time of Day

**URL:** https://community.parabola.io/t/shopify-sales-by-time-of-day/2264
**Category:** Ask a question
**Tags:** Building-Flows
**Created:** [February 9, 2022, 1:35am UTC](https://community.parabola.io/t/shopify-sales-by-time-of-day/2264 "2022-02-09T01:35:53Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![Roger](https://avatars.discourse-cdn.com/v4/letter/r/c0e974/32.png) [@Roger](https://community.parabola.io/u/Roger)
#### Post date: [February 9, 2022, 1:35am UTC](https://community.parabola.io/t/shopify-sales-by-time-of-day/2264/1 "2022-02-09T01:35:53Z")

</div>

Hi Parabola community!

Has anyone tackled this question with Parabola yet?

**Anyone Know A Tool/App To Calculate Best Hour And Day Of Week For Sales For A Shopify Store?**

> **[Anyone know a tool/app to calculate best hour and day of week for sales for a...](https://community.shopify.com/c/shopify-discussions/anyone-know-a-tool-app-to-calculate-best-hour-and-day-of-week/td-p/1156479)**
>
> Hi all, Does anyone know of a good tool that can easily tell us at any given point which day of the week, and which hour (or best performing hours on each day), our store converts the most sales? I looked around at a lot of the analytics apps but...

So far my attempt pulls order date/time data and sends it to a Google Sheet. I’m now using the Google Sheet to try and figure out most popular time of day for sales, as well which day of the week is most popular. But, I’m a novice at Google sheets so it’s taking me more effort to find these answers within Google Sheets.

Perhaps the Parabola team has a recipe up its sleeve to help easily determine popular time of day and day of week for Shopify sales, all within Parabola (without having to rely on Google Sheets to finish the task).

---

<div class="post-metadata">

### Author: ![Ayana\_Usui](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/ayana_usui/32/1985_2.png) [@Ayana\_Usui](https://community.parabola.io/u/Ayana_Usui)
#### Post date: [February 9, 2022, 7:03pm UTC](https://community.parabola.io/t/shopify-sales-by-time-of-day/2264/2 "2022-02-09T19:03:58Z")

</div>

Hi Roger! Definitely a good use-case for Parabola. I’ve modified our Shopify orders summary recipe a bit to get our data set-  
 ![image](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/e/ee069cba0b96c645a531eae034e375eada612044.png)

The flow is can be adjusted to pull by day, hour, or day and hour by updating the [Format Date](https://parabola.io/transform/format-dates) step to the following:  
By Day of Week: dddd  
By Hour: HH  
By Day of Week and Hour: dddd HH

Heres a snippet of the card I’ve created: parabola:cb:b6fef302-d519-4947-8aed-c2cf5afec731

Let me know if you have any questions! Happy building

---

<div class="post-metadata">

### Author: ![Roger](https://avatars.discourse-cdn.com/v4/letter/r/c0e974/32.png) [@Roger](https://community.parabola.io/u/Roger)
#### Post date: [February 23, 2022, 4:06am UTC](https://community.parabola.io/t/shopify-sales-by-time-of-day/2264/3 "2022-02-23T04:06:02Z")

</div>

> [@Ayana\_Usui](#):
>
> parabola:cb:b6fef302-d519-4947-8aed-c2cf5afec731

Thanks Ayana! I’ll give it a try~
