29 AI Prompts for Agency Reporting That Turn Client Data Into Decisions

Build a one-page reporting brief for this client from the context I supplied and the available Swydo sources. Include the business model, services we manage, business goal, primary KPI, agreed target, budget, reporting cadence and audience. Add seasonal factors, constraints and known changes that could affect interpretation. Mark each item as confirmed or needing input. Finish with the few questions that must be answered before we can judge success. Don’t infer business agreements from the report’s contents.

For each goal in this client’s brief, propose one primary outcome metric and up to two supporting metrics from the available sources. State the exact source field or event, what it counts, and any known attribution or calculation rule. Compare that definition with the client’s supplied definition of a useful result. Flag gaps, such as ad conversions without qualified-lead data. Draft a measurement agreement that separates what we can report now from what needs clarification or additional data.

List this client’s accessible Swydo sources and the available metrics and dimensions relevant to the brief. Inspect the selected report and its widget settings. Show which source, field, date setting, comparison and filter each main KPI uses, wherever that configuration is available. Compare these with our measurement agreement. Flag missing access, unsupported fields, filters that change scope and settings we still need to inspect manually. Return a short list of checks in order of their effect on the report.

Use this client’s last six complete months of the primary KPI, or the available history if shorter, to establish a baseline. Show monthly values, variation and any known definition changes from the supplied records. Flag uncertainty about historical definitions. Compare the existing target I supplied with that history. Propose a next-period target range and review milestones using the known budget, capacity and seasonal plans. Label assumptions and explain what would need to change to reach the upper end. If the history can’t support a useful target, say which input is missing.

For the accessible clients in our agreed group, compare the primary KPI over the two periods we defined. Show both values, the absolute change, percentage change and gap to any target I supplied. Keep incompatible metrics and currencies in separate groups. Recommend up to three clients to review first using the size of the change, business importance from the briefs and evidence quality. Give a reason and first check for each. List accounts that can’t be assessed and the input they need.

For the clients in the supplied budget sheet, retrieve spend from available Swydo sources through the last complete day of the current month. If those sources are unavailable, use the spend export I supply and clearly label that fallback; state its coverage and do not treat missing values as zero. State the dates and currencies. Show budget, actual spend, elapsed days and projected month-end spend at the current daily rate. Flag projections outside the agreed pacing tolerance; use 10% above or below budget if none was supplied. Then assess how the planned changes I supplied affect that simple projection. Separate missing budgets from missing spend. Recommend which accounts need a pacing review, with the calculation behind each flag.

For our selected clients and sources, compare the primary KPI for the last seven complete days with the preceding four complete weeks. Use the earlier weeks as a comparable daily or weekly baseline. Account for weekday patterns. Return a short status summary for each client and show daily values only for flagged accounts. Separate retrieval errors, missing values, empty results, reported zeros and unusual measured changes. Where existing source-health or alert information is available, use it as additional evidence. For each flagged account, state whether the data supports a performance observation, a measurement concern or an unresolved issue, and name the first check needed.

Review the supplied commitments for our selected clients as of today, and state the date. List overdue items, actions due today and decisions due in the next seven days. Match relevant items to the verified performance concerns in this conversation. Prioritize by deadline, client impact and dependencies. For each item, show the recorded owner, next action and blocker. Keep unknown status separate from confirmed delay. Draft a concise account-team work queue without assigning new owners or inventing completion dates.

Reconcile the two figures we identified for this client. Record each source, exact dates, time zone, metric definition, filters, attribution settings and calculation where available. Verify each figure against its retrieved data or supplied export. Reproduce it only where the same source, dates, definitions, filters and aggregation are available; otherwise state the limit and request the smallest missing export. Show which differences are explained, which are legitimate differences in measurement and which remain unresolved. If the measures should match, quantify the remaining gap and propose the next check. Don’t force agreement by changing definitions or choosing the more favorable number.

