ML Study Jam —Classification model in BQML

Predict Visitor Purchases with a Classification Model in BQML

Prerequisite

Dataset — Google Analytics logs

Explore ecommerce data

Image for post
Image for post
Image for post
Image for post
Image for post
Image for post
Image for post
Image for post
Image for post
Image for post
Image for post
Image for post
Image for post
Image for post
Pictures from https://nest.com/
Image for post
Image for post

Select features and create your training dataset

Image for post
Image for post
Image for post
Image for post
Image for post
Image for post
Query by using SQL syntax
Image for post
Image for post

Select a BQML model type and specify options

Image for post
Image for post
Three BQML model types
Image for post
Image for post
Use logistic_reg as BQML model type to train the model. Notice we only train 9 months here because we need the last 3 months for evaluating prediction accuracy
Image for post
Image for post
The final model — Picture from ML Study Jam

Evaluate classification model performance

Image for post
Image for post
Image for post
Image for post
Image for post
Image for post

Improve model performance with Feature Engineering

Image for post
Image for post
Image for post
Image for post
Image for post
Image for post
Image for post
Image for post
Image for post
Image for post
Image for post
Image for post
Image for post
Image for post
better quality of the model

Predict which new visitors will come back and purchase

Image for post
Image for post
Image for post
Image for post

Results

Additional information

References

Final

An Android/Flutter engineer at Line Corporation.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store