Using Clay formulas for data cleaning

All demos from “101 Tutorial for Clay.com -- 2024 Beginner's Guide”

1. 1:534:36Importing leads and setting up a Clay tableShows how to create a new table in Clay by importing a CSV or using built-in sources to start a prospecting list.Clay· Build a list from ICP filters
2. 9:512:40Enriching leads with BuiltWith technographicsDemonstrates using the BuiltWith integration within Clay to identify technologies used by target companies based on their domain.Clay· Append firmographic/technographic data
3. 12:299:23Using Clay formulas for data cleaningCurrentWalks through writing and running formulas to normalize domains and handle conditional logic for data enrichment.Clay· AI account/prospect research
4. 21:493:45Finding contacts at target companiesShows how to use the 'Find People' integration to search for specific titles like Founders or Sales Directors at a list of companies.Clay· Find decision-makers at target accounts
5. 25:324:20Setting up an email waterfall with ProspeoDemonstrates the waterfall enrichment feature to find and verify work emails using multiple providers like Prospeo.Clay· Waterfall enrichment
6. 38:274:23Finding leads based on job postingsDemonstrates how to use Clay to find companies currently hiring for specific roles like Sales Development Representatives.Clay· Funding/hiring triggers
7. Watch “101 Tutorial for Clay.com -- 2024 Beginner's Guide” →

AI account/prospect research

Clay12Outreach12Salesloft4Pipedrive3Instantly2ZoomInfo2Apollo1GoHighLevel1

1. 2:541:17Researching negative Glassdoor reviews with Clay AIShows how to use Clay's AI enrichment to search Glassdoor and Indeed for specific negative employee feedback regarding HR processes to use as a sales trigger.@Sales_Feed
2. 4:520:47Extracting structured data from AI research columnsDemonstrates how to define AI outputs to create structured columns (e.g., True/False for turnover) and using formulas to parse AI-generated text.@Sales_Feed
3. 17:227:47AI-powered company research and summarizationDemonstrates using Clay's AI (GPT and Sonet models) to scrape company websites and generate summaries to qualify if a lead is B2B or B2C.@matthewlucero
4. 12:299:23Using Clay formulas for data cleaningCurrentWalks through writing and running formulas to normalize domains and handle conditional logic for data enrichment.@ericnowoslawski
5. 26:093:23Scraping company mission statements with AIShows how to use Clay's web scraper and AI to find and summarize a company's mission statement from their website for research purposes.@matthewlucero
6. 41:235:26Using Claygent for AI web researchWalks through setting up a Claygent (AI Agent) prompt to scrape specific information from LinkedIn profiles or websites automatically.@Tim-Yakubson
7. 4:362:38Using AI Prompts for Persona Research in ClayDemonstrates using Clay's AI prompts to analyze company data and automatically identify target personas like Chief Information Security Officers.@MarkColgan
8. 11:561:19Finding competitors with Claygent AIDemonstrates using Claygent (Clay's AI agent) to browse company websites and identify their top three competitors for use in sales outreach.@OskarMoen
9. 2:582:53AI account research and filtering in ClayThe video shows how to use Clay's AI formulas and text scrapers to identify if companies are running Facebook ads and to filter them based on specific business criteria.@heyreach
10. 5:401:49Data manipulation and research with Clay AIShows how to use natural language instructions to manipulate data and perform research tasks within the Clay table.@matthewlucero
11. 13:524:44Enriching prospect data with ClaygentDemonstration of using Clay and Claygent to find company information, website data, and decision-maker profiles based on a list of prospects.@heyreach
12. 27:374:20Building a prospect dossier with AI agentsA walkthrough of setting up an AI agent in Clay to scrape LinkedIn and web data to find professional achievements and strategic relevance for a lead.@smartleadai