For this client and the agreed periods, break down the primary KPI by the dimension we selected. Show both values and absolute changes, including gains that offset losses. Rank the largest contributors to the net movement and explain the denominator for any contribution percentage. Reconcile additive values only when rows and total use the same aggregation, scope and coverage. Explain remaining differences and identify limited or omitted rows. For rates or averages, use the appropriate components instead of adding the row values. Recommend the segment to investigate first and one question the data still can’t answer.

For this client and the agreed periods, compare the available stages in our defined funnel, from reach or visits through the primary outcome. Show counts and relevant rates with their denominators. Identify where volume changed and where the rate between comparable steps changed. Keep populations from different sources separate unless the supplied data supports a valid connection. Rank the steps that deserve investigation and suggest a check for each. Explain which parts of the funnel we can’t assess with the available fields.

Compare this client’s marketing results with the supplied sales data for the agreed periods. Use comparable cohorts suited to the business model and reliable matching fields where available. For lead generation, show leads, qualified leads, sales and revenue; allow time for leads to mature. For ecommerce, compare relevant order and revenue measures and state how returns and cancellations are treated. Calculate cost per qualified result or order only where valid. Flag unmatched records and identify where the observed gap appears. State what we can conclude if the datasets can’t be matched reliably.

For this client and the agreed periods, assess organic search against the goal in the brief. Use available Search Console clicks, impressions, click-through rate and average position, then inspect relevant page or query changes. Compare that evidence with GA4 landing-page sessions and the defined key-event measures for Google organic traffic where supported data or a supplied export allows that scope. Otherwise state the scope difference. Keep the two sources’ definitions clear and don't treat Search Console clicks and GA4 sessions as individually matched. Identify useful progress, business-outcome gaps and the strongest next check. Label explanations that still need evidence.

Assess this client’s social results for the agreed periods against the objective in the brief. Use the relevant available measures for awareness, visits or business outcomes, and separate paid from organic results. Compare platforms using their actual definitions; don’t add incompatible reach or engagement measures. Show which content or campaign patterns support the goal, which changes are only supporting signals, and where the evidence stops. Recommend one next action and the result we should use to judge it.

For this client’s primary KPI, compare the agreed periods with the corresponding periods last year where comparable history exists. Note weekday, holiday and definition differences. Place the supplied account changes alongside the trend. Assess each proposed explanation against the timing and affected segments: supported, plausible but unconfirmed, contradicted or untestable with this evidence. Show the comparison behind each assessment and the next useful check. Don’t treat a similar seasonal pattern or nearby change date as proof of cause.

Using this client’s verified findings and the options I supplied, rank the next actions by likely business impact, evidence strength, effort and dependencies. Explain the basis for each judgment; avoid precise uplift estimates without support. Separate checks that reduce uncertainty from changes intended to improve results. Recommend one action to start, one to defer and anything to stop or leave alone. Include the expected learning or outcome, the metric to review and the condition that would change your recommendation.

For this client, compare the budget or target options I supplied using the agreed baseline and outcome definitions. Show the arithmetic for each scenario, including the efficiency it assumes and the result it would require. Include a range that tests weaker performance as spend increases. Distinguish simple arithmetic at current efficiency from a forecast. Assess the options against the supplied margin, capacity and risk limits. Identify the evidence or small test needed before we recommend a larger commitment.

Turn the chosen action for this client into a specialist brief. State the business question, source evidence, exact comparison periods and the relevant campaign, page or segment. Separate the verified problem from the suspected cause. Include the task, proposed owner based on the roles I supplied, dependencies, required access, acceptance criteria and review date. Define what evidence the specialist should return. Mark unagreed owners or dates as proposed and missing details as unresolved. Keep the brief specific enough to become a task.

Compare the proposed actions for this client with the supplied scope, budget and approval rules. Identify which actions can proceed under the existing agreement, which require a client decision and which can’t be classified from the information available. For each decision, state the request, reason, options, effect of delay and information the client needs. Distinguish approval from missing access or materials. Draft a concise decision list using only confirmed deadlines and costs; label proposed terms clearly.

