AnswerBun.com

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:

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

Add your own answers!

Related Questions

Add CC/BCC in Journey Builder email send

3  Asked on January 9, 2021 by zuzannamj

     

Pulling Subscriber Status from Lists using SSJS

1  Asked on January 8, 2021 by shuckyducky

     

Mass Delete flow and flow versions

1  Asked on January 7, 2021 by ghosty

     

Create dynamic picklist in lwc

1  Asked on January 6, 2021 by ajinkyasd

       

Page layout assignments with XML metadata API

1  Asked on January 3, 2021 by baxter

   

Link is not rendering correctly for non-English emails

1  Asked on January 3, 2021 by mike-marks

     

Fail Record video Html

0  Asked on January 2, 2021 by daniela-cerqueira

       

Allow community-users to create employees for multiple accounts

1  Asked on January 2, 2021 by hans-christian-milman

   

On Lead Conversion update Contact field

2  Asked on January 1, 2021 by mahesh-raghuraman

       

Ask a Question

Get help from others!

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