Automated Report from Salesforce to Journey Builder

Salesforce Asked by CRM Admin on January 2, 2022

I am needing to automate a report in Salesforce to go to Journey Builder as a data extension but can’t find a good way to do so. I need Journey Builder to receive the updated report daily and then send out emails based on the report.

automation journeybuilder marketing cloud

One Answer

You can create an import inside of email studio that will import a sales cloud report:

https://help.salesforce.com/apex/HTViewSolution?id=000273869&language=en_US

From there, you can setup an automation to run daily in automation studio that would look like this:

Import File>SQL Query>Journey Entry

Import File would import the sales cloud report you created, SQL Query would allow you to join to any other tables (Like Subscribers), Journey Entry to inject the results into your journey.

Best,

Kevin

Answered by Kevin on January 2, 2022

Automated Report from Salesforce to Journey Builder

One Answer

Add your own answers!

Related Questions

Marketing Cloud Field-Level-Encryption with SSJS not work

OAuth2 token request failing

VF Email Template Error – Attempt to de-reference a null object

Invalid type: Schema.SObject

Where to find the CSS styles behind a Salesforce CSS class?

Validate Salesforce Access Token via custom backend app

Change owner in process builder from set of values

Does Named Credentials provide a way to store returned access tokens?

Single SOQL query to list ALL Products with ALL Quote Line Items and ALL Order Products?

Assigning field value from set help

OAuth JWT Token Bearer Flow returns Invalid Client Credentials

refresh token not update access token

Error when setting “rendered” attribute on apex:mapMarker

Edit properties of a Visualforce Email Template in apex so the email sent through Messaging.sendEmail() will have the most recent data in it

error when trying to remove css class from classList in js LWC

SFMC MobilePush that uses SFDC ContactID as SFMC ContactKey

navigate to custom lightning record page in lightning component

Data export: Views vs Tracking Extract

I am looking for a Regex Validation to avoid ” in the text field . I have tried using the below formula But its not working

Need to set the custom object’s list view records un-editable

Ask a Question