回答編集履歴
2
補足
answer
CHANGED
|
@@ -2,4 +2,7 @@
|
|
|
2
2
|
```SQL
|
|
3
3
|
select
|
|
4
4
|
split(split(url, '&')[OFFSET(1)], '=')[OFFSET(1)] as utm_source
|
|
5
|
+
,split(split(url, '&')[OFFSET(2)], '=')[OFFSET(1)] as utm_medium
|
|
6
|
+
,split(split(url, '&')[OFFSET(3)], '=')[OFFSET(1)] as utm_campaign
|
|
7
|
+
from テーブル
|
|
5
8
|
```
|
1
修正
answer
CHANGED
|
@@ -1,5 +1,5 @@
|
|
|
1
1
|
[split](https://cloud.google.com/bigquery/query-reference?hl=ja#split)を使用して分割して取り出すというのもありかな。
|
|
2
2
|
```SQL
|
|
3
3
|
select
|
|
4
|
-
split(split(url, '&')[OFFSET(
|
|
4
|
+
split(split(url, '&')[OFFSET(1)], '=')[OFFSET(1)] as utm_source
|
|
5
5
|
```
|