{% extends "base.html"%} {% load staticfiles %} {% block title %} User Manual {% endblock %} {% block localization %} User Manual {% endblock %} {% block page-title %} {% endblock %} {% block body-special %}
{% endblock %} {% block content%}Welcome to the Mango Analytics Getting Started guide, here you will find everything you need to know about Mango, and how to get around.
Dive In!
The “Getting Started Guide” provides you with the following information and procedures:
Lets start by the name. We named this awesome reporting tool “Mango Analytics” because we wanted to offer a new and fresh way to show trunk and user behavior. We want you to have accurate and real-time information in just a couple of clicks, we even want you to save on your monthly telco bill by identifying abusive users on your company (which, by the way, 8 out of 10 companies have).
We know how hard is to make and in-depth expenditure analysis,and lets be honest, you probably don't know which user is making tons of offshore calls making your telco bill grow immensely. You probably download your monthly CDR onto a spreadsheet program and it takes you forever to make a good analysis, am I right?
Mango Analytics will help you save on your phone bill in ways you didn't know existed! Just set all your trunk costs and bundles, import the CDR data and that’s it!
Mango Analytics is free software, and will always be. We believe in open source projects and sharing our experience in telco, and we also acknowledge that if Mango is useful for us, surely it will be useful for you too. We want everyone to have the best possible analytic reports.
If you like Mango Analytics, and it has been helpful for your company, consider making a donation. We need your support in order to make Mango Analytics better and more powerful!
Mango Analytics offer in-depth trunk and user analysis per day, month and telco(s) billing periods. You will be able to know top dialed destinations, users with excessive use (or abuse), as well as user detailed reports.
We like to think that we made Mango Analytics as intuitive as possible, whenever you see a question mark like this it means that a brief explanation is waiting for you to read. Just hover your mouse over the question mark to see the explanation.
Please gather all the information needed before starting Mango setup:
During first set up, all the previous info will be asked to input, please be as detailed as possible on the rates and destinations.
The main page is the PBX dashboard with at a glance information of your trunks, users and destinations. You can toggle to Trunks, Users and Pinsets pages for more detailed information.
On the upper right area, the Setup button will give you access to all Trunks, Rates and Bundle setup.
Mango Analytics is a complex system, and as such, we realize it is a little difficult to set up correctly at first.
That's why we've prepared a series of video tutorials; if you dislike reading you may learn how Mango Analytics works and how to configure it from our videos, which you can find here.
Mango Analytics Dashboard page consists on at a glance information of your current and historic user & providers usage; This main page will give you quick information regarding top dialed destinations, users with the most expenditure and past 5 months expenses, letting you know who and how they’re using your telecom resources.
Very handy and simple real-time interface where you will be able to see the current outgoing calls. It refreshes itself every 15 seconds. Here you can see who is calling, where are they calling, and how much time they have been on the phone.
The main trunks area will give you detailed info on cost, destinations, billing periods and bundles purchased with your trunk providers.
On this section you will be able to see gross and per trunk usage and costs. The first left table and right graph offer at-a-glance costs and destination information.
Depending on how much trunks you have set up, beneath “Upper gross and per trunk area”, you will have detailed information of each trunk.
On the upper left corner this two buttons are available. By default, current month information is shown, but you can toggle to whichever date you want.
Usage(upper gross and per trunk area)
This month´s destinations graph (upper gross and per trunk area)
The trunk detail section will show one left panel and one right graph per trunk. Those aren’t necessarily the ones you have on your Elastix setup, but the ones you have already set up on the settings page of Mango Analytics.
Left Panel
The Average Monthly Cost gives you the current month usage (not the billing period interval), and the monthly average usage of this trunk. This average is taken from the last 6 months use.
This button will take you to the tariffs and bundles area for this trunk, showing detailed fees previously set, as well as all your bundles. You can edit or delete information on this part. Remember, if you modify or delete data, it is critical that you import all data again, so that all costs can be re-calculated.
This button will take you to an in-depth analysis page of each trunk, we’ll get to that section next.
Here is the basic layout of the trunk analysis page
As you can see you get the same information of the trunks from the general trunk page, but there’s two new graphs and a Billing table.
Here is the basic layout of the users/pinsets general page
You get three zones here:
On the upper left corner these two buttons are available. By default, the current month information is shown, but you can toggle to whichever date you want.
As you can see, you get:
This button will take you to the usage analysis page of the user/pinset
On this page you get:
On the upper left corner these two buttons are available. By default, current month information is shown, but you can toggle to whichever date you want ( just “Detailed Usage” table changes ).
Here you can filter by various fields the CRD data in Mango Analytics and you can download it with the filters applied.
On this page you can change your settings of MAngo Analytics, which are:
Mango analytics doesn't interact with the production CDR of your Elastix system, it only imports data. There are two types of data import.
Rate changes
It’s normal that rates are changed by your telco provider once in awhile, to do this, you only need to change them on the rates area, there’s no need to import data again . New rates will be used only for new calls, older calls will have older rates. If you run again data import, all old calls will be assigned the new rates, so please be careful.
Trunks Edit, Delete or Modifications
You can change any information you want on your Trunks, even add new ones with their new rates, all these changes will be reflected on the CDR starting on the date you made the changes, all older information will use old Trunk info. If you run again the data import, all old calls will use updated Trunk information.
You can delete a Trunk on your Mango setup, all prior stats will still be available for you. PLEASE DON'T run again the data import, as this will delete all data of the previously deleted trunk.
Bundles Edit, Delete or Modifications
Bundles cannot be modified, only deleted. If you need to modify a bundle, you can delete it and create a new one, all new bundles are applied automatically.
Trunk setup is fairly simple, you only need to setup the basic Trunk information and save changes.
On the Setup area, the upper left table will show Trunks that have already been set up, the ones that haven’t been set up appear on the right of that same page on a table named “Unconfigured Trunks”.
To setup a trunk just click on the Trunk name you want to set up from the right pane.
You need to input basic Trunk info
Click save and proceed with the setup of the remaining trunks.
NOTE. The info input on this area, is for reporting issues, it does not affect in any way your Elastix configs
All configured Trunks will now appear on the upper left table on the Setup Area. Please be sure that you have set up all your Trunks, on the right panel, under “unconfigured Trunks” you’ll see the Trunks that still need to be configured. If you have trunks that you don't use, you don't need to set them up, it won't affect your reporting.
Deleted Trunks
Its important that you know that only the Trunks that are set up on your Elastix system will be displayed on the left panel of the setup area, it you want to report trunks that were deleted before this procedure, you need to set them up again on your Elastix trunk config. Please be SURE to use the exact name as they had before, because, otherwise, Mango won't be able to track them down on your general CDR.
Trunk Types
Your Elastix PBX system accepts several types of Voice technologies, such as
When using PSTN analog lines, its recommended that you configure your analog lines per channel, not per group, that way you will be able to report each channel, as normally local telcos offer bundle packs per channel.
Example. Local telco charges you $20 monthly per line, offering say 100 minutes free for domestic calls. You need to create a bundle for each analog line. If you have your 4 analog lines on one group, Mango Analytics won't be able to assign a bundle for each line, it will be applied to all lines.
All this information will be imported from your Elastix system.
Rates setup is the most crucial setup of all. We are going to elaborate on this area, above all the explanation you'll find helpful per country examples.
Difference between dialed number and outgoing number:
Mango will ID the previous call example as 011-44-1234-5678.
So, in other words, you'll need to know all prefixes for outgoing numbers from your Elastix system in order to configure all your rates and costs.
First of all, you need to gather all the information per provider for fee application, you need to know all the places where you normally call, as well as costs, prefixes, increments and connection fees.
On the Setup Area, (left panel Configured Trunks), you will see all previously configured Trunks. If you don't see the trunk you want to set up, first you'll need to configure it.
This is the most time consuming process of them all. Please take your time to fully understand it, and do not rush on the tariff setup process, as one mistake can screw all the reports up.
Base rates are all the rates that your provider charges you for local, domestic, mobile and international calls. You need to setup each rate per destination. Even if rates are that same for local and domestic, we recommend setting up both rates, that way Mango will report per destination in full detail.
On the left side of the rate input area, you will see all tariffs already set, you can edit them or delete them. When you are done setting up your rates, please click “Return to Setup”
Now you'll be able to see all of your configured rates.
Same destination on several trunks, but different prefixes for each
On some PBX scenarios, you use 2 or more trunks for the same destinations, for failover or channel balance, or god knows why, and some telcos will give you global rates and some others very detailed rates.
For Example. Your users call to Spain quite a lot, calls are balanced among 2 providers,
Destination | Prefix | Provider #1 | Provider #2 |
---|---|---|---|
Spain All | 34 | $0.01 | $0.20 |
Spain Proper | 349 | $0.1 | |
Spain Mobile | 346 | $0.15 | |
Spain Madrid | 3491 | $0.0015 |
On the table above you can see a typical example of tariff detailing, Provider #2 gives you a flat rate for all Spain, meanwhile Provider #1 offers detailed rate for different types of destinations.
Even though Provider #2 offers only 1 flat rate, it's recommended that you input the detailed tariffs for provider #2 Trunk. We know its more work for you, but it will greatly improve Mango´s reporting and analysis data.
To configure your bundles, go to the setup page on Mango Analytics. On the section called “Configured Rates” you can see all your base rates per provider. Select the provider to which you want to add a bundle, then, for every destination configured on that trunk you’ll have the option to add a bundle, to do so, just click on “Assign Bundles”. Please provide :
When you’ve finished filling in all the information, press “Save Bundle”, and repeat, if necessary, for every destination.
When you have finished configuring all your trunks, base rates and bundles, you can import all of your data from the Elastix system. There’s two ways to do this:
And that’s it!
Prefixes setup examples for some countries
If you are on the MGM area codes (Mexico City, Monterrey and Guadalajara) 8 digits are used for local calls, all other areas will use 7 digits. The total amount of digits needs to be 10 (including area code + phone number)
Example:
In all probability, you’ll have different rates for international destinations; For example, you have a rate for calls to USA/CAN which is different for calls to Europe or South America. It’s very important that you configure all call rates were you normally call to.Please be as detailed as possible.
Remember, the more detailed your rates are, the more detail your Mango Reports will have
NOTE: If you use 2 providers for the same destinations, it’s very important that both trunks have the same destinations setup.
DR uses only 3 main country area codes which are 809, 849 & 829.
Example:
In all probability, you’ll have different rates for international destinations; For example, you have a rate for calls to USA/CAN which is different for calls to Europe or South America. It’s very important that you configure all call rates were you normally call to.Please be as detailed as possible.
USA/CAN uses many country area codes
In all probability, you’ll have different rates for international destinations; For example, you have a rate for calls to México which is different for calls to Europe, South America or even Central America . It’s very important that you configure all call rates were you normally call to. Please be as detailed as possible.
Si señor! Mango is free and will always be for Asterisk servers. Further Mango applications will be released for other paid PBX platforms where we will indeed charge for it, and that way, Mango analytics for Asterisk will always be updated and free for use under GPL V3!
We are developing the repositories for older Elastix versions, they will be free as well, but installation will be manual. Please check our website once in awhile for updated info.
Not at the moment, but its considered for version 2
Not at the moment, but its considered for version 2
Not at the moment, but its considered for version 2
V1 doesn't have the functionality, but its already considered on V2. You will be able to group extensions and generate detailed reports and analytics.
Realtime report is intended for visualizing outgoing calls that cost you, we don't want to report info that really doesn't affect your pocket. For version 2, inbound toll free calls are going to be visualizable on the report.
That's a very good question. We need Mango to be available for everybody, and english is the base language of all open source projects, V2 will we on more languages.
No, and we don't plan to support legacy PBX's
When a call is made by extension 1 (lasted 40 secs), and then transferred to extension 2 (lasted 3 mins), only the call from extension 1 will be billed, in other words, call indeed lasted 3 mins and 40 seconds, but only 40 seconds will be reported and billed by Mango Analytics. This is mainly because Asterisk CDR treats transferred calls as internal calls, and Mango has no way of knowing that it was a transfer. We are working on this issue and hope it will be solved on V2.