Brand mention rows for BI tools
One row per brand per answer: the brand and every configured competitor on every answer, and each discovered brand where an answer names it. Share of voice = SUM(named) as a percent of the total; a tracked brand’s visibility = SUM(present)/SUM(tracked).
GET
Brand mention rows for BI tools