The Scenario
You're preparing a competitive strategy presentation for next week's leadership review, and your category director has asked a specific question: for the ten core category keywords in your competitive analysis workbook, which brands own the most search real estate, and by how much?
You have the ten keywords in column A of your competitive analysis worksheet. Jungle Scout has the share-of-voice data. What you're about to do by hand is look up each keyword, read off the top three brands and their percentages, switch to the workbook, type them in, and do that ten times.
The bad version:
- Search the first keyword in Jungle Scout, navigate to the share-of-voice view, read the top three brand names and percentages.
- Switch to the workbook, type three brand names into columns B, D, F and three percentages into C, E, G.
- Do this for ten keywords.
- Realize you misread the second brand's percentage on keyword six and have to go back.
This is three hours of work that produces a table any executive will read in sixty seconds.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook. It reads your keyword list, pulls Jungle Scout share-of-voice data, and writes the results into the columns you specify.
For the 10 core category keywords in column A of my Excel competitive analysis sheet, pull the Jungle Scout share-of-voice data and write the top 3 brands and their percentages into columns B through G.
SheetXAI reads each keyword, pulls the Jungle Scout share-of-voice breakdown, and writes the top three brands and their percentages into columns B through G across all ten rows.
What You Get
- Columns B, D, and F with the top three brand names for each keyword's share-of-voice data.
- Columns C, E, and G with each brand's share percentage, formatted consistently.
- Consistent brand name formatting across all rows — no capitalization inconsistencies from manual transcription.
- If a keyword has fewer than three brands with measurable share, the remaining columns are left blank rather than padded with zeros.
What If the Data Is Not Quite Ready
I only want the top brand per keyword, not the top three
For each keyword in column A of my competitive analysis worksheet, fetch Jungle Scout share-of-voice data and write the top brand name and its share percentage into columns B and C.
The percentages are coming back as decimals but I need them as whole percentages
Fetch share-of-voice data from Jungle Scout for each keyword in column A. Write the top three brands into columns B, D, F and their share percentages into C, E, G formatted as whole numbers (e.g., 34, not 0.34).
I want to add a concentration label based on the top brand's share
Fetch Jungle Scout share-of-voice data for each keyword in column A. Write top brand and share into columns B and C. Add a column D labeled "Concentration" — write "Dominated" if the top brand holds more than 40%, "Fragmented" if less than 20%, and "Contested" otherwise.
Kill-chain: pull SOV, calculate brand concentration, and flag high-priority attack keywords
For each keyword in column A of my competitive analysis worksheet, fetch Jungle Scout share-of-voice data. Write the top brand and share into columns B and C. Calculate total top-3 brand concentration in column D. Flag in column E any keyword where no single brand holds more than 25% share — label those "Opportunity" and the rest "Contested." Sort by column D ascending so the most fragmented markets surface first.
Ask for the data pull and the strategic scoring in the same prompt — you get an analysis-ready workbook, not a raw data dump.
Try It
Get the 7-day free trial of SheetXAI and open an Excel workbook with your category keywords in column A, then ask it to pull Jungle Scout share-of-voice data and write brand ownership percentages into the workbook. See the related spoke on building a product launch brief, or return to the Jungle Scout overview.