Grassroots Marketing Campaign Data and Map Creation

Job ID: 39513474

Budget: $25 – $50 USD

I am seeking a freelancer to assist with creating a detailed Excel spreadsheet and a Google Map to support a grassroots marketing campaign for my home care business across 11 towns in Central New Jersey.

Deliverables:
1. Excel Spreadsheet:
- One tab per town (11 tabs total) including:
- Census Tract & ZIP Code
- % of Population Age 75+
- % of Population Age 50–65+
- Median Household Income
- Homeownership Rate
- Target Group (Client, Caregiver, or Both)
- Direct Mail Priority (High / Medium / Low)
- Zone Assignment (Zone 1–4)
- Senior Hotspots (e.g., senior centers, churches, libraries, etc.)
- Medical Centers (geriatrics, podiatry, rehab centers)
- Transportation Companies (non-emergency medical transport)
- Events for Seniors happening between July–December 2025.

Each tab should leave 5 blank rows at the bottom for notes.

2. Google Map:
- Highlight all 11 towns divided into Zones 1–4 with different colors.
- Pins for senior hotspots, medical centers, and transportation companies.
- Layers to toggle between: Client-targeted areas, Caregiver-targeted areas, Events, and Hotspot types.

Budget: $35-$50 USD

Timeline: Completion by June 18-19, 2025
Related categories: Data Entry Excel Web Scraping Web Search Data Mining