The Scenario
You manage sales enablement. Your team has ten product demo videos in Spotlightr, each behind a lead capture form. Every Monday you pull per-viewer data and hand it to reps so they can prioritize follow-up calls based on who actually finished a demo. The video IDs are in your Excel workbook. The view records are in Spotlightr. The dashboard shows them one video at a time.
The bad version:
- Open Spotlightr, click into the first video, navigate to the Views tab, write down viewer IDs and watch percentages, switch to Excel, type them in.
- Go back. Second video. Same sequence.
- After forty minutes you've covered three videos and the data for video one is already formatted differently than video two because you forgot which column you were using.
Reps are asking for the list. The data exists. Getting it into a shape the team can act on is the entire problem.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the video IDs, pulls the per-view records from Spotlightr for each one, and writes everything into a dedicated worksheet — formatted, labeled, and ready.
Pull the detailed view data for every video ID in my Excel sheet and append each record as a new row in the "Engagement" tab, including viewer ID and whether they completed the video.
What You Get
- An "Engagement" worksheet populated with one row per view record across all video IDs.
- Columns: videoId, viewerId, watchedPercent, completed.
- Videos with no view records are skipped rather than adding blank rows.
- The worksheet is overwritten each run so Monday's list is always fresh.
What If the Data Is Not Quite Ready
You want the viewer's email address rather than just the viewer ID
For each video ID in column A, fetch all Spotlightr view records including viewer email if available. Write videoId, viewerEmail, watchedPercent, and completed into the "Engagement" sheet — leave viewerEmail blank for anonymous views.
You only want completed views for the priority list
For each video ID in column A, fetch all Spotlightr view records where completed is true and write videoId, viewerEmail, and watchedPercent into the "Completed Views" sheet.
The video IDs are split across two worksheets
Fetch all Spotlightr view records for every video ID in column A of the "Demos" sheet and the "Webinars" sheet. Write all records into a single "All Views" sheet with columns: source, videoId, viewerEmail, watchedPercent, completed.
You want the view records plus a follow-up priority score
For each video ID in column A, fetch all Spotlightr view records and write videoId, viewerEmail, watchedPercent, completed into the "Engagement" sheet. Add a "Priority" column: 3 if completed is true, 2 if watchedPercent is above 0.5 and completed is false, 1 otherwise.
Reps get a ranked list. The entire thing runs before your second cup of coffee.
Try It
Get the 7-day free trial of SheetXAI and open your Excel demo tracking workbook with Spotlightr video IDs in column A. Ask SheetXAI to pull all per-viewer watch records and write them into a new worksheet, ready for the sales team to sort and act on. See also: Pull Spotlightr Analytics Into an Excel workbook and the Spotlightr hub.