User Manual
Contents
1. section above Call Prefix The call prefix used for identifying the recipient call e Examples o For the UK you would need to input 01144 where 011 is your international prefix code o For Spain landlines you input 011349 where 011 is your international prefix 34 is the country code and 9 is the Spain s landline code o If you only have one rate for all international calls and your intl prefix is 011 just setup 011 as call prefix o For more prefix examples go to section Fees Examples 18 NZXT TELECOMUNICACIONES DE MEXICO SA DE CV Mango Analytics User Guide 2013 NOTE normally retail telcos don t require any prefix for local calls you can leave it empty for local calls All calls that don t have any prefix match will use the default fee Minute Fee The rate per minute that your Telco charges you You need to enter it using the currency you setup on My settings page Billing interval Depending on your country and Telco you may be charged per minute per second or per 6 seconds increment or whatever funky increment your Telco offers Please be sure to input the seconds your increment has for this destination e Examples o If your Telco charges per minute input 60 o If your Telco charges by the second input 1 o If your Telco charges you by 30 seconds increment input 30 Call Connection Fee Per call fee that your Telco charges you This charge is only made once per call If your Telco charges you a flat rate per2. 00 More 5000 B33 9 273 00 More 463 4414 10 243 00 More You get three zones here e Most expensive users pinsets table well you get the idea the 5 most expensive users pinsets on your system the ones who have been on the phone for the most minutes e Cost per extension user pinset graph This shows you usage per user pinset for the past 2 months e Finally you get a table with all your extensions pinsets registered on the Elastix system their total seconds calls and cost If you want more detail per user pinset you can hit the Detail link at the side of every user pinset Last Month B On the upper left corner these two buttons are available By default the current month oio is shown but you can toggle to whichever date you want 9 NZXT TELECOMUNICACIONES DE MEXICO SA DE CV Mango Analytics User Guide 2013 Users Pinsets Detail 140 Je analysis User me ew 469 Detail Usage analysis EE This Month 130 Extensi 469 ME August ension 5 100 July Name on oe fe nt 50 Country Destination Cost USD oa Fef Mexico Local Landline 3720 00 S40 lf Mexico Local Landline 173 00 30 lf Mexico Domestic Mobile 04 00 a United States International 60 00 Local LandineDomestic Landine Intemational Local Mobde Domestic Mobile Default Tariff rbr fee s daily cost 150 100 50 Augi Augi Aug U Avge Aug OT Augi Aug TN Aug LN Aug LU Aug LH Aug L Aug Ly Aug LY Avg 6 Aug LT Avg Ls Aug LW Av Aug
3. 2 Avg Aug IN Auga Ag IN AUIS Aug ZT AUIS Aug IN AUGNN Aug INAUG Date Time Provider Destination Seconds Cost USD Dialed Number 01 August 2013 09 09 30 Nextor Local Landline 2103 108 00 a As you can see you get Extension the extension pinset number Name the name of the user Destinations called A graph located at the right hand side of the extension number pinset and the name which details expenses per destination for the past 2 months e Second graph which details the user pinset cost per day e A table containing all calls from that user pinset the date time of each call as well as seconds cost dialed number and the provider EEEE This button will take you to the usage analysis page of the user pinset 10 NZXT TELECOMUNICACIONES DE MEXICO SA DE CV Mango Analytics User Guide 2013 Usage Analysis of User Pinset b s monthly behavior L L E Pee S400 S200 kp January February March Apri May June TOP 10 MOST EXPENSIVE DIALED NUMBERS OF THE MONTH Seba Wet 1S Sesh Sarees 10 5610 5254 00 E 4 2179 111 00 J 6 1822 596 00 E 2 1607 84 00 m m T 1045 563 00 m a 5 gpg 554 00 a 3 T18 39 00 1 361 271 00 E 1 355 518 00 3 183 15 00 Detailed Usage Date Time Destination Minutes Cost USD Dialed Number On this page you get e A graph detailing monthly user pinset cost behavior of the current year e Agraph and a table detailing the top 10 most expensive dialed numbers of the month e A table
4. Initiative so that you have a better understanding of what we are proposing and why e Basic information of how to access Mango Analytics thru your Elastix Interface and brief understanding of user permissions Understand all tables graphs and some other things offered and how to interpret them Detailed information of costs rates and bundles setup and why is it so important to provide all that information correctly Why Mango Analytics Let s 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 let s 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 did not know existed Just set all your trunk costs and bundles import the CDR data and that s it Why is it free Mango Analytics is free software and will always be We believe in open source projects and sharing our experience in Te
5. call and not per minute leave Minute Fee in 0 and input here the connection fee only Notes Brief note about this destination 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 Rates configured Return to setup Destination Prefix Connection Fee Minute Fee Local Landline 52 0 0 USD 3 0 USD Ez E International 1 0 0 USD 5 0 USD Ez j Domestic Mobile 521 1 0 USD 3 0 USD a EJ J Local Mobile 52155 3 0USD 0 0 USD Ea ES J Local Landline Defaut 0 0 USD 0 7 USD Ea ES Now you ll be able to see all of your configured rates 19 NZXT TELECOMUNICACIONES DE MEXICO SA DE CV Mango Analytics User Guide 2013 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 Spain All 3 0 01 0 20 i 3 l 4 Spain Proper 49 0 1 Spain Mobile 346 0 15 Spain Madrid 3491 0 0015 On the table above you can see a typical example of rate detailing Provider 2 gives you a flat rate for all Spain meanwhile Provider 1 offers detailed rate for different types of destination
6. named Detailed Usage showing all the calls of the user pinset of the month 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 Last Month Custom 11 NZXT TELECOMUNICACIONES DE MEXICO SA DE CV Mango Analytics User Guide 2013 General CDR page Mango Analytics A angs 5 AN 2 yc gt General CDR General Cost Detail Report m Setup My Settings About 7 a wf g 7 C g C C Pan we D D i 7 1c Start date gt Y Provider T Download Current Data End date gt T m Destination Dialed Number T Duration FT Extension Number F Cost f Pinset Number F Prv ft 2 53 4 5 6 Next Total Calls 566 Total Minutes 1805 77 Total Cost 5978 00 USD Showing page 1 of 6 Date Dialed Number Extension Pinset Provider Destination Duration Cost 22 Jul 2013 19 29 54 468 Nextor Local Landline 5 Sec 3 00 USD 22 Jul 2013 16 55 23 469 Nextor Local Landline 157 sec 9 00 USD 224 JuV2013 16 58 58 5002 Mambo Local Landline 276 Sec 15 00 USD 22 Jul 2013 20 18 37 468 Nextor Local Landline 3 sec 3 00 USD 22 Jul 2013 20 19 13 468 Nextor Local Landline 31 sec 3 00 USD Here you can filter by various fields the CRD data in Mango Analytics and you can download it with the filters applied 12 NZXT TELECOMUNICACIONES DE MEXICO SA DE CV Mango Analytics User Guide 2013 My S
7. of where your calls are going to Trunk detailed information Provider a Monthly behavior of F Trunk Name 2500 Trunk Type sip ERA EE Billing Interval 15 of every month Payment Type Postpaid 1500 Average Monthly Cost LTO This Month s Usage 1806 00 USD Average Usage 721 50 USD S500 Rates and Bundles Trunk Analysis 0 Apr May May Jun Jun Jul Jul Aug Ag Sep Sep Oct Provider Nextor Monthly behavior of F Trunk Name 5000 Trunk Type sip 4000 Billing Interval 15 of every month Payment Type Postpaid 3000 Average Monthly Cost ERE E This Month s Usage 3495 00 USD Average Usage 1894 33 USD LD Rates and Bundles Trunk Analysis So Apr May May Jun Jun Jul Jul Aug Ag Sep Sep Oct 6 NZXT TELECOMUNICACIONES DE MEXICO SA DE CV Mango Analytics User Guide 2013 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 e Left Panel Provider Name Name given to trunk when configured on Mango Analytics setup area Trunk Name Name given to trunk when created on your Elastix System Trunk Type E g SIP DAHDI H323 Billing interval If postpaid it will show the billing period start date Payment type Prepaid or postpaid The Average Monthly Cost gives you the current month usage not the billing peri
8. per call not per minute so on this scenario no prefix needs to be set cost per minute needs to be in 0 00 and cost per call shall be in Connection Fee Domestic Call 01 prefix is the national domestic prefix All carriers charge per minute just add additional info as required Local Mobile call Mexico uses 044 prefix for local mobile calls just input 044 on the prefix area All carriers charge per minute just add additional info as required Domestic Mobile call Mexico uses 045 prefix for domestic mobile calls just input 045 on the prefix area All carriers charge per minute just add additional info as required International call 00 is the prefix used for calls outside Mexico If you have a flat international rate just create an international fee with 00 as prefix and a fixed cost 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 21 NZXT TELECOMUNICACIONES DE MEXICO SA DE CV Mango Analytics User Guide 2013 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 Dominican Republic almost all carriers use s
9. to be available for everybody and english is the base language of all open source projects V2 will we on more languages Can I use Mango on my legacy PBX No and we don t plan to support legacy PBX s Outgoing transferred calls are reported partially 23 NZXT TELECOMUNICACIONES DE MEXICO SA DE CV Mango Analytics User Guide 2013 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 Contact Mango Analytics http www mangoanalytics or Customer Service Department info nextortelecom com Mango Analytics offers paid support for installation and setup please contact soporte nextortelecom com Chip In 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 Please contact customer service department they ll guide you thru the donation process or go to our website http www mangoanalytics or 24 NZXT TELECOMUNICACIONES DE MEXICO SA DE CV
10. Extensions Pinsets PaGe ccccccscsssssssessesseeesssseesseesseseessseeueseeeseeeeass 9 General CDR Page crni aa a E eens 12 My Settings Page eenean salen ee ee secant ae can ut eels inca oauuetg 13 First SOUND seo seeciece esc tessa averk cea a a AN tite one dana sac peania via onder N 13 Understanding Trunk S tup ccccssssseceeececescccssseeeeeecsecasssseeeeeeecessncagssseeeeeeeesecasssees 15 Understanding Rates SCtu p oee T TAT 17 Understanding Bundles Setup cccccssssssssseseeeeseeceassseseeeeeceeseceasseeeeeeseeseaassseeeees 20 Understanding Data IMmporting ccccccssssseeeeeecceseessseeeeeeeccsseceassseseeeeecesseseassereneees 21 Rates EXaMpleS neroa ea a mie ek 21 Ratos TOL MOKICO ar A eben taleuauenedaiaeaenaienaes 21 Rates for Dominican REPUDIIC cccccceessseeseeeceeeeeeeeeeeeeeeeeeeeeesseaeaeeeeeeeeees 22 Rates TOR USAF GAIN a ess caine a a N 22 Frequently Asked Questions ccccccccccscccccceeceseeeeseeeeeeeeeeseeeeeseeeeeeeseaeeeseeeeeeeneneeeens 23 Contact Mango Analytics ccccccccccccccccccceeeeeeeeeeeeeeeeeeeeseeeeeeeeeesseaeessseeeeeeessaaeeeeetaeeeeees 24 CHID IN anna acca aac wan es sae ae ee 24 2 NZXT TELECOMUNICACIONES DE MEXICO SA DE CV Mango Analytics User Guide 2013 Overview What s in this guide The Getting Started Guide provides you with the following information and procedures e An overview of the Mango Analytic
11. Mango Analytics User Guide 2013 Mango Analytics Aavanced PBX Reporting User Manual V 1 0 All Rights Reserved The use disclosure modification transfer or transmittal of this work for any purpose in any form or by any means without the written permission from Mango Analytics Nextor Telecom is strictly forbidden September 2013 Disclaimer The content of this manual is subject to change without notice and should not be construed as a commitment by the customer or Mango Analytics Nextor Telecom This manual is furnished for global use only and Mango Analytics Nextor Telecom assumes no responsibility or liability for any errors or inaccuracies that may appear herein 1 NZXT TELECOMUNICACIONES DE MEXICO SA DE CV Mango Analytics User Guide 2013 Table of Contents Overview 3 What s in this Quid cccccccccecee cece eee eeeeeeeeeseeea sansa sansa sa esesaeeeeaeeeeasaesenaes 3 Mango Analytics overview Of how and WhY cccccccessseseseeeeeeeeeeeeseeeseeeeees 3 Wy Mango AN aIVUIGS eesin iguwaesa emus msangecanens aageneeaesres 3 WY IS MEMOS ce iactenn dashes shoteber anita E 3 Before you get Started cccccccccceeecsseseeeeeeeeeeeeeeeeeeeeeetaeseeeeeeeeeeeeeeeenensess 3 POM al OVGCRVICW nts ain a Saharan eee ees 4 PASO ANG Page sassscestciostas iste a E dates sesawrewonn ite N 4 FR Se FUT Sl Seca oo wastes ernneceaaaieaus een A A A antennae 5 SEIS oka a a E dceeaunsicanwassemuacentaabecnares 5 Users
12. SD 329 62146 Landline June 15 2013 July 14 2013 499 00USD 0 0 W Intemational May 15 2013 June 14 2013 499 00USD O 0 Domestic baad Mobile April 15 2013 J May 14 2013 499 00USD 0 0 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 e The first graph located at the right of the trunk information shows you the total minutes and cost of that trunk by month for the past 6 months e The Traffic Segmentation graph shows you the percentage of calls by destination so you ll get an idea of where your calls are going e The Billing table shows you the billing period cost calls and seconds talked of the last 6 billing periods 8 NZXT TELECOMUNICACIONES DE MEXICO SA DE CV Mango Analytics User Guide 2013 Users Pin sets Here is the basic layout of the users pinsets general page This Month Current period 01 Augi2013 31 Augi2013 Average monthly cost by user is 207 78 USD 1700 Most expensive users a aces Ma W August Extension Name Cost USD a July 469 lt a z 726 00 ETI 460 l 573 00 AGBO 507 00 i 5002 417 00 2000 466 as 2 34 00 E o ABO ABE 469 ABA 463 470 Name Extension Total Seconds Total Calls Period Total USD Detail 68 469 11566 T3 726 00 More 460 10494 92 573 00 More 4660 9704 14 3507 00 More 5002 699 25 3412 00 More E 466 6524 4 304 00 More a a 8 8 468 4998 49 363
13. USA and CANADA USA CAN uses many country area codes Local call If your number is in area code 212 you need to set 212 as your prefix and destination as local the billing interval is most likely 6 or 60 as all telcos charge per 6 or 60 second increments just setup additional info as required Domestic call You need to set up at least one rate with prefix 1 for USACAN domestic calls but its very important to add extra rates for Puerto Rico Dominican Republic Alaska etc for all countries that share prefix 1 just add additional info as required Local Mobile call No need to setup as same rates and prefixes are used for fixed and mobile lines Domestic Mobile call No need to setup as same rates and prefixes are used for fixed and mobile lines 22 NZXT TELECOMUNICACIONES DE MEXICO SA DE CV Mango Analytics User Guide 2013 International call 011 is the prefix used for calls outside USACAN If you have a flat international rate just create an international fee with 011 as prefix and a fixed cost 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 FAQS Is mango Really Free Si senor Mango is free and will alway
14. ame prefix setup DR uses only 3 main country area codes which are 809 849 amp 829 Local call If your number is a 849 you need to set 849 as your prefix and destination as local the billing interval is most likely 1 as all DR telcos charge per second just add additional info as required Domestic call You need to make two more tariff rates one for 809 and another one for 829 set destination as National just add additional info as required Local Mobile call DR requires prefix 1 for local and domestic mobile calls You need to generate 3 tariff rates one for each area code 809 849 amp 829 On the destination part select local cell phone or national cell phone whichever fits you best just add additional info as required Domestic Mobile call Same example as above Calls to USA CAN Puerto Rico are dialed with 1 prefix Set Destination as International and set up additional info as required International call 011 is the prefix used for calls outside DR If you have a flat international rate just create an international tariff with 011 as prefix and a fixed cost 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
15. 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 Preparing for rates setup First of all you need to gather all the information per provider for rate 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 Configured Trunks Name Tech Billing End Day Monthly cost USD sip 15 399 00 Add Base Rates a Ol Nextor sip 15 499 00 Add Base Rates Ol Name You can click on the Trunk name in order to see detailed rates and bundle information Add Base Rate By clicking on it you will be redirected to the rates input area we will cover it briefly F o Trunk Edit Modify Trunk information configured during Trunk Setup e O funk Delete This will delete ALL info Mango has of this Trunk It won t appear on stats nor graphs NOTE This WON T delete any data from your Elastix main CDR 17 NZXT TELECOMUNICACIONES DE MEXICO SA DE CV Mango Analytics User Guide 2013 Add Base Rates This is the most time consuming process of them all Please take your time to fully understand it and do not rush on the rate setup process as one mistake can screw all the reports up Base rates are a
16. ase rates and bundles you can import all of your data from the Elastix system There s two ways to do this e Thru the Start Test Run button If you start thru here pressing this button will lead you to a page where you can select from which date you want to import select it or use the default date from 6 months before then click Start This will lead you to a informative page where it tells you the percentage of calls processed as well as the estimated time to finish processing calls When Mango finishes processing your calls go to the results page there you will be informed about how many calls were weren t processed If they weren t processed it s because the calls didn t have a base rate on which to calculate costs You can go back to the setup to add more base rates or you can click Run and Save to save the data without the non processed calls and continue to the dashboard e Thru the Import Data button which is the same as above without the option to review processed calls And that s it Fees Examples Prefixes setup examples for some countries Mexico almost all carriers use same prefix setup 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 I m in Mexico City Local call 8 digits will be sent to Telco and they charge
17. ch Billing End Day Monthly cost USD sip 15 399 00 Add Base Rates Ea o Nextor sip 15 5499 00 Add Base Rates Leia lca Unnamed Trunk Configured Rates Nextor Trunk Destination Prefix Connection Fee Minute Fee Has bundles Local Landline 52 0 00 USD 3 00USD 3 Assign Bundles el o International 1 0 00 USD 5 00USD x Assign Bundles baad J Domestic Mobile 521 0 00 USD 3 00USD x Assign Bundles Oo Local Landline 52155 0 00 USD 3 00USD yg Assign Bundles vor No bundles have been configured yet Setup area 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 1 To setup a trunk just click on the Trunk name you want to set up from the right pane 2 You need to input basic Trunk info a Alias This is the Friendly name for the Trunk b Monthly fee The monthly fee of this Trunk c Billing start date The start date of your monthly Telco invoice If your account is prepaid just input 1 d Payment method Whether your Telco agreement is prepaid or postpaid e Channels How many channels you have available for this trunk For E1 lines you can have up to 30 channels or concurrent calls for T1 lines you can have up to 24 channels or concurrent calls f Click save an
18. cs retrieves past day CDR at 02 00 AM everyday local time the import time is static and cannot be changed On your reports and graphs you will always see info up to one day before the present date Fees 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 fees area there s no need to import data again New fees will be used only for new calls older calls will have older fees If you run again data import all old calls will be assigned the new fees 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 data the 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 14 NZXT TELECOMUNICACIONES DE MEXICO SA DE CV Mango Analytics User Guide 2013 Understanding Trunk Setup Configured Trunks Unconfigured Trunks Name Te
19. d proceed with the setup of the remaining trunks 15 NZXT TELECOMUNICACIONES DE MEXICO SA DE CV Mango Analytics User Guide 2013 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 e PSTN E1 T1 Lines Traditionally connected to your PBX with a E1 T1 PCI e card It can handle up to 24 calls T1 and 30 calls on an E1 e SIP H323 IAX calls sent via the Internet to your local Telco or another VoIP provider No limit on channels e PSTN Analog Traditional connected to your PBX with a PCI e card Each port is one channel only When us
20. ettings NA 3 7 on A r a ly ICS i ee ie bal i ee My Settings Updating user information o Setup My Settings About l AMOVeENCEO FEA KREDOrINS l Country Mexico ii Company Name My Company Contact First Name Name Contact Last Name Last Name Contact Email me example com Currency Code USD Currency Symbol amp Save On this page you can change your settings of MAngo Analytics which are Country The country where your system is located Company Name Your company name Contact First Name Installing user name Contact Last Name Contact Email Currency Code E g MXN USD GBP ARS Currency Symbol The symbol of the currency selected First Setup Understanding Data Setup Mango analytics doesn t interact with the production CDR of your Elastix system it only imports data There are two types of data import e First data import This import happens during first set up after all trunks fees and bundles are already configured If your Elastix server is brand new you can import at any time but if you have had a Elastix system for a long time your CDR may be huge so we recommend you to make first import at off peak hours This data 13 NZXT TELECOMUNICACIONES DE MEXICO SA DE CV Mango Analytics User Guide 2013 import can last some seconds or several hours it all depends on how many calls are saved on your main CDR and obviously on your power server e Daily data import Mango analyti
21. ing 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 16 NZXT TELECOMUNICACIONES DE MEXICO SA DE CV Mango Analytics User Guide 2013 Understanding Rates Setup 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 Huge difference between these two types of numbers e Dialed Number What your user dials to reach a certain destination This number can include an internal prefix only used for your Elastix users o For example When user wants to dial number 44 1234 5678 they need to dial 9 44 1234 5678 e Outgoing Number This is the number sent to your Telco and it changes depending on country access technology provider etc o Example Your user dials 9 44 1234 5678 and your Elastix converts this number onto 011 44 1234 5678 Mango will ID the previous call example
22. l have detailed information of each trunk Last Month 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 Upper gross and per trunk area This Month Usage 01 Aug 31 Aug This month s destinations Provider Bundles Cost Calls Cost Monthly Cost Total Cost 0 00 USD 1407 00 USD 399 00 USD 1806 00 USD 0 00 USD 2996 00 USD 499 00 USD 3495 00 USD Local Landline Gross consumption as of today 5301 00 USD Intemational i Local Mobile Domestic Mobile 5 NZXT TELECOMUNICACIONES DE MEXICO SA DE CV Mango Analytics User Guide 2013 e Usage upper gross and per trunk area e At the upper left table all general per trunk information will be showed This information does not reflect your providers billing period data it will show only current month costs o Provider Your providers trunk name o Bundles Cost Your bundle expenses o Calls Cost The cost of all your calls will not reflect calls that apply to any bundle you have o Monthly Cost The flat monthly fee your provider charges you o Total Cost Sum of bundle cost calls cost and monthly fee e On the bottom of the table a gross total will be shown e This month s destinations graph upper gross and per trunk area o This Pie graph shows the gross destination percentage based on call volume from all your configured trunks it will give you a good idea
23. lco 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 Before You Get Started 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 3 NZXT TELECOMUNICACIONES DE MEXICO SA DE CV Mango Analytics User Guide 2013 Please gather all the information needed before starting Mango setup e Telco s connected to PBX and trunks e Detailed rates of each and every one of your Telco providers e Detailed bundle info 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 Pin sets pages for more detailed information On the upper right area the Se
24. ll 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 A g O A Hz Y A c et i l ID gt i a on i gt Setup Add base rate to provider O Setup My Settings About Destination Local Landline T Rates configured Return to setup Country Mexico T Pee i F i Destination Prefix Connection Fee Minute Fee l fi Local Landline 52 0 0 USD 3 0 USD Call Prefix wa wa f International 1 0 0 USD 35 0 USD mpn Ez Minute Fee 0 0 USD ie Domestic Mobile 521 1 0 USD 3 0 USD EAE J J Local Mobile 52155 3 0USD 0 0 USD Ez Billing interval 60 seconds F J Local Landline Default 0 0 USD 0 7 USD Leia Ez Call Connection Fee 0 0 USD Notes Save Rate Cancel Destination What type of destination it is you will have the next options e Local Landline Select when calling a local landline in your area Domestic Landline Select when calling to a landline inside your country Local Mobile Select when calling a Mobile in your area Domestic Mobile Select when calling a Mobile inside your country International Select when calling a foreign country Country By default your country will appear please select another country for international calls Be sure to select International as well on the Destination
25. nations If you need more detail on the destinations you need to set up the right rates for each trunk 4 NZXT TELECOMUNICACIONES DE MEXICO SA DE CV Mango Analytics User Guide 2013 e Top Users last 7 days o Quick overview of which users are the ones using or abusing more of your telecom resources Very helpful at a glance data For further data analysis please go to users section e Graphs o The lower right graph represents your current and past 5 months expense for each trunk You will see one vertical line for each trunk you have This is quite helpful you can see on a simple graph how your expenses per trunk are or have been The graph is your gross usage per trunk The lower left graph also reports current and past 5 months calculated based on the providers billing period Realtime 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 Trunks 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 wil
26. od interval and the monthly average usage of this trunk This average is taken from the last 6 months use O O O O Rates and Bundles 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 Trunk Analysis is button will take you to an in depth analysis page of each trunk we l get to that section next 7 NZXT TELECOMUNICACIONES DE MEXICO SA DE CV Here is the basic layout of the trunk analysis page Usage 2013 07 31 2013 09 01 Apr May May Jun Jun Jul Jul Aug Aug Sep Sep Oct 5000 USD Mango Analytics User Guide 2013 Trunk Analysis 12000 min Provider Rates amp Bundles aie 1000 min Trunk Name a Trunk Type sip 00 min 3000 USD Billing Cycle 15 of every month Payment Type Postpaid 7000 USD 400 min SE MIS USD MOFUSD fas u 200 mi j Sh 0045 j IED 200 mm Average Monthly Cost This Month s Usage 3495 00 USD 0 USD Oo mm Apr May May Jun Jun Jul Jul Aug Aug Sep Sep Oct Average Usage 1172 83 USD Traffic Segmentation by Cost Billing Billing Interval Total Cost Total Calls Total Seconds Sept 15 2013 J Oct 14 2013 499 00USD 0 0 Aug 15 2013 J Sept 14 2013 809 00USD 40 4493 ae July 15 2013 J Aug 14 2013 4232 00 U
27. s Even though Provider 2 offers only 1 flat rate its recommended that you input the detailed tariffs for provider 2 Trunk We know it s more work for you but it will greatly improve Mango s reporting and analysis data Understanding Bundles Setup 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 Name The name of the bundle Billing Mode If the bundle has free minutes select Minute if it has free calls select Call Cost The monthly cost of the bundle Amount of minutes calls The amount of free calls minutes Start Date Date when the provider will start applying this bundle e End Date The bundles by default have a lifespan of 2 years but if you know it doesn t last that long you can fix the end date e Priority If you have multiple bundles for a destination you can specify the order in which you want them applied When you ve finished filling in all the information press Save Bundle and repeat if necessary for every destination 20 NZXT TELECOMUNICACIONES DE MEXICO SA DE CV Mango Analytics User Guide 2013 Understanding Data Importing When you have finished configuring all your trunks b
28. s be for Asterisk servers Further Mango applications will be releasedfor 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 Is it available for 1 X Versions of Elastix 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 Does Mango reports inbound toll and toll free calls Not at the moment but its considered for version 2 Can I download nice looking report with graphs and everything Not at the moment but its considered for version 2 I have tons of rates and its impossible to upload them manually can I import them onto Mango Not at the moment but its considered for version 2 I need a report per users group is that possible 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 doesn t report inbound and internal calls why 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 Why if Mango is developed in Mexico and offered on Elastix Ecuatorian distro isn t it available in spanish That s a very good question We need Mango
29. tup button will give you access to all Trunks Rates and Bundle setup Portal Overview KD Dashboard Main Dashboard Se My Settings About This month s costs TOP Destinations from last 7 days TOP users from last 7 days 705 00 USD Country Destination Cost Extension Name Cost 2060 00 USD il Local Landine 2064 00 USD 469 647 00 USD j Mexco Local Mobile 75 00 USD 4660 483 00 USD Gross monthly consumption as of today 2765 00 USD pg vexco Demenfic Mahle O z 306 00 USD Unted States Internabonal 5 00 USD 450 288 00 USD 466 282 00 USD Monthly Call Costs Costs by Billing Period y g E Mambo 400 E hex Mango Analytics Dashboard page consists on at a glance information of your current and historic user amp 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 e Current month cost o The upper left table shows the current monthly cost of each of your configured trunks This cost is the partial cost of the month It doesn t reflect the cost of your providers billing period For more details on trunks please click on the button called More located at the right of each trunk e Top Destinations from last 7 days o Quick overview of top destinations This information is gathered from your last 7 days of usage showing your top dialed desti
Download Pdf Manuals
Related Search