AI Weekly Business Reports
Turn store exports into an editable weekly PowerPoint with traceable numbers, clear decisions, and an owner for each action.
An AI weekly business report should turn exports into decisions the team can review. Choose the meeting questions first, attach the underlying data, and make each important number traceable to an export. Finish with an editable action list and a PDF checked page by page.
Scott’s Cohort 2 workshop uses an example GMV Max deck with attributed revenue of $4,007.24 on ad cost of $3,374.94. Six campaigns under 1.00 reported ROI accounted for 41.7% of the cost in that example. The first figure describes the report. The second gives the meeting a place to start looking. SCT Camp Cohort 2
What should go into a weekly review deck?
| Page | Question to answer |
|---|---|
| Executive view | Which two or three decisions need the team this week? |
| Scale and trend | What changed compared with the agreed prior period? |
| Contributors | Which campaigns or SKUs account for most of the movement? |
| Exceptions | Which spend, inventory, or conversion signals need a closer look? |
| Actions | Who will check what, by when, and what would change the decision? |
| Sources | Which exports, dates, currencies, and definitions are in use? |
Use the order that fits the meeting. An inventory review needs stock coverage, aged stock, and replenishment dates. A paid media review may start with spend and attributed revenue. The decisions dictate the sequence.
What inputs should the assistant get?
Give the assistant the official store or ad export, the date window and comparison period, metric definitions, and any targets the team already uses. Provide a previous deck if it shows the intended structure. Ask it to save the source path or sheet next to each chart and mark unsupported explanations for review.
For a GMV Max report, keep the dashboard’s attributed revenue separate from profit. TikTok’s reporting includes paid and organic orders for the campaign. When combining rows, calculate the ratio from total revenue and total cost instead of averaging row-level ratios. TikTok GMV Max reporting definitions
How do you review the PowerPoint and PDF?
Open the editable deck and trace a few headline numbers to the export. Check that the titles, labels, charts, and action list can be edited. Look at the final PDF page as well as the opening page. In the workshop, one export displayed correctly in PowerPoint but lost characters in the PDF. Another clipped evidence on the final page. Checking only the slide editor would have missed both.
Read each action with the owner. “Review product conversion” is hard to act on. “Compare Product 03’s listing and traffic sources against the top two products before Thursday” tells someone where to start. Keep assumptions explicit so the reviewer can ask for the missing data.
How do you reuse it next week?
Keep the validated slide structure, calculations, and metric definitions. Replace the weekly inputs, rerun the report, and bring forward the outcome of last week’s actions. A recurring daily team update can use the same source data and a smaller set of questions. GMV Max daily report workflow