Skip to main content
telmof93992697
Level 1
Jul 1, 2019 10:36 PM UTC
Solved

Basic Report

I'm looking to create a daily report with a overview of email delivery metrics (i.e sents, opens, clicks). Is there an option to create an automation to export this data?

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    badr_eddineAccepted solution
    Level 3
    Jul 2, 2019 9:54 AM UTC

    Hi,

    Like Kapil said, there is a schema inside Delivery with the name Indicators(Indicators).

    To achieve your Daily Export Workflow you will need 3 things,

    • Scheduler : Where you will configurate the daily execution
    • Query :

          - your targeting dimension needs to be "Deliveries",

          - after, add a condition to get the deliveries of the same day, there is a schema under Deliveries called Scheduling, try to find the field ContactDate (scheduling/@contactDate),set the operator to After and value to GetDate() (getdate take the current date starting from midnight)

    • Export : Here where you will use the Indicators Schema, select all the fields that you will like to get in your daily export.

    Thanks,

    Badr.

    View in thread

    2 replies

    kapilKochar
    kapilKochar
    Level 6
    Jul 2, 2019 2:50 AM UTC

    Hi ,

    You can build one technical workflow based on your requirement and fetch values from indicator schema under delivery.  Once workflow logic done export that in csv file which you can save to any SFTP/FTP location.

    Thanks,

    Kapil

    Translate
      badr_eddineAccepted solution
      Level 3
      Jul 2, 2019 9:54 AM UTC

      Hi,

      Like Kapil said, there is a schema inside Delivery with the name Indicators(Indicators).

      To achieve your Daily Export Workflow you will need 3 things,

      • Scheduler : Where you will configurate the daily execution
      • Query :

            - your targeting dimension needs to be "Deliveries",

            - after, add a condition to get the deliveries of the same day, there is a schema under Deliveries called Scheduling, try to find the field ContactDate (scheduling/@contactDate),set the operator to After and value to GetDate() (getdate take the current date starting from midnight)

      • Export : Here where you will use the Indicators Schema, select all the fields that you will like to get in your daily export.

      Thanks,

      Badr.

      Translate
        Terms & ConditionsAccessibility statement

        Loading footer...