Creating Tables

What are Data Tables and Why Use Them?

Data tables in Salesnode are customizable containers designed to store and manage your campaign contacts and other relevant data efficiently. Creating tables allows you to organize your information systematically, making it easier to integrate with outbound campaigns and automate your sales processes. Understanding how to configure these tables correctly is essential for maintaining clean data and ensuring your campaigns run smoothly.

How to Create a New Table in Salesnode

Creating a new table is a straightforward process that involves naming your table, selecting a data source, and configuring deduplication settings to manage duplicate records effectively. Follow these steps to create your table:

1. Navigate to the Sidebar.
2. Click on Tables.
3. Click the New table button.
4. Fill in the configuration fields as described below.
5. Click Create to finalize your table.

Step-by-Step Configuration Details

1. Table Name

This is the label for your table and is used to organize and identify it within Salesnode. Choose a clear and descriptive name that reflects the content or purpose of the table, such as Prospects Q3 or Event Attendees.

2. Data Source

The data source determines where your table’s data comes from. You can choose from several options, each suited for different use cases:

• CSV File: Upload a CSV file to create your table. This is useful if you already have contact lists or data exported from other systems.
• Apify: Use this option to create a table from the results of an Apify actor. You will need to specify the actor ID to fetch the data. This is ideal for web-scraped or automated data collections.
• Webhook: Create a table that receives data dynamically through webhooks. This is perfect for real-time or automated data entry from external sources.

To enable these data sources, you may need to add API keys or authorize connections.

3. Deduplicate Records

Deduplication helps maintain data quality by preventing duplicate entries in your table. You can choose how Salesnode handles duplicates when new data is inserted.

4. Deduplication Columns

Select one or more columns that Salesnode will use to identify duplicates. For example, you might use an email address or phone number column. Choosing the right columns ensures accurate detection of duplicates based on your specific data.

5. Select Action for Duplicate Records

When duplicates are detected, you can decide how to handle them:

• Merge with Existing Record: Combines new data with the existing record, updating fields as necessary. This is useful when you want to enrich existing contact information without losing any data.
• Skip New Record: Ignores the new entry if a duplicate exists, preserving the original record unchanged. Use this if you want to avoid overwriting any existing data.

Detailed Configuration Use Cases and Implications

Configuring your table correctly impacts how your data is managed and used in campaigns. Here are some common scenarios and recommendations:

1. Using CSV Files for One-Time Imports: Ideal for static lists or initial imports. Deduplicate based on email to avoid sending multiple emails to the same contact.
2. Apify for Automated Data Collection: Great for continuously updated data scraped from websites. Use merging to enrich existing contacts with fresh data.
3. Webhook for Real-Time Data: Useful for live data feeds from forms or other apps. Deduplication should be strict to avoid flooding your table with repeated entries.

Implications of Deduplication Settings

• Merging duplicates can improve data richness but may require careful mapping of fields to avoid data loss.
• Skipping duplicates preserves original data but might miss updates or corrections in new entries.

Troubleshooting and Tips for Table Creation

When creating tables, you might encounter some common issues or need to tailor configurations for specific needs. Here are some important points to consider:

Best Practices for Table Configuration

To get the most out of your data tables, consider these best practices:

• Choose meaningful table names to easily identify your data sets.
• Select appropriate deduplication columns based on unique identifiers like email or phone number.
• Use merging when you want to keep your data up-to-date and enriched.
• Regularly review your data sources and deduplication settings to ensure they align with your campaign goals.