Your Gemini Entreprise Prompt Playbook for ACERO

ACERO × Gemini — Prompt Playbook
ACERO × Google Workspace AI

Your Gemini Enterprise
Prompt Playbook for ACERO

Real prompts for real ACERO work. Built from your team's actual workflows — advisors, SEPO, BI, delivery. Copy, customize, and go.

4Prompt blocks
45Ready prompts
4Role tracks
P

Persona

Give Gemini a role. It shapes tone, depth, and how it frames every answer.

Act as a senior production advisor reviewing a cost estimate...
T

Task

State exactly what you need. One specific action — not a vague request.

Draft a SEPO initiation email for Project ID #2045...
C

Context

The background that shapes the output. Client, project type, constraints.

...Google account, stamped estimate attached, cost-plus pricing applies.
F

Format

Tell it how to deliver. Table, bullet list, paragraph, email with subject.

Format as a short email with subject line and bullet callouts.
● Concise

One request per prompt

Packing five questions in one message gets five mediocre answers.

❌ "Help with the SEPO stuff + report + this email" ✅ "Draft SEPO initiation email for project 2045."
● Clear

No vague asks

"Make this better" sends Gemini in 10 directions at once.

❌ "Make this email better" ✅ "Shorten to 3 bullets. Professional tone."
● Consistent

Same word, whole chat

Call it "estimate" throughout. Switching to "doc" or "file" mid-chat confuses context.

Pick one term per concept and stick with it. Always.

⚡ Keep these handy

Step by step"Think step-by-step."
Devil's advocate"What's the strongest counterargument here?"
Critique"Critique this from the POV of [role]."
Alternatives"Give me 3 different versions of this."
Hard constraint"Focus only on [X]. Do not mention [Y]."
Clarify first"Ask me any questions before you start."
Expand"Elaborate on point 2 with specific examples."
Audience"Write this for [audience]. Tone: [tone]."
🔍
Filter:
📧

Write the SEPO initiation email

That email you draft every time a project is ready for data entry. Ten minutes you shouldn't be spending.

Advisor Quick win
The situationEstimate is stamped. Now you need to notify SEPO with the project ID, job folder link, and any callouts specific to this account. Drafting it from scratch every time costs 10+ minutes per project.
Prompt — paste into Gemini
Act as a production coordinator at a media ad agency. Draft a data entry initiation email to the SEPO team. Project details: - Project ID: [Project ID] - Client/Account: [Client name, e.g. Google] - Estimate type: [Original / Revision / Actualization] - Job folder: [Paste Google Drive link] - Key callouts: [e.g. "vendor X is always preferred" / "cost-plus pricing applies" / "endorsed stamp = standard review"] Format: Short email with subject line. Professional but friendly. Bullet list for callouts only.
Start a new chat for each project. Mixing projects in one conversation makes Gemini pull in wrong details from earlier in the thread.
💰

Write up the savings module entry

You helped reduce vendor cost. Now you need to document it clearly so BI can validate it without sending it back.

Advisor Quick win
The situationThe savings module is the most common source of BI validation errors — it gets left blank, or the notes are missing the backup documents that prove the numbers. Eugene and Stephanie both flagged it. Gemini can help you write entries that pass validation the first time.
Prompt
I'm writing up a savings entry for a production project and need to make sure it's documented well enough to pass BI validation. Here's what happened: - Type of saving: [e.g. Vendor rate negotiation / Scope reduction / Rebid] - Original cost: [$X] - Final cost: [$Y] - How I achieved it: [Brief description, e.g. "Renegotiated director day rate from $X to $Y by presenting competing bids"] - Backup documents available: [e.g. Version 1 estimate + Version 2 estimate / Competing bid documents] Write a clear savings note I can paste into the savings module. It should: (1) state the saving amount, (2) explain what type of saving it is, (3) reference which documents validate the numbers. Under 80 words.
BI validates savings by looking for two documents: the original and the revised estimate. Mention both in your notes so Stephanie doesn't have to email you asking for them.
🎯

Answer a client question with data instead of intuition

Advisors answer 80% of client questions on intuition. Gemini can help you find what the data actually says first.

