The SearchAdsHQ team is excited to announce that our platform for Apple Search Ads optimization and management has been supercharged with custom columns.
We’ve seen multiple cases where Apple Search Ads managers needed metrics beyond those already included in the SearchAdsHQ platform. Or they needed to calculate vital metrics in a manner that differs from ours. Custom columns have been designed to fix all those issues.
With the new feature, you can save your own formulas as custom columns to be able to:
- Have your key metrics calculated the way you do and have them readily available in the system;
- Display custom metrics that matter to you on the SearchAdsHQ dashboard and use them for Apple Search Ads optimization;
- Gauge KPIs considering the discrepancies and have them at hand to optimize for.
Custom columns: popular use cases
From the available metrics, numbers and operators, you can make up a wide range of formulas and save them as custom columns on the dashboard.
Below, we’ve described the most popular cases of using this SearchAdsHQ functionality. Needless to say, you can have totally different approaches to calculating the metrics from the examples.
1. The “Custom ROAS” column
Let’s say you want to optimize Apple Search Ads for ROAS. By default, SearchAdsHQ gauges ROAS using the following formula:
ROAS = Revenue / Spend * 100%
This ROAS is displayed on the dashboard.
However, you are aware that you’ve got high discrepancy and the ROAS calculated with the formula above won’t produce clear results for you. You need ROAS corrected to LAT On users, Redownloads and extra organics that come in with paid installs (AppsFlyer suggests adding 5%):
Custom ROAS = (Installs + Installs * Lat On Downloads Share + Installs * Redownloads Share + Organics) * ARPU / Spend
In fact, there are different ways how to calculate ROAS with adjustments, but let’s go with the formula above.
All the settings in SearchAdsHQ will have to be performed from the following popup window:
To create the “Custom ROAS” column, insert all the formula components in the upper menu using the metrics, operators and a number – 0.05 (for Organics).
Then, give the column a unique name, add a description and set percent as the format.
Note! Don’t include “… * 100%” in the very formula if you set percent (%) as the column format: it will be added automatically.
And just like that, you set up a “custom ROAS” column for quick access to the metric you use as well as for better optimization.
2. The “Custom Cost per Goal” column
The same way you did for ROAS, you can build a custom column to get Cost per Goal with discrepancies considered and have it readily available on the dashboard for Apple Search Ads optimization purposes.
On the SearchAdsHQ dashboard, you can find Cost per Goal gauged this way:
CPG = Spend / Goals
However, this calculation doesn’t imply discrepancies. Again, you can get your true Cost per Goal using different approaches, and here’s one of the possible formulas:
Custom CPG = Spend / (Goals / LAT Off Downloads Share)
This is a way to get CPG corrected to LAT On traffic.
Goals in the formula are those generated by LAT Off users. These data can be found in the SearchAdsHQ dashboard (under Goals), along with LAT Off Downloads Share – the percentage of the total downloads number represented by those LAT Off users.
So, to calculate Goals (extrapolated) from the available data, use this formula: Goals/LAT Off Downloads Share.
The Total Goals you get are then factored in the formula to receive Custom CPG corrected to LAT On discrepancies. The formula configured via the SearchAdsHQ custom column will look as follows:
3. The “Custom Conversion Rate” column
Сonversion rate estimates how your funnel works and whether it requires optimization. However, the way you calculate the conversion rate largely depends on what you define as your conversion event and on your funnel in general.
Currently, SearchAdsHQ tracks and displays the following conversions:
- Tap Through Rate (TTR): Taps / Impressions * 100%;
- Download Rate (DR): Downloads / Taps * 100%;
- Goals Rate: Goals / Installs * 100%;
- All Conversions Rate = All Conversions / Installs * 100%.
But for your optimization purposes, you may need conversion statistics beyond those that we offer. For example, you’d like to understand your conversion from impressions to installs, so you need to add in the following formula:
Conversion Rate = Installs/ Impressions
In the SearchAdsHQ platform, the settings will look the following way:
Again, make sure that you name the column in a unique way, and don’t include 100% as a multiplier, while setting percent as the column format.
Depending on the kind of conversion you track, here are other possible formulas to receive custom conversion rates in SearchAdsHQ:
Conversion Rate = Downloads / Impressions
Conversion Rate = Installs / Taps
Conversion Rate = Goals / Taps
Conversion Rate = All Conversions / Taps
How to set up a custom column in SearchAdsHQ
Custom columns can be created from and be applied to any dashboard level, except for search terms and negative keywords. Below is the workflow to make proper settings:
Step 1. Start with clicking on the “Edit Columns” button:
Step 2. Choose “Add Custom Column”:
Step 3. Choose “+New Custom Column”:
Step 4. You’ll see the “Create custom column” popup:
Here, you have to configure the following:
1) the formula itself by using metrics, numbers and operators from the upper menu.
Ad performance and in-app conversion metrics can be selected from the available options in the dropdown menu. By clicking on the “Number”, you’ll see the field to insert the value you want. To add an operator into the formula, simply click on it.
2) the name of the custom column. Make sure you don’t assign one name to different columns, so that you can easily differentiate between them on the dashboard.
3) the column format – value ($), percent (%) or number (1, 2, 3), depending on the metric type. For example, set percent for a custom ROAS column or value for custom Cost per Goal.
Note! Don’t include “… * 100%” in the formula if you set percent (%) as the column format, it is added automatically.
4) the column description, so that you can understand what the column is about after you’ve added it to the system. The description will be displayed on the dashboard in the tooltip associated with the respective custom column.
Step 5. Click “Create”.
The configured custom column will appear in the list of existing columns. If you want to change its position on the dashboard, use the right menu where you can reorder columns by dragging and dropping.
Step 6. Choose “Apply” to add the column to the dashboard.
We’ve described the use cases above only to name a few. In fact, there are many more formulas that you might need and can set up through our platform. Custom columns are a step towards customized Apple Search Ads optimization, tailored to the individual needs of your business.
Want to try? Request a free SearchAdsHQ demo and we will show you how to use custom columns and other platform features to run profitable Apple Search Ads campaigns.