Find out which marketing is really bringing in customers, every Monday — AI Use Case | Ava Digital
← All AI use cases
AI Use Case · Marketing

Find out which marketing is really bringing in customers, every Monday

A weekly email counts new inquiries by the source customers told you (‘Google’, ‘a friend’, ‘Facebook’) and by the source your form captured, and points out where the two disagree.

How it works

  1. Add a required ‘How did you hear about us?’ dropdown to your contact or booking form, and log every inquiry to a Google Sheet with the date, the self-reported answer and the page or UTM source if your form captures it.
  2. Every Monday morning the automation pulls the last 7 days of rows from the sheet.
  3. An AI step groups the rows by source, counts them, notes any source that jumped or dropped versus the prior week, and flags rows where the two sources disagree or the answer is blank.
  4. The summary goes to the owner by email or Slack, with the raw counts table attached.
  5. The owner reviews it, and once a month compares the counts to booked jobs before changing any ad or marketing spend.

The guardrail

The tally is a rough guide built on what customers remember; a person decides any budget change and checks it against booked jobs.

Tools that do this: Google Forms or your website form, Google Sheets, n8n, Zapier or Make, Gmail or Slack, an AI model (Claude or ChatGPT)

Prompt to start with
You write a short weekly lead-source summary for a small business owner. Use only the data below and do the counting carefully.

Business: [business name]
Week: [start date] to [end date]
This week's inquiries (date | self-reported source | captured source or UTM | booked yes/no/unknown):
[paste rows]
Last week's counts by self-reported source: [paste counts, or 'none']

Output:
1. A table of self-reported source with count this week and last week.
2. Two or three plain sentences on what stands out (a source that rose or fell by 2 or more, or most inquiries from one source).
3. A list of rows where self-reported and captured sources disagree or the answer is blank, with the date only.
4. One line: 'Small numbers move a lot week to week; check against booked jobs before changing spend.'
Do not recommend budget changes, do not guess sources for blank rows, and do not invent totals; if there are fewer than 5 inquiries, say the sample is too small to read.
Get a free audit We’ll set this up for your business, end to end.