Curt Mfg Store Database Enrichment

Curt Manufacturing needed an updated, enriched database of their retail store network across the US. I was brought on through WeKnow to conduct secondary research and fill in missing data points for each store in the database.

The existing database had store names and partial address/phone data, but was missing critical business intelligence fields. The goal was to build a complete, actionable dataset that could support outreach, partnership development, and market analysis.

For each store in the database, I sourced and verified the following:

Location details: State, city, full address confirmation

Digital presence: Website URL, email address, Facebook page

Brand intelligence: Other brands carried in-store (names and details)

Group affiliation: Whether the store belonged to a larger group, including group name, number of locations, and location names

Key contacts: Owner or store manager name, designation, direct phone number, and email

All data was gathered through secondary research, cross-referencing multiple online sources to verify accuracy. Each entry was validated before submission, and an initial quality check was conducted after the first 10 rows to ensure alignment with the client's expectations.

Work was completed in Google Sheets, with research conducted across company websites, social media profiles, business directories, and public records. Every data point was cross-verified to maintain accuracy and consistency across the dataset.

Enriched 1,202 store records with complete business intelligence data within the 7-day project timeline. Each row was updated across all required data points, giving Curt Mfg a ready-to-use resource for store-level outreach, partnership development, and market analysis.