Shopify

See which products bring buyers back, and what your ad spend really returns.

Try Dot with Shopify

Dot copies your orders, customers and products, then answers in plain English with the SQL beside it.

Threadecommerce

Daniel Weber9:41 AM

@Dot Which first-order products lead to a second order within 90 days?

1 reply

DotAPP9:42 AM

4 steps · 20s · Access Online

Cold brew concentrate: 38% of its first buyers order again, twice the store average.

Source: Shopify.

Chart

Threadecommerce

Lisa Park9:41 AM

@Dot What was our blended ROAS last month, with Meta and Google Ads spend against Shopify revenue?

1 reply

DotAPP9:42 AM

5 steps · 34s · Access Online

3.1x, down from 3.6x in August as Meta spend rose.

Sources: Shopify, Meta Ads and Google Ads.

Here is the data.

September
Ad spend, Meta and Google$48K
Shopify revenue$149K
Blended ROAS3.1x

Threadecommerce

David Mensah9:41 AM

@Dot Which products had the highest refund rate this quarter?

1 reply

DotAPP9:42 AM

5 steps · 25s · Access Online

Linen shirt: 17% of its orders refunded, three times the store average.

Source: Shopify.

Here is the data.

ProductOrdersRefunded
Linen shirt84017%
Rain jacket61011%
Slim chinos1,1209%

Connect Shopify

  • Shop URL and app credentials
  • Read-only: nothing is written back
  • Synced every few hours (daily on Free)
  • No warehouse of your own needed

More in Commerce & billing

Connect your data.

Start for Free