Advisor Prompt chain
The situationNoah put it directly: "I'd say 80% of my answers are intuition-based." That's not a bad thing — it's informed intuition. But when a client asks a specific question about cost benchmarks or director rates, Gemini can help you think through what supporting data you might have and how to frame a data-backed response.
Prompt 1 — Figure out what you actually know
A client asked me this question: "[Paste the question]" My intuitive answer is: [What you'd normally say] Help me think through: (1) what data or evidence would make this answer more credible, (2) what questions I should ask myself before responding, (3) how to frame my answer if I have partial data but not a complete picture. I want to be honest with the client about what I know vs. what I'm estimating.
then in the same chat
Prompt 2 — Draft the actual response to the client
Using the framing above, draft a 3-4 sentence response I can send to the client. Be direct. Acknowledge where I'm drawing on experience vs. hard data. Don't oversell the certainty. Tone: confident but honest.

Pre-close checklist before marking a project complete

That "pre-flight" button everyone wished existed — built with a prompt instead.

Advisor Prompt chain
The situationKathy asked for it directly: "Is there a button you can press before closing a project that reviews everything and says 'hey, over here it says this — double-check these things?'" This prompt gets you to the same place.
Prompt 1 — Build your review list
Act as a quality control advisor at a production management agency. I'm about to close a project. Client: [Client name] Project type: [e.g. Film / Stills / Events / Digital] Modules completed by SEPO: [e.g. estimates, bids, deliverables, shoots] Modules I'm responsible for: [e.g. savings, GAFFY fee validation] Create a structured pre-close checklist grouped by module. Flag which fields are most likely to cause downstream BI validation errors if left blank or wrong.
then in the same chat
Prompt 2 — Prioritize discrepancies you found
I reviewed the project and found these issues: [e.g. "Savings module blank" / "Vendor marked non-preferred but client profile says always preferred" / "Bid totals don't match estimates module"] Which of these is most likely to break the BI report downstream? List them in priority order with a one-line reason for each.
📖

Summarize a client profile into quick-reference rules

Client profiles are dense Word docs. Get the rules that matter in 30 seconds.

Advisor SEPO
The situationGoogle, McDonald's, and every other account has a client profile or playbook with rules for SEPO. These docs are long, inconsistently formatted, and often not updated. Gemini reads them and extracts what matters.
Prompt — attach the client profile doc
I'm uploading a client profile for [Client name]. Extract the content into these sections: 1. Vendor rules (always preferred / never use / conditional) 2. Stamp/estimate type rules (what each means for data entry) 3. Module-specific rules (which modules apply and how to complete them) 4. Fee rules (e.g. GAFFY, cost-plus, agency fee specifics) 5. Any unclear or contradictory instructions (flag for advisor review) Format: numbered list under each section. Plain language. Flag anything that seems outdated or contradictory.
Attach the Word doc directly in Gemini. You don't need to copy-paste anything.
📝

Write the "I need something from you" note to the advisor

Flag a pending field without sending a one-liner that gets ignored for three weeks.

SEPO Quick win
The situationDuring data entry you hit a field you can't answer. The project stalls. When your note back to the advisor is vague, it sits unresolved for months. This prompt produces a note that's specific enough to get a same-day answer.
Prompt
I'm a data entry specialist completing a project and need to flag pending items to the advisor. Project ID: [Project ID] What I completed: [Brief summary of what you entered] Fields I left pending (and why): - [Field name]: [Reason, e.g. "Savings module — no savings data in job folder" / "Vendor preference — stamp says endorsed but client profile doesn't have a rule for this stamp type"] Write a professional note under 150 words that: (1) confirms what I completed, (2) lists pending items with a clear reason for each, (3) tells the advisor exactly what I need from them. No blame language. Specific enough that they can reply without asking a follow-up question.
🔎

GAFFY fee validation — prepare the field-by-field check

The Google Agency Fee process where SEPO goes field-by-field to validate. Get ready before you open the tracker.

SEPO Advisor
The situationKathy called GAFFY "the biggest win" — but the validation process is convoluted. SEPO gets an automated email saying projects are "ready for validation," then goes field-by-field. This prompt helps you prep a structured check before opening the tracker.
Prompt
I'm about to validate Google Agency Fee (GAFFY) entries for the following projects. Help me prepare a structured validation approach. Number of projects to validate: [number] What I'm checking: [e.g. fee percentages, project IDs, estimates match, correct fee category applied] Common errors I've seen before: [e.g. wrong fee tier selected / fee applied to wrong estimate version / missing documentation] Create a short field-by-field validation checklist I can use for each project. Format as a table: Field | What to check | Common error to watch for. Keep it to the most important fields only — I need to move quickly.
Run through this checklist before touching the tracker. Catching errors mentally first means fewer corrections mid-validation.
📊

Write a validation findings note (and fix the tone)

Julie said it plainly — that "rejection email" name is contentious. Write findings notes that fix problems without starting fights.

BI Team Quick win
The situationStephanie validates estimates, bids, savings, shoots, and deliverables. When she finds issues, she sends an email. Independent contractors sometimes push back, saying "it's not my job to check third-party data entry." The note's tone matters. This prompt writes a clear, neutral findings message that focuses on the fix, not blame.
Prompt
Act as a BI analyst at a media production company. I completed a data validation pass and found discrepancies I need to communicate to the advisor. Client: [Client name] Report period: [e.g. Q1 2026] Issues found: - [Issue 1: e.g. "Project 2045 — savings module has no backup documents"] - [Issue 2: e.g. "Project 2089 — bid totals don't match estimate figures"] - [Issue 3: e.g. "Project 2103 — savings entry references a document not in the job folder"] Write a concise validation findings note. Include: (1) what I reviewed, (2) specific issues with project IDs, (3) exactly what I need from the advisor to resolve each issue, (4) a suggested deadline. Tone: factual, collaborative, zero blame language. This is a "data quality check" note, not a rejection.
Try replacing "rejection" with "data quality check" everywhere. Gemini can help you rewrite your email templates with neutral language if the current ones are causing friction.
📈

Write the quarterly report narrative

Tableau is ready. The PowerPoint template is downloaded. Now write the story that goes with the numbers.

BI Team Advisor Prompt chain
The situationStephanie builds the Tableau template quarterly, exports to PowerPoint, and delivers to the client team. The data is there — but turning numbers into a client-facing story always gets rushed. This prompt writes that story in minutes.
Prompt 1 — Executive summary
Act as a business insights analyst presenting quarterly performance to a marketing client. Client: [Client name] Period: [e.g. Q1 2026] Key metrics: - Total production spend: [$X] - Cost savings vs estimate: [$Y] - Bids reviewed: [number] - Any notable trends: [e.g. "Shoot costs up 12% vs prior quarter" / "Savings rate improved"] Write a 2-paragraph executive summary to open the quarterly presentation. Lead with the most important finding. Tone: data-driven, confident, client-friendly. No jargon.
then in the same chat
Prompt 2 — "What's next" recommendations slide
Based on those findings, draft 3 forward-looking recommendations for next quarter. Each must: (1) reference a specific finding, (2) suggest one concrete action, (3) state the expected outcome. Format as a slide — brief headline + 2-sentence explanation per recommendation.

Handle "can you pull this?" without the back-and-forth

Someone sends you a vague data request. Clarify what you actually need before you start pulling anything.

BI Team Quick win
The situationStephanie's first question is always "when do you need this by?" — but before even that, you need to know what they're actually asking for. This prompt helps you draft a reply that gets everything you need in one exchange.
Prompt
I'm a BI analyst and received this data request: "[Paste the request exactly as received]" Help me: (1) identify the 3-4 clarifying questions I need answered before starting (deadline, data scope, format needed, purpose/audience for the output), (2) draft a short reply asking those questions. Tone: friendly, collaborative, not unhelpful. Under 100 words for the reply.
🔬

Explain why benchmark data can't go in a report

The constraints exist. Explaining them without a five-paragraph lecture is the hard part.

BI Team Quick win
The situationAggregated insight dashboard data isn't always publishable. Minimum 3 clients, enough data points, Google can't exceed 33% of any benchmark. Eugene and Stephanie navigate this regularly. This prompt gets a clear 2-3 sentence explanation to an account team without the full rules lecture.
Prompt
Write a clear, 2-3 sentence explanation for an account team explaining why a specific data point from our insights dashboard cannot be used in their client report. Reason: [e.g. "Only 2 clients contribute to this segment — below our minimum of 3" / "Google represents more than 33% of the data in this benchmark, which violates our data-sharing constraints"] The explanation should: (1) state the data is unavailable for reporting, (2) give the reason simply, (3) suggest an alternative (e.g. "you can use this internally but not in a published report" / "try filtering for a broader region where you have more data points"). Tone: direct, no jargon, no apology language.
🎙️

Turn a meeting transcript into action items

45 minutes of transcript → clean next steps in under 2 minutes. Works for client calls, workshops, or internal meetings.

Advisor BI Team Delivery Prompt chain
The situationEvery workshop and client call produces a pile of decisions, follow-ups, and open questions. They live in someone's notes until the next meeting. Gemini can read the transcript and extract exactly what you need — even Google Meet transcripts.
Prompt 1 — Attach your transcript
Acting as a senior project manager, generate a structured report from the attached meeting transcript. Include these sections: 1. Meeting summary (3 sentences max) 2. Decisions made (what was agreed) 3. Action items — format as: [Owner] → [Task] → [Deadline if mentioned] 4. Open questions still needing answers 5. Information or data that was requested Format: bold section headers. Action items as a numbered list.
then in the same chat
Prompt 2 — Turn into a follow-up email
Using the action items above, draft a follow-up email to send to the full team. Recipients: [e.g. Client team + internal team] Tone: professional, direct. Include: subject line, brief recap (2 sentences), numbered action item list, note on open questions still pending, next meeting date if it came up.
🗂️

Document a process that lives in people's heads

The way it works: someone trains someone else verbally. Then that person leaves. This prompt captures it before it's gone.

Delivery Prompt chain
The situationTori confirmed it: "There's essentially no standardization and no guardrails." Kathy has been carrying the institutional knowledge for 17 years. When Sarah says "it takes two years to really get it" — that's not onboarding, that's tribal knowledge transfer. This prompt changes that.
Prompt 1 — Brain-dump the process
I'm going to describe a work process in rough, conversational terms. Reorganize it into a clear, numbered step-by-step workflow document. Process name: [e.g. "SEPO Data Entry Initiation" / "Advisor Project Close-Out"] Who does it: [Role] Trigger: [What starts this process] Here's the process as I know it: [Describe it however it comes out — Gemini will clean it up] After I finish, organize this into: (1) numbered steps, (2) who owns each step, (3) what system or tool is used, (4) common mistakes to avoid, (5) decisions that vary by account or advisor.
then in the same chat
Prompt 2 — Find the gaps
Review this process document. What steps are unclear? What would confuse someone doing this for the first time? What decisions have no clear rule? List every gap — I'll go fill them in before sharing with the team.
Add "Please ask me any clarifying questions before you organize this" to get Gemini to flag what it needs before it starts writing.
🚀

Create an onboarding guide for a new advisor on an account

Right now it's "talk to your managing advisor and figure it out." Replace that with something they can actually use.

Delivery SEPO
The situationTori said it clearly: "We do a very minimal onboarding, and all we say is: talk to your client team to understand the nuance." There's no gold-standard process. Advisors want to do it right — Kathy confirmed that — they just haven't been told how. This prompt builds the thing that should exist.
Prompt
I need to create a quick-start onboarding guide for a new advisor joining the [Client name] account team. What I know about this account: - Key SEPO rules: [e.g. stamp types and what they mean, vendor rules] - Data entry specifics: [e.g. modules they care about, typical project types] - Common mistakes new advisors make: [e.g. missing savings documentation, wrong fee category] - Who to contact for questions: [Names/roles] - Tools and folders they need access to: [Google Drive structure, tracker locations] Create a one-page quick-start guide with: (1) "First week" checklist, (2) key rules at a glance, (3) who to ask for what, (4) the 5 most common mistakes and how to avoid them. Keep it scannable — no paragraphs over 3 sentences.
📋

Open a team status meeting with a verbal tracker summary

Screen's up, tracker is loaded. Turn the data into a 30-second spoken summary before you start going row by row.

Advisor SEPO Delivery Quick win
The situationThe Google team pulls up the tracker in their weekly meeting. Projects are filtered by advisor, quarter, status. Tori described it: "they can sort by spend, savings, pending." This prompt gives you the opening sentence that sets the room's attention before you start drilling down.
Prompt
I'm running a team project status meeting. Here's a snapshot of our tracker: Total projects: [number] Completed: [number] Pending advisor response: [number] In progress with SEPO: [number] On hold / flagged: [number + brief reason if known] Items needing a decision today: [List any specific projects] Write a 3-sentence verbal status update to open the meeting. Follow it with a bulleted list of the top 2-3 items the group needs to decide or act on today. Format: spoken summary paragraph → action bullets.
💡

Brainstorm solutions to a workflow problem

Something is slow, manual, or broken. Think through the options before you bring a fix to the team.

Delivery Advisor BI Team Prompt chain
The situationRussell said it: "There are a lot of manual steps we need to automate." Projects sit pending for months. Validation is done by people who shouldn't be doing it. BI is triple-checking data entry instead of analyzing. This prompt helps you map options before you propose anything.
Prompt 1 — Map the options
Act as my business advisor. I work at a media production management company and want to solve this workflow problem: Problem: [Describe it plainly — e.g. "Projects submitted to SEPO sit pending for months with no visibility. Advisors don't follow up because there's no in-system status tracking. SEPO has a spreadsheet tracker but it's not connected to the main platform."] Constraints: [What can't change — e.g. "Must work within Google Workspace. No major platform rebuild. Low developer hours available."] Give me 3 approaches to fix this. For each: (1) describe the solution, (2) effort level (low/medium/high), (3) main risk or limitation.
then in the same chat
Prompt 2 — Build a this-week action plan
I want to test option [#]. What 3-5 steps can I take this week to pilot it? Assign one owner per step. Format as a simple numbered task list.
🎫

Write a clear admin request so it gets done in one pass

Adding a vendor, user, campaign, or agency contact? Write it so SEPO doesn't have to ask a follow-up question.

SEPO Delivery Quick win
The situationSEPO handles more than data entry. They add vendors, agencies, users, campaigns, venues, and ticket items. When these requests come in by email with missing info, they bounce back. One structured request means one pass and done.
Prompt
Write a structured admin request message for this system update: Request type: [e.g. Add new vendor / Add new user / Update campaign / Add agency contact / Add venue] What's needed: [Plain language description] Details: [Name, ID, contact, account, category, or whatever applies] Why it's needed: [Brief context] Urgency: [Deadline or "no rush"] Format: Subject line, Request type, Details as bullet list, Urgency note. Under 120 words.
🎯

Prep for a client presentation from scratch

48 hours before the call. Use Gemini to structure your thinking before you open a single slide.

Advisor Delivery Prompt chain
The situationYou know what you want to cover. Getting it into a tight narrative takes more time than it should. Gemini can go from bullet points in your head to a structured story arc in minutes — and then stress-test it against the hardest questions a client might ask.
Prompt 1 — Pick a structure
I'm preparing a presentation on [topic, e.g. Q1 production performance review]. My goal: [e.g. show Google their cost savings and flag two projects that need scope decisions]. Audience: [e.g. Google client team — 5 senior marketing managers] Time available: [e.g. 30 minutes] Give me 3 different ways to structure this. For each structure: what it leads with, what it risks leaving out.
then in the same chat
Prompt 2 — Stress-test it
I'm going with structure [#]. Now act as a skeptical client at this meeting. What are the 3 hardest questions they're likely to ask? For each question, suggest how I should respond.
The "act as a skeptical [role]" pattern is one of the most useful in any prep scenario. It surfaces the pushback you haven't thought of yet.
🛡️

Write data quality rules for a specific account or module

The rules exist in people's heads, in Word docs, and in spreadsheets. Turn them into something that can actually be shared.

Delivery BI Team
The situationTori said it clearly: "There's nothing in-application that prevents things from going off the rails." The rules aren't enforced — they're taught by word of mouth. Eugene wants the data quality process moved out of BI and closer to where errors are made. This prompt captures the rules as a structured document that can be shared and enforced.
Prompt
I need to document data quality rules for a specific module so they can be shared with advisors and SEPO. Module: [e.g. Savings / Estimates / Bids / Deliverables / Shoots / GAFFY] Account: [e.g. Google / All accounts] Rules I know: [List them however you know them — Gemini will organize] Common errors I see repeatedly: [List them] What "good" looks like: [Describe a correctly completed entry] Organize this into a data quality rule sheet with: (1) required fields and what goes in each, (2) conditional rules (if X then Y), (3) common errors and how to catch them, (4) what to do if you're not sure. Format as a table where possible.
💼

Build a production value story for a new business pitch

Russell's goal: close more clients with data. Use your aggregate insights to build the "why us" narrative.

Delivery Advisor Prompt chain
The situationRussell said it: "I could close four customers if I had the data to back up what I'm saying." APR is pivoting to being a data-proven company. The benchmark data exists — turning it into a compelling pitch narrative is where Gemini earns its keep.
Prompt 1 — Build the value narrative
Act as a business development consultant for a production management company. I'm building a pitch narrative to show a prospective client the value of working with us. Prospect type: [e.g. Global brand with large production budgets / Regional marketing team scaling production] Data I have to back this up: [e.g. "Average 12% cost savings vs estimate across clients" / "Rebid success rate" / "Average time from estimate to production close"] What makes us different: [Your differentiators — data, SEPO program, benchmarks, etc.] Draft a 3-paragraph pitch narrative that leads with a client pain point, introduces our solution with specific data, and ends with a clear value statement. Tone: confident, data-backed, not salesy.
then in the same chat
Prompt 2 — Turn it into a 3-slide structure
Turn that narrative into a 3-slide structure for a new business deck. For each slide: (1) slide title, (2) 2-3 key points, (3) what visual or data point would go here. Format as a simple outline.
📊

Compare multiple bids and prepare a negotiation position

You have two or three bids back. Before the bid treatment meeting, build your comparison and know your position.

Advisor Prompt chain
The situationRussell was explicit: the bidding stage is where the vast majority of APR's work happens. Round one, round two — comparing bids and negotiating is the core job. The time between receiving bids and the award meeting is short, and that pressure is exactly why clients skip competitive bidding altogether. This prompt builds the comparison before you're in the room.
Prompt 1 — Build the comparison
Act as a production cost advisor. I've received multiple bids for a project and need to compare them before the bid treatment meeting. Project type: [e.g. TVC / Stills / Digital / Events] Client: [Client name] Bids received: [Number of bids] Bid summaries: - Bid 1 ([Company name]): Total [$X]. Key line items: [Director rate, shoot days, post, etc.] - Bid 2 ([Company name]): Total [$Y]. Key line items: [Director rate, shoot days, post, etc.] - Bid 3 ([Company name]): Total [$Z]. Key line items: [Director rate, shoot days, post, etc.] Create a comparison table: Bid | Total | Key variance items | What stands out (high/low vs expected). Then write a 2-sentence summary of where the biggest cost differences are.
then in the same chat
Prompt 2 — Build the negotiation argument
Based on this comparison, help me prepare for the negotiation. The preferred bid is [Bid #] but the client's budget ceiling is [$X]. What are the 3 strongest arguments I can use to negotiate down the cost? What should I ask them to reduce first without affecting the creative? Keep each argument to 2 sentences.
Russell's rule: don't stamp the estimate until after the award meeting — changes can happen in the room. Keep this chat open through the meeting.
🎬

Research a director and prepare a recommendation for the client

Noah's exact use case — a client is choosing between directors and you need to give them confidence in a choice.

Advisor Quick win
The situationNoah said it: "A client was waffling between directors. I said I was on a shoot with this director with another client a year ago — you're going to be very happy with this choice. They thanked me enormously afterward." That recommendation came from having access to the information. This prompt helps you write that recommendation in a way that makes the client feel confident.
Prompt
I need to write a director recommendation for a client who is choosing between two options. Client: [Client name] Project type: [e.g. brand film / TVC / stills campaign] Director being recommended: [Name] Why I'm recommending them (my notes): [What I know — past projects, experience, style, any firsthand insight] Alternative director being considered: [Name and any relevant context] Client's concerns or priorities: [e.g. "They want someone who's worked with their category before" / "Budget is tight so they want predictability"] Write a 3-4 sentence director recommendation I can include in an email or present verbally. Lead with the strongest reason. Sound confident, not salesy. End with what specifically makes this the right choice for this brief.
🛡️

Build an audit-ready project folder checklist

Julie's team spent 200 hours hunting documents during a PwC audit. This prompt builds the checklist that prevents that.

Advisor Delivery
The situationJulie: "Audit trail is everything for me. When I was audited last summer by PwC, we dropped 200 hours finding everything. It was a huge drain, a huge expense, and a lot of stress." The documents exist — they're just not consistently filed. This prompt produces a project-specific checklist of what must be in the folder before you close.
Prompt
Act as a production compliance advisor. I need to build an audit-ready folder checklist for a completed project. Client: [Client name] Project type: [e.g. TVC / Stills / Events / Digital] Audit requirements I know about: [e.g. "L'Oreal requires 15%+ savings documented" / "Single bid waivers must be in the root folder" / "All estimate versions must be retained"] Scope of work: [Brief description] Create a folder checklist grouped by document type: (1) Estimates and bid documents, (2) Savings evidence, (3) Vendor contracts and approvals, (4) Compliance documents (waivers, approvals), (5) Correspondence. For each item, note: required or recommended, and where it should live in the folder structure. Flag anything that's commonly missing.
Julie's rule: single bid waivers should be in the top 5 folders of the parent directory — not buried in a subfolder. Use this checklist before you close any L'Oreal or high-compliance account project.
🔍

"Do I believe this data?" — sanity-check a suspicious number

Julie pulls data from Acero and 40% of the time she can't trust it. This prompt helps you investigate before it goes to a client.

Advisor BI Team
The situationJulie: "I look up a director's rate and I think — how did this possibly happen? I keep digging and find they put in the director's travel, location scout day, and who knows what else into the day rate. The rate was hyperinflated. I can't present that to my clients." She said 40% of the time she has to kick data back. This prompt helps you investigate the anomaly systematically.
Prompt
I'm reviewing a data point from our production management system and something looks off. Help me think through whether this number is reliable before I share it with a client. The data point: [e.g. "Director day rate of $X for a TVC in Los Angeles"] Why it looks suspicious: [e.g. "It's 3x higher than what I'd expect for this director category"] What I know about the project: [Any context — project type, client, year, scope] Give me: (1) a list of likely reasons this number could be inflated or wrong (e.g. line items rolled up incorrectly, wrong category selected), (2) what I should check in the source documents to verify it, (3) how to explain to the client that I'm validating the data before sharing it — in one sentence, no alarm language.
📋

Draft or respond to an RFP for integrated / non-traditional production

Beyond broadcast — RFPs for influencer, events, activations, print, 360. Abbe and Julie's world.

Advisor Delivery Prompt chain
The situationAbbe and Julie flagged it directly: "RFPs are huge. It could be a supplier RFP, an influencer RFP, an events and activation RFP for third-party vendors." The platform was built for broadcast production. For everything else — influencer, print, events, 360 — there's no standard workflow. This prompt helps you structure the work that doesn't fit neatly into traditional modules.
Prompt 1 — Structure the RFP scope
Act as a production management advisor specializing in integrated and non-traditional production. I need to structure a response to an RFP. Client: [Client name] RFP type: [e.g. Influencer program / Events and activations / Supplier RFP / Print and below-the-line / 360 integrated] What they're asking for: [Paste or summarize the brief] Our relevant experience: [What we've done in this space] Key differentiator we want to lead with: [e.g. data-backed savings / SEPO program / benchmark access] Outline the structure for our RFP response: section headings, what to cover in each section, and what to include as evidence or appendices. Keep it to 5-6 sections maximum.
then in the same chat
Prompt 2 — Write the executive summary section
Write the executive summary section of this RFP response. 2-3 paragraphs. Lead with the client's problem, then our solution, then why us. Tone: confident, specific, not generic. Avoid buzzwords like "seamless" or "end-to-end."
📦

Reconcile deliverables at project close

Noah entered 156 deliverables at award. By close, most had changed. This prompt helps you reconcile what was planned vs. what actually shipped.

Advisor BI Team
The situationNoah: "Why am I entering deliverables at the award when by the end of the project they've completely changed? Going through 156 items and manually figuring out what needs to change is a near impossible task." Abbe added: "Brands start with a set of assets they want — by post-production it's changed radically." This prompt builds a structured reconciliation so the close data is actually accurate.
Prompt
I need to reconcile the deliverables for a completed project. What was entered at award has changed significantly by post-production. Project: [Project name / ID] Client: [Client name] Deliverables entered at award: [Paste list or describe — e.g. "3x 30sec TVCs, 2x 15sec cut-downs, 5x social assets"] What actually delivered (from completion report / agency): [Paste or describe actual output] Do the following: (1) create a reconciliation table showing Original vs. Final vs. Status (added / removed / changed / unchanged), (2) flag anything that was planned but not delivered, (3) flag anything delivered that wasn't in the original scope, (4) write a 2-sentence note I can add to the project record explaining the changes. Format the table cleanly — I may paste it into a report.
If the agency hasn't sent a completion report, use the prompt below (Prompt 27) to request one first.
📬

Request a completion report from the agency

Abbe: "More often than not we don't get the completion report." Write the ask so it actually gets answered.

Advisor Delivery Quick win
The situationAbbe: "We ask the agency to define and put in all of the assets they actually delivered. Sometimes we get it — more often than not we don't." Without the completion report, you can't reconcile deliverables, validate cost per asset, or close the project accurately. This prompt writes the request so it's specific enough to get a complete response.
Prompt
Write an email to an agency contact requesting a production completion report for a finished project. Project: [Project name] Client: [Client name] Agency contact: [Name / role] What I need confirmed: [e.g. final list of all assets delivered / trafficking destinations (paid vs organic) / any scope changes from original brief] Deadline: [Date or "end of week"] Format: short email with subject line. Include a clear list of exactly what information I need — formatted so they can respond point by point. Friendly but specific. Under 150 words.
🗂️

Map client tier requirements for workflow and data entry

Julie's framework: L'Oreal needs audit trail + 15% savings. PepsiCo doesn't care about either. Build the tier map so everyone knows what's required per account.

Delivery Advisor
The situationJulie said it directly: "Not everybody needs the same workflow. Otherwise you're overcontributing and wasting time. Some clients are Tier 1 — full audit trail, strict savings targets. Others are Tier 3 — minimal documentation, the advisor just needs to be on set." Right now these rules live in Word docs or people's heads. This prompt builds the tier map.
Prompt
I need to create a client tier framework that maps each account to its workflow and data entry requirements. Clients to map: [List clients with any notes you have, e.g.:] - L'Oreal: audit trail critical, 15%+ savings target required, full documentation - PepsiCo: advisor presence on set is priority, savings less critical, lighter documentation - Google: specific data fields required, GAFFY fee validation, strict module completion - [Add others] Organize these into 3 tiers: Tier 1 (full workflow, strict documentation), Tier 2 (standard workflow, moderate documentation), Tier 3 (lightweight workflow, advisor-led). For each tier, define: (1) required modules to complete, (2) documentation required before close, (3) savings documentation level, (4) SEPO involvement level. Format as a table.
Once built, share this with SEPO so they know what's required per account without needing to ask the advisor every time.
📁

Create a standard folder structure template for job folders

Noah has a clear structure. Other advisors have 60 folders with 58 empty ones. Build the standard so everyone starts the same way.

Delivery SEPO
The situationNoah: "I have a clear consistent folder structure. But when I tap into a colleague or independent contractor, they'll put new folders in subfolders and won't use anything that exists. Then I have to spend time reorganizing that I don't have." Julie added: "I opened 58 empty folders hunting for one single bid waiver." This prompt builds the template that prevents both problems.
Prompt
Help me design a standard job folder structure for production projects that any advisor or contractor can follow consistently. Project types we run: [e.g. TVC / Stills / Events / Digital / Integrated] Documents that must always be easy to find: [e.g. single bid waiver, stamped estimate, savings evidence, vendor contracts, client approval emails] Our current approach (what exists, even if messy): [Describe or skip if starting fresh] Platform: [Google Drive / OneDrive / Both] Design a folder structure with: (1) top-level folders (max 6 — keep it simple), (2) what goes in each, (3) naming convention for files, (4) which folders must be created at project setup vs. added later. Then write a one-paragraph instruction I can share with contractors explaining the structure and why it matters.
💹

Build a cost-per-deliverable tracking summary

Julie's procurement clients get bonuses based on cost savings APR delivers. This prompt builds the summary that makes those savings visible.

Advisor BI Team Delivery
The situationJulie said it clearly: "The procurement people get bonuses based on the savings APR delivers. It's not just cost per deliverable — it's what was the cost per deliverable before AI and what is it now with AI, because then I can track my savings against my forecast and get a bigger bonus." This prompt builds the before/after tracking summary that tells that story.
Prompt
I need to build a cost-per-deliverable summary for a completed project to show the client their procurement savings. Client: [Client name] Period: [e.g. Q1 2026 / Full year 2025] Projects included: [Number or list] For each project (or in aggregate): - Total deliverables produced: [number and types] - Original estimated cost: [$X] - Final actual cost: [$Y] - Savings achieved: [$Z and/or %] - Key savings drivers: [e.g. bid negotiation, scope reduction, vendor rebid] Create: (1) a cost-per-deliverable table (deliverable type | estimated cost | actual cost | savings), (2) a 2-sentence executive summary of the savings story, (3) a one-line client-facing statement they can use internally to report on APR's value. Format the table so it can be copied into a PowerPoint slide.
⏸️

Write a project hold notice with expected resume date

There's no "hold" status in Acero. Projects stall with no visibility. This prompt creates the communication that fills that gap.

Advisor SEPO Delivery Quick win
The situationOne of the biggest pain points across every interview: projects sit pending for months with no visibility. There's no hold status in the platform. SEPO doesn't know if a project is stalled or abandoned. Advisors don't always follow up. A hold notice written clearly prevents the confusion and keeps SEPO's tracker accurate.
Prompt
Write a brief project hold notice to send to the SEPO team and any relevant parties. Project ID: [ID] Client: [Client name] Reason for hold: [e.g. "Client has paused the production pending budget approval" / "Estimate revision in progress" / "Awaiting creative brief from agency"] Expected resume date: [Date or "TBD — will update by 2026"] Any actions needed while on hold: [e.g. "No action needed" / "SEPO please do not proceed with data entry until further notice"] Format: Short email or note, subject line included. Under 80 words. Clear, friendly, no unnecessary detail.
🧠

Analyze qualitative project notes to explain a data anomaly

Julie: "I want to run AI on all the qualitative stuff and ask — why did this happen? It doesn't make sense."

BI Team Advisor Prompt chain
The situationJulie puts it perfectly: "I look up a data point and I don't believe it. I go into the project description and project takeaways — they're qualitative. I want to run AI on all of that and say 'why did this happen?'" Gemini can read project notes and help you explain why the numbers look the way they do.
Prompt 1 — Upload notes, ask why
I'm attaching project notes, takeaways, and description fields from a production project. A specific data point looks unusual and I want to understand why. The unusual data point: [e.g. "Director day rate is $X — much higher than expected for this project type"] What I expect it to be: [Your benchmark or instinct] Read through the attached notes and: (1) identify any context that would explain this number, (2) flag any mentions of scope changes, unusual arrangements, or added costs, (3) tell me if the notes justify this figure or if the data looks like an entry error. Give me a plain-language explanation in 3-4 sentences that I could share with a client if needed.
then in the same chat
Prompt 2 — Write the client-facing explanation
Based on that analysis, write a 2-sentence explanation I can include in a report or email to the client explaining why this figure is what it is. Factual, no hedging, no alarm language.
Attach project notes directly in Gemini — you don't need to copy-paste the text. It reads Word docs, PDFs, and Google Docs.
📅

Know which dates to enter — and when

Date fields go unfilled because nobody explains what they mean. This prompt gives you a plain-language guide for every milestone.

Advisor Quick win
The situationEugene put it directly: "The dates are all over the place and they don't mean anything." Fields for project open, bidding start, production kick-off — they either go unfilled or get filled with whatever date someone happens to be clicking. The result: APR can't report on how fast or slow they move. This prompt gives you a cheat sheet so you know exactly what to enter and when.
Prompt
Act as a production workflow trainer. I work at a production consultancy and I need a plain-language reference guide that explains each project milestone date field and when to enter it. Project stages we use: Pre-bid → Bidding → Award → Pre-production → Production → Post-production → Job Wrap For each stage, tell me: 1. What the date represents (what actually happened on that date) 2. When I should enter it (immediately? end of day? only once confirmed?) 3. What NOT to do (common mistakes — e.g. backdating, using today's date as a placeholder) Format as a simple table with three columns. Plain language, no jargon.
Save the output as a sticky note or doc in your job folder. New advisors on your team will thank you for it — Cathy notes onboarding currently gives almost no guidance on this.
🗂️

Run your weekly status check without the babysitting

Twelve brands, a manual Excel tracker, and a weekly call spent asking "is this in Acero yet?" — there's a better way to prep.

Advisor Chain
The situationJulie Lane describes it perfectly: "I have 12 brands, $50 million in spend, and an incredible amount of babysitting. On every weekly status call: 'Did this job award?' 'Yes, two days ago.' 'Then why is it not in Acero?' My monthly report is tied to spend — if I can't track spend every month I could be overdelivering and losing profitability." Gemini can't log into Acero for you, but it can help you structure and prep your weekly chase so it's fast, complete, and doesn't rely on you remembering everything.
Prompt 1 — Build your status template
Act as an account operations manager. I manage multiple brands on one client account and need to run a weekly status check to make sure all awarded jobs are captured in our production tracking system. My current situation: - Number of active brands/projects: [e.g. 12 brands, ~30 active projects] - Team mix: [e.g. mix of staff and independent contractors] - Biggest gap: Jobs that are awarded but not yet entered in the system, missing budget data, or projects that closed without a final entry Create a weekly status check template I can fill in before my status call. Include: (1) jobs to confirm as awarded, (2) jobs missing Acero entry or budget, (3) projects approaching close that need data cleanup, (4) any ICs with outstanding actions. Keep it simple — this should take me 10 minutes to fill, not 30.
then in the same chat
Prompt 2 — Draft the chase message
Based on the template above, draft a short Slack or email message I can send before the status call to the advisors on my team. The message should: list the specific projects that need to be in the system by end of day, be direct but not accusatory, and make it easy to reply with a quick update. Keep it under 100 words.
Paste your current Excel tracker data directly into Gemini. It reads tables well and can help you spot gaps or flag anything that looks stuck.
🤝

Brief an IC on their data responsibilities — without the pushback

"That's not my job." Here's how to set expectations clearly before the doom loop starts.

Advisor Quick win
The situationJulie is direct about this: "The independent contractor says 'I'm not paid to fix third-party mistakes' — and I'm in a doom loop every single month trying to get my data right." The rejection email from BI goes to the IC, the IC pushes back, nothing gets fixed, Julie's monthly report is wrong. The problem usually starts at the briefing stage: ICs are brought on without a clear scope of what "data responsibilities" actually means. Get ahead of it with a written brief.
Prompt
Act as a managing advisor at a production consultancy. I need to write a short, professional brief for an independent contractor joining my account team. The brief should clearly explain their data entry and validation responsibilities so there are no disputes later. Context about this IC engagement: - Account: [Client name] - IC's role: [e.g. Production advisor reviewing bids and shoots] - Data they'll be responsible for: [e.g. savings entries, bid review, deliverable confirmation] - Third-party data entry involved: [Yes/No — e.g. offshore team entering granular line items] Write a 200-word brief that covers: what data they own, what they're responsible for reviewing even if entered by others, what to do when something looks wrong, and the timeline for corrections when BI sends a validation note. Firm but professional tone — this is onboarding documentation, not a complaint.
Send this before the engagement starts, not after the first validation error comes back. The conversation is much easier when expectations are set early.
📝

Write a clean SEPO tracker log entry

The initiation email arrives. Before you start data entry, the tracker needs a complete row — this makes it fast and consistent.

SEPO Quick win
The situationEvery initiation email that arrives gets logged in the SEPO Google Sheet tracker before data entry begins. Cathy: "They log it into their own little tracker, then assign it, then start data entry." When tracker entries are rushed or inconsistent, visibility breaks down — Cathy can't see what's pending, the advisor doesn't know where things stand, and things sit for months with no status. Gemini can read the initiation email and write the tracker row for you.
Prompt
I've received a SEPO data entry initiation email. I need to create a log entry for our Google Sheet tracker before I begin. Here is the initiation email: [Paste the full email] From this email, extract and format the following fields as a single spreadsheet row: - Date received - Project ID - Client / Account - Estimate type (original / revision / actualization) - Advisor name - Job folder link - Key callouts or special instructions - Assigned to (leave blank for me to fill) - Status (set to: In Progress) If any field is missing from the email, write "Missing — follow up with advisor" in that cell.
This also works in reverse — if you need to write the summary note back to your manager or Cathy about what's currently pending, Gemini can format a status update from a batch of tracker rows.
🔍

Document a "who changed this?" audit note

SEPO gets blamed for errors. Half the time, someone else went in and changed it. Here's how to write that up properly.

SEPO Quick win
The situationCathy is clear: "SEPO is always blamed for errors. When I look at recent activity, more times than not, someone else went in and changed it after SEPO completed their entry." Without a written record, the error sticks to SEPO. Gemini can help you write a neutral, factual audit note that documents what the activity log shows — useful for escalations, process reviews, or just protecting your team's record.
Prompt
Act as a data operations coordinator. I need to write a clear, factual audit note documenting a data change in a production tracking system. Here is what the recent activity log shows: [Describe or paste what the log shows — who changed what, when, what the original value was, what it changed to] The error was flagged by: [e.g. BI validation / advisor / client team] SEPO's original entry date: [Date] When the change occurred: [Date — after SEPO marked complete] Write a 3-4 sentence audit note that: (1) states the facts of the change without accusation, (2) confirms SEPO's original entry was correct, (3) recommends a next step (e.g. advisor to review and correct, or flag for process review). Neutral, professional tone.
Keep a folder of these notes. If there's ever a pattern review or a workflow audit, having documented examples makes the case for system-level change much stronger.

Build an agility story from incomplete date data

APR wants to prove it's fast. The date fields are a mess. Here's how to tell that story with what you actually have.

BI Chain
The situationEugene: "When we report on agility or how fast we deliver — how much benefit we're providing the client in terms of speed — we can't pull any data on that. The date fields don't get filled in. People just pick whatever date they happen to be clicking." APR wants to be a data-proven company. This prompt helps BI build the most credible agility narrative possible from the data that actually exists, while being honest about what's missing.
Prompt 1 — Assess what data you have
Act as a BI analyst at a production consultancy. I want to build a report on project turnaround speed and delivery agility, but our milestone date fields are inconsistently filled. Here is a sample of what date fields I have populated and how complete they are: [Describe what's available — e.g. "bid received date is ~80% populated, award date is ~60%, project open date is ~95%, production start is ~30%"] Client or scope: [Client name or project type] Time period: [e.g. Q1–Q3 2024] Based on this, tell me: (1) which date-to-date gaps are calculable with enough data to be meaningful, (2) which ones have too many nulls to report on reliably, (3) what caveats I need to include in any agility metric I publish. Be direct — I'd rather know what I can't say than publish something that gets challenged.
then in the same chat
Prompt 2 — Write the agility narrative
Based on the available data and the caveats we identified, write a 3-sentence agility narrative I can include in a client report. It should present what we can prove, acknowledge where data is limited, and frame the improvement opportunity honestly. No inflated claims.
This is also a great way to make the case internally for why date fields need to be mandatory. A narrative that says "we could tell this story if 40% more fields were filled in" is a compelling argument.
📊

Set up a new client's reporting from scratch

The building is where the work is. This prompt structures the decisions that need to be made before the first report runs.

BI Chain
The situationSteffanie is clear: "The building is where the work is. Once it's built, running the report is very smooth." But building it requires a set of decisions — which modules to validate, which fields matter to this client, what the report cadence is, and what validations need to pass before the first run. Getting those decisions documented upfront saves months of back-and-forth later.
Prompt 1 — Define what to track
Act as a BI analyst onboarding a new client to a production data reporting program. I need to define what data we'll track and report on before building the first report. Client context: - Client name / type: [e.g. large CPG brand, retainer client] - Production types they run: [e.g. broadcast, experiential, digital] - Report cadence they've requested: [Monthly / Quarterly / Annual] - What they care most about: [e.g. savings, spend by category, cost per deliverable, agility] - Any custom fields specific to this client: [If known] Give me a structured onboarding checklist that covers: (1) which data modules to validate for this client, (2) which fields are critical for their reporting goals, (3) what I need to confirm with the advisor before building, (4) what a "clean enough to run" threshold looks like for first report. Format as a checklist.
then in the same chat
Prompt 2 — Write the advisor briefing
Based on the checklist, draft a short email to the managing advisor explaining which data fields are critical for this client's reporting, what needs to be filled in consistently from day one, and what happens to the report if those fields are missing. Keep it under 150 words — practical, not lecturing.
Steffanie notes she has clients where the report "just works" because she invested in building it right at the start. That investment pays off every quarter after.
📣

Write an internal message that builds data appetite

APR wants to be a data-proven company. This helps BI communicate why the data fields matter — without sounding like a lecture.

BI Delivery Quick win
The situationEugene: "Having the culture in the company that can comprehend the data, ask for it, and have the appetite — that's what we're trying to promote." The problem isn't just bad data entry. It's that advisors don't see why it matters to them personally. A well-written internal message that connects data quality to things advisors care about — like having the right numbers in client conversations, or winning new business — is worth more than another training slide.
Prompt
Act as a BI lead at a production consultancy. I want to write a short internal communication to our advisor team that builds enthusiasm for data quality — not compliance, enthusiasm. The specific data gap I want to address: [e.g. "milestone dates not being filled in" / "savings entries missing backup docs" / "deliverables not updated at close"] The benefit to advisors if this improves: [e.g. "you'll be able to answer client questions in 30 seconds instead of digging through dashboards" / "your savings numbers will be credible in the next review"] Tone: Practical, collegial. Not a policy announcement. Not a guilt trip. Write a 150-word message I can send to the advisor team. It should: explain what we're seeing, show what good data makes possible for them personally, and make one clear ask. No bullet points — this should read like a human wrote it.
Eugene also points out that the people advisors interact with most often aren't the data experts. Tailor this message for the advisor's perspective, not the BI perspective.
📋

Summarize the pre-bid brief for project setup

Before any financial data exists, the brief needs to be captured. This gets it into a structured, system-ready format.

Delivery Advisor Quick win
The situationRussell describes the pre-bid stage as "a data gathering exercise." Before any bids come in, you should already have the job brief, draft creative direction, high-level budget range, draft schedule, draft deliverables, and usage rights captured in one place. In practice this information is scattered across emails and meeting notes and never properly filed. Gemini can read whatever you received and turn it into a structured pre-bid summary.
Prompt
Act as a production advisor. I've received the initial brief and materials for a new project at the pre-bid stage. I need to create a structured pre-bid summary I can file in the job folder before bidding begins. Here are the materials I have: [Attach the brief, email, or paste the relevant content] Extract and organize the following into a clean summary: 1. Job overview (client, project name, type of production) 2. Creative direction (attach or summarize) 3. High-level budget range (if stated) 4. Draft schedule / key dates 5. Draft deliverables (list what's been requested) 6. Usage rights / distribution (if mentioned) 7. Open questions (anything missing that we'll need before bids go out) Format as a one-page summary. Flag anything that's missing with "TBC — needed before bid."
Russell notes that auto-ingesting this brief data is the future state. Until then, having it structured and in the folder means the whole team starts with the same information.
💼

Determine which service tier applies to this project

Milestones align to the rate card. Knowing when APR joins a project — and at what level — affects how it's set up from the start.

Delivery Quick win
The situationRussell is direct: "Some projects we join at kickoff, some at the pre-bid meeting — those are reduced-cost projects. The milestones aren't just about capturing time; they align to our rate card." Advisors who don't know which tier applies can set up the project wrong from the start, creating misaligned scope and billing issues later. This prompt helps you determine and communicate the right service level clearly at project setup.
Prompt
Act as a production delivery consultant. I need to determine the correct service tier and engagement point for a new project, and communicate it to the client and internal team. Project details: - Client: [Client name] - Project type: [e.g. broadcast TVC / experiential / digital / print] - When APR was engaged: [e.g. before kickoff / at pre-bid meeting / post-award] - Scope of work agreed: [Brief description or attach SOW] - Any special arrangements (e.g. reduced cost, project-only basis): [Note here] Based on this, tell me: (1) which service tier this project falls into, (2) which milestones APR is responsible for from this engagement point, (3) what needs to be set up in the project record to reflect this correctly, (4) any flag if we're being asked to deliver scope outside what the tier covers. Plain language, no jargon.
When in doubt about which tier applies, ask before the project is set up — not after the first invoice goes out.
🎬

Capture on-set negotiations before you leave the shoot

"I saved the client $20,000." Did you write it down? This prompt turns your shoot-day memory into a proper record.

Advisor Delivery Quick win
The situationRussell puts it plainly: "Our people brag — 'I saved the client $20,000 on set.' Did you write it down? Nah, why would I write it down? That's the problem. We should absolutely be tracking on-set negotiations. We provide a service on the day of the shoot and we have nothing to show for it." This prompt helps you document what happened on set in a structured, Acero-ready format while it's still fresh — even from bullet notes on your phone.
Prompt
Act as a production advisor documenting on-set activity for a project record. I attended the shoot today and need to capture what happened — especially any negotiations, savings, or scope changes — in a format I can enter into our system. Here's what I remember from today: [Type your bullet notes — e.g. "negotiated craft services down $3k, director wanted extra setup hour pushed back, agency tried to add unscripted VFX shot I flagged as scope change"] Project: [Project name / ID] Client: [Client name] Shoot date: [Today's date] Format my notes into: 1. On-set savings entry (what I negotiated, original vs. agreed cost, brief rationale) 2. Scope changes or deviations flagged (what was requested, what I said, outcome) 3. Shoot attendance note (that APR was present and actively managing) 4. Any follow-up actions for post-production Plain language, factual, ready to paste into project notes.
Do this before you leave the parking lot. By tomorrow morning, two-thirds of the detail will be gone. Thirty seconds of bullet notes now saves an hour of reconstruction later.
🧾

Document post-production overages and reconcile at job wrap

Approved costs. Actual costs. Overages. Cost-plus reconciliation. This prompt structures the job wrap so nothing leaks.

Advisor Delivery Chain
The situationRussell: "Once we're at job wrap — you've got your approved costs, overages that happened in the shoot or in post, and cost-plus reconciliation for clients who need it. This can take months and often doesn't get documented properly. The estimates were approved, but the actuals tell a different story." This prompt helps advisors structure the final reconciliation so it's clear, complete, and ready to enter.
Prompt 1 — Overage summary
Act as a production advisor reconciling a project at job wrap. I need to document overages and produce a clear summary comparing what was approved vs. what was actually spent. Project: [Project name / ID] Client: [Client name] Approved total (from stamped estimate): [Amount] Here are the overages I'm tracking: [List each — e.g. "Extra shoot day: +$18,000 / Agency VFX additions: +$7,500 / Talent buyout amendment: +$4,200"] Create a job wrap overage table with: (1) line item, (2) approved amount, (3) actual amount, (4) variance, (5) reason / justification. Then write a 2-sentence summary I can include in a close-out note to the client.
then in the same chat
Prompt 2 — Cost-plus reconciliation note
Based on the overage table, write a cost-plus reconciliation note I can attach to the final invoice upload. It should confirm the approved base, itemize the adjustments, and state the final reconciled total. 150 words maximum. Professional, no ambiguity.
Russell notes cost-plus reconciliation can take months for some clients. Setting up a standard format at the start of every project makes the eventual reconciliation much faster.
🔁

Write the client postmortem at job close

Russell called it out as a missing field. Before the job gets closed, get the learning on record.

Delivery Advisor Quick win
The situationRussell explicitly flagged this: "There is a client postmortem. We could have a field for that — and then the job gets closed." Currently it doesn't happen, so every project closes with institutional knowledge lost. The next advisor on the account starts from scratch. Gemini makes writing a postmortem fast enough that people might actually do it.
Prompt
Act as a senior production advisor. I'm closing out a project and need to write a structured postmortem before it's marked complete. This will be filed in the job folder and used to brief the next advisor who works with this client. Project overview: - Client / Account: [Client name] - Project type: [e.g. broadcast TVC / experiential / digital] - Budget (approximate): [Approved / Final reconciled] - Key challenges during this project: [Bullet notes — what went wrong or was harder than expected] - What worked well: [What you'd repeat] - Client-specific notes: [Any preferences, sensitivities, or rules that future advisors should know] - Savings delivered: [Key negotiation wins] Write a 250-word postmortem structured as: (1) Project summary, (2) What worked, (3) What to watch for next time, (4) Client-specific guidance for the next advisor. Factual, useful, no fluff.
Even three bullet points per section is better than nothing. A two-minute postmortem that gets filed beats a perfect one that never gets written.

Some tasks are too big for one prompt. Chaining breaks them into connected steps — the output of each prompt becomes the input for the next. Stay in the same chat window so Gemini carries the context forward.

Prompt 1
Brainstorm or gather raw material
Prompt 2
Evaluate or filter the options
Prompt 3
Create the final output

If the chat gets long and outputs feel off — ask Gemini to summarize the thread, then start a new chat and paste that summary as context before continuing. Re-attach any documents you uploaded originally.

🔒

No client confidential data

Don't paste client names, contract terms, or proprietary financials into public AI tools. Use placeholders in your prompts instead.

Always review the output

Gemini can be wrong — especially with numbers, dates, and names. Check before you send or use anything it generates.

🔄

Iterate, don't quit

If the first output isn't right, don't start over. Tell it what's wrong and ask again. One follow-up prompt fixes most issues.

📚

Save your best prompts

When something works well, save it to a Google Doc. Build a shared team library. Future-you will thank current-you.