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

Basic Report

Avatar

Avatar
Validate 1
Level 1
telmof93992697
Level 1

Likes

4 likes

Total Posts

1 post

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 1
telmof93992697
Level 1

Likes

4 likes

Total Posts

1 post

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile
telmof93992697
Level 1

01-07-2019

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?

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 1
Level 4
badr_eddine
Level 4

Likes

42 likes

Total Posts

41 posts

Correct Reply

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

Avatar
Validate 1
Level 4
badr_eddine
Level 4

Likes

42 likes

Total Posts

41 posts

Correct Reply

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

02-07-2019

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.

Answers (1)

Answers (1)

Avatar

Avatar
Validate 1
MVP
kapilKochar
MVP

Likes

128 likes

Total Posts

140 posts

Correct Reply

43 solutions
Top badges earned
Validate 1
Contributor
Give Back 10
Give Back 5
Give Back 3
View profile

Avatar
Validate 1
MVP
kapilKochar
MVP

Likes

128 likes

Total Posts

140 posts

Correct Reply

43 solutions
Top badges earned
Validate 1
Contributor
Give Back 10
Give Back 5
Give Back 3
View profile
kapilKochar
MVP

01-07-2019

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