Daily DevOps Lead Tracking Workbook
Daily DevOps Lead Tracking Workbook
Use this workbook to connect traffic source, consultation intent, and follow-up outcomes so the site is measurable from first click to finished lead.
Need help putting the workbook into practice? Book a strategy call or review the consulting page to map the workbook to a working follow-up process.
Workbook Purpose
The live site already captures UTM parameters, referrers, landing pages, and CTA clicks. This workbook turns those signals into a simple operating record for follow-up and reporting.
Suggested Columns
| Column | Purpose |
|---|---|
lead_id |
Stable internal identifier for the inquiry. |
submitted_at |
Timestamp of the submission or booking. |
source |
UTM source or channel. |
medium |
UTM medium. |
campaign |
UTM campaign name. |
content |
UTM content / CTA variant. |
term |
UTM term or search term. |
first_landing_page |
First page seen in the session. |
landing_page |
Page where the conversion happened. |
referrer |
Referring page or domain. |
cta_id |
Stable CTA identifier when applicable. |
form_id |
Contact form identifier when applicable. |
lead_name |
Contact name for follow-up. |
lead_email |
Contact email for follow-up. |
company |
Organization name. |
request_summary |
Short description of the request. |
owner |
Person responsible for the follow-up. |
status |
New, contacted, qualified, won, lost, or nurturing. |
next_step |
Immediate action for the lead. |
outcome |
Final result after follow-up. |
notes |
Internal notes and handoff details. |
CSV Template
The repo includes a starter CSV at docs/templates/lead-tracking-template.csv.
Operating Rules
- Keep the workbook small and current.
- Record the source metadata at the time the lead arrives.
- Do not rely on memory for the follow-up stage.
- Review stalled leads weekly.
- Use the workbook alongside the GA4 events and lead-tracking data flow docs.
Related Pages
- Consulting
- Daily DevOps Content Calendar and Promotion Plan
- Daily DevOps SEO Growth Roadmap
- Lead Tracking Data Flow
Next Step
If you want the full conversion path, start with the consulting page and then use the workbook to track the lead from source to outcome.
Frequently Asked Questions
What should I record first?
Capture the source, landing page, and CTA identifier as soon as the lead arrives. Those fields are the fastest way to keep attribution intact.
Why keep the workbook small?
Small workbooks get used. If the sheet turns into a second CRM, the follow-up process usually gets slower instead of better.
How does this connect to GA4?
The workbook sits alongside the GA4 events so you can match the lead record to the form_submit or cta_click signal that brought it in.
What if the lead comes from a booking link?
Record the booking URL, the first landing page, and the UTM values that were present when the booking happened.