By implementing a simplified Marketing Cloud business unit and preference model across all campuses, the eComm team will reduce costs, streamline the constituent experience, and decrease the level of backend management needed. The current model has 151 business units and 373 associated preferences. This project aims to reduce these numbers by at least 50%.
Reports can often have the same contact listed numerous times, so identifying the unique count is important to confirm the Report criteria is accurate. Having a total 9,000 unique contacts when expecting 250 is an indicator of incorrect criteria and should be investigated.
For organizations with a large number of Salesforce users, Public Groups optimize performance and bring efficiency. Given eComm's 300 person userbase with an average of 20 new licenses each month, we couldn't manage without them.
The Free Map Tool has a ZIP Code Radius Search Map which allows you to determine what Zip Codes fall into a set range from a set point (ie. 10 mile radius of 80203). These Zip Codes can then be used in a Salesforce Report to capture an audience based on where individuals live. This is often useful when hosting an in-person event and determining who to invite.
GeoCode, a field in Salesforce available on a Contact's record, currently comes from the Advance database. Advance will be getting rid of this field during the migration to Ascend, so it will no longer be available in eComm's instance of Salesforce. In preparation for this change, Salesforce Reports currently using this field need to be recreated with an alternative method or deleted by April 25, 2023.