This can be done using the latest version of Connector for Salesforce + Campaign Monitor and the Scheduled Apex functionality of Salesforce.
First, install the latest version of Connector. If you are upgrading from an existing version, simply install this package on top of your existing installation. If you are installing the Connector for the first time, you will have to refer to the installation and configuration guide.
After the successful installation, you will have to create a few scheduled jobs in Setup in your Salesforce org. Navigate to Setup > App Setup > Develop > Apex Classes, and click the Schedule Apex button (Don't worry, you don't have to write any Apex code!). From the Schedule Apex screen, configure your scheduled job as follows:
- Job Name: Type "1. snbCampMonSchedulable"
- Apex Class: Select "snbCampMonSchedulable"
- Schedule Apex Execution: Set as per your preference
Repeat the same steps with the following Apex classes:
- snbCMSchedCampSum (New in v3.13, updated August 2013)
Updated April 2012: The Apex classes snbCMSchedEmailOpensCampMem and snbCMSchedSubscriberClicksCampMem are only available in the package version 3.7 or later. If you are using an older version of the Connector, please upgrade to the latest version at http://www.snbapps.com/products-and-services/cloud-integration
Navigate to Setup > Administration Setup > Monitoring > Scheduled Jobs, and the screen should look similar to this:
These scheduled jobs refresh data for 10 recently sent campaigns. This is due to the limitation of Salesforce Apex Governor, which only allows 10 callouts to external systems per execution.