As part of our June 2021 update, Publishwide introduced custom variables, which allow you to gain even deeper insight on your data. With custom variables, you’ll be able to calculate things like figure out the true ACOS of an ad (i.e. include KENP royalty and AMS orders royalty) rather than rely on Amazon’s flawed methods.
This post will help teach you how to build your own Custom Variables!
How Custom Variables Work
At its heart, custom variables work by taking an existing metric and doing math to it.
The inspiration for custom variables came about when I was calculating my true ACOS. Even with Publishwide’s data, I still found myself doing calculations by hand.
That thought formed the basis for custom variables.
The impetus was simple: users will always have their own particular way of looking at data, and there’s simply no way that we can reliably account for all of those different ways.
Building Your First Custom Variable
A quick look at your custom variables page.
The custom variables page is pretty simple to understand:
You can create your own variable by clicking on the “Create Variable” button
You can edit existing variables by clicking on the “Edit” button
You can delete existing variables by clicking on the “Remove” button
For the purpose of this walkthrough, we will be creating a variable for calculating the royalty from your AMS Ads Orders.
First, click on the “Create Variable” button to launch the creation process:
This is where you’ll be building your custom variables
Next, give your variable a name. For our purpose, we’ll call it “AMS Sales Royalty (70%)”
Once you’ve named your variable, select a format. We currently have 4 types of variable formats:
Currency – this will show your variable as a currency
Decimal – this will show your variable as a decimal
Integer – this will show your variable as a whole number
Percent – this will show your variable as a percentage
N.B. If you don’t know what format you want your variable to be, you can leave it blank and Publishwide will try to figure out what the format should be, based on the existing metrics you want to do math on.
After you select the variable format, click on the “+” to add the initial variable that you’d like to do math on. For our purpose, we’ll select “Ads Sales” – the creation box should look like this:
Next, you’ll want to click the “+” sign again and select a mathematical function. We currently support the following functions:
Once you’ve selected a mathematical function, you’ll need to add another value. In this case, we would select “Fixed Value” and put in “0.7”
Then, click the “Create Variable” button to finish. You should have a brand new custom variable called “AMS Sales Royalty (70%)”
Using Multiple Custom Variables at Once
You can create a custom variable that uses a custom variable that you’ve already created.
For example, if we take the new “AMS Sales Royalty (70%)” variable that we just created, we can add it to the “Ads KENP Royalty” metric and use that to figure out the total actual income your AMS ads have earned. See below:
You can use a custom variable that you built as part of another custom variable
We can then divide the Spend metric with that custom variable to determine the true ACOS of your ads!
Now you can calculate the true ACOS based on the sum of your AMS KENP and AMS orders royalty
Other Things You Should Know About Custom Variables
If you delete a custom variable that is used by other custom variables, this will automatically invalidate the other ones and throw an error on your reports that use them.
Custom variables follow order of operations – which means multiplication/division is performed before addition/subtraction.
We will continue making additional improvements to custom variables in the near future. In the meantime, we hope that custom variables will help you gain deeper actionable insights on your existing data!