Tables

Tables in Salesnode are powerful customizable data grids that allow you to organize and manage your campaign contacts and other relevant records efficiently. Understanding how tables work and how to use them effectively can significantly enhance your outbound campaigns and data handling.

What are Tables?

Tables are custom data containers where you can store various types of information related to your sales campaigns, such as contact details, interaction history, and campaign-specific notes. Each table consists of rows (records) and columns (fields), enabling you to structure data in a way that fits your unique business needs. By leveraging tables, you can centralize your data management and seamlessly integrate it with your automated campaigns.

When to Use Tables

Knowing when to use tables helps you maximize their value. Use tables whenever you need to organize large sets of contact or campaign data that require custom fields beyond basic contact information. They are ideal for:

1. Managing segmented contact lists with tailored data points.
2. Tracking campaign-specific metrics or statuses.
3. Storing enriched contact details updated automatically.
4. Integrating external data sources like CRMs or Apify for real-time syncing.

Practical Examples of Table Schemas

• Lead Management Table: Columns for First Name, Last Name, Email, Phone, Lead Source, Status, and Notes.
• Event Attendees Table: Columns for Name, Email, Ticket Type, Registration Date, and Attendance Status.
• Customer Feedback Table: Columns for Customer Name, Email, Feedback Text, Rating, and Follow-up Date.

Column Types

Columns define the type of data each field in your table will hold. Choosing the appropriate column type ensures your data is stored correctly and can be effectively filtered, segmented, and used in campaigns. Below is an overview of available column types, their purposes, example use cases, and validation rules:

1. Single Line Text

   • Purpose: Store short text values.
   • Example Use Cases: First Name, Company Name.
   • Validation: Limited to a single line of text without line breaks.

2. Long Text

   • Purpose: Store multi-line content.
   • Example Use Cases: Notes, Descriptions.
   • Validation: Allows multiple lines and longer text.

3. Email

   • Purpose: Store email addresses.
   • Example Use Cases: Contact emails.
   • Validation: Must follow valid email format (e.g., [email protected]).

4. Currency

   • Purpose: Store monetary values with currency formatting.
   • Example Use Cases: Budget, Deal Size.
   • Validation: Numeric values with optional currency symbols.

5. Phone

   • Purpose: Store phone numbers with formatting and validation.
   • Example Use Cases: Contact phone numbers.
   • Validation: Accepts numbers and standard phone formatting.

6. URL

   • Purpose: Store website or profile links.
   • Example Use Cases: Company website, LinkedIn profile.
   • Validation: Must be a valid URL format (http/https).

7. Date

   • Purpose: Store calendar date values.
   • Example Use Cases: Follow-up date, Meeting date.
   • Validation: Must be a valid date.

8. Timezone

   • Purpose: Store timezone identifiers.
   • Example Use Cases: Contact timezone for scheduling.
   • Validation: Must be a recognized timezone string.

9. JSON

   • Purpose: Store structured JSON objects.
   • Example Use Cases: Complex data like custom metadata.
   • Validation: Must be valid JSON format.

10. Number

    • Purpose: Store numeric values (integer or decimal).
    • Example Use Cases: Number of employees, Scores.
    • Validation: Numeric input only.

11. Checkbox

    • Purpose: Store boolean true/false values.
    • Example Use Cases: Opt-in status, Task completed.
    • Validation: Boolean.

12. Single Select

    • Purpose: Select one option from a predefined list.
    • Example Use Cases: Status (New, Contacted, Qualified).
    • Validation: Must match one of the predefined options.

13. Multi Select

    • Purpose: Select multiple options from a predefined list.
    • Example Use Cases: Interests, Tags.
    • Validation: Must match one or more predefined options.

14. Created Time

    • Purpose: Auto-generated timestamp of record creation.
    • Example Use Cases: Record creation date tracking.
    • Validation: Read-only, system-generated.

How Column Types Affect Filtering and Campaigns

Each column type influences how you can filter, segment, and target contacts in your outbound campaigns. For example, email columns enable direct email targeting, date columns facilitate time-based follow-ups, and single or multi-select columns help you segment your audience by status or interests. Proper column type selection ensures your filters work correctly and your campaigns reach the right contacts.

Enrichment Capabilities

Tables in Salesnode support data enrichment, which automatically populates and updates fields with fresh information from integrated sources. Enrichment helps keep your contact data accurate and up-to-date without manual input. For example, enriching a contact’s phone number or company details can improve personalization and campaign effectiveness.

You can configure enrichment to:

1. Populate empty fields with new data.
2. Update existing fields when better or more recent data is available.
3. Sync data automatically from external sources like Apify or your CRM.

Auto-Sync with External Data Sources

Tables can be set to auto-sync with external data providers such as Apify or your CRM system. This synchronization keeps your tables current by regularly importing updates, reducing manual data entry and ensuring your campaigns use the latest information.

Best Practices

Using tables effectively requires some best practices to ensure data integrity, ease of use, and campaign success. Consider the following guidelines:

1. Plan Your Table Schema Carefully: Define the columns and their types based on your campaign goals and data needs before importing or entering data.
2. Use Filters to Segment Your Data: Apply multiple filters simultaneously using the Filter button in the toolbar. Filters can be combined with AND/OR logic and are saved for convenience.
3. Leverage Sorting to Organize Views: Use the Sort button to order your records by one or more columns. Sorting preferences are saved and help you quickly find important data.
4. Keep Column Types Consistent: Avoid mixing incompatible data types in the same column to maintain accurate filtering and segmentation.
5. Regularly Enrich and Sync Data: Set up enrichment and auto-sync to keep your tables updated and reliable for campaigns.

Filtering and Sorting Explained

Filtering allows you to narrow down your table view by setting conditions on one or more columns. For example, you can filter contacts where Status is “Qualified” AND Country is “USA.” Sorting arranges your table records based on column values, such as sorting by Last Name ascending, then by Created Time descending.