Slide 26
Slide 26 text
イメージ
26
CREATE OR REPLACE FUNCTION
`your-project.your_dataset.label_roas`
(roas_time
s_param FLOAT64, roas FLOAT64) RETURNS STRING
LANGUAGE js AS R"""
if (roas < roas_times_param
) {
return `ROAS < ${Math.round(
roas_times_param *
100)}%`;
} else if (roas >= roas_times_param
) {
return `ROAS ≧ ${Math.round(
roas_times_param *
100)}%`;
} else {
return '不明';
}
""";
ルーティーンのクエリ
BigQuery
カスタムクエリ
パラメータ閾値更新
SELECT
campaign_id,
campaign_name,
ad_group_id,
ad_group_name,
impressions,
clicks,
cost,
revenue,
revenue / NULLIF(cost, 0) AS roas,
`your-project.your_dataset.label_roas`(
@roas_
times_param, revenue / NULLIF(cost, 0)) AS
roas_label
FROM
your_dataset.your_table
ORDER BY
roas DESC