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.

One Answer

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

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.



Answered by Kevin on January 2, 2022

Add your own answers!

Related Questions

OAuth2 token request failing

4  Asked on December 14, 2021 by varun


Invalid type: Schema.SObject

1  Asked on December 14, 2021 by lalitha-rallabandi


Assigning field value from set help

1  Asked on December 14, 2021 by bblackinton


refresh token not update access token

2  Asked on December 12, 2021 by sergey-bondarenko


SFMC MobilePush that uses SFDC ContactID as SFMC ContactKey

1  Asked on December 12, 2021 by juliehurtz


Ask a Question

Get help from others!

© 2023 All rights reserved. Sites we Love: PCI Database, MenuIva, UKBizDB, Menu Kuliner, Sharing RPP, SolveDir