Weekly Competitor Share-of-Voice Report in Notion (Talkwalker)

PromptCreate workflow

Build me an agent workflow that produces a weekly competitor share-of-voice report and saves it as a new page inside a Notion database.

Trigger: cron, every Monday at 8:00am in my local timezone.

Inputs I should be able to configure when I install the workflow:

1) My own brand: either a Talkwalker project ID + topic ID for my brand, or a free-text query if I don't have a project configured. 2) A list of competitors, each with a display name and a Talkwalker query string (3 to 8 competitors is typical). 3) The Notion parent: a database ID for a 'Competitive Intel' (or similarly named) database where the new page should be created. 4) Optional: a list of stakeholder names to address in the recommended actions section.

What the agent should do on each run:

Step 1 — Pull data for my brand. If a project + topic is configured, call Talkwalker's Get Histogram (Project) operation for the last 7 days, requesting volume, sentiment distribution, theme breakdown, and demographic split. If no project is configured, fall back to Talkwalker's Get Histogram (Global) operation with my brand query for the same window and metrics.

Step 2 — Pull data for each competitor. For each competitor in the list, call Talkwalker's Get Histogram (Global) operation for the same 7-day window with the same volume / sentiment / themes / demographics breakdown so the numbers are directly comparable. Histogram calls cost 10 credits each, so respect the configured competitor list and don't fan out beyond it.

Step 3 — Pull top influencers. For my brand and for each competitor, call Talkwalker's Get Top Influencers operation over the same 7-day window to identify the authors and sources driving each conversation. Capture name, reach/engagement, and a representative post or link if available.

Step 4 — Compare to the previous 7 days. Re-run histograms for the prior week (day 8 through day 14) for each brand so you can compute week-over-week deltas in volume, sentiment mix, and theme weight. Cache or pass these alongside the current-week numbers.

Step 5 — Synthesize. Don't just dump numbers. Write a real competitive analysis with: (a) a share-of-voice ranking of all brands by volume and by reach with WoW deltas; (b) sentiment leaders and losers, calling out who shifted positive/negative and why the themes suggest it happened; (c) the narrative themes each competitor is winning, with one or two example phrases per theme; (d) notable influencer moments per brand (which voice drove the spike, and what they said); (e) a 'so what for us' recommended actions section with 3 to 5 concrete moves my team should consider this week.

Step 6 — Write the report to Notion. Call Notion's Create a Page operation with the configured database as parent. Title format: 'Competitive SOV — Week of {Monday date}'. Page body sections, in order: Executive Summary; Share-of-Voice Rankings (volume + reach + WoW deltas); Sentiment Leaders & Losers; Narrative Themes by Competitor; Top Influencers & Notable Moments; Recommended Actions for Our Team; Methodology & Sources (lists the Talkwalker queries used and the date range, so the report is auditable).

Tone: written for a marketing leader skimming on Monday morning. Tight, opinionated, decision-oriented. Use bullets and short paragraphs, not walls of text. The agent's value is synthesis and framing, not charts.

Error handling: if a single competitor query fails (rate limited, bad query, no data), continue with the others and note the gap in the Methodology section instead of aborting the whole run. If the Notion create call fails, retry once, then surface the full report text so I can paste it manually.

Additional information

What does this prompt do?

Ranks share of voice for your brand against a configurable list of competitors using the last seven days of social and news mentions.
Surfaces week-over-week deltas, sentiment leaders and losers, and the narrative themes each competitor is winning or losing.
Calls out the top influencers and notable moments driving each brand's conversation that week.
Writes a polished competitive intel page to a Notion database with an executive summary, per-competitor breakdowns, and recommended actions for your team.

What do I need to use this?

A Talkwalker account with a project configured for your brand, plus the competitor names or queries you want to track.
A Notion workspace with a Competitive Intel database (or any database where the new page should live).
About fifteen minutes to confirm the competitor list, the Notion database, and the delivery time.

How can I customize it?

Change the schedule. Monday morning is the default, but you can move it to any day or hour that fits your team's planning rhythm.
Edit the competitor list. Add, remove, or rename competitors at any time, and tune each query to be as broad or narrow as you want.
Reshape the Notion page. Adjust which sections appear, rename the database, or have Geni write directly to a parent page instead of a database.

Frequently asked questions

Do I need a paid Talkwalker plan for this to work?

Yes. This workflow uses Talkwalker's analytics, so you need a Talkwalker login that can access projects, histograms, and influencer data for your brand and competitors.

How many competitors can I track?

There is no hard limit, but each competitor in the list adds a few Talkwalker calls per run. Most teams track between three and eight competitors so the Monday report stays focused and fast.

What if I do not have a project for my own brand in Talkwalker?

Geni can run the same analysis using a global query for your brand, just like it does for competitors. The output is the same, you just lose access to project-specific topics and filters.

Can the report go somewhere other than Notion?

Yes. You can ask Geni to send the same write-up to a Slack channel, an email, or a Google Doc instead. Notion is the default because it is the most common home for ongoing competitive intel.

How is this different from a Talkwalker dashboard?

A dashboard shows charts. This workflow reads those charts for you, compares brands, and writes a narrative analysis with rankings, deltas, and recommended actions, so the Monday meeting starts with conclusions instead of raw data.

Stop staring at competitor dashboards on Monday morning.

Connect Talkwalker and Notion once, and Geni delivers a written competitive intel report to your team every week.

Explore more prompts Create workflow