dbt
Answers that pick the right model and match your metric definitions.
01
Dot learns your dbt project
Model docs, SQL and lineage.
Ryan Ortiz9:41 AM
@Dot Where does revenue in fct_orders come from, and does it include refunds?
1 reply
DotAPP9:42 AM
10 steps · 50s · Access Online
From stg_stripe__charges through int_payments, net of refunds. Stripe and Shopify are its sources.
Source: dbt’s fct_orders.
Here is the data.
| Step | Model |
|---|---|
| Sources | stripe, shopify |
| Staging | stg_stripe__charges |
| Intermediate | int_payments |
Today
Ryan Ortiz9:41 AM
Dot Where does revenue in fct_orders come from, and does it include refunds?
Dot9:42 AM
10 steps · 50s · Access online
From stg_stripe__charges through int_payments, net of refunds. Stripe and Shopify are its sources.
Source: dbt’s fct_orders.
- Sources: stripe, shopify
- Staging: stg_stripe__charges
- Intermediate: int_payments
Priya Shah9:41 AM
@Dot Does our MRR model spread annual plans over 12 months? What was September MRR?
1 reply
DotAPP9:42 AM
6 steps · 37s · Access Online
Yes, mrr_monthly spreads them evenly. September MRR was $412K, up 4% on August.
Source: dbt’s mrr_monthly.
Chart
Today
Priya Shah9:41 AM
Dot Does our MRR model spread annual plans over 12 months? What was September MRR?
Dot9:42 AM
6 steps · 37s · Access online
Yes, mrr_monthly spreads them evenly. September MRR was $412K, up 4% on August.
Source: dbt’s mrr_monthly.
Daniel Weber9:41 AM
@Dot Which model should I use for marketing attribution, and how does it credit touches?
1 reply
DotAPP9:42 AM
6 steps · 36s · Access Online
Use fct_attribution. It gives first and last touch 40% each and splits the rest.
Source: dbt’s fct_attribution.
Chart
Today
Daniel Weber9:41 AM
Dot Which model should I use for marketing attribution, and how does it credit touches?
Dot9:42 AM
6 steps · 36s · Access online
Use fct_attribution. It gives first and last touch 40% each and splits the rest.
Source: dbt’s fct_attribution.
02
Dot answers with dbt metrics
Queried through the dbt Cloud Semantic Layer.
Priya Shah9:41 AM
@Dot What was the average contract value of new deals by quarter this year?
1 reply
DotAPP9:42 AM
10 steps · 50s · Access Online
$22.6K in Q3, up 24% since Q1, led by Enterprise.
Source: dbt’s average_contract_value.
Chart
Today
Priya Shah9:41 AM
Dot What was the average contract value of new deals by quarter this year?
Dot9:42 AM
10 steps · 50s · Access online
$22.6K in Q3, up 24% since Q1, led by Enterprise.
Source: dbt’s average_contract_value.
Daniel Weber9:41 AM
@Dot Show weekly signups by acquisition channel since January.
1 reply
DotAPP9:42 AM
10 steps · 1m 0s · Access Online
Organic leads with 4,820 signups. Paid search is up 22% since March.
Source: dbt’s signups.
Chart
Today
Daniel Weber9:41 AM
Dot Show weekly signups by acquisition channel since January.
Dot9:42 AM
10 steps · 1m 0s · Access online
Organic leads with 4,820 signups. Paid search is up 22% since March.
Source: dbt’s signups.
Lisa Park9:41 AM
@Dot Which product modules are behind their ARR target?
1 reply
DotAPP9:42 AM
4 steps · 28s · Access Online
Analytics is 8% behind target at $2.1M. The other three modules are on track.
Source: dbt’s arr.
Here is the data.
| Module | ARR | Of target |
|---|---|---|
| Analytics | $2.1M | 92% |
| Billing | $3.4M | 101% |
| Payroll | $2.8M | 104% |
Today
Lisa Park9:41 AM
Dot Which product modules are behind their ARR target?
Dot9:42 AM
4 steps · 28s · Access online
Analytics is 8% behind target at $2.1M. The other three modules are on track.
Source: dbt’s arr.
- Analytics: $2.1M ARR, 92% of target
- Billing: $3.4M ARR, 101% of target
- Payroll: $2.8M ARR, 104% of target
More in Semantic layers
Looker
Power BI
Cube
Steep
Malloy
Azure Analysis Services
Connect your data.
Start for Free