.svg)
%20(1).svg)
Supersearch
Extract City State or Country from Addresses
B2B sales prompt: This prompt standardizes messy location data by extracting the most specific geographic element available from each entry in {{property_1}}. It automatically inspects the address format and returns only the city when city, state, and country are present; only the state when state and country are present; and only the country when that is the sole element. The output is a clean, single-value location label per record, enabling faster segmentation and consistent enrichment.Use this for B2B lead generation, territory mapping, and account routing where precise geo granularity matters for outbound. Sales and marketing teams can filter prospects by city, assign reps by state, or localize messaging by country without manual cleanup. The workflow fits seamlessly into an AI sales research workflow or outbound prompt for prospecting by taking raw CRM exports, web-scraped locations, or list uploads and turning them into standardized geographic fields.Value highlights:- Improves list quality for cold email personalization and geo-targeted campaigns.- Reduces enrichment errors by returning only the most relevant location component.- Speeds up data prep for regional sequences, event invites, and territory-based cadences.- Works well with enrichment pipelines, lead scoring, and routing rules.Data involved includes free-text location strings within {{property_1}} from CRMs, spreadsheets, or scraped profiles. If the original input is in another language, the final description here is in English and the prompt still extracts city, state, or country according to the same rules.
AI Prompt Preview
For each location listed in {{property_1}}, check the format to determine what information is available. If the location contains a city, state, and country, extract and respond with the city. If the address contains a state and country, extract and respond with the state. If the address contains only a country, extract and respond with the country. The response should only include the extracted city, state, or country, depending on what is available in the address, and nothing else.
48,304 runs
.png)
“My template combines personalized messaging with a structured follow-up sequence that has proven to be very successful.”
.svg)
Recommended Prompts
Start building your AI sales engine
Get started now to access exclusive templates and elevate your projects to the next level.
Stop letting poor deliverability kill your pipeline. Join 50,000+ sales teams who've made the switch to Instantly for better inbox placement, higher response rates, and more closed deals.
No credit card required.