首页 文章

在Google Data Studio中创建新的计算字段 - 广告系列类型

提问于
浏览 次
0

我尝试在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
google-adwords google-data-studio

1 回答

  • 0

    我不是正则表达式的主人，你没有描述你得到的错误，但我猜测错误可能是由方括号引起的？

    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
    回复于

相关问题