Embedded Files
Summary
Summary
This calculation is designed to standardise ad sizes in your dashboards and reports. The logic categorises variations of ad sizes into a single standard size.
This logic can be extended to include other common ad sizes or to standardise dimensions for video, display, or responsive creatives. It's ideal for scenarios where you are managing multiple campaigns across platforms. This type of standardisation ensures that data is clean, reliable, and actionable.
Please see below for benefits and implementation steps.
Benefits
Benefits
Cleans inconsistent data for better reporting
Enables accurate performance comparisons by size
Allows for clear comparison between data sets
Helps avoid fragmented metrics across dashboards
Implementation
Implementation
In this example, we'll be using the Google Ads Manager platform and the Creative Data View but you can apply this logic to any dimension which contains creative size data.
Step 1
Step 1
Navigate to Data in the left navigation then choose Calculation and press the + button.
Create a calculated field using an IF statement
Step 2
Step 2
Use this logic to group the size variations:
Note: [Size] = Text dimension containing your creative size information
Example
Example
IF( [Size] CONTAINS "300 x 250" OR [Size] CONTAINS "300 x 251", "300 x 250", [Size] )
Note: This logic can be extended by transitioning it to a CASE statement.
Step 3
Step 3
Test the calculation and save it by pressing the button at the bottom of the page.
Step 4
Step 4
Add the new calculation dimension to your dashboard widgets and reports.
There is often more than one way to solve a problem in the Tapclicks platform, so it's important to consider how each one could impact the performance of your instance. Here are some key points to keep in mind:
Advanced calculations: While powerful, advanced calculations can slow performance with large datasets. Use simpler calculations when possible and reserve advanced ones for when necessary to maintain efficiency.
Limit CASE statements: Keep CASE statements to 10 branches or fewer. Larger ones can slow processing, so simplify or break them into smaller segments for better performance.
Data lookups for large conditions: For complex conditions, consider using data lookups from external sources like Google Sheets to simplify logic and improve performance.
Page updated
Report abuse