Enrichment Columns
Census Enrichment makes it easy to enrich Person and Company data with third-party data and sync them to any business apps. The outcome also materializes in your data warehouse.
Census connects with third party data providers like Clearbit (Now Hubspot Breeze), Apollo and others
Challenges with Enrichments CRM-based Enrichments
Enriching first party data, in your data warehouse or CRM systems, with third party data (e.g. company size, address, etc) is challenging for a number of reasons:
Running enrichments directly on CRM eats up your API quota
CRM based enrichments are not easily accessible across other business apps like marketing tools or outreach tools
A single enrichment provider is not sufficient because no single solution has all the correct data
You still have to dance around combining first party data, third party data, and manual edits to make these enrichments useful for personalized campaigns
Historical, enrichment flow includes hitting an API directly on top of a CRM tool, storing it in the CRM tool, sending it to your warehouse, run sql to combine the company or person data, then sync this data back to CRM or marketing automation destinations. Along the way, this leads to race conditions, duplicated records and unnecessary enrichment cost.
Census Enrichment simplifies this entire workflow. With just a few clicks, you can enrich your warehouse (and CRM ) data, combine it seamlessly with your existing datasets, and sync enriched insights to any business app—all in minutes.
Setup Enrichments
To set up enrichments, you can follow our quick start guide.
Once your enrichment is configured, Census will start querying your enrichment service and populating results.
You can immediately start using the new enrichment-powered attributes on your datasets within Census Segments and Syncs. Note that you'll see an indication in syncs and segments if the enrichment is still actively running but data will be backfilled in future sync runs if enrichment data is not immediately available at sync time.
Enrichments is currently supported on Snowflake, Redshift, BigQuery, Databricks, and Postgres with more warehouses coming soon!
Warehouse Writeback
The outcome of Enrichment Columns materializes in your data warehouse under Census Schema. Census Datasets join your enriched columns with your first party data to help you visualize, explore and sync to any destination.
Supported Enrichment Services
Here are the list of services Census currently integrations to provide data enrichment and this list is constantly growing. Looking for a particular service, let us know!
Clearbit
Look up person and company data based on an email or domain. Sync fresh and reliable data across your systems in real time with over 100 attributes on more than 44 million companies and 350 million contacts.
Keep in mind:
Census uses the Clearbit API Secret Key, not the Publishable Key. This should be available in the Clearbit API section.
Enriching does use API credits. Please see your Clearbit Dashboard to track your usage.
Person
id, name.givenName, name.familyName, name.fullName, location, timeZone, utcOffset, geo.city, geo.state, geo.country, geo.lat, geo.lng, bio, site, avatar, employment.name, employment.title, employment.role, employment.subRole, employment.seniority, employment.domain, facebook.handle, github.handle, github.id, github.avatar, github.company, github.blog, github.followers, github.following, twitter.handle, twitter.id, twitter.followers, twitter.following, twitter.location, twitter.site, twitter.statuses, twitter.favorites, twitter.avatar, linkedin.handle, googleplus.handle, fuzzy, emailProvider, indexedAt
Company
domain
id, name, legalName, domain, domainAliases, site.phoneNumbers, site.emailAddresses, tags, category.sector, category.industryGroup, category.industry, category.subIndustry, category.sicCode, category.naicsCode, description, foundedYear, location, timeZone, utcOffset, geo.streetNumber, geo.streetName, geo.subPremise, geo.city, geo.state, geo.stateCode, geo.postalCode, geo.country, geo.countryCode, geo.lat, geo.lng, identifiers.usEIN, metrics.raised, metrics.alexaUsRank, metrics.alexaGlobalRank, metrics.employees, metrics.employeesRange, metrics.marketCap, metrics.annualRevenue, metrics.estimatedAnnualRevenue, metrics.fiscalYearEnd, facebook.handle, linkedin.handle, twitter.handle, twitter.id, twitter.bio, twitter.followers, twitter.following, twitter.location, twitter.site, twitter.avatar, crunchbase.handle, logo, emailProvider, type, phone, tech, techCategories, parent.domain, ultimateParent.domain, indexedAt
Apollo.io (coming soon)
Need help with data enrichment?
having issues with Enrichments or have feedback for us? Contact us via support@getcensus.com or start a conversation with us via the in-app chat.
Last updated