Advice and answers from the Statsbot Team

Statsbot can answer any question about your analytics if you formulate it correctly. The amount of available metrics is heavily dependent on how much data you have - it could be a few dozens or hundreds of thousands. Ready to remember? Luckily, you don't have to. We are here to explain how to ask Statsbot about your data.

***

Metrics

Metrics are quantitative measurements. For example, the metric Sessions is the total number of sessions, the metric Sessions/User is the average number of sessions per user.

To look at the list of available metrics, you can use the command:

@statsbot list metrics

OK, don't panic, just choose what metric you want to query and ask Statsbot for it:

@statsbot <metric> <time range>

In this article we give the examples of queries from Google Analytics, but the rules are the same for all analytical platforms you are going to integrate with Statsbot.

Well, imagine, you want to find in Google Analytics how many users you've had this week:

@statsbot users this week

You can add specific dimensions and  filters to make your query more detailed.

***

Dimensions

Dimensions are attributes of your data. For the instance, the dimension Age can indicate the age of users. And the dimension Browser indicates what kind of browser is used by your users.

Here are the most popular dimensions in Google Analytics:
• Gender
• Age
• City
• Source /Medium
• Keyword
• Browser
• Device Category
• Operating System

To use dimensions in your query and get the segmentation view report, use "by" command:

@statsbot <metric> by <dimensions> <time range>

For example, if you want look at monthly users by a source in Google Analytics, type:

@statsbot users by source this month

***

Filters

Filters allow you to limit and modify the data in reports, include or exclude some options. For example, you can use filters to focus on a specific directory, or exclude internal traffic from your reports (such as traffic from your home or company intranet).

We're giving you the most common filters in Google Analytics:
• Users status (new, paid, returning)
• Geographical position of users (Canada, USA, New York)
• Type of traffic (mobile, referral)

To use filters' query, type "for" command:

@statsbot <metric> for <filter> <time range>

Imagine, you need to filter /help landing page:

@statsbot sessions for paid traffic last 27 days

You can also combine filters and dimension in one query to get more specific data:

@statsbot <metric> by <dimension> for <filter> <time range>

For example:

@statsbot users by landing page for mobile traffic this year


***
All these examples don't mean that Statsbot has a special query language syntax. You can miss "by" and "for" as well as the part of metric, dimension and filter names. Statsbot will do its best to guess what you meant. Just feel free to explore it.

The more specific queries you ask, the more valuable data for making business decisions you get. Go ahead and get your profit!

Did this answer your question?