Create a report like Tracking indicators (deliveryFeedback) but using as dimensions custom recipient fields | Community
Skip to main content
salvdangelo
salvdangelo
Level 5
September 20, 2017
Solved

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

  • September 20, 2017
  • 3 replies
  • 1757 views

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 Raghav​Amit_Kumar​

Jean-Serge Biron​

Adhiyan​

Adobe Campaign​

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by Amit_Kumar

    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

    3 replies

    Amit_Kumar
    Amit_Kumar
    Level 10
    September 20, 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

    salvdangelo
    salvdangeloAuthor
    Level 5
    September 20, 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

      Amit_Kumar
      Amit_KumarAccepted solution
      Level 10
      September 22, 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

        Terms & ConditionsAccessibility statement

        Loading footer...