Complete reference for every field returned in Intent Audience parquet exports. Each audience export contains up to 125 fields across intent scoring, contact, company, and demographic categories.
ts: Date-level timestamp. The time portion is always midnight.
Identity Fields
Email and identity resolution data. Present on every row.
Field
Type
Description
email
string
Primary resolved email address
domain_lc
string
Email domain (e.g., acmecorp.com)
is_email_business
string
"true" or "false"
is_email_personal
string
"true" or "false"
is_international
string
"true" if non-US
Email Hashes
Multiple hash algorithms and case variants for matching against your own data:
Field
Algorithm
Input
md5_lc_hem
MD5
Lowercase email
md5_uc_hem
MD5
Original-case email
sha1_lc_hem
SHA1
Lowercase email
sha1_uc_hem
SHA1
Original-case email
sha256_lc_hem
SHA256
Lowercase email
sha256_uc_hem
SHA256
Original-case email
Additional enrichment-sourced hashes are available with the emails_ prefix: emails_md5_lc_hem, emails_sha1_lc_hem, emails_sha256_lc_hem, and their _uc_ variants.
Person Fields
Contact-level data from the identity graph.
Name
Field
Type
Description
Example
first_name
string
First name
jane
middle_name
string
Middle name
marie
last_name
string
Last name
smith
Email
Field
Type
Description
email
string
Primary resolved email
emails
string
All known emails (comma-separated)
personal_email
string
Primary personal email
personal_emails
string
All personal emails (comma-separated)
current_business_email
string
Current work email
business_emails
string
All business emails
primary_contact_emails
string
Primary contact emails
valid_emails
string
Validated emails
invalid_emails
string
Known-invalid emails
Email Validation
Field
Type
Values
email_validation_status
string
catchall, invalid, unknown, valid
personal_email_validation_status
string
unknown, valid
current_business_email_validation_status
string
catchall, unknown, valid
email_last_seen
date
Last date email was verified active
current_business_email_validation_date
date
Business email validation date
Phone Numbers
All phone fields use E.164 format (e.g., +15551234567). Multiple numbers are comma-separated. Each phone field has a matching DNC (Do Not Call) field with positionally-aligned y/n values.
-- Read all parts of an audience export
SELECT * FROM read_parquet('audience_part-*.parquet');
-- Filter to high-intent contacts
SELECT first_name, last_name, email, company_name, job_title, score, perc_score
FROM read_parquet('audience_part-*.parquet')
WHERE score = 'high'
ORDER BY perc_score DESC;
-- Unique contacts across all topics
SELECT DISTINCT ON (email) email, first_name, last_name, company_name
FROM read_parquet('audience_part-*.parquet');
Quick Start with Python
import pandas as pd
df = pd.read_parquet('audience_part-0000.parquet')
# High-intent contacts with company data
leads = df[(df['score'] == 'high') & (df['company_name'].notna())]
leads[['first_name', 'last_name', 'email', 'company_name', 'job_title', 'perc_score']]
Text fields are lowercase. Names, addresses, industries, and most string values are stored in lowercase. Apply your own casing for display.
Boolean-like values are strings. Fields like has_children, is_homeowner, and is_married return "y" / "n" (not true / false). is_email_business and is_email_personal return "true" / "false".
JSON fields are stringified.education_history is JSON encoded as a string. Parse it in your application.
Null fields appear as null. If a field has no value for a given row, it will be null in the parquet file. Handle missing values in your code.
Dates use ISO 8601.ts is a timestamp. Date-only fields use YYYY-MM-DD.
