How to Monitor Repeat Purchase Behavior Using Google Data Studio and BigQuery | by Noemi Ramiro | Towards Data Science

PHOTO EMBED

Mon Aug 30 2021 22:01:09 GMT+0000 (Coordinated Universal Time)

Saved by @admariner

SELECT *,
CASE WHEN customer_seq > 1 THEN 'Repeat Customer'
ELSE 'New Customer'
END AS RepeatPurchase
FROM (
    SELECT  *,
    RANK() OVER (PARTITION BY CustomerID ORDER BY date) AS customer_seq
    FROM online_retail
)
content_copyCOPY

https://towardsdatascience.com/how-to-monitor-repeat-purchase-behavior-using-google-data-studio-and-bigquery-c2b5adbe8ebb