What is Revenue per Year?
Revenue per Year is the amount of revenue your company generates from a single customer over the course of a year.
Revenue per year can be calculated by dividing your total revenue by the number of customers you have.
Revenue per year is a great way to see how much revenue your company is generating from its customers.
For example, if you have 100 customers and you generate $1,000,000 in revenue, your revenue per year is $10,000.
How do you calculate Revenue per Year in Redshift?
It can be difficult to calculate Revenue per Year directly inside of Redshift; that's where Causal comes in.
Causal is a modelling tool which lets you build models on top of your Redshift data. You simply connect Causal to your Redshift account, and then you can build formulae in Causal to calculate your Revenue per Year.
What is Causal?
Causal lets you build models effortlessly and share them with interactive, visual dashboards that everyone will understand.
In Causal, you build your models out of variables, which you can then link together in simple plain-English formulae to calculate metrics like Revenue per Year. This makes your models easy to understand and quick to build, so you can spend minutes, not days, on your models.

When you're done, you can share the link to your model with stakeholders. They'll be able to view your model's outputs in a visual dashboard, rather than a jumble of tabs and complex formulae. The dashboards are interactive, letting viewers tweak your assumptions to see how they affect the model's outputs.
Causal lets you add visuals in a single click, letting you plot out graphs and distributions for metrics like Revenue per Year.