If you are not much of a reader, you can watch the webinar where our Marketing Specialist Marek will explain everything you need to know about Numeric variables:
Here is a list of formulas used in the video:
VAT
Base Price * VAT Rate
Example: If the base price is $100 and VAT is 20%, then:
VAT = 100 * 0.20 = $20
Extract VAT from Total Price
Final Price - (Final Price / (1 + VAT Rate))
Example: If the final price is $120 and VAT is 20%, then:
VAT = 120 - (120 / (1 + 0.20)) = 120 - 100 = $20
Base price
Final Price / (1 + VAT Rate)
Example: If the final price is $120 and VAT is 20% → Base Price = 120 / (1 + 0.20) = $100
Fixed discount
Original Price - Sale Price
Example: If the original price is $150 and the sale price is $120, then:
Discount = 150 - 120 = $30
Discount %
((Original Price - Sale Price) / Original Price) * 100
Example: If the original price is $150 and the sale price is $120, then:
Discount % = ((150 - 120) / 150) * 100 = (30 / 150) * 100 = 20%
ROAS
Revenue / ad spend
Example: If revenue is $5,000 and ad spend is $1,000, then:
ROAS = 5000 / 1000 = 5 (meaning you earn $5 for every $1 spent on ads)
ROAS in %
(Revenue / Ad Spend) * 100
Example: If revenue is $5,000 and ad spend is $1,000, then:
ROAS % = (5000 / 1000) * 100 = 500%
CPA
Ad Spend / conversions
Example: If ad spend is $1,000 and you got 50 conversions, then:
CPA = 1000 / 50 = $20 (meaning it costs $20 to acquire one customer
Conversion rate
(Conversions / Clicks) * 100
Example: If you have 500 clicks and 50 conversions, then:
Conversion Rate = (50 / 500) * 100 = 10%
Fixed profit margin
Revenue - COGS
Example: If revenue is $10,000 and COGS is $6,000, then:
Profit = 10,000 - 6,000 = $4,000
Profit margin %
((Revenue - Cost) / Revenue) * 100
Example: If revenue is $10,000 and total cost (COGS) is $6,000, then:
Profit Margin % = ((10,000 - 6,000) / 10,000) * 100 = (4,000 / 10,000) * 100 = 40%
Creating your own numerical variables doesn’t differ very much from creating the text ones – the name and input text are fundamental here as well. What is an additional feature, though, is mathematical operations.
As usual, choose such a name for your variable that lets you know what value it gives back to you.
EXAMPLE 1: Your data source features only prices with VAT not included, and you’ve decided to create a variable that does include VAT. The equation will look like this – price*1.21.
Enter the equation as your input text (1.). The preview will show you the supplemented equation (2.) as well as its result (3.).
You can read more about variables on our blog.