Order count / New VS Returned users

[Mahmood1]

Hello!

I have been trying to achieve a query / formula where I can get the order count & new vs returning users.

I am connecting looker studio to big query and I rely on the below fields for my analysis:

• Order_id
• customer_id
• created_at (as order date & time)
• brand_name

I wanted to achieve the below:

• Count of first time buyers for a selected brand in a specific period of time
• Count of 2nd time buyers for a selected brand in a specific period of time
• Count of 3+ time buyers for a selected brand in a specific period of time
• Count of first time buyers based on the overall data
• Count of 2nd time buyers based on the overall data
• Count of 3+ time buyers based on the overall data

Thanks in advance.

[sam8]

I don't think you'll be able to compute 1st-2nd-3rd+ buyers in Looker Studio. If you can, I'd recommend computing that in BigQuery first and then sending it downstream to Looker Studio.