Crimson Feature of the Month: How to Organize Your Data to Maximize Crimson
The beginning of the new year is a great time to review your Crimson data to clean up or organize your Source Codes. Understanding the difference between Fund Codes, Program Codes, Initiative Codes and Source Codes is key to maximizing all the features in Crimson. Scroll down to learn how to set up and edit each of these codes. You can also download a one-page overview to use as an easy reference.
How Crimson Data is Set Up:
Data in Crimson is set up in a four-level hierarchy:
1. Fund: This is the campaign level that identifies which committee or cycle and election it is. This allows you to identify information from the current campaign or committee and correctly report it to the FEC.
Example: P2022 is a Fund Code for donations raised in the 2022 primary while G2022 is the Fund Code for donations raised in the general election.
2. Program: This code identifies broad channels or categories of fundraising.
Example: Housefile mail, prospect mail, telemarketing, online, major donor, or event.
3. Initiative: This code refers to every housefile and prospect appeal sent from your campaign. Each mailing, email, event, or other type of appeal should receive a unique Initiative Code.
Example: P001 would be prospect sent the education mailing
4. Source: This code identifies individual segments within an Initiative. With a prospect appeal, the Source Code would refer to the list that you rented, and the code for a housefile appeal would refer to a specific segment, such as donation level or geographic area. To make events easier to manage, give each of them a unique Source Code. This will help you track the donations made at each event.
Example: P001A Family Matters List, P001B Clark County Republicans & P001C Candidate Contact List
Remember: Every Source Code is linked to a broader Initiative code and an even broader Program code. However, Crimson will only require you to select a Fund Code and Source Code when entering or loading a gift.
Setting Up Fund Codes
Because Fund Codes are the top category to organize all other data, these should be limited and strategically created. Please contact Crimson Customer Support to add or edit them.
How to Create & Edit Program Codes
1. To set up a new Program Code, click on the Fundraising menu on the left-hand side of your Crimson dashboard and then the Settings icon in the navigation bar.
2. In the next window, options to manage Program, Initiative, Source, Fund, Revenue, and Project/Event Codes will appear with multiple options.
1. Program Tab: this is the default, so a list of existing Program Codes will be displayed upon opening the settings.
3. Search Code, Description: use this field to look up a Program Code by name.
How to Create a Program Code
1. From the Program Tab, click on the Add button.
2. Enter the name of the code, a description, and the type of program under the Program Group ID — Direct Mail, Telemarketing, Digital, and Major Donors.
How to Create & Edit Initiative Codes
Since all gift data requires a Source Code, they must be set up before any contributions are added. There are two ways to set them up – manually enter or import into Crimson.
Remember that each Source Code must be linked to an Initiative Code, and each Initiative Code must be linked to a Program Code. Before you set up your Source Codes, please review how your data is ordered to follow any naming conventions that your organization has established.
Set Up Initiative Codes
1. To set up a new Initiative Code, click on the Fundraising menu on the left-hand side of your Crimson dashboard and then the Settings icon in the navigation bar.
3. Enter your Initiative Code and add a description. Then use the drop-down menu under description to connect the Initiative Code to the right Program Code.
Note: You can also select Initiative Type and enter a Note, but this field is not required.
How to Edit Initiative Codes
1. Go to the Initiative Search under Settings in the Fundraising Dashboard. In the search bar, enter the Initiative Code you wish to edit. It will appear below.
3. Once the Initiative Code is open, additional options will display.
1. Fundraising tab: This section displays the funds raised and counts from the Initiative.
2. Source Codes: This section shows all the Source Codes linked to the Initiative.
3. The drop-down menu allows you to select which time frame you wish to see data.
4. Overview Data: See the topline data for this Initiative Code.
5. Response Analysis: click here to create a Bluebook with the data from the Initiative Code.
How to Add and Edit Source Codes
Enter Source Codes Manually
If you only need to add a few Source Codes, there are two ways to manually enter them.
button. A new Source Code will appear under the tab.
● Option 2: Return to the Settings section under the Fundraising Dashboard and click on the Source Tab. Click on the button.
Import Source Codes
1. Before importing your Source Codes, please download our template from the Helpdesk. This template is a spreadsheet that contains the required fields — Source Code and Source Description.
2. Confirm that the correct Initiative Code has been entered into Crimson.
Note: Make sure you only have one worksheet named Source saved in your Excel file.
5. Your Source Codes should be uploaded and saved in Crimson.