If a recipient opened the same email twice or more, they only count as one unique open. Total unique opens – how many recipients opened your emailĭivide the number of opens by the number of total recipients and multiply the outcome by 100.īear in mind that you need the unique opens only.Total recipients – how many email addresses are on your mailing list.You need two variables to calculate the open rate: Open rate = (total unique opens ÷ total recipients) x 100 Email open rate calculation formula Formula #1 If the open rate is low, your key task is to increase it. If the rate is good enough, you can go deeper and analyze other consequent metrics to optimize your emails. This metric defines the success or failure of the campaign. The open rate shows how many recipients of the entire mail list opened the email campaign. We have collected essentials about the email open rate and introduced them below. However, the metric has its own quirks that you should explore in detail. On one hand, the email open rate is easy to calculate and work with. It is a foundation slab on which you can build analytics of your email campaigns. Of more than 20 metrics, the open rate was highlighted as a pivotal one. This function is not available in Excel.In the blog post on Email Marketing Metrics, we broke down key performance indicators by their priority.Even though the dates are just one day apart, they lie in different months. MONTHS('' '' 1) returns 14, the number of months between April 2010 and June 2011. Even though both dates are the last day of their months, the last month is not counted, because the day is less than 31. 31 March to 30 April is not considered a whole month, even though they are both the last day of their months. MONTHS('' '' 0) returns 14, the number of months between 3 April 2010 and 17 June 2011. If startdate is after enddate the result will be negative. In other words it returns MONTH(enddate) - MONTH(startdate) + 12 * (YEAR(enddate) - YEAR(startdate)). If mode is 1, MONTHS identifies the month that startdate and enddate each lie in, and returns the difference between those months. MONTHS(startdate enddate mode) if mode is 0, MONTHS returns the number of whole months between startdate and enddate, day of the month to day of the month (see examples). This function is only available if the Analysis AddIn is installed.

Returns the number of months between two dates.

In openoffice calculate difference time