Shopify

Beta

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

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

Threadecommerce

Lisa Park9:41 AM

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

1 reply

Dot9:42 AM

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

Source: Shopify.

Threadecommerce

David Mensah9:41 AM

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

1 reply

Dot9:42 AM

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

Sarah Chen9:41 AM

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

1 reply

Dot9:42 AM

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%

More in Commerce & billing

Connect your data.

Start for Free