关于“使用 BigQuery ML 預測訪客購買行為”的评价

John M. · 评论over 1 year之前

GHI L. · 评论over 1 year之前

zhe w. · 评论over 1 year之前

Hanbyul C. · 评论over 1 year之前

Mateus F. · 评论over 1 year之前

潮 髙. · 评论over 1 year之前

Jamie L. · 评论over 1 year之前

Jose Andres E. · 评论over 1 year之前

Didier C. · 评论over 1 year之前

Very cool, never used BQ before and this is so cool

John M. · 评论over 1 year之前

Martha C. · 评论over 1 year之前

Ashenafi K. · 评论over 1 year之前

Egor I. · 评论over 1 year之前

Christian d. · 评论over 1 year之前

Becky P. · 评论over 1 year之前

Matias J. · 评论over 1 year之前

Leonardo F. · 评论over 1 year之前

Kauã B. · 评论over 1 year之前

Bhanuprakash Y. · 评论over 1 year之前

When I'm execute this query #standardSQL CREATE OR REPLACE MODEL `ecommerce.classification_model` OPTIONS ( model_type='logistic_reg', labels = ['will_buy_on_return_visit'] ) AS #standardSQL SELECT * EXCEPT(fullVisitorId) FROM # features (SELECT fullVisitorId, IFNULL(totals.bounces, 0) AS bounces, IFNULL(totals.timeOnSite, 0) AS time_on_site FROM `data-to-insights.ecommerce.web_analytics` WHERE totals.newVisits = 1 AND date BETWEEN '20160801' AND '20170430') # train on first 9 months JOIN (SELECT fullvisitorid, IF(COUNTIF(totals.transactions > 0 AND totals.newVisits IS NULL) > 0, 1, 0) AS will_buy_on_return_visit FROM `data-to-insights.ecommerce.web_analytics` GROUP BY fullvisitorid) USING (fullVisitorId) ; I've faced an error the database is not located at US. I don't know what I need to do.

VIJAY M. · 评论over 1 year之前

Bhanuprakash V. · 评论over 1 year之前

Amir G. · 评论over 1 year之前

Jeevan K. · 评论over 1 year之前

Colin M. · 评论over 1 year之前

Mijbel A. · 评论over 1 year之前