The best content most small businesses own is sitting in a spreadsheet nobody opens.

Average response time. Jobs finished this month. Five star reviews since Labor Day. The before and after on a kitchen that used to look like a crime scene. That stuff sells. A prospect will scroll past your tenth "we care about quality" post without blinking, but "we answered 212 calls last month and the average wait was 41 seconds" makes them stop.

Nobody posts it because turning a number into a video used to take a designer, an editor and a week of back and forth, and nobody's spending that on a Tuesday post.

That changed on October 8. Anthropic launched Claude Dashboards and Claude Motion in beta. Dashboards builds live charts from your connected data. Motion turns a chart or an update into a short animated clip you can export as an MP4. Pair those with two newer tools most people haven't heard of yet, and you've got a weekly video habit that takes about 45 minutes and no timeline editor.

This is how I'd set it up.

What shipped, and who actually gets it

Read the plan limits before you get excited, because they matter here.

Claude Dashboards is in beta on Pro, Max, Team and Enterprise, per Anthropic's help article. You ask a question in a chat (or pick Output, then Dashboards), and Claude writes the SQL behind each chart. Click any number and you see the query that produced it. Each chart shows when its data last refreshed. Data comes from warehouses like BigQuery, Snowflake and Redshift, or from apps you've already connected to Claude, like Salesforce. The help article doesn't mention uploaded spreadsheets as a source, so don't assume your CSV works there.

Claude Motion is the more fun of the two, and it's Team and Enterprise only for now. Team has it on by default. On Enterprise, an owner has to switch it on under Organization settings, then Artifacts. You describe the animation, attach your data or images, and Claude writes code that animates text, charts, shapes and images. You can edit by chat ("change the Q3 number to 18%") or in the built in editor, then export to MP4.

Three limits worth knowing:

  • No footage, no people. Motion doesn't use a video model, so it can't make realistic video. It animates graphics. That's fine for numbers. It's the wrong tool for a testimonial.

  • No sound. The help article says nothing about audio, and reviewers note there's no voice or music. You add that later.

  • It eats your usage. Anthropic says longer or more complex animations burn more of your plan limit than a normal message. Keep clips short.

Also, both are betas, so expect things to move around. Get the weekly habit going and don't lean too hard on any one button.

Pick five numbers worth watching

Before you open anything, decide what you'll show. My test for a number is two questions. Would a customer care? And does it change week to week, so you've got something new to say?

