# Signup conversion rate: Formula and dbt YAML | Silicon

URL: https://meetsilicon.com/metrics/signup-conversion-rate/

> Signup conversion rate is the percentage of visitors who create an account.

## Formula
Signup conversion rate = signups / unique visitors
## Why it matters
It measures how well your site and onboarding turn interest into accounts, and is the first step of most growth funnels.
## Common pitfalls
- Visitors and signups must be counted over the same period and from the same traffic sources.
## Define it in dbt for Silicon
Add this to your model's YAML. Aggregate metrics sit under a column's meta.metrics; ratios are type: number metrics that reference other metrics. Rename models and columns to match your project.
schema.yml Copy
models:
- name: fct_web_sessions
meta:
metrics:
signup_conversion_rate:
type: number
sql: ${signups} / NULLIF(${visitors}, 0)
format: percent
description: Share of visitors who sign up
columns:
- name: visitor_id
meta:
metrics:
visitors:
type: count_distinct
description: Unique visitors
- name: signup_id
meta:
metrics:
signups:
type: count_distinct
description: Accounts created
Once it's defined, anyone can ask about signup conversion rate in plain English and get an answer built on this definition. See the metrics reference for every option.
## Related
- Active users ->
- Activation rate ->
- Semantic layer ->
## Tell us where your data lives today.
Book 30 minutes with the founder. Tell us where your data is today, and see Silicon running on sample data.
Talk to Sujay
30-minute call with the founder