MARKET RESEARCH
Monthly Ecosystem Pricing Landscape Report
Once a month, rolls up every tracked competitor's snapshots into a single landscape report covering pricing trends, packaging shifts, and feature-gating moves across the whole…
How it runs
The automated pipeline, trigger to output.
- TriggerMonthly schedule fires
- ActionRead full snapshot historyCoda
- LogicAggregate ecosystem metrics and trend deltas
- ActionWrite narrative landscape reportOpenAI
- ActionSave report docGoogle Drive
- OutputPost report with top three shiftsSlack
What it does
The weekly trackers catch individual changes; this template steps back and synthesizes the whole category once a month. It pulls every snapshot history from the tracking store, computes ecosystem-level trends (median entry price, how many players went usage-based, which features migrated up or down tiers), and writes a structured landscape report with charts described in prose.
When to use it
Use it to feed monthly strategy reviews, board updates, or pricing-committee meetings. It answers "where is the category heading" rather than "what did one competitor do" — and it does it without an analyst spending a day in spreadsheets.
How it works
- 1A monthly schedule fires the run.
- 2The full snapshot history is read from Coda.
- 3A logic step aggregates cross-competitor metrics and trend deltas versus the prior month.
- 4An OpenAI step writes the narrative landscape report with sections per theme.
- 5The report is saved to a Google Drive doc for distribution.
- 6A Slack post links the report and highlights the three biggest ecosystem shifts.
Set it up
What you configure once, before turning it on.
- 1Connect CodaDocs, packs, automations.
- 2Connect OpenAIModels, embeddings, files.
- 3Connect Google DriveDocs, sheets, slides, files.
- 4Connect SlackChannels, DMs, threads, mentions.
- 5Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
- 6Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
- 7Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.
More Market Research workflows
Weekly Materiality-Ranked Filing Digest by Email
Each Friday, aggregates the week's regulatory filings across the coverage universe, ranks them by materiality.
Earnings Keyword-Spike Alert into Linear
Scans new earnings-call transcripts for a set of strategic keywords you care about, and when a competitor's mention frequency spikes above its historical baseline.
Allocate Sales Territory TAM from BigQuery Geo Data to HubSpot
When triggered by a webhook, queries BigQuery public ZIP-level business data to compute TAM per sales territory.
Discover Adjacent Segments from BigQuery and Rank Expansion Bets
On a schedule, scans BigQuery public industry data for fast-growing NAICS sectors adjacent to your core segments, scores them as expansion bets.
Blend BigQuery TAM with Live Competitor Signals into a Notion Brief
On demand, sizes a chosen segment from BigQuery public data, gathers current competitor signals via Brave Search, and synthesizes a one-page market brief into Notion.
Cross-Competitor Theme-Shift Analyst
An agent that gathers the latest earnings transcripts across all tracked competitors, compares this quarter's themes against the prior quarter stored in Coda.
Run it inside a business
This workflow drops into a full company template. Import the org, and this is one of the playbooks its agents run.
Run this workflow in your colony.
14-day trial. No DevOps. No Sales call. Provisioned in under a minute.