Draft a hiring funnel report from stage records

A hiring funnel report with stage counts, conversion calculations and data-quality notes.

Choose one of three approaches. The steps for that option appear below.

Choose an option above. On a phone, swipe the tabs left or right to see all options →

Gemini Notebook: builds the event table, drafts the report

Gemini Notebook proposes the event table and the report draft. You correct the table before drafting and check the report.

  1. You

    Choose source data

  2. Gemini Notebook

    Build event table

  3. You

    Check the table

  4. Gemini Notebook

    Draft the report

  5. You

    Check and finish

  1. Choose the source data and check the inputs

    Use: You

    Have ready: the application-stage events, date window, funnel definitions and reporting-group size and complementary-suppression rules. Keep originals locally.

    Check

    Check definitions, suppression rules and control totals are supplied; if not, stop and list what is missing.

  2. Build an event table and input checklist

    Use: Gemini Notebook

    Upload the source data to a Gemini Notebook base chat and ask for an event table and an input checklist.

    Details

    What to paste into the tool

    Task: Draft application-level event table with duplicate and missing-stage flags, source row IDs, effective dates and explicit still-to-confirm entries; Required-input checklist recording supplied and missing definitions, suppression rules and reconciliation totals; Authorized source packet with event row IDs, dates, supplied definitions, counting rules, suppression rules, required control totals or missing-input flags, permitted audience and source dates; Retained original supplied evidence in the authorized local location. Use the cleared source packet only to produce the event table and input checklist; keep the source packet unchanged as a retained attachment reference and the local-originals reference as a label only; list duplicates and missing stages without choosing an inferred resolution. Do not resolve ambiguous event order or missing reporting rules; flag them for the analyst. Use only supplied material and source row IDs; preserve effective dates and entries still to confirm; do not infer protected traits, evaluate named candidates or make causal claims; keep this as preparation only

  3. Check and correct the event table

    Use: You

    Check and correct the event table against the sources; resolve the input gate from the supplied evidence.

    Check

    Trace each row to its source; keep missing-input flags. Check duplicate and missing-stage flags.

  4. Draft the report from the checked table

    Use: Gemini Notebook

    Paste the checked table and rules into the same chat and ask for a reporting draft.

    Details

    What to paste into the tool

    Task: Draft funnel counts, conversion calculations and data notes with source references, formulas, denominators, missing-data counts and unresolved questions; Required-input checklist recording supplied and missing definitions, suppression rules and reconciliation totals; Authorized source packet with event row IDs, dates, supplied definitions, counting rules, suppression rules, required control totals or missing-input flags, permitted audience and source dates; Retained original supplied evidence in the authorized local location. Read the freshly cleared table and supplied rules; state counting definitions, show each conversion formula and its denominator, list missing-data counts and retain row references; apply both suppression rules before showing any table; return the missing-input checklist in place of a report if required inputs are absent; retain the checklist and source packet for review, with the local-originals reference as a label only. Do not resolve missing totals by inference. Use only supplied material and source row IDs; preserve effective dates and entries still to confirm; do not infer protected traits, evaluate named candidates or make causal claims; keep this as preparation only

  5. Recompute the numbers and finish the copy

    Use: You

    Recompute counts and conversions from source rows, correct the draft, keep correction and issue logs, then record the decision and approver.

    Check

    Check denominators, window, event order, missing-data counts and suppression rules; confirm audience and source dates. No communication, account or record change or employment decision; each stays separate.

Before you paste into any AI tool, remove any confidential information. Put it back at the end.

Tools in this workflow

Deciding between ChatGPT and Claude for this? See the comparison.

Final check

Never paste credentials or full payment details.

Check supplied denominator definitions, reporting window, event order and missing-data counts against source rows; recompute counts and conversions; apply the supplied reporting-group size and complementary-suppression rules; record unresolved discrepancies.

If definitions, suppression rules or required control totals are absent, return a missing-input checklist and stop report preparation; withhold unsuppressed output and reconciliation claims.

Retain source references, dates, unresolved facts, correction and issue logs and the permitted audience locally; record human disposition as preparation only.

No external communication, record update, account change, purchase or employment decision is part of these designs.

Check the result against your original inputs. Approve it before sharing or acting.

What still needs checking
  • Whether the organization permits each cleared upload to the chosen account and audience
  • Whether all reporting definitions, suppression rules and required reconciliation totals are supplied; absent required inputs return a missing-input checklist instead of a final report
  • Exact reporting operations, row references and citation coverage need an authorised sample check against original evidence

Share this page