Weekly Competitive Radar in Slack, Powered by Ramp Spend Data

Build me a weekly competitive radar that runs on a cron schedule every Monday at 8am America/New_York. The trigger is purely time-based, no other inputs.

Configurable inputs for the workflow:

1) category_slug — the Ramp Rate software category we compete in (for example crm or marketing-automation). 2) our_vendor_name — our company name as it would appear in the leaderboard (for example HubSpot). 3) slack_channel — the channel ID or name to post into (default #competitive). 4) competitor_count — how many top competitors to profile alongside us (default 3).

Each Monday the agent should do the following with the Ramp Data integration (no auth, public dataset):

Step 1: Resolve our_vendor_name to a canonical vendor slug using Resolve Ramp Rate Vendor Name. If the resolver returns nothing, post a short Slack message to slack_channel saying the radar could not identify our vendor and stop.

Step 2: Call Get Ramp Rate Category Summary for category_slug to get overall adoption and growth context for the category.

Step 3: Call Get Ramp Rate Category Vendor Leaderboard for category_slug. Read the ranked list and identify (a) our current rank, (b) the top competitor_count vendors that are not us, (c) any vendor whose rank shifted notably versus the previous run (the agent should remember last week's leaderboard between runs).

Step 4: Call Get Ramp Rate Vendor Profile once for our vendor and once for each of the top competitor_count competitors. From each profile capture adoption rate, year-over-year growth, new adopter share, and competitor switch-in / switch-out rate.

Step 5: Compose an analyst-brief Slack message and post it to slack_channel using Slack — Send a Message. The message must:

• Lead with a single one-sentence headline calling out the most important shift this week (a leaderboard move, a competitor with surging new-adopter share, our switch-in rate inflecting up or down, or a category-level growth turn). • Then a short Where We Stand line: our rank, our adoption rate, and our YoY growth versus the category. • Then a Movers section: who climbed or fell on the leaderboard since last run, with the size of the move. • Then a Momentum section: which competitor has the strongest new-adopter share right now and whether ours is rising or falling. • Then a Switch flow line: is our switch-in rate trending up or down, and which competitor we are pulling from or losing to most. Keep the tone tight and analyst-like, no marketing fluff, no emojis beyond at most one in the headline, no hedging language.

Persist the leaderboard snapshot between runs so the next Monday's message can compare against it. On the very first run, skip the week-over-week comparison sections and note that this is the baseline.

Handle empty data gracefully: if any Ramp Data response comes back with an empty data array, post a short message to slack_channel saying the radar found no rows for that category this week and skip the rest of the brief.

Additional information

What does this prompt do?

Pulls fresh adoption and growth numbers for your software category from Ramp's public spend dataset every Monday morning.
Compares you against the top three competitors on adoption rate, year over year growth, new adopter share, and switch-in rate.
Posts an analyst-brief Slack message that leads with the single biggest shift since last week, then calls out leaderboard moves and momentum changes.
Runs unattended on a weekly schedule so your category lead, PMM, or founder always opens Monday with a real read on the market.

What do I need to use this?

A Slack workspace and a channel for your competitive updates (for example, #competitive).
The category your product competes in, written as a slug like crm or marketing-automation.
Your own vendor name and the names of the top competitors you want tracked.

How can I customize it?

Change the schedule. Move the run to a different day or time, or switch to monthly if weekly feels too frequent.
Swap the Slack channel or send the brief as a DM to a specific exec instead of a public channel.
Adjust the comparison set. Track the top five vendors instead of three, or pin a specific list of named competitors you care about.

Frequently asked questions

Where does the data come from?

Ramp publishes anonymized adoption and spend benchmarks for software categories based on real customer activity. This workflow reads that public data, so the numbers reflect actual buyer behavior instead of vendor self-reporting.

Do I need a Ramp account?

No. The Ramp dataset used here is public, so there is nothing to set up on the Ramp side. You only need to connect Slack so the brief can be posted.

What if my category is not tracked?

Ramp tracks a long list of software categories, but coverage is not universal. If your exact category is missing, pick the closest match (for example, sales-engagement instead of outbound-tooling). The agent will tell you if the slug it tries comes back empty.

Can I post to more than one channel?

Yes. Duplicate the workflow, or ask the agent to fan out the same brief to a leadership channel and a wider product channel with slightly different framing for each.

How long is the Slack message?

Short on purpose. The brief is written in an analyst tone, leads with the single most important shift, and keeps the rest to a few tight bullets so it gets read on a phone before the first meeting of the week.