Write a summary of this client’s results for the agreed period and the audience in the brief. Stay under 150 words. Lead with the result that matters most to the business goal, then explain the main supported finding and the agreed next step. Use the verified figures in this conversation. Include the most useful win or concern if it changes the decision. Translate technical terms into plain language while preserving their meaning. Keep unknown causes and proposed actions distinct from confirmed facts and commitments.

Draft an email to this client about the missed target identified in our analysis. State the KPI, actual result, target, gap and reporting period near the start. Explain what the evidence confirms and what remains unresolved. Describe the agreed response, any decision needed from the client and the next update date I supplied. Use plain language and acknowledge the effect on the business goal. Don't invent a recovery date, an excuse or a commitment that the team hasn't agreed. Keep the exact source metric names; don't relabel clicks as visits, sessions, people, leads or inquiries.

Prepare a call brief for this client using the verified results for the agreed periods and the notes I supplied. Give me the number to lead with, three talking points, the decision we need and three likely questions with short, evidence-based answers. Make the strongest objection explicit. Separate what we know from what needs a check. Include one question to ask the client that could change our interpretation or plan. Keep the brief easy to refer to during the conversation.

Outline a quarterly review for this client using the completed quarter’s exact dates, agreed goals and verified results. Limit it to ten sections or slides. Cover results against targets, the most consequential changes, work completed, evidence about its effect and unresolved issues. Then compare the proposed priorities for next quarter and state the client decisions needed. Give each section one point and its supporting evidence. Put the biggest business concern early and flag any claim that still needs data.

Create a decision record from the supplied notes from this client’s call, then write a recap email under 150 words. Separate decisions, agreed actions, proposals and open questions. For each agreed action, show the recorded owner, due date, dependency and expected evidence of completion. Mark any missing owner or date as unconfirmed. Include the next update date only if the notes establish it. Preserve conditions attached to approvals and don’t convert a suggestion or discussion point into a commitment.

For this client and the agreed outcome metric, propose the next review and a candidate alert rule. Use up to 90 complete days of available history, noting weekday patterns, missing values and delayed outcomes. Test the proposed threshold over its proposed measurement period and show the dates it would have triggered. Explain likely false alarms, limitations and what the account owner should do after a trigger. Compare with relevant existing alerts where accessible. Keep the proposed rule separate from any claim that it has been created.

Compare this client’s agreed actions with the current status and evidence I supplied, as of the review date we defined. Classify completion status as confirmed complete, in progress, blocked or unconfirmed. Flag overdue items separately. Show the original promise, owner, due date, latest evidence and next step. Separate work completed from results observed. Identify any change to the planned scope or completion date that affects when we can judge the outcome. Draft the smallest set of questions needed to resolve uncertain status.

Assess whether this client’s agreed change is ready for evaluation. Check the implementation evidence, elapsed time, outcome maturity and availability of a suitable baseline. If ready, compare appropriate before-and-after periods using the agreed success measure, with exact dates and relevant segments. Account for known budget, seasonal and concurrent changes. State whether the result supports continuing, adjusting, stopping or further observation, and how strong that conclusion is. If it’s too early or key inputs are missing, give the specific evidence and next review needed.

Prepare a retention review for this client using the last three complete months of the agreed KPI, targets and the account context I supplied. Separate performance concerns, delivery issues, relationship feedback and gaps in what we know. Show the evidence for each concern and identify improvements as well as problems. Recommend the conversation, corrective action or clarification that would help most. Don’t treat a KPI decline alone as proof that the client intends to leave or assign an unsupported churn probability.

Assess the case for more investment in this client using the agreed reporting history, business outcomes, scenario analysis and business constraints I supplied. Show what has improved, whether the gains are consistent and what might limit additional results. Compare increased spend or scope with maintaining the current plan. State the assumptions, required approvals and evidence gaps. Recommend an expansion, a limited test, more preparation or no increase, with a measurable success condition and a review point. Don’t promise that historical efficiency will hold at higher spend.