Tableau 中的广告系列效果

问题描述

我正在 Tableau 中进行营销活动分析，我想在转化为客户之前按月和区域在饼图中查看已经看过 1 个营销活动的潜在客户百分比、已经看过两个营销活动的潜在顾客百分比等等.

例如，在下面的示例数据集中，2 月份有 5 个潜在客户，其中只有潜在客户 id abc 看到了两个活动，其余 4 个看到了一个活动.因此视图将是饼图，其中 20%(5 分之 1)的潜在客户已经看过两个活动，其余 80% 的人已经看过 1 个活动.如果选择了三月，则饼图将是 100% 一个广告系列，因为只有 1 个潜在客户.

如果选择了区域过滤器美国，那么 2 月份将有三个唯一的潜在客户(abc、efg、klm)，并且视图将是饼图，其中 33% 的潜在客户已经看过两个广告系列，其余的两个广告系列，即 77% 已经看过 1 个广告系列.

我从这里的链接中得到了想法，但在添加月份和区域过滤器时无法做到.

解决方案

只需添加两个计算字段都是LOD，如下详述-

每个潜在客户的广告活动 as

{ FIXED [Lead id] : COUNT([Campaign])}

'Measure_val` as

COUNTD([Lead id])/ATTR({ FIXED : COUNTD([Lead id])})

将Measure_val 格式化为数字格式的百分比.

添加要查看的过滤器，通过右键单击将两个过滤器添加到 CONTEXT(注意:为了在 LOD 计算之前计算过滤器.普通过滤器计算 LOD 字段之后的视图计算).检查过滤器是否已变灰.

通过右键单击将Campaign per Lead 转换为维度.

将 Measure_val 添加到尺寸、角度和文本(对于标签可选)和 Campaign per Lead 添加到颜色和文本(再次可选)，你就完成了.

请告诉它是否有效.

I am doing campaign analysis in Tableau where I want to see the percentage of leads that has seen 1 campaign,percentage of leads that has seen two campaign and so on in pie chart filter by month and region before they convert to customer.

For e.g in below sample data set there are 5 leads in February of which only lead id abc has seen two campaigns and rest four has seen one campaigns. So the view will be pie chart where 20%(1 out of 5) of lead has seen two campaigns and rest 80% has seen 1 campaigns. If March is selected then pie chart will be 100% one campaign as there is only 1 lead.

If in region filter US is selected then there are three unique leads(abc,efg,klm) in february and view will be pie chart with 33% lead has seen two campaigns and rest two i.e 77% has seen 1 campaign.

I got idea from the link here but not able to do it when month and region filter is added.Campaign analysis in Tableau

解决方案

Just add two calculated fields both LOD, as detailed below-

Campaigns per Lead as

{ FIXED [Lead id] : COUNT([Campaign])}

'Measure_val` as

COUNTD([Lead id]) / ATTR({ FIXED : COUNTD([Lead id])})

Format Measure_val as per cent in number format.

Add your filters to view, add both filters to CONTEXT by right clicking them (Note: In order to have filters calculated before LOD calculation. Normal filter calculates the view after LOD fields are calculated). Check whether filters have been greyed out.

Convert Campaign per Lead to dimension by right clicking it.

Add Measure_val to size, angle and text(for label-optional) and Campaign per Lead to color and text(optional again) and you're done.

Do tell if it worked.

这篇关于Tableau 中的广告系列效果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！