The value of speed

After a lot of hard work, you’ve done it. You’ve made your company’s site
noticeably faster. Now it’s time for the fun part: showing stakeholders how much
extra revenue your work has generated!
In this post we’ll walk through how to do that by calculat…


This content originally appeared on web.dev and was authored by Lina Hansson

After a lot of hard work, you've done it. You've made your company's site noticeably faster. Now it's time for the fun part: showing stakeholders how much extra revenue your work has generated!

In this post we'll walk through how to do that by calculating the relative mobile conversion rate. This metric is useful because it quantifies the effects of site improvements while excluding external factors like marketing campaigns, which can obscure your findings. Let's get started!

Relative Mobile Conversion Rate (Rel mCvR)

A site's conversion rate can be influenced by site characteristics—like speed and usability—and by external factors—like marketing campaigns, seasonal events, and the mix of marketing channels.

A conversion happens when a site visitor becomes a customer. What counts as a conversion will vary depending on the nature of the site. Buying a product, subscribing to a service, registering as a user, or even just viewing a particular page could be considered a conversion. Check with your marketing team if you're not sure how conversions are counted in your company.

Since you're interested in how site speed affects conversions, the mobile site is most relevant—that's where you're most likely to see the benefits of speed improvements. Rather than looking at the mobile conversion rate alone, though, you'll be analyzing the relative mobile conversion rate (Rel mCvr), which is calculated by dividing the mobile conversion rate by the desktop conversion rate. This approach reduces the noise from external factors, which tend to affect both desktop and mobile, and makes it easier to see whether any increases in the mobile site's effectiveness were actually caused by the speed improvements.

Table showing comparison of mobile/desktop conversion rate and relative mobile conversion rate

Caution: Rel mCvR is influenced not only by speed, but also by other site characteristics like usability. If other big changes were made to the site during the period you want to analyze, you won't be able to measure the effects of speed improvements on their own, but you can show the benefits of all the improvements as a group.

Doing the analysis

If you have access to your site's page analytics data, you can follow along using that. This walkthrough uses Google Analytics to get site data. If you don't have a Google Analytics account, you can learn how to set one up at Get started with Analytics. Or, if you just want to see how Rel mCvR is calculated, you can get the sample data set shown below from this Google Sheet and skip steps 1–3.