Take a four truck HVAC shop. Here's what I'd track:

  1. Speed. Average time from first call to booked appointment. Customers care about this more than your logo.

  2. Volume. Jobs completed this week. Proof you're busy without saying "we're busy."

  3. Reviews. New five star reviews this week, plus one short quote.

  4. Before and after. One job, two photos, one number (old system at 9 SEER, new one at 17, or whatever's true).

  5. The seasonal one. Furnace tune ups booked before the first cold snap, pools opened before Memorial Day, whatever fits your calendar.

Where the numbers come from matters. If your calls, bookings and reviews already run through Go High Level, most of this is sitting in your reporting. If it's scattered, a basic Make.com scenario can drop each closed job and each new review into one Google Sheet every night. One sheet, one tab, one row per event. Nothing fancy, and it'll still be running in six months.

One hard rule. Only real numbers. If the week was slow, post a different number or skip it. If a customer catches one padded number, they'll stop believing the rest.

Step one: build the dashboard

If your data lives somewhere Claude can reach, build the dashboard once and reuse it every week. Open a chat, choose Output, then Dashboards, and paste this:

Build a dashboard called "[Business Name] Weekly Numbers" from [name the table or connected app].

Show five charts, one per number: average minutes from first call to booked appointment, jobs completed, new five star reviews, [your before and after metric], and [your seasonal metric].

Each chart compares this week to the previous four weeks.

Put the single number for this week in large type above each chart.

Label every chart in plain English a customer would understand. No internal codes or abbreviations.

If any number looks off compared to the prior four weeks by more than 30 percent, flag it under the chart so I can check it before it goes public.

Don't skip the flag line. It's your circuit breaker. If a bad import doubles your job count, you want to catch it in the dashboard, not in the comments of a Reel.

Then click a few numbers and read the queries. You don't need to know SQL. Ask Claude "explain this query like I'm the owner, not the analyst" and check that it's counting what you think it's counting.

No warehouse and no connected app? Totally normal for a small shop. Export the sheet as a CSV, drop it into a regular Claude chat and ask for the same five charts as a file you can download. You lose the live refresh, so you'll redo it each week, but the prompt above still works with one change: replace the first line with "Using the attached CSV."

FROM THE AI NEWSROOM

The AI Workflow Blueprint

The exact systems behind everything in this issue. The audit sheets, the routing logic, the templates and the review cadences, built out step by step so you can copy them straight into your own stack. One time, forty seven dollars.

Get the Blueprint for $47

Step two: turn one number into a clip

Here's where Motion actually pays off. Pick the one number from this week's dashboard with the best story. Just the one.

In a chat, type a request for an animation (or open the Artifacts tab and choose a Motion template), attach the dashboard screenshot or the CSV, and use this:

Make a 15 second animation for a vertical Instagram Reel and TikTok, watched on a phone with the sound off.

Audience: homeowners in [City] who might need [service] this winter.

Scene 1 (0 to 3 seconds): big text "[Hook, for example: How long you'll wait for us]".

Scene 2 (3 to 10 seconds): animate this week's number counting up to [number], with the four week trend line drawing in behind it.

Scene 3 (10 to 15 seconds): text "[One line proof point]" then our name "[Business Name]" and "[phone or website]".

Use our colors [hex codes]. Use one font. No more than 8 words on screen at once.

Keep it simple enough that I can change the number next week without rebuilding it.

Anthropic's own tip is to tell it who's watching, where it plays and roughly how long it runs, and the prompt does all three. I put the "change the number next week" line in because every Motion animation is code. Next Monday you open the same artifact and say "change 41 seconds to 38 seconds and update the trend line with the attached CSV." Thirty seconds of work instead of a new build.

Before you post, check two things. The help article doesn't list aspect ratios or resolution, so play the exported MP4 on your phone and make sure nothing important gets cropped by the Reels interface. And since there's no audio, add a trending track inside Instagram or TikTok, or through Buffer (more on that below).

On Pro and not Team? You still get Dashboards, just not Motion. Your fallback is step four below, or the quick and dirty version: screen record yourself clicking through the dashboard while you say the number out loud. A rough video of the owner saying a real number does fine.

Step three: explain the process with ngram

Numbers show you're good. But plenty of people don't call because they don't know what happens next, and a process video fixes that. The single most useful one most businesses never make is "here's how booking with us works."

That's where ngram comes in. Its 2.0 release landed on Product Hunt in early October. You upload a document, a deck or a screen recording, and it builds a narrated explainer. It cleans up the recording by cutting dead air, zooming in on the important parts of the screen, highlighting buttons and smoothing the cursor. It adds captions, and you can add an AI presenter if you want a face on screen. You edit by chatting with it instead of dragging clips around a timeline.

Here's the 15 minute version:

  1. Record the booking flow. Open your website on your phone or laptop and book a fake appointment from start to finish. Don't narrate. Don't rush. Just do it.

  2. Upload it to ngram and paste in the prompt below.

  3. Read the script it writes before you look at the video. Fix any step that's wrong.

  4. Export three versions: 9:16 for Reels and TikTok, 1:1 for Facebook, 16:9 for your website and YouTube.

Turn this screen recording into a 60 second explainer called "How booking with [Business Name] works."

Audience: a homeowner who has never hired us and is a little nervous about price and timing.

Cover only these steps, in order: [step 1], [step 2], [step 3], [what happens after they book].

Tell them exactly what happens next and when, for example "you'll get a text with your tech's name and photo the morning of."

Plain, friendly language. No jargon. No claims about price or speed that aren't shown in the recording.

Captions on. End with "[phone or URL]."

On pricing, check the ngram pricing page before you commit. As listed, the free plan gives a one time grant of credits good for about 60 seconds of premium AI video, Basic is $29 a month with 720p export, and Premium is $59 a month with 1080p plus one brand kit, one custom voice and one custom avatar. Credits get used per second of generated footage, so regenerating ten times costs ten times.

My advice: use the free credits to make the booking video once. If it's good, it'll run for a year. You might never need the paid plan.

Step four: repurpose with Spira

Spira launched its Maxima video model on October 5 and took #1 of the day and #1 of the week on Product Hunt. You give it a plain text script and it returns a finished social video with a presenter, B roll, captions and music. You can upload product shots and recordings for it to build around, and it can schedule posts to TikTok, Instagram, YouTube, X and LinkedIn from a shared calendar.

That makes it the Pro user's answer to Motion, and a good way to get two or three extra posts out of the same number.

Write the script from your dashboard in Claude first. Spira will make a slick video out of a lazy script without complaining, so the script is on you.

Write three 30 second video scripts based on this week's number: [number and context].

Script 1: the customer's problem, then the number as proof.

Script 2: a quick behind the scenes moment that explains how we hit that number.

Script 3: a myth people believe about [service], busted with the number.

Each script: under 75 spoken words, first line under 8 words, no claims beyond the number I gave you, end with "[CTA]."

Paste the best one into Spira, upload two real job photos, and generate.

A few cautions. Creator is $15 a month for 1,200 credits and Growth is $59, per a third party breakdown of Spira's plans, and video eats credits fast, so test before you commit. Spira labels every post as AI generated, which I'd want anyway. And if you use its clone feature built from a photo and a voice sample, only clone yourself, and only with your own voice. Not your office manager, not your best tech, unless they've said yes in writing.

Step five: distribute it once, everywhere

Now you've got a Motion clip, a booking explainer and a Spira video or two. Don't post them by hand across five apps.

Load them into Buffer. Two recent updates make this smoother. Since October 7, scheduled Instagram posts can carry the stuff you used to finish inside the app, like music, which fixes Motion's silent clips. And since September 28, a single post can hold images and video together, so your before and after photos can ride along with the clip.

Then give the number a second life in your customer email. If you send a newsletter on Beehiiv, add a standing section called "Number of the week." One number, one sentence of context, the clip embedded or linked. Customers who'd never follow you on TikTok will read it, and it costs you nothing because the work's already done.

The 45 minute Monday

Here's the rhythm. Same time every week, ideally before the phones get busy.

  1. Minutes 0 to 10. Open the dashboard. Read the five numbers and any flags. Check one query you haven't looked at before.

  2. Minutes 10 to 20. Pick the story number. Update last week's Motion animation by chat, export the MP4, watch it on your phone.

  3. Minutes 20 to 30. Run the three script prompt. Make one Spira video from the best script.

  4. Minutes 30 to 40. Load everything into Buffer for Tuesday, Thursday and Saturday. Add music to the clip.

  5. Minutes 40 to 45. Paste the number and one sentence into your newsletter draft.

You only make the booking explainer once. Make it in week one, then reshare it once a month.

The fine print

It's beta software. Dashboards and Motion launched October 8. Expect bugs and moving buttons.

Motion is locked to Team and Enterprise. Pro and Max users get Dashboards but not the animation, at least for now.

The tool numbers are vendor claims. Ngram's credit math and Spira's "one pass" promise come from their own pages and launch posts. Test on your own content before you pay.

Privacy still applies. Motion artifacts aren't covered under a business associate agreement, according to reviewers who dug into the limits, so keep patient data, customer names and addresses out of anything you animate. Aggregate numbers only.

Bad data travels fast. If your sheet counts a rescheduled job twice, you'll broadcast the error in high definition. That flag line in the dashboard prompt isn't optional.

FROM THE AI NEWSROOM

The AI Business Accelerator

For operators who would rather build it with someone than build it alone. The full stack, installed alongside you, with the decisions made in the room instead of guessed at. Ninety seven dollars.

Join the Accelerator for $97

This week

Pick your five numbers and write them on a sticky note. If you can't name five, start with three.

Get those numbers into one place, whether that's a connected app, a warehouse, or one Google Sheet fed by Make.

Build the dashboard with the prompt above and click through at least three queries.

Record your booking flow on your phone and turn it into a 60 second explainer with ngram's free credits.

Block 45 minutes every Monday morning on your calendar and call it "Numbers."

Jordan

The AI Newsroom | Practical AI for people with a business to run.