Sign-in rates can be measured before & after Status by querying Customers in Shopify.

Query Customers in Shopify to measure sign-in rates

Update number of orders to see sign-in rate by purchase frequency

Querying for sign-in rate BEFORE Status:

1. How many first-time customers placed an order in the last 90 days?

   last_order_date >= -90d and number_of_orders = 1 e.g. 10,000

2. Of those first-time customers, how many created an account:

   last_order_date >= -90d and number_of_orders = 1 and customer_account_status = 'ENABLED' e.g. 1,000

3. First-time customer sign-in rate = 10%

Querying for sign-in rate AFTER Status:

1. How many first-time customers placed an order in the last 7 days?

   last_order_date >= -7d and number_of_orders = 1 e.g. 1,000

2. Of those first-time customers, how many created an account:

   last_order_date >= -7d and number_of_orders = 1 and tagged_with = #statuscustomer e.g. 300

3. First-time customer sign-in rate = 30%

A note on sign-in rates before Status

To calculate sign-in rate before Status, we query first-time customers with “account enabled” in a time period.

Pulling this data before launching Status is key, because Shopify does not track when an account was created — meaning if you query for “account enabled” after launching Status, you will see a combination of accounts created before Status and accounts created after Status.

• Customers who placed another order are no longer included in your “before” search.