How do I search contact data in an extended table?

If you're using an integration for Contacts, like eCommerce or Eventbrite, you can run searches on the data stored. Many times these integrations create what is called an extended table (aka custom table), which is separate from the main contact table. The main table and the integrated table are joined based on the email address.

How-To

Contacts dashboard

1. Go to Contacts
2. Click 'Find Contacts' icon (spyglass at the top right of the contacts table)
3. Use the drop down menu on left to scroll to bottom and find extended table
4. Click on (+) to display fields in that table
5. Check the box to select the field you want from your extended table
6. Enter a value in the text box
7. Click 'Search'

Custom report builder (Analytics)

Availability depends on your license. Contact Client Success for questions.

1. Navigate to the Analytics Dashboard.
2. Choose Custom Reports from the left-hand navigation.
3. Click Create Custom Report at the top-right.
4. Choose "Contact Report".
5. Name your report and give it a description (description is optional).
6. Open the "Select Field" drop-down and search for the name of the extended table field you are looking for (I chose to look for object type in Salesforce to pull all Leads in the system).
7. Click Run Report once you are done creating clauses.
8. Use the drop-down on Run Report to choose additional fields to include in your report (I chose Lead Status and Lifetime Engagement).
9. Once you are satisfied with your report you can save it in the top-right and export using the three dots at the top-right of the report grid.