| Table of Contents |
|---|
Adding Contacts to your Campaign Using SharpenDB2:
Once you’re ready to add contacts to your campaign, you’ll do so via a new SharpenDB2 campaign table (Admin > Configuration > SharpenDB2 > Fathom Contacts).
Click the New Table button in the upper-left corner and name your campaign table.
...
Once you’ve created your new table, click the “structure” tab along the top, right above the name of the table. Here, we can add some new columns in order to drive our OmniOut campaign.
...
Click the Add Column button and add each of the following columns. You don’t necessarily need to populate each column with contact information, but be sure to add them to the table structure (with the appropriate field type) so that everything maps properly with OmniOut.
...
Field Name | Type | Additional Notes |
|---|---|---|
id * | int | This field is present by default — don’t delete it The ID maps your contacts so that you update contact row instead of ending up with duplicates. (e.g. a contact w/ the ID of 1 can be updated in your CSV and re-uploaded at any time, overriding the existing row with the most up-to-date information). |
firstName | 'varchar' | |
lastName | 'varchar' | |
phone | 'varchar' | |
'varchar' | ||
memberTimezone | 'varchar' | |
company | 'varchar' | |
city | 'varchar' | |
state | 'varchar' | |
status * | 'varchar' | This is the stage in the campaign where you’d like to insert this contact (generally, you want the contact to go to the first stage of the campaign—this gives you the option to leapfrog portions of the campaign if necessary). |
owner * | 'varchar' | This is the particular owner you want to assign to the contact (e.g. if you want to handle Adam’s contacts differently from Ric’s, you’d enter the respective owner here). If you don’t have a specific owner, insert an asterisk and the interactions will go to the default Q. |
imported * | ‘tinyint’ | This is a boolean field that lets OmniOut know whether a contact has been imported for a given stage yet. Enter 0 (that’s a zero) for new contacts. This will change to 1 after the contact has been imported for a stage. Then, switch back to 0 when it transitions to the next stage. |
lastActionTime * | ‘datetime’ | This date/time field will populate with the last OmniOut import timestamp. |
. Adding Contacts to your Campaign individually using
...
SharpenDB2
Now that you’ve setup your table structure, you’re ready to input your contacts. You can add a row of data individually by using the Add Row button in the upper right.
...
With your exported report, it’s easy to fill out the CSV and massage your data before uploading using the Import CSV button.
Once your contacts loaded, you are ready to head back to OmniOut and link your new DB Table to our campaign.
...
The information below utilizes SharpenTables, a legacy method of adding contacts to an OmniOut campaign. We’d recommend using the above method, but are preserving the directions below just in case you have campaigns that are already setup.
Adding Contacts to Your Campaign in Bulk using SharpenTables (legacy)
Once you’re ready to add contacts to your campaign, you’ll do so via the Fathom Contacts table (Admin > Configuration > Sharpen Tables > Fathom Contacts).
Navigate to the bottom of the data tab and click more to reveal the Import Records button. Download the CSV template so that you can ensure the proper fields are in place for your campaign.
...
Field Name | Notes |
|---|---|
Full Name | |
First Name | |
Last Name | |
Phone Number | |
Email Address * | Only required if you are emailing within the campaign. |
SSA Campaign Status | This is the stage in the campaign where you’d like to insert this contact (generally, you want the contact to go to the first stage of the campaign—this gives you the option to leapfrog portions of the campaign if necessary). |
SSA Campaign ID | This is the unique campaign key. |
SSA Imported | This is a boolean field that lets OmniOut know whether a contact has been imported for a given stage yet. Enter 0 (that’s a zero) for new contacts. This will change to 1 after the contact has been imported for a stage. Then, switch back to 0 when it transitions to the next stage. |
SSA Owner | This is the particular owner you want to assign to the contact (e.g. if you want to handle Adam’s contacts differently from Ric’s, you’d enter the respective owner here). If you don’t have a specific owner, insert an asterisk * |
...
Adding Contacts to Your Campaign Individually using SharpenTables (legacy)
Navigate to Admin > Configuration > Sharpen Tables > Fathom Contacts. At the bottom of the data tab, click Add Record and fill in the same required fields listed above.
...