This page covers the core ideas and terminology you'll run into when using TexAu. Worth a quick read before you go deeper.
Tables
A table is the main thing you work with in TexAu. It's like a spreadsheet: each row is a record (a person, a company, a lead) and each column holds a piece of data.
Tables are where you:
- Store your raw data (imported or entered manually)
- Run enrichments to find missing information
- View and export your results
- Connect to external tools via webhooks and integrations
Columns
Columns define the structure of your table. Each column has a name, a data type, and a type that determines how it behaves.
Column types
This table scrolls sideways on small screens.
| Type | What it does | Example |
|---|---|---|
| Static | Stores data you enter or import manually | First Name, Company Domain |
| Processor | Runs an enrichment action using a provider | Find Work Email, Get Company Info |
| Data Source | Pulls data from an external connected source | CRM Contact Sync |
| Derived | Computes a value using a formula from other columns | Full Name = First Name + Last Name |
| Waterfall | Tries multiple providers in sequence until data is found | Email Waterfall (Provider A, then B, then C) |
| Output | Holds data received from a webhook | Webhook Response Data |
Rows
Each row represents one record —a person, a company, a URL, whatever you're working with. Rows can be:
- Added manually (one at a time or in bulk)
- Imported from a CSV file
- Created via an incoming webhook
- Added by a data source integration
Semantic data types
Every column has a semantic data type that tells TexAu what kind of information it holds. There are 32+ types, including:
- People data —First Name, Last Name, Email, Phone, Job Title, Department, Seniority Level
- Company data —Company Name, Domain, Description, Employee Count, LinkedIn URL
- Location data —Country, City, Postal Code
- Digital data —LinkedIn Profile URL, Twitter URL, Website URL
- Financial data —Currency, Number
- Date/Time —Date
- Other —ID, Free Text
Setting the right data type matters because it:
- Helps TexAu match the right enrichment providers automatically
- Turns on smart formatting and validation
- Improves accuracy for AI and formula operations
Enrichment
Enrichment is the process of finding missing data for your records. Say you have a list of company domains —enrichment can find the company name, employee count, LinkedIn URL, and more.
TexAu connects to multiple data providers to find this information. You can run enrichment manually or schedule it to run on its own.
Waterfall enrichment
Waterfall enrichment lets you try multiple data providers in order, so you get better coverage without overspending:
- Try Provider A first (often the cheapest or most accurate).
- If Provider A doesn't return data, try Provider B.
- If Provider B doesn't return data, try Provider C.
- Stop as soon as any provider returns data.
This typically finds 20-40% more data than using a single provider, and you only pay for the one that actually returns a result.
Templates
A template is a pre-built table configuration you can clone and use right away. Templates include:
- Pre-configured columns with the right data types
- Provider setup and waterfall logic
- Processing rules and formulas
- Recommended settings
TexAu has a library of global templates for common use cases (email finding, company enrichment, lead scoring, etc.), and your team can create workspace templates to standardize your own workflows.
Formulas
Formulas let you create computed columns that calculate values from other columns. They work like spreadsheet formulas:
- Text manipulation —combine names, extract domains from emails, format strings
- Math —add, subtract, multiply, divide, round
- Logic —IF/THEN conditions, AND/OR checks
- Data handling —COALESCE (use the first non-empty value from multiple columns)
Example: CONCAT(firstName, " ", lastName) creates a full name from separate first and last name columns.
Processing actions
Processing actions are built-in tools that clean and standardize your data. Some examples:
- CleanDomain —extract a clean domain from a URL or email
- NormalizePhoneNumber —standardize phone numbers to a consistent format
- ValidateEmail —check if an email address is valid
- NormalizeCompanyName —remove suffixes like Inc., LLC, Corp.
- RemoveExtraWhitespace —clean up messy text
You can apply processing actions to individual columns without writing any code.
Integrations
Integrations connect TexAu to external tools and services —your CRM, email platform, data providers, and more. They're used for:
- Pulling data into TexAu (data sources)
- Enriching records with external provider data
- Pushing enriched data back to your tools
Most integrations connect with one click through secure authorization. Some use API keys.
Webhooks
Webhooks let data flow between TexAu and other apps in real time:
- Incoming webhooks —receive data from external systems to create or update rows in your table.
- Outgoing webhooks —automatically send enriched data to external systems when rows are enriched or updated.
Scheduled jobs
Scheduled jobs automate enrichment on a recurring basis. You can configure jobs to run:
- Once, at a specific date and time
- At an interval, every N minutes within a time window
- Daily, at a set time
- Weekly, on specific days at a set time
All schedules support timezone configuration.
Credits
Credits are how you pay for enrichments and AI operations in TexAu. Different actions cost different amounts:
- Each enrichment provider has a per-row credit cost.
- AI operations have a per-row cost based on the model used.
- Your plan includes a monthly credit allowance, and you can buy more as needed.
Quick reference
This table scrolls sideways on small screens.
| Concept | What it is |
|---|---|
| Table | Your data container —rows and columns |
| Column | A data field with a type and behavior |
| Row | A single record in your table |
| Semantic Data Type | What kind of data a column holds (email, phone, domain, etc.) |
| Enrichment | Finding missing data using external providers |
| Waterfall | Trying multiple providers in sequence for better coverage |
| Template | A reusable, pre-configured table setup |
| Formula | A computed column based on other column values |
| Processing Action | A built-in data cleaning/transformation tool |
| Integration | A connection to an external tool or service |
| Webhook | Real-time data flow to/from external systems |
| Scheduled Job | Automated enrichment on a recurring basis |
| Credits | How you pay for enrichments and AI operations |
Next steps
- Your first enrichment —put these concepts into practice
- Creating a table —build your first table
- Understanding columns —deep dive into column types