Tableau 中的广告系列分析 [英] Campaign analysis in Tableau

问题描述

我正在进行活动分析，活动的目标是将潜在客户转化为客户.我想看看有多少潜在客户在转化为客户之前会以百分比的形式暴露于多少营销活动.

I am doing campaign analysis and the objective of campaigns is to convert lead into customer. I want to see how many leads are exposed to how many campaigns in terms of percentages before they convert to customer.

以下是有四个唯一线索的示例数据.abc 看过三个活动，efg 看过两个活动，依此类推

Below is the sample data where there are four unique lead. abc has seen three campaigns, efg has seen two campaigns and so on and so forth

我想在饼图中显示可能类似于下面表格中的内容，其中 4 个潜在客户中的 2 个潜在客户各看过 1 个广告系列，因此 50%，1 个潜在客户看过 2 个广告系列，因此 25% 和 1 个潜在客户看过 3 个广告系列，所以另外 25%

I want to show in pie chart may be something like below in tableau where out of 4 leads 2 leads has seen 1 campaign each so 50%, 1 lead has seen 2 campaigns so 25% and 1 lead has seen 3 campaign so another 25%

推荐答案

首先，您必须找到每个 Lead 已公开的广告系列数量，计算广告系列:

First of all you have to find how many campaigns have been exposed for each Lead, Count Campaign:

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

由于您想使用此值细分饼图，因此需要将此计算字段转换为维度.

Since you want to breakdown your pie with this value, you need to convert this calculated field into a dimension.

为了计算您要查找的百分比，您只需要一个额外的步骤；指标:

In order to calculate the % you're looking for, you need just an additional step; Metric:

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

这样做，您会将每个值与潜在客户 (4) 的总不同值进行比较

Doing so you're going to compare each value to the total distinct value of your Lead (4)

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