Create a report like Tracking indicators (deliveryFeedback) but using as dimensions custom recipient fields

Avatar

Avatar

salvdangelo

Avatar

salvdangelo

salvdangelo

20-09-2017

Hi,

I'd like to create a DELIVERY report that is similiar to this one:
Tracking Indicators (deliveryFeedback)

except that I have to use custom fields (as dimensions) that belongs to:
- Recipient (such as language, country...)

- Tables linked to recipient

Example for language:

Metrics

Sent

Received

% Received

Open (unique)

% Open (unique)

Click (Unique)

% Click (Unique)

Segments

Italian

1000

950

95,00%

500

52,63%

400

80,00%

English

500

465

93,00%

430

92,47%

200

46,51%

French

100

95

95,00%

40

42,11%

30

75,00%

I may duplicate Delivery and tracking statistics CUBE and edit with my dimensions, but I cannot reach Recipient from nms:deliveryLogStats default scheme.

What am I supposed to do next?

Vipul RaghavAmit_Kumar

Jean-Serge Biron

Adhiyan

Adobe Campaign

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

Amit_Kumar

MVP

Avatar

Amit_Kumar

MVP

Amit_Kumar
MVP

21-09-2017

Hi, Salvatore,

Workflow Names: Refresh for deliverability, Tracking

I have explained the tracking process in my blog; Link for Detailed Tracking Logs functioning Process is Web Tracking and the Quest for better Leads - Marketing Cloud Blog.

You can't use nms:trackingLogRcp directly in the current cube, you have to create a new as a dimension is different.

Regards,

Amit

Answers (2)

Answers (2)

Avatar

Avatar

salvdangelo

Avatar

salvdangelo

salvdangelo

20-09-2017

Hi Amit,

Can you tell me where may I find at least one of these technical workflows that populates the pre-existent indicators in nms:deliveryLogStats you were talking about ?


EDIT: Trying using nms:trackingLogRcp in a custom cube (a sort of duplicate of the original one) I can reach required fields and select them as dimension but when I apply the report above with this cube it returns a generic error.

Salvatore

Avatar

Avatar

Amit_Kumar

MVP

Avatar

Amit_Kumar

MVP

Amit_Kumar
MVP

20-09-2017

Hi,

Tracking Indicators (deliveryFeedback) is system schema, and its values are populated by technical workflows.

You have two options now:

1. Extend the schema and add a link/attributes as per your requirements and fill that using a workflow.

2. Use nms:trackingLogRcp instead of nms:deliveryLogStats and this should solve your problem.

Regards,

Amit