How to configure MASS Report DDPs.
: This feature can use multiple Salesforce reports; One for Recipients, and multiple others for data.
- Create a report of the desired recipients of the mass report. Ensure that the first column of this report is the record ID (Contact, Lead, User). As long as the first column is the record ID, the columns afterwards can be any fields and in any order.
- Put the recipient report in the Mass Recipient Report field.
- If using the SF Report DDP Feature, the columns from the Mass Recipient Report (MRR) are available for use as filters for the SF Report being used to fill data. In the Filter section for SF Report to DDP, refer to the Mass Recipient Report columns as !param# (where # is the column number, starting at 0). For example, pv0=!param3 would use the 4th column in the MRR.