The Scenario
It's Thursday afternoon and the weekly video performance report is due to the marketing team by end of day. You have an Excel workbook with 30 Spotlightr video IDs in column A — the same workbook you've used for four weeks running. Columns B through F are supposed to show loads, plays, play rate, completion rate, and share count for the current week. Right now they're blank.
The data exists in Spotlightr. Getting it into the workbook is where things fall apart.
The bad version:
- Open the Spotlightr dashboard, click into the first video, screenshot or note the analytics values, switch back to Excel, paste them into row 2.
- Repeat for video 2. And video 3. Thirty times.
- Realize halfway through that Spotlightr's dashboard shows lifetime metrics by default, not this week's data, and you've been copying the wrong numbers for the last eight videos.
You're supposed to be analyzing this data, not transcribing it. The reporting is supposed to tell you something — and right now it's just consuming your afternoon.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the video IDs, calls the Spotlightr analytics API for each one, and writes the results back into the right columns — all from a single prompt.
Pull Spotlightr analytics for every video ID listed in my Excel sheet and fill in the play rate and completion rate columns — leave blank if a video has no data yet.
What You Get
- Spotlightr analytics fetched for every video ID in column A.
- Play rate written into the play rate column, completion rate into the completion rate column.
- Rows where a video ID returns no data get a blank rather than an error, keeping the workbook clean.
- The whole operation runs in one pass — you don't click through a single dashboard screen.
What If the Data Is Not Quite Ready
Some video IDs in column A have been deleted from Spotlightr
You don't know which ones are stale. You want valid rows filled in and deleted-video rows flagged.
For each video ID in column A, fetch Spotlightr analytics and write loads, plays, playRate, completionRate into columns B–E. If the API returns a 404 or "not found," write "deleted" into column B and leave C–E blank.
You need a rolling 7-day window, not lifetime totals
For each video ID in column A, fetch Spotlightr analytics for the date range in cells H1 (start) and I1 (end) and write loads, plays, playRate, completionRate into columns B–E.
The video IDs are spread across two worksheets
Your workbook has a "Product Demos" sheet and an "Onboarding Videos" sheet, each with video IDs in column A. You need both pulled in one prompt.
Fetch Spotlightr analytics for every video ID in column A of the "Product Demos" sheet and the "Onboarding Videos" sheet — write loads, plays, playRate, completionRate into columns B–E of each respective sheet.
You want analytics plus a performance tier label written in one pass
For each video ID in column A, fetch Spotlightr analytics and write loads, plays, playRate, completionRate into columns B–E. Then write a performance tier into column F: "High" if completionRate is above 0.60, "Medium" if between 0.30 and 0.60, "Low" if below 0.30.
One prompt, fully labeled output, reporting-ready the moment SheetXAI finishes.
Try It
Get the 7-day free trial of SheetXAI and open your Excel video tracking workbook with Spotlightr IDs in column A. Ask SheetXAI to pull this week's metrics for every ID and write them back into the adjacent columns. See also: Export Top Spotlightr Videos to an Excel workbook and the Spotlightr hub.