Embedded Files
Summary
Summary
This logic is designed to group device types into consistent, easy-to-understand categories based on common variations in platform labels. For example, terms like “Smartphone,” “Mobile Phone,” or “Mobile” are all standardised under a single category.
This approach helps ensure consistency across datasets, making it easier to compare performance metrics like impressions, clicks, or conversions across devices. It's especially useful when consolidating data from multiple platforms or preparing clear, client-facing reports.
Please see below for benefits and implementation steps.
Benefits
Benefits
Reduces confusion caused by varied device type terminology across platforms.
Standardized device categories enable actionable insights, such as:
Adjusting creative for better performance on "Mobile."
Investing more in "TV" if it shows higher engagement.
Implementation
Implementation
Step 1
Step 1
Navigate to Data in the left navigation then choose Calculation and press the + button.
Create a calculated field using a CASE statement
Step 2
Step 2
Use this logic to group the Device Type variations:
Note: Any values not assigned by the lines in the CASE statement will be labelled as "Unassigned"
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