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.
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)
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.