What’s new in Email Meter Enterprise?

While you’ve been busy making your company more efficient, we’ve been taking all of your feedback and ideas, and integrating them into our platform. We’ve added User and Team Management, Google Groups metrics, and export to CSV function, and Advanced Filtering!

  • User Management: Located at the top right drop down arrow. Here, you can                                           see a list of all of your users, who’s an admin and who isn’t.                                       You can add new users, and delete old ones. You have control                                   over which users have access to the data (admins, viewers, or                                   sync only).

Screen Shot 2018-09-27 at 16.46.22

  • Team Management: Located at the top right drop down arrow. You can set users                                      and managers. These teams can also be used as filters for                                        your data.

Screen Shot 2018-10-02 at 15.44.05

  • Google Groups: In a new tab on the left. This is a good way to manage your Google                           Groups; seeing which ones are getting the most traffic, and maybe                             getting rid of some that aren’t as useful.

Screen Shot 2018-09-27 at 16.46.46

  • Export to CSV: A small cloud icon at the top right of different metrics. This will                                   automatically export your data. You can do your own checks,                                     metrics, and comparisons. This feature gives you the ability to                                   manually customize your reports to meet your specific business                                 needs.

Screen Shot 2018-10-04 at 15.38.11

  • Advanced Filtering: At the top bar. Allows you to include or exclude specific                                              domains and email addresses.

Screen Shot 2018-09-27 at 16.49.28

These added features will allow you to further customize how you see your email analytics… and there are many more to come!

 

 

 

 

 

Email Meter Enterprise – FREE for 30 Days

Email Meter is an email analytics platform that tracks productivity. You can use it for a specific team, or even your entire company. This platform is especially powerful for customer facing positions. As a company, you always want to be as efficient as possible, and you want to show your clients that you’ll be there for them when they need it. In our “Response Time” tab, you have easy to see metrics which include average response times, a histogram of time to response, and more! Some numbers may be a little too high, and could be affecting your business, which is why using this tab is helpful in determining what you can improve.

Screen Shot 2018-08-14 at 17.21.57

Response Times: great for analyzing client facing roles.

Competitive? Then our “Compare Metrics” is the perfect tab for you. Here, you can compare yourself to yourself at another point in time, a team to another team; whatever, and whoever you want to compare, it’s doable. This can be an incentive to be the best employee or the best team in terms of email productivity. This in turn leads to a more successful and efficient company.

Compare View: a nice way to compare different teams, people, and more!

Compare View: a nice way to compare different teams, people, and more!

Committing to something isn’t easy, especially if it’s a new product. For this reason, we are offering a FREE, 30 day trial of Email Meter Enterprise. No credit card required and best of all, no commitment. All we ask from you is your honest feedback. Don’t like something? Let us know. Loving a feature and would like us to expand on it? Great, we can get our developers working on it.

We have more metrics available on the platform, which you can try by clicking here if you are a G Suite administrator for your company, and if you’re not, no worries, just send this blog post to whoever is responsible.

 

Introducing Email Meter Enterprise: email statistics and performance management for companies

Email Meter Enterprise

We’ve launched the most advanced real-time email statistics solution for your company, whether big or small. By gaining insights into your email activity, you can take data driven actions to optimize your company’s productivity. Introducing Email Meter Enterprise: your new email analytics platform.

Email Meter Enterprise Dashboard

Let’s review some of the features!

Email Meter Enterprise – Features

  • Powerful dashboards: you get a full set of dashboards: Received, Sent, Response Time, All Mail, More Metrics… That’s roughly 40 (more every week!) different metrics about your email, response time, attachments, etc.
  • Dive deep and filter your data: filter by user, team, date ranges… or mix and match to get exactly the data you need!
  • Departments and teams: add users to custom teams and check their metrics with just one click. Comparing users and teams performance has never been easier!
  • Fast and reliable: get access to months’ worth of data in a matter of seconds.
  • Compare: create custom segments and easily compare their email metrics.

Using Email Meter Enterprise we discovered that our sales team’s response time is quite fast, with most emails replied to within the first 15 minutes. This is a vital metric for customer service teams as we need to ensure they are being as responsive as possible.

