Understanding the Limits

When updating CRM data via the connector, it is essential to understand the limits imposed by Salesforce Marketing Cloud. The script run time limit is 30 minutes, but this is not the only constraint. The connector itself has a limit of 25 calls per 20 seconds, which can be a bottleneck in high-volume scenarios.

Performance Considerations

To avoid timeouts and performance issues, it is crucial to consider the volume of data being processed. In this scenario, with 26k transactions per hour, the script may hit the connector’s limit, leading to timeouts and errors. We have seen this issue in similar scenarios, where the script is unable to process the data within the allotted time, resulting in failed automations.

The root cause of this issue is the high volume of data being processed, combined with the connector’s limit of 25 calls per 20 seconds. This can be mitigated by using a more robust data integration tool or a CRM-side job to unpack the data.

Solutions and Workarounds

One possible solution is to use a more robust data integration tool, such as Apache Nifi or Mulesoft, to move data into CRM. Another approach is to use a file drop from FTP and a job on the CRM side to unpack the data, as suggested by Nathalie Starr. This approach can help reduce the load on the connector and avoid timeouts.

example.ssjs

var file = File.read("path/to/file");
var data = file.getContent();
// Process the data and update CRM using the connector

Best Practices

To avoid similar issues in the future, it is essential to follow best practices when designing and implementing automations in Salesforce Marketing Cloud. This includes understanding the limits and constraints of the platform, as well as using robust data integration tools and CRM-side jobs to unpack the data.

Checklist for High-Volume Automations

• Understand the limits and constraints of the platform
• Use robust data integration tools, such as Apache Nifi or Mulesoft
• Consider using a CRM-side job to unpack the data
• Monitor and optimize the automation for performance
• Test the automation thoroughly before deploying to production

What is the script run time limit in Salesforce Marketing Cloud?

The script run time limit is 30 minutes.

What is the limit of calls per minute for the connector?

The connector has a limit of 25 calls per 20 seconds.

What are some possible solutions to avoid timeouts and performance issues?

Using a more robust data integration tool, such as Apache Nifi or Mulesoft, or using a CRM-side job to unpack the data.

How can I monitor and optimize the automation for performance?

By using the built-in monitoring and optimization tools in Salesforce Marketing Cloud, as well as testing the automation thoroughly before deploying to production.