Need help in creating an email report to show me emails scheduled out 7 days in the future.

Forum|Forum|3 years ago
November 28, 2022
1 reply
2691 views

Hi.
I can't seem to find anything on this. Can Marketo create a report where it shows emails scheduled 7 days in the future? I understand there's a calendar, but I would like an email report sent to me every Monday showing me the emails that are in scheduled to be sent out during the upcoming week.

Thanks,
Kristal

Marketo

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 Darshil_Shah1

I don't think there's a direct OOTB report that could get you details about email programs/smart campaigns scheduled to send out emails, aka, an alternative to the Marketing Calendar. There's no direct API endpoint for this as well, but you can use email/smart campaign/program query API with apt parameters in the GET call to get the details about the recently approved/scheduled assets, but here as well you'd need to slice and dice the results to get accurate data depending on how much you're able to narrow down API response using the query parameters. I think having a proper folder structure, naming convention, and tags would be helpful in filtering data.

Darshil_Shah1

Accepted solution

Community Advisor and Adobe Champion

I don't think there's a direct OOTB report that could get you details about email programs/smart campaigns scheduled to send out emails, aka, an alternative to the Marketing Calendar. There's no direct API endpoint for this as well, but you can use email/smart campaign/program query API with apt parameters in the GET call to get the details about the recently approved/scheduled assets, but here as well you'd need to slice and dice the results to get accurate data depending on how much you're able to narrow down API response using the query parameters. I think having a proper folder structure, naming convention, and tags would be helpful in filtering data.

K

kklugAuthor

Level 2

Hi.
Thank you for your advice. Could you provide an example of how I would use a smart campaign to show all emails that are scheduled to be sent this week or 7 days out? Also, I noticed you mentioned folder structure. Could you explain how to setup a folder structure that would show emails scheduled 7 days out?

Thanks!

Darshil_Shah1

Community Advisor and Adobe Champion

Well, if a smart campaign is scheduled to send out an email, then you'd want to get the info on the smart campaign's schedule to get details about the email send date/time. Having a proper naming convention, folder structure, and tags (for programs only) would help you to query and filter the correct campaigns/email program using the Marketo API. For example, you can filter all the "Send Email" campaigns within the program whose name contains today's date + [1 to 7] days, optionally you can also filter on the apt tag values (in case you choose to include the date string in the tag instead of the name as well).

Refer to this program naming convention on the Marketo nation community. With that being said, there are no standard/cemented regulations for naming conventions, you should set up and stick to the convention that works best for you. Also, the response would contain the campaign's run/email program's run date-time for you to be able to determine the email send times and map them out.

I hope you find this helpful! Please let us know if you have questions.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded