sourcetable

Calculate Viewability Metrics

Calculate anything using Sourcetable AI. Tell Sourcetable what you want to calculate and see your results in a spreadsheet.


Learn more
Jump to

Introduction

Understanding viewability metrics is crucial for digital marketers and advertisers aiming to evaluate the actual visibility of their ads on a screen. Calculating viewability involves determining if an advertisement is seen by a user within a specific viewing space and duration. This metric is essential for improving ad performance and spend efficiency. Essential factors include the percentage of the ad displayed and the time duration for which it is visible. Techniques and tools vary, but precise calculation is key.

With the rise of AI tools in digital marketing, platforms like Sourcetable have simplified the tracking and calculation of complex metrics such as viewability. We will delve into effective methods to calculate viewability and demonstrate how Sourcetable's AI-powered spreadsheet assistant enhances these tasks, offering intuitive and accurate analysis. Learn more about this tool and try it for yourself at app.sourcetable.com/signup.

sourcetable

How to Calculate Viewability

To accurately measure ad viewability, you must follow a precise calculation methodology. Viewability indicates whether an ad was visible to a user and is a critical metric for optimizing ad performance.

Understanding Viewability Metrics

Viewability is defined as the ability of an advert to be seen by a user. To calculate the viewability rate, use the formula Viewability Rate = (Viewable Ad Impressions / Measured Ad Impressions) x 100. This metric helps determine the effectiveness of ad placements and their visibility to users.

Tools Required for Calculating Viewability

It is essential to use the right tools for tracking ad viewability. Third-party vendors such as IAS, MOAT, Comscore, and DoubleVerify are equipped to measure viewability through integrations with marketing platforms. Additionally, specific partners may be needed for tracking viewability on walled gardens like Facebook and Amazon.

Key Considerations for Accurate Measurement

Ensure that you're using measured ad impressions, which are always lower than the total ad impressions due to measurement limitations by vendors. This distinction is crucial for the accuracy of the viewability rate. Moreover, adding a measured rate to marketing dashboards can aid in the clarity and stability of viewability data, making it easier to track and optimize in real-time.

Best Practices for Viewability Calculation

To maximize the accuracy and utility of viewability metrics, establish a baseline before implementing changes. Regularly utilize A/B testing on ad layouts and optimize both the page speed and the loading methods of ads to enhance chances of them being viewed. Activate asynchronous loading to decrease unseen ads and adapt your strategies to meet evolving viewability standards from partners.

sourcetable

How to Calculate Viewability in Digital Advertising

Viewability in digital advertising is a crucial metric, indicating the percentage of ads that are actually seen by users. To accurately measure this, follow these defined steps aligned with industry standards.

Understanding Viewability

Viewability is measured only for ads that are on the screen for at least one second. This standard ensures that only meaningful impressions are considered in the calculation.

Calculating Viewability Rate

To determine the viewability rate of your digital ads, apply the formula Viewability Rate = (Viewable Ad Impressions / Measured Ad Impressions) x 100. Here, Measured Ad Impressions refer to the impressions that are measurable by viewability tracking systems. Not every impression can be measured due to technical limitations, making measured impressions typically less than total impressions.

Using Third-Party Tools

Implementing third-party tools such as IAS, MOAT, Comscore, and DoubleVerify is standard practice. These tools are integrated with marketing platforms to effectively track viewability, ensuring accurate reporting and insights.

Additional Metrics

Beyond the basic rate calculation, consider evaluating Average Time in View and using Quartile Viewability Rates for a deeper analysis. These metrics can highlight when and how long ads were viewed, providing a robust understanding of ad performance.

Viewability is not just a number; it's a significant indicator of ad effectiveness and user engagement. Proper calculation and analysis of viewability can lead to more strategic decisions in digital marketing campaigns.

sourcetable

Examples of Calculating Viewability

Example 1: Basic Viewability Calculation

Determine if 50% of an ad's pixels are in view for at least one second. If an ad size is 300x250 pixels, ensuring that at least 150x125 pixels are visible for one second meets the standard viewability threshold. Calculate the visible area and compare it to 300x250/2. Record the visible duration to confirm it exceeds one second.

Example 2: Viewability in a Scrolling Page

Track an ad at the bottom of a content page. As the user scrolls, start a timer once 50% of the ad appears in the viewport. If the timer records at least one second while 50% or more of the ad remains visible, the ad is viewable. Use JavaScript to detect and calculate the pixel dimensions and the time.

Example 3: Video Ad Viewability

For a video ad to be considered viewable, at least 50% of its area should be visible while playing for at least two consecutive seconds. Calculate the viewable threshold by measuring the area of the video player and the duration of its visibility. Use event listeners to track when the visibility criteria are met.

