Exporting form submissions and running them through AI analysis is a fast, low-effort way to demonstrate lead volume and quality to skeptical clients — and to surface content and keyword opportunities you'd otherwise miss.
The core insight: most clients don't know how many real leads they're getting, or what those leads are worth. A structured analysis turns raw form data into a compelling story.
Upload the CSV to ChatGPT and prompt it to:
gad_source values indicate ad-driven inquiriesExample prompt structure:
Here is a CSV export of contact form submissions from [client] for [date range].
Please:
1. Categorize each entry as: legitimate lead, spam, job inquiry, or internal test
2. Count each category
3. Summarize the top themes and questions in the legitimate leads
4. List any entries that appear to have come from paid ads (look for UTM or gad_source fields)
ChatGPT will produce a categorized table and summary. Typical output for a mid-size senior care client: ~138 legitimate leads, ~28 spam, ~3 job inquiries out of 200 total entries.
Ask a follow-up prompt:
Based on the themes in the legitimate leads, suggest 10 blog post topics
that directly address what these prospects are asking about.
For each topic, include: title, target keywords, recommended word count, and
whether an FAQ section would be appropriate.
Common high-value themes that emerge for senior care clients:
- Availability / "do you have openings?"
- Cost and payment options (Medicaid, private pay, disability)
- Difference between assisted living and memory care
- How to schedule a tour
- What the move-in process looks like
These themes become the basis for a content plan. See [1] for how to publish and promote these posts.
Once you have a legitimate lead count, calculate the potential revenue to reframe the conversation from cost to opportunity:
Monthly revenue per resident × 12 months = annual value per resident
Annual value × number of legitimate leads = total addressable revenue pool
Total pool × 10% conversion = conservative revenue opportunity
Example (Adavacare):
- 138 legitimate inquiries in one year
- ~$6,000/month per resident × 12 = $72,000 annual value
- 138 × $72,000 = ~$10M total pool
- 10% conversion = ~$1M annual revenue opportunity
This reframes the client conversation: the question isn't whether digital marketing is working — it's whether you're capturing your share of existing demand.
Configure Gravity Forms to export automatically or set up a Google Sheets integration so lead data accumulates in a shared sheet. Options:
Deliver a weekly or monthly summary to the client that includes:
- Total inquiries (legitimate vs. spam)
- Top themes / what prospects are asking about
- Which locations or services are generating the most interest
- Source breakdown (organic, ad-driven, direct)
For a more complete picture, pair the form fill analysis with a Google Search Console export:
This reveals the gap between what people are searching for and what the site currently ranks for — and validates the content plan. See [2] for the full GSC workflow.