AArdvark wrote: Fri Jan 10, 2025 6:16 pm
(stares at explanation like a deer in headlights)
Ok. Me go now back to cave, try make fire.
Ok, I'll try harder with a use case.
So I sell to companies who use a particular software (KnowBe4, anti-phishing training) and we can get them a discount on renewals so we need to run a campaign to let them know.
So where do I start? I need a list of KnowBe4 customers, which can be tough because its in security so very close to chest. But I know that there is a review site called G2 that incentivises users of that software to rate it and verifies that they do in fact use it. The problem is the reviews only give First Name, Last Initial, and Job Title. What do I do with that?
For like the last 20 years I would have gone through the reviews one by one, lookup in Google, grab the most likely Linkedin Profile (or other website if that doesn't come up) then no matter which type of website determine the company associated with the name searched and pop it in a spreadsheet.
Well, now cuz the magic that is AI, I have one tool that automatically "Scrapes" G2 for the names and titles and then upload to a "Table" which I built in Clay. The table has one column that automatically pulls in the first (10 actually) google results. Another column cleans a few odd characters off the end of the link. The next one is the AI Enhance function where you literally tell it in plain english what you want it to do and then it does that for each row.
In this case I instructed it to first determine whether the link was a linkedin profile or not, if so then output the current employer, if not then review whatever website comes up and determine the company of the person most closely matching the searched name.
A project that manually done would have taken days to pull off is done in seconds after a mere 30 minutes designing the table.
Marvelous Maching.
