How to Normalize Locations/Isolate Just the City or State
Introduction
Utilizing the capabilities of AI and GPT can significantly simplify the process of extracting city names from a company's location, aiding in both lead scoring and personalized email creation. This guide walks you through the steps required to isolate city names from full locations, enhancing your company filtering methods and personalizing your email outreaches.
Procedure
1. OpenAI x Clay
◦ Start by heading to 'Enrich Data' within Clay. Subsequently, select 'AI and GPT'. This will open the interface for your interaction with the GPT.
2. Set Up AI Messages
◦ To obtain the desired output, you need to create two messages. The first message sets the AI's context, stating that it's an assistant required to isolate the city name from the provided location.
◦ The second message, where you act as the user, you provide the location to the AI. Specifically instruct the AI to isolate and provide just the city name from the input location.
3. Input the Company's Location
◦ Retrieve the company's location from the 'Enrich Company' section and use this as the input for the AI. The location typically includes the city and the state.
4. Review the AI's Response
◦ The AI will process the input and generate just the city name from the full location. This city name can then be used for further operations like filtering company data.
5. Utilize the Extracted City Name
◦ Use the isolated city name to filter your company data. For instance, you might want to focus on companies based in a specific city.
◦ Alternatively, you can use the city name to personalize your emails, e.g., "Hey, I saw you are the CEO at [company name]. I actually visited [city] a few years ago and loved it."
Conclusion
Leveraging Clay's AI and GPT integrations can simplify the task of isolating city names from full company locations. This process can enhance your ability to filter company data based on city and to personalize your email outreach, making your interactions more efficient and effective.