These SQL are based on available ecommerce dataset that has millions of Google Analytics records for the Google Merchandise Store loaded into BigQuery.
- Out of the total visitors who visited our website, what % made a purchase?
- What are the top 5 selling products?
- How many visitors bought on subsequent visits to our website?
- What are the risks of only using the above two fields?
- Creating a classification model
- Evaluating the classification model performance
- Improve performance
- Predict which new visitors will come back and purchase