Example 4: Calculating Viewability with Multiple Open Tabs

Measure viewability when multiple tabs are open and the ad might not be in the active tab. Only count the ad as viewable when its tab is active, and it meets the previously stated visibility and time criteria. Use browser focus events to detect when the tab is active.

sourcetable

Master Calculations with Sourcetable

Discover the power of Sourcetable, an AI-powered spreadsheet designed to enhance how you compute, from daily tasks to complex data analysis. Whether you're tackling academic challenges, streamlining work processes, or exploring new data insights, Sourcetable stands apart as a versatile tool engineered for accuracy and efficiency.

Calculate Viewability with Ease

Understanding how to calculate viewability is crucial in digital advertising to gauge ad impressions that are actually seen by users. Sourcetable simplifies this process. By inputting the necessary data, such as total ad impressions and measurable impressions, Sourcetable's AI instantly computes the viewability rate using the formula (Measurable Impressions / Total Impressions) * 100%. The results are displayed clearly in the spreadsheet, while the integrated chat interface provides a detailed explanation of the steps taken, ensuring full transparency and understanding of the calculation.

AI Assistance for Every Need

Sourcetable's AI assistant is not just another tool; it's your personal calculation partner. It can process any mathematical query with precision, making it invaluable for students, professionals, and anyone in need of reliable computational aid. From solving complex equations to performing statistical analysis, Sourcetable provides answers and explanations swiftly, which enhances learning and decision-making.

Choose Sourcetable for its blend of advanced AI capabilities and user-friendly interface, tailored to support a myriad of computational needs across different fields. Experience a smarter way to calculate and collaborate with Sourcetable.

sourcetable

Use Cases for Calculating Viewability in Digital Advertising

Optimizing Campaign Effectiveness

By calculating viewability rate using the formula (Viewable Impressions / Total Impressions) x 100 = Viewability Percentage, advertisers can gauge the effectiveness of their ads. A higher viewability implies a greater chance of the ads influencing consumer behavior, thus enhancing campaign effectiveness.

Cost Efficiency Analysis

Utilizing viewable CPM, advertisers can determine the economic efficiency of their campaigns. This metric enables comparison between the cost of viewable impressions and the total CPM paid, ensuring budget is spent on ads that are actually seen.

Improving Ad Visibility and Impact

Knowing the quartile viewability rate of video ads helps advertisers understand viewer engagement at critical intervals (25%, 50%, 75%, 100%) of the video. This information is crucial for adapting creative elements to maintain viewer interest and maximize impact.

Accounting and Accountability

Through the metric of burned budget, advertisers can assess how much of their expenditure was used on unviewed ads. This metric provides accountability by highlighting inefficiencies and enabling more strategic budget allocations.

Performance Benchmarking

With viewability metrics, advertisers can benchmark performance across different publishers and platforms, adjusting strategies based on comparative data to improve overall visibility and impact of their advertisements.

sourcetable

Frequently Asked Questions

How is the viewability rate calculated?

The viewability rate is calculated by dividing the number of viewable ads by the number of measured ads.

What is the formula for calculating the viewability percentage?

The viewability percentage formula is: Viewability = (total viewable ad impressions / total measured ad impressions) x 100.

How is average time in view calculated?

Average time in view is calculated by dividing the total time in view by the number of viewable ads.

What is quartile viewability rate and how is it calculated for video ads?

Quartile viewability rate is used for video ads and measures whether an ad is viewable at the 25, 50, 75, or 100 percent of the video playthrough.

How is viewable CPM calculated?

Viewable CPM is calculated by dividing the cost to serve only viewable impressions by the CPM paid to serve all ad impressions.

Conclusion

Understanding how to calculate viewability is crucial for optimizing ad performance and ensuring effective visibility. Calculating this metric involves determining the percentage of an ad that appears in view for a specified duration. Viewability rates are crucial for advertisers seeking to evaluate the actual exposure of their ads to potential customers.

Sourcetable, an AI-powered spreadsheet, simplifies these calculations and more, making it an invaluable tool for advertisers and marketers. Its user-friendly interface allows for easy input and manipulation of data, enabling users to efficiently calculate metrics like viewability. Moreover, Sourcetable supports experimenting with AI-generated data, providing a practical platform for testing and refining marketing strategies.

Experience the ease of performing advanced calculations by trying Sourcetable for free at app.sourcetable.com/signup.



Sourcetable Logo

Calculate anything you want with AI

Sourcetable takes the math out of any complex calculation. Tell Sourcetable what you want to calculate. Sourcetable AI does the rest. See the step-by-step result in a spreadsheet and visualize your work. No Excel skills required.

Drop CSV