google-ads-api - 在 Google 数据洞察中创建新的计算字段 - 广告系列类型
问题描述
我试图在 Google Data Studio 中创建计算字段。我想详细了解我的广告系列类型。默认为“仅显示”、“仅搜索”或“购物”。我有兴趣添加其他选项,例如:基于函数 REGEXP_MATCH 和我的广告系列名称的 GMAIL 或 Youtube。这是代码,这是我写的代码:
CASE
WHEN Campaign type IN ("Display Only") AND NOT REGEXP_MATCH(Campaign, "(?i).*[REM].*") THEN "Display"
WHEN Campaign type IN ("Display Only") AND REGEXP_MATCH(Campaign, "(?i).*[REM].*") THEN "Display - remarketing"
WHEN Campaign type IN ("Search Only") AND NOT REGEXP_MATCH(Campaign, "(?i).*[GSN].*") THEN "Search"
WHEN Campaign type IN ("Search Only") AND REGEXP_MATCH(Campaign, "(?i).*[GSN].*") THEN "Search"
WHEN Campaign type IN ("Shopping") THEN "Reklama produktowa"
WHEN Campaign type IN ("Display Only") AND REGEXP_MATCH(Campaign, "(?i).*[YT].*") THEN "Display - Youtube"
WHEN Campaign type IN ("Display Only") AND REGEXP_MATCH(Campaign, "(?i).*[GMAIL].*") THEN "Display - Gmail"
END
解决方案
我不是正则表达式大师,你没有描述你得到的错误,但我猜错误可能是由方括号引起的?
CASE
WHEN Campaign type IN ("Display Only") AND NOT REGEXP_MATCH(Campaign, "(?i).*REM.*") THEN "Display"
WHEN Campaign type IN ("Display Only") AND REGEXP_MATCH(Campaign, "(?i).*REM.*") THEN "Display - remarketing"
WHEN Campaign type IN ("Search Only") AND NOT REGEXP_MATCH(Campaign, "(?i).*GSN.*") THEN "Search"
WHEN Campaign type IN ("Search Only") AND REGEXP_MATCH(Campaign, "(?i).*GSN.*") THEN "Search"
WHEN Campaign type IN ("Shopping") THEN "Reklama produktowa"
WHEN Campaign type IN ("Display Only") AND REGEXP_MATCH(Campaign, "(?i).*YT.*") THEN "Display - Youtube"
WHEN Campaign type IN ("Display Only") AND REGEXP_MATCH(Campaign, "(?i).*GMAIL.*") THEN "Display - Gmail"
END
推荐阅读
- python - 尝试 Python 时的 Crontab 头痛
- arrays - map() 没有渲染 html 元素
- javascript - 当我有许多相同的 php 文件时更改 php 中的 html 代码
- servicestack - ServiceStack OrmLite SQL 错误?
- delphi - 更新半透明图片时程序如何停止闪烁?
- c++ - 为什么 std::execution::par 不使用 std::views::iota 迭代器启动线程
- matlab - 如何在实时信号的 FIR 带通滤波器中获得瞬态响应?
- google-cloud-platform - 如何阻止谷歌云虚拟机的存储类 pd-extreme?
- r - 绘制微积分函数
- python - 如何显着提高嵌套循环的速度?