Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

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

Avatar

Avatar
Validate 25
Level 4
salvdangelo
Level 4

Likes

45 likes

Total Posts

130 posts

Correct Reply

4 solutions
Top badges earned
Validate 25
Validate 10
Validate 1
Boost 5
Boost 3
View profile

Avatar
Validate 25
Level 4
salvdangelo
Level 4

Likes

45 likes

Total Posts

130 posts

Correct Reply

4 solutions
Top badges earned
Validate 25
Validate 10
Validate 1
Boost 5
Boost 3
View profile
salvdangelo
Level 4

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
Springboard
MVP
Amit_Kumar
MVP

Likes

329 likes

Total Posts

649 posts

Correct Reply

231 solutions
Top badges earned
Springboard
Ignite 5
Ignite 3
Ignite 1
Validate 10
View profile

Avatar
Springboard
MVP
Amit_Kumar
MVP

Likes

329 likes

Total Posts

649 posts

Correct Reply

231 solutions
Top badges earned
Springboard
Ignite 5
Ignite 3
Ignite 1
Validate 10
View profile
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
Validate 25
Level 4
salvdangelo
Level 4

Likes

45 likes

Total Posts

130 posts

Correct Reply

4 solutions
Top badges earned
Validate 25
Validate 10
Validate 1
Boost 5
Boost 3
View profile

Avatar
Validate 25
Level 4
salvdangelo
Level 4

Likes

45 likes

Total Posts

130 posts

Correct Reply

4 solutions
Top badges earned
Validate 25
Validate 10
Validate 1
Boost 5
Boost 3
View profile
salvdangelo
Level 4

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
Springboard
MVP
Amit_Kumar
MVP

Likes

329 likes

Total Posts

649 posts

Correct Reply

231 solutions
Top badges earned
Springboard
Ignite 5
Ignite 3
Ignite 1
Validate 10
View profile

Avatar
Springboard
MVP
Amit_Kumar
MVP

Likes

329 likes

Total Posts

649 posts

Correct Reply

231 solutions
Top badges earned
Springboard
Ignite 5
Ignite 3
Ignite 1
Validate 10
View profile
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