| Title: | BigQuery SQL samples | |
|---|---|---|
| Owner: | Sylvain Paillard | |
| Creator: | Sylvain Paillard | May 14, 2020 |
| Last Changed by: | Sylvain Paillard | Aug 24, 2022 |
| Tiny Link: (useful for email) | https://boxalino.atlassian.net/wiki/x/AQB-AQ | |
| Export As: | Word · PDF | |
Hierarchy
Children (11)
How to retrieve the list of product properties and values
How often are accessories bought together with their parent product
How to retrieve the sessions and their duration of customers with only one lifetime purchase
How to retrieve the sessions and their duration of the first purchase done by customers
How to retrieve the first, second and third order dates of a customer
How to retrieve the first session after a purchase
How to retrieve the exit page of a session
Retrieve the product list price, discounted price, and margin at the time of an order
Identify the distribution of sales per product according to their discount levels
Orders & revenue per customer account for 2 different years
How to retrieve the list of product properties and values
How often are accessories bought together with their parent product
How to retrieve the sessions and their duration of customers with only one lifetime purchase
How to retrieve the sessions and their duration of the first purchase done by customers
How to retrieve the first, second and third order dates of a customer
How to retrieve the first session after a purchase
How to retrieve the exit page of a session
Retrieve the product list price, discounted price, and margin at the time of an order
Identify the distribution of sales per product according to their discount levels
Orders & revenue per customer account for 2 different years
Labels
There are no labels assigned to this page.