Weekly Databricks KPI email brief for executives

PromptCreate

Every Monday at 7am, generate a short written executive brief from our Databricks lakehouse KPIs and email it to the leadership list, so non-technical stakeholders get the numbers without opening a dashboard.

Start by running a query on our Databricks SQL warehouse with the Execute SQL Statement operation. Pull the core business KPIs (for example revenue, new signups, and active users) for the last completed week and the prior week, so each metric can be compared week over week. Use the warehouse that holds our reporting tables.

The statement runs asynchronously, so poll the Get SQL Statement operation until its status is SUCCEEDED before reading the results. If it is still running, wait a moment and check again. If it fails or is cancelled, stop and report the error instead of sending a partial brief.

Once the results are back, write a concise narrative summary in plain language aimed at executives. Lead with the highlights and the biggest movers, calling out which KPIs rose or fell the most and any notable trends week over week, rather than opening with a raw metrics table. Keep it short, avoid jargon, and give brief context for the changes where it helps.

Send the finished brief with the Gmail Send a Message operation to the leadership distribution list. Put the reporting week in the subject line (for example, 'Weekly KPI brief: week of March 3'), and lead the body with the key takeaways. A compact recap of the underlying numbers can follow the narrative for anyone who wants the detail.

Additional information

What does this prompt do?

Pulls your core business KPIs (like revenue, new signups, and active users) for last week and the week before.
Compares the two weeks and highlights the biggest movers and trends.
Writes a short, plain-English summary that leads with the takeaways instead of a wall of numbers.
Emails the finished brief to your leadership list every Monday morning.

What do I need to use this?

A Databricks account with a SQL warehouse that holds your KPI data
A Gmail account to send the brief from
The email addresses for your leadership list

How can I customize it?

Change the send time or day, for example Friday afternoon instead of Monday morning
Swap in the KPIs that matter most to your team, such as churn, bookings, or pipeline
Update the recipient list or the wording of the subject line

Frequently asked questions

Do my executives need a Databricks login to read the brief?

No. Only the person setting this up needs Databricks access. Everyone on the leadership list just receives a normal email.

Which KPIs can it report on?

Any metric you can pull from your warehouse, such as revenue, new signups, active users, churn, or bookings. You choose what goes in.

How does it decide what to highlight?

It compares last week against the prior week and leads with the biggest movers and clearest trends, so leadership sees what changed first.

Where does the reporting week show up?

Every morning, get an emailed rundown of delays and cancellations at your hub airports, worst-hit first, so your team can plan around the chaos before the day gets busy.

5d ago

Agentic Task

Prompt

Stop rebuilding the weekly numbers email by hand.

Let your lakehouse KPIs write their own executive brief and land in leadership's inbox every Monday.

Explore more prompts Create