Step 1: First get the speed and conversion data for the mobile site.

  • Open this custom report in Google Analytics, select your site from the Select a view drop-down list, and click Create.
  • Once the report has been generated, click Select a metric > Metric Group > Ecommerce Conversion Rate.

    Screenshot of Google Analytics: select a metric, Metric Group, Ecommerce Conversion Rate

  • Select the Week view for the dataset.

    Screenshot of Google Analytics: select a week

  • Select a time period that covers 2–3 months before the speed optimization and 2–3 months after. (In our example, that's January 2018 through October 2018.)

    Screenshot of Google Analytics: select a start date

  • Export the report to Google Sheets or your preferred spreadsheet application.

    Screenshot of Google Analytics: export to Google Sheets

Step 2: Now get the speed and conversion data for the desktop site. Open this custom report in Google Analytics and repeat the process for step 1 to export the data to a spreadsheet.

Step 3: Copy the Ecommerce Conversion Rate column in the desktop report spreadsheet and insert it next to the Ecommerce Conversion Rate in the mobile report spreadsheet.

Step 4: To calculate the Rel mCvR, create a new column titled Relative Mobile Conversion Rate (Rel mCvR). Then add a formula to divide the mobile conversion rate by the desktop conversion rate.

Screenshot: spreadsheet cells showing relative rate formula

Step 5: Create a chart based on the Mobile Avg. Page Load Time (sec) and Relative Mobile Conversion Rate (Rel mCvR) columns. To do that in Google Sheets:

  • Click Insert > Chart.
  • In the Chart Editor pane, select the Line chart chart type.
  • Select the Week Index, Mobile Avg. Page Load Time (sec), and Relative Mobile Conversion Rate (Rel mCvR) columns as the data ranges.
  • Click the Customize tab and then select Series.
  • In the Series selector drop-down list, select Relative Mobile Conversion Rate (Rel mCvR).
  • In the Axis drop-down list select Right axis.
  • If you like, click Chart & axis titles to customize the chart title and the left and right y-axis labels.

You should now have a chart that looks something like this: Chart: mobile load time versus relative mobile conversion rate

Step 6: Using the chart, identify a period before the speed optimization (when load times were high) and a period after the speed optimization (when load times should be lower) that you want to analyze. In this example, you would compare eight weeks in Jan–Feb to eight weeks in Aug–Sept.

Step 7: In a new sheet, calculate the average load time and rel mCvR for the two periods. Then add the revenue coming from mobile visitors during the period after the speed optimization (Aug–Sept in the example). You can find revenue data in Google Analytics under the section Audience > Mobile > Overview.

Revenue data for January through September showing Rel mCvR

Step 8: Now calculate what the revenue would have been if Rel mCvR had not improved. Do this by dividing the revenue (€1,835,962) by the current Rel mCvR (51%) and multiplying by the Rel mCvR for the period before the speed optimization (42%).

Screenshot: spreadsheet cells showing formula for revenue without Rel mCvR improvements

Step 9: Subtract the revenue that the company earned from what it would have earned if Rel mCvR had not improved.

Screenshot: spreadsheet cells showing extra revenue formula

In this example, the company earned an additional €323,993 in eight weeks thanks to Rel mCvR improving—that is, thanks to the mobile site becoming faster.

Screenshot: spreadsheet cells showing extra revenue due to Rel mCvR improvements

Things to consider when analyzing Rel mCvR

  • As noted above, other changes to the site, such as UX improvements, can influence Rel mCvR. Check that speed was the only big change to the site during the period you want to study. If there were other changes, Rel mCvR can tell you the effect of the changes as a group, but not of an individual change.

  • Watch out for any changes or events that affected the desktop site but not the mobile site—they can skew your results. If you discover any desktop-only changes, omit the affected period from your analysis.

  • You might wonder whether an increase in Rel mCvR is caused by a shift in conversions from desktop to mobile rather than an increase in conversions overall. While there is likely to be some change in the mix of desktop and mobile conversions due to speed improvements, keep in mind that Rel mCvR calculates the mobile conversion rate relative to the desktop conversion rate. So, you only see an increase in Rel mCvR when mCvR goes up more than dCvR. In other words, when doing this calculation you're already counting low, which means you have a safety margin that can compensate for any shifts in the channel mix.

Summing up

While it has some limitations, Rel mCvR is a great low-cost way to estimate how much a speed optimization increased revenue without, for example, having to run server-side or slow-down tests. And quantifying the relationship between performance and revenue can help you demonstrate the value of development projects whose benefits might not be immediately clear to non-technical stakeholders.

Next steps

Aircraft instrument panel image by Arie Wubben on Unsplash


This content originally appeared on web.dev and was authored by Lina Hansson


Print Share Comment Cite Upload Translate Updates
APA

Lina Hansson | Sciencx (2019-06-13T00:00:00+00:00) The value of speed. Retrieved from https://www.scien.cx/2019/06/13/the-value-of-speed/

MLA
" » The value of speed." Lina Hansson | Sciencx - Thursday June 13, 2019, https://www.scien.cx/2019/06/13/the-value-of-speed/
HARVARD
Lina Hansson | Sciencx Thursday June 13, 2019 » The value of speed., viewed ,<https://www.scien.cx/2019/06/13/the-value-of-speed/>
VANCOUVER
Lina Hansson | Sciencx - » The value of speed. [Internet]. [Accessed ]. Available from: https://www.scien.cx/2019/06/13/the-value-of-speed/
CHICAGO
" » The value of speed." Lina Hansson | Sciencx - Accessed . https://www.scien.cx/2019/06/13/the-value-of-speed/
IEEE
" » The value of speed." Lina Hansson | Sciencx [Online]. Available: https://www.scien.cx/2019/06/13/the-value-of-speed/. [Accessed: ]
rf:citation
» The value of speed | Lina Hansson | Sciencx | https://www.scien.cx/2019/06/13/the-value-of-speed/ |

Please log in to upload a file.




There are no updates yet.
Click the Upload button above to add an update.

You must be logged in to translate posts. Please log in or register.