Email Meter Enterprise Compare

The Compare section allows you to compare up to four segments (with custom user, teams or dates), to help you monitor your various teams’ email activity all on one view.

Update [July 19th 2018]: Email Meter Enterprise is now available for all G Suite editions.


Sounds interesting? For more information and next steps, head over to https://emailmeter.com/enterprise or get in touch with our sales team.

 

Gmail logs + BigQuery integration: 1 year later

It’s been a year since Google announced some new exciting features for G Suite Enterprise, including a small gem for companies that want to get the most out of their data: Gmail logs integration in BigQuery. Here’s what Google wrote on February 2017:

 Today, we are making it easier to analyze Gmail logs with a preconfigured BigQuery integration so administrators can run sophisticated, high-performing custom queries, analyze their data and build custom dashboards.

BigQuery + Gmail logs

That sounds great! At Email Meter, we’re always looking into better ways to bring you new powerful statistics, so this is very interesting! We’ve been doing tests for a while. Let’s see:

[warning: tech stuff ahead]


How it works:

  • Gmail logs are stored in realtime into a preconfigured BigQuery integration with the following schema. (NOTE: logging starts after you enable the feature in the G Suite Enterprise admin panel, read more here)
  • BigQuery organizes the data in daily tables.
  • You can run queries directly on the BigQuery console or write your own app. There are some libraries out there for different languages.
  • Queries should be made using SQL Standard, although Google uses their own SQL (“Legacy”) in their examples.

Aaaaand, that’s all… In fact, this is all the info you can find on the internet about this matter. For real. No one seems to have published anything else about this, or shared any code, apart from these two posts in this blog (thanks Mannetje!) – Link + Link

Querying – getting real stats!

We ran a query over the whole domain, for received emails. Each action that occurs when Gmail is receiving an email logs a single entry in BigQuery, so we must filter a little bit.

/* received emails */
(message_info.destination.service == 'gmail-ui'
  AND message_info.source.service == 'smtp-inbound')
/* we only need the final entry + not spam */
  AND message_info.action_type == 3
  AND message_info.is_spam == FALSE

Wildcards are permitted here so we’re checking all the daily tables for the last 7 days.

BigQuery Gmail logs query example

BigQuery Gmail Logs Results Query example Gmailmeter

Voilá! We got 4713 emails, each one with extensive data. We turned some of this data into a nice email report for one single day, and used some processing to throw reply time right into the mix. Also, we generated the report for the whole domain and also for one user. Useful, isn’t it?

Gmailmeter BigQuery integration Gmail test report

Once we’re up and running, we can build reports like this one. Or complex dashboards! Privacy matters, this isn’t real data.

Response time:

In our tests, minimum response time was above 1s, reaching peaks of 5-6s or higher. This is due to Google’s BigQuery inner processes (it does scale with you)

That might not seem impressive at first, but think of a pretty big company (+2000 employees) and a year’s worth of email. That’s a lot of mail. Well, it still should take a few seconds for most queries! Now we’re talking. Google BigQuery is scalable, flexible and fast even for GBs of data.

Other findings:

Throughout our research we discovered some stuff that wasn’t well documented in the schema, and we also found some data limitations (for example, thread IDs are not logged).

There’s also a lot of data available in the logs about deliverability, server spam rules, and email behaviour.

Gmailmeter BigQuery gmail logs

Using Gmail logs + BigQuery, we can apply Big Data techniques to email usage stats


Conclusions on integrating Gmail logs into BigQuery

Google released a year ago a feature for G Suite Enterprise that allows administrators to automatically log Gmail logs to BigQuery.

It seems that some bigger companies are already utilizing this feature, and BigQuery is already an established product, so the future for this product is pretty exciting.

Good news: if your company is using G Suite Enterprise already, or is thinking about upgrading,  you can leverage Big Data techniques to analyze and get stats for your email usage data using a cloud-powered database. It’s powerful, fast and cheap.

Not so good news: there’s very little publicly available info about how to use this feature and the Google docs are incomplete. Intensive research and development is needed.

We’d love to hear your feedback and experiences. Please add your comments below or get in touch (hello@emailmeter.com).