Skip to content
Workflow · Track and forecast · Opening soon

Insightly pipeline report by stage and owner

Export your opportunities from Insightly, then group them by pipeline stage and owner. Add count, total value, probability weighted value, and flags for groups that are past forecast close date, have no activity in 30 days, or have no value.

Early access opens shortly. Check back soon.

Someone typed

“show our insightly open opportunities by pipeline stage and owner with count, total and probability weighted value, and flag the groups holding opportunities past their forecast close date, with no activity in thirty days, or with no value”

The agent read it as

show Insightly open opportunities by pipeline stage and owner with count, total and probability weighted value, and flag the groups holding opportunities past their forecast close date, with no activity in thirty days, or with no value

What the agent built

1 step, each one an ordinary Mammoth step you can open and change.

  1. File
    Insightly open opportunities
    CSV export · 40 rows
  2. Step
    Summarize and flag groups
    Step 1
  3. Result
    Opportunity pipeline flags
    28 rows
  4. Schedule
    Runs when you say
    Proposed

On the sample files, every step runs and the result has 28 rows.

What you get back

The result of that run, the rows to look at first.

Opportunity pipeline flagsSample data28 rows
Pipeline StageOwnerOpportunity countTotal value (USD)Probability weighted value (USD)Past close dateNo activity 30 daysNo valueGroup status
QualificationLeah Bennett392,00033,450110Needs attention
VerbalPriya Nair3208,000172,380110Needs attention
DiscoveryNoah Chen334,0006,360101Needs attention
NegotiationDana Ortiz3293,000204,220100Needs attention
ProposalMarcus Flynn162,00034,100100Needs attention
DiscoveryEthan Cole100001Needs attention
QualificationMarcus Flynn244,50016,910001Needs attention
DiscoveryDana Ortiz119,5003,705000No issues
DiscoveryOwen Park114,0002,240000No issues
DiscoveryTara Singh116,0003,520000No issues
NegotiationMarcus Flynn154,00035,100000No issues
NegotiationNoah Chen1125,00092,500000No issues
28 rows in the result · 12 shown, problems first. Sample data: illustrative figures, not business results.

How it works

How to use the Opportunity pipeline flags workflow

  1. 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and working on sample files.
  2. 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
  3. 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.

Opportunity pipeline flags: questions

How do you report Insightly opportunities by stage and owner?
Export your opportunities from Insightly, then group them by pipeline stage and owner. Add count, total value, probability weighted value, and flags for groups that are past forecast close date, have no activity in 30 days, or have no value.
What export should I use from Insightly?
Use an opportunities export that includes pipeline stage, owner, forecast close date, last activity date, value, and probability. Those fields let you build the report and the flags.
What happens to rows that do not match a rule?
Rows that do not match a rule stay in the report unless you set a rule to flag or exclude them. Each row is checked against the rules you define.
How do I change the rules in words?
Edit the rule text to say what should be grouped, summed, counted, or flagged. You can change the fields, thresholds, and labels without changing the whole workflow.

Get early access to this workflow

It opens already built and working on sample files. Swap in your own exports to see your result.

Early access opens shortly. Check back soon.

Workflows like this

The number you report every month, rebuilt from the latest export, plus the forecast that follows from it.

All track and forecast workflows →