Sigma
Trace any Sigma number to its source, then carry your workbooks over to Dot.
01
Dot explains your workbooks
Formulas, warehouse SQL, lineage and live values.
Daniel Weber9:41 AM
@Dot How is ROAS calculated in our Paid Media workbook?
1 reply
Dot9:42 AM
Attributed revenue divided by ad spend, per campaign. It reads ad_spend and orders in BigQuery.
Source: Sigma’s Paid Media.
[Attributed Revenue] / [Ad Spend]Today
Daniel Weber9:41 AM
Dot How is ROAS calculated in our Paid Media workbook?
Dot9:42 AM
Attributed revenue divided by ad spend, per campaign. It reads ad_spend and orders in BigQuery.
Source: Sigma’s Paid Media.
[Attributed Revenue] / [Ad Spend]
Lisa Park9:41 AM
@Dot What does the Pipeline workbook show for Q4 commit right now?
1 reply
Dot9:42 AM
$3.6M right now, up $400K since Monday.
Source: Sigma’s Pipeline.
Here is the data.
| Q4 commit | Now |
|---|---|
| Amount | $3.6M |
| Deals | 41 |
Today
Lisa Park9:41 AM
Dot What does the Pipeline workbook show for Q4 commit right now?
Dot9:42 AM
$3.6M right now, up $400K since Monday.
Source: Sigma’s Pipeline.
- Amount: $3.6M now
- Deals: 41 now
David Mensah9:41 AM
@Dot Which of our Sigma workbooks read the orders table?
1 reply
Dot9:42 AM
Five: Pipeline Health, Daily Revenue, Cohorts and two more.
Source: Sigma’s lineage.
Here is the data.
| Workbook | Elements on orders |
|---|---|
| Pipeline Health | 6 |
| Daily Revenue | 4 |
| Cohorts | 3 |
Today
David Mensah9:41 AM
Dot Which of our Sigma workbooks read the orders table?
Dot9:42 AM
Five: Pipeline Health, Daily Revenue, Cohorts and two more.
Source: Sigma’s lineage.
- Pipeline Health: 6 elements on orders
- Daily Revenue: 4 elements on orders
- Cohorts: 3 elements on orders
02
Rebuild workbooks in Dot
One tab per page, every element checked against Sigma.
Lisa Park9:41 AM
@Dot Recreate our Pipeline Health workbook in Dot.
1 reply
Dot9:42 AM
All but one element matches; it differs by a time zone cutoff.
Source: Sigma’s Pipeline Health.
- Pipeline
- $14.2M
- Win rate
- 27%
- Sales cycle
- 48 days
Today
Lisa Park9:41 AM
Dot Recreate our Pipeline Health workbook in Dot.
Dot9:42 AM
All but one element matches; it differs by a time zone cutoff.
Source: Sigma’s Pipeline Health.
- Pipeline
- $14.2M
- Win rate
- 27%
- Sales cycle
- 48 days
David Mensah9:41 AM
@Dot Rebuild just the Forecast page, and keep its scenario control.
1 reply
Dot9:42 AM
Rebuilt. The control still switches scenarios.
Source: Sigma’s Forecast.
- Plan
- $12.0M
- Upside
- $13.4M
- Downside
- $10.9M
Today
David Mensah9:41 AM
Dot Rebuild just the Forecast page, and keep its scenario control.
Dot9:42 AM
Rebuilt. The control still switches scenarios.
Source: Sigma’s Forecast.
- Plan
- $12.0M
- Upside
- $13.4M
- Downside
- $10.9M
Sarah Chen9:41 AM
@Dot In the rebuilt Pipeline Health, compare every chart with last year.
1 reply
Dot9:42 AM
Done. Each chart now shows both years.
- Pipeline
- +18%
- Win rate
- +3 pts
- Sales cycle
- −6 days
Today
Sarah Chen9:41 AM
Dot In the rebuilt Pipeline Health, compare every chart with last year.
Dot9:42 AM
Done. Each chart now shows both years.
- Pipeline
- +18%
- Win rate
- +3 pts
- Sales cycle
- −6 days
More in Dashboards
Tableau
Metabase
Connect your data.
Start for Free