Each time you create a Scoring model,Acoustic Campaign adds three non-editable Scoring columns to your database. The Scoring columns are, <model name>_Behavior (Activity Score + Recency Score), <model name>_Score and <model name>_Rank.
Contact scores that are associated with a particular model are uploaded in these fields. For example, if you create and name a new Scoring model GardenPromoW2011. When you create this new model, Acoustic Campaign adds three additional columns to your database (rank, score, and behavior). The new columns are called GardenPromoW2011_Behavior, GardenPromoW2011_Score, and GardenPromoW2011_Rank. If a contact gets a behavior score of 25 because the contact ordered a catalog by submitting a Web form request, the number 25 populates in the GardenPromoW2011_Behavior field.
No matter how many Scoring models you create for your organization, you can have no more than 400 columns in your database. If you have 398 columns and want to create a new Scoring Model, Acoustic Campaign does not create a Scoring model and you can receive a warning message informing you to delete columns in your database to accommodate the addition of the new three Scoring columns. Also, each Scoring model must have a unique name. This name drives the columns in your database.
In order to map scoring fields over to Salesforce.com, you will first need to have a scoring model created using the same database as the one that is syncing with Salesforce.com. Once the model(s) are created,you will find three fields that will end with _Behavior, _Rank and _Score. For example:
- Scoring_Model_Name_ Rank
- Scoring_Model_Name_ Score
Once the fields are created, you can go into the CRMi mapping console and map them over to Salesforce.com. There are a total of six fields that are on the Lead and Contact object that can be used to map the scoring model fields from Acoustic Campaign to Salesforce. The fields are labeled as Silverpop Behavior Score, Silverpop Lead Rank & Silverpop Lead Score. Ensure that these fields are added to the default lead and contact page layout for the integration user that is being used to sync record between the two systems.
Once you are in the CRMi mapping console, locate theAcoustic Campaign fields that are on the Salesforce page layout and map the fields as a one-way sync from the Acoustic Campaign to Salesforce.com. If you are mapping these fields on an existing integration, ensure to choose Pull all historical data when selecting the sync direction.
Once you complete all the above mentioned tasks, navigate to the Review and Active tab in the CRMi mapping console and activate the mapping and synchronize the scoring model metrics. Scores may be mapped to CRM Leads for Lead INSERTS through the synchronization, but thereafter scoring updates in Acoustic Campaign are not updated on the CRM Lead. This would satisfy a need to get the original score value passed from Acoustic Campaign to CRM, but does not accommodate the ability to keep the score updated in CRM thereafter.