What is the Multi-Level Smart Connector Feature?
The Multi-Level Smart Connector feature allows you to join two or more datasets. For example, if you have data in more than one place that you would like to show up in TapClicks as a single dataset, you can use the Multi-Level feature to make the association between these data locations.
Let’s use an example to illustrate this:
You have collected data about leads from two separate forms on different tabs in the same spreadsheet. On one tab you have collected information about the company of the lead. On another tab you have collected information about the user themself. The company form collects things like business name, city, state, and zip code. The personal data form collects information such as their name and personal preferences. On both forms you ask for the person to provide their email address and both forms populate CSV files.
When uploading this data into TapClicks you want to bring both tabs together into one Smart Connector. The way to accomplish this is to use the multi-level feature and join the datasets by associating the email address in one CSV file with the same email address in the other CSV file.
A Multi-level Smart Connector is simply a way to join data from different places. The “levels” in the multi-level name refers to the parent-child relationship amongst data. The parent data being the one you relate the others to through making the association for a specific field or set of fields.
When building a Multi-Level Smart Connector it helps to be familiar with a few terms and concepts that are used in this article.
Think of a data table as one tab in an excel file. You might have data on multiple tabs but they aren’t necessarily connected together.
Many people are familiar with the concept of merging tables. When you compile multiple excel tabs into one single tab, you are effectively merging the data. To Join data, you are connecting separate data tables together using a common field. The data stays in separate places but you have made an association amongst them.
When joining two or more data tables, the field(s) used to associate the data tables is called the relational field. In the example above, the person’s email address was the relational field. We could use it to inform the system that the various data tables are related.
How to create a Multi-Level Smart Connector
Basic Smart Connector Setup Steps
If you want to skip to just the Multi-level step, please click here
- Navigate to Data in the left sidenav
- Select Smart Connectors from the subnav
- Click on the (+) plus sign to add a new Smart Connector
- Provide a name and other details
- Select a Delivery Type from the dropdown. In this example we will use the Manual Upload Delivery Type.
Note: The Multi-Level Smart Connector feature will work with all delivery types
- Click on Select Sample File and choose the first file you want to upload
- Click on Upload
- A field mapping section will appear. Verify the fields are correctly mapped by ensuring the suggested field types are accurate for the data you have provided (dates for a date field, numbers for a number field, etc)
Note: There are three pieces of data required to make a Smart Connector functional: At least one Date field, at least one field that associates to a client record, and at least one number field.
- Select the field(s) that will define uniqueness for your dataset. You will need to map these unique fields to any other data table you join to this one. Effectively, these are your relational fields. For more information about Unique Fields, please see this article.
- Save Changes
Steps Specific to Multi-Level
- Once you have saved changes on your Smart Connector, the option will appear at the bottom of the page to add sublevels. A sublevel is simply another data table you want to join with the one you have already created.
- Click on the (+) plus sign next to Smart Connector Sublevels
- The new page is nearly identical to the previous smart connector creation page. Simply sill out the details using the previous steps to include name of sublevel, Delivery Type, and field mappings
- Once you upload your sample file, you will see the field mapping window again. This time there is a new column called Parent Inheritance.
Note: The drop down options in the Parent Inheritance field are the Unique Fields you chose in the first smart connector mapping step. All of these will need to be mapped to the same data as it exists in the new sublevel file.
- After you have selected these options, click Save Changes