pressingmssql2005
mssql2005 时间:2021-05-05 阅读:(
)
MizuCallcenterPlatformTutorialAboutThisisaquickintroductionforunderstandingtheMizuCallcenterplatform.
TheMizuCallcenterisbasedontheMizuManagewiththeadditionofthefollowingfunctionalitiesandmodules:Anewtypeofuserscalled"operators"(thesearemostlythesameasVoIPenduserswithafewadditionalpropertieslikeassignedcampaignandtheyaretreatedspeciallybythemizuserver)Campaign:youcanrundifferentcampaignssimultaneously(withdifferentbusinesslogic,differentsettings,scripts,GUI,clientsandoperators)MAgent:clientapplicationfortheoperators.
Traditionalcallcentersuseastandardvoipclient(softphoneorhardwarephone)andusuallyaseparatewebbasedCRMfrontend.
TheMAgentclientapplicationhasalltheseintegratedinasingleapplicationallowingeasierusageandcontrol.
MAgentLite:ifyouwishtokeepyouroldCRM(moredetailsbelow)GUI:supervisorscancreateadifferentuserinterfaceforeachcampaignbyusingthe"GUIdesigner"formfromtheMManageapplication.
ThiswillbevisiblefortheagentontheQuestionnaireform(fromtheMAgentapplication)Script:eachcampaigncanhavedifferentbusinesslogic.
Thiscanbedefinedusingthe"Script"formfromtheMManageCallcenterstatistics:statisticsbycampaignoragent(availablephonenumbers,totalcalls,"successful"calls,agentworktime,etc)Predictivedialer:aserversidedialertoautomaticallydialthephonenumbersbasedontheavailableagentsandpreviousstatisticshistory.
Thepurposeistoreducetheoperatorwaittimetotheminimumbyeliminatingconnectandringtimes.
TermsCallcenters:http://en.
wikipedia.
org/wiki/Call_centreOutboundcallcenter:Operatorswillcallclients(phonenumbers)forexampletosellsomethingInboundcallcenter:Clientscallstooperators.
CallsarehandledbyIVR.
Forexample:receptionistsOperators:PeopleworkingasagentsClients:CalledpeopleincaseofoutboundcallcenterorcallerpeopleincaseofinboundcallcenterCRM:databasebacked(callcenterspecifictablesandstoredprocedures)andfrontend(MizuManageandMAgent)FeaturesEasyInstallationoftheclientapplications:afterdownloading,installationtakesonlyafewminute.
Installationisjustassimpleasanyotherwindowsprogram:nextnextnextfinish.
Nootherconfigurationisrequiredbydefault.
AutomaticCallDistribution:simpleautomaticdialing,powerdialing,predictivedialing,predictiveintelligentdialingCallRecording:allcallscanberecordedandstoredRealtimecallcheckout:supervisorscanlistentotheongoingcallsrealtimeCustomizableScripts:scripttree,withanynumberofbranches,answers,andreasoncodes.
CustomizableGUI:MAgentGUIcanbecompletelydesignedfromMizuManageCustomizableIVR:anynumberoflanguages,anynumberofbranches,calltransferstotheoperatorsStatisticgeneration:customerstatistics,operatorstatistics,callrelatedstatistics,worktimestatistics,campaignstatisticsInvitationletter:customizationandautomaticprintingVirtualCallCenter:moreserveronthesamehardware(completelyseparatedsoftwareanddatabase)WorksfrombehindfirewallswithdynamicIPaddresses:theclientdoesn'trequirepublicIPaddressesAutomaticdialing:Theoperatordoesn'thavetopressabuttonfordialing,itisallautomaticDatabasedialing:Theoperatorcansearchinthedatabase(byaddress,name,ageetc.
)andwithpressingjustonebutton,theoperatorcancallbackhisclient.
Manualdialing:withthisfeaturetheoperatorcandialanybodybyhisnumber,ifshe/heisallowedtodoso.
Callbackscanbescheduled:theoperatorcancreateacallbackiftheclientrequiresso.
AutomaticCallDistributoronthecallcenterserverwillplacethecalls,asmanytimesandintervals,asitisconfigured.
InstallFollowtheMizuVoIPServertutorialtoinstalltheservice.
TheonlydifferenceisthatyoumustenabletheCallcenterINandOUTmodulesintheConfigurationWizard(thiscanbeenabledalsoanytimelateraftertheinstallfromtheMizuManageapplication->Configmenu).
InadditionyouwillhavetoinstalltheMAgentorMAgentLightapplicationforeachdesktopusedbytheoperators(thesearenativeWindowsapplicationsbuthavebeentestedandworksalsounderLinuxbyWine).
WorkflowSystemadministratorswillcreatetheproperVoIPsetup(peers,routingandothersettings)andwillmonitorthesoftswitch(failedroutes,etc)Callcentersupervisorswilladdtheagentusers,createcampaigns,scripts,GUIandwatchcallcenterstatisticsAgentswillusetheMAgentapplicationtoperformtheirwork(ortheMAgentLightifathirdpartyCRMisused)Callscanbeinitiatedbythreeways(configurablegloballyorbycampaign):1.
predictivedialerbytheserver2.
automaticcallsfromtheMAgentQuestionnaireform3.
manualcalls(fromthe"Callsfromdatabase"or"Manualcall"form)SoftwarecomponentsApplicationServerThecallcenterserveriscompletelyintegratedwithoursoftswitchserverplatform.
Minimumrequirementswith50agents:Windows2003/2008/2012/2016/2019,1GBRAM,DualCoreCPU,20GBHDDTheserverishandlingthecallscomingfromtheMAgents,MAgentwillquerytheserverforphonenumberstocallorthecallsareinitiatedfromthepredictivedialeranddroppedtotheMAgentswhentheyarealreadyconnected.
TheCallcenterOutmodulemustbeenabled(canbeenabledfromtheconfigurationwizard)DatabaseThedatabasebackendisusedtostoreCDRrecords,usertablesandotherdata.
Minimumrequirementswith50agents:MSSQL2005/2008/2012/2014/2016/2017/2019,2GBRAM,DualCoreCPU,128GBHDD.
ForsimpleusagethereisnoanyskillsrequiredbutforadvancedusageyoumightneedsomebasicSQLknowledge.
Themostimportantcallcenterspecifictablesare:tb_cclient:usuallyalargetablecontainingalltheavailableclients(phonenumber,name,addressandotherdetails)tb_cccampaigns:containourcampaignsettings(campaignname,settings)tb_ccampain_clients:eachcampaignhasitsownassignedclients.
Theapplicationsareworkingmainlywiththistable.
Herewestorethedataforclientsrelatedtoacampaign.
Forexamplethenumberofcallattempts,whetherwehavesuccessfullysoldsomethingfortheclient,datathattheoperatorswillenterfromMizuManage,andotherdetails.
tb_ccscripts:scriptworkflowtb_ccscript_answers:dataselectedorenteredbytheoperatorswhilenavigationtroughthescripttb_gui:eachcampaigncanpresentaseparateinterfaceintheMAgentapplicationMizuManageApplicationusedbytheadministratorsandsupervisorstosetupandmonitorthecampaigns(scripts,GUIbuilder,MAgentsettings,clientdatabase,assignclientstocampaigns,statistics,etc)MAgentApplicationusedbytheagents(operators)tomakeorreceivecallsandloadandenterdatafrom/tothedatabase.
ThisisbasicallyaVOIPclientandaCRMfrontendcoupledinoneapplication.
OnthefirstloginthedatabaseIP,port,usernameandpasswordisrequired.
Thiscanbesavedandonsubsequentloginsonlytheagentusernameandpasswordisrequired.
FromMAgenttheagentsareabletodothefollowingtasks:-Login/Logoff(Filemenu)-Changetheirowncampaign(ifallowed)Makecalls:-ByrunningtheQuestionnaireform(thisisthemostimportantform.
MostoftheactivityshouldbedonefromhereanditsGUIandscriptcanbebuiltbythesupervisorsfromtheMizuManageapplication)-Callfromdatabase(ifallowed).
Userscansearchandselectaclientandcalldirectlyfromhere.
-Manualcall:islikeasoftphonewithbasiccallcontrolfunctionsDuringcallstheycanselectvariousactions(Actionsmenu)likeHoldDTMForcalltransfer.
Agentalsocanseetheirownstatistics(fromtheDatamenu)orsetupMAgentpreferences(fromtheConfigmenu)MAgentLightYoumightchoosetouseouradvancedsoftswitchplatformwithyouroldCRM.
InthiscaseyoucanusetheMAgentLightapplicationtoautomatesometasks.
CanbeusedtomonitorcallcentercallstatusandperformautomaticCRMrequests.
ForthisaseparateVoIPphoneandaseparateCRMfrontendmustbeused(preferablyawebbasedfrontendsoitcanbecontrolledbytheapplication)Theonlydisadvantageisthatyourclientsdatabasewillbeduplicated(storedinyourCRM,butyouneedtoalsoimportthemtotheMizuplatform–tb_cclientdatabasetable)BasicsettingsTobeabletousethecallcenterfunctionality,thesemodulesmustbeenabledfirstontheserverside.
ForthisyoucanusetheConfigurationWizardfromMManageConfigmenuandmakesurethattheCallcenterInandOutmodulesareenabled(checkifyourlicenseallowsthis,otherwiseenablingthemoduleswillnothaveanyeffect).
Ifthecallcentermodulesareenabledthenyouareallowedtosetupsomebasicsettingsdirectlyfromthewizard("Callcenter"and"Predictivedialer"pages).
Therearemanyotheroptionsthatcanbesetonsystemlevelusingthe"Configuration"form(select"callcenter"intheCategoryFilter)Incomingcallscanbehandledinmanydifferentways:routethecallnormallytothecallednumberrouteincomingcallstoagents(ortoagroupofagents)aspecial"Callback"numbercanbespecifiedandincomingcallscanbetreatedaftertheconfiguration(routetofreeoperator,orroutetoapredefinednumber)handletheincomingcallsbyanIVRIncomingunknownnumberscanbeautomaticallystoredintothedatabaseandascheduledcallbackcanbeinitiatedautomaticallyandassignedtoafreeoperator.
Formaximumperformance,youcanalsorestrictthemaxring-timeandthework-timeallowedfortheoperatorsbetweentwocalls(administrativetasksintheCRM).
Whenthetimeoutwillelapse,thenextcallwillbeinitiatedautomaticallywithoutanyinteractionneededfromtheagent.
Youcanalsodefinehowmuchtimethesystemwillrecallaclientandwhatistheminimumintervalbetweentworecalls.
Theserecallsareforthenotconnectedorfailedcalls,butagentareallowedtocreatemanualrecallsiffurtherdiscussionwithaclientisrequired.
OutgoingcampaignsYouwillhavetowalkthroughthefollowingconfigoptiontosetupyourcallcenter:1.
CallRoutingHereyouhavetodoexactlythesamestepslikefortheVoIPsoftswitch.
FollowtheRoutingandtheAdminGuide.
2.
ScriptThescriptisaconvenientwayto"drive"youroperatorstroughyourbusinesslogic.
Forsimplecampaignthereisnoneedforascript,butifagentshavetoaskmanyquestionsthanthescriptcaneasetheirwork.
Forthisyouwillhavetousethe"Scripts"formfromtheMizuManageapplication.
Addanewscriptormodifyanexistingone.
Pleasenote,thatthereare2typesofscripts:IVRscripts(usedbytheserverforincomingIVRcalls)andclientsidescripts.
Don'tuseserversideactionsinclientsidescripts!
3.
GUIUsethe"GUIdesigner"formforthistask.
Evenifyoudon'tcreateanycustomizedGUI,thedefaultGUIwillbeloaded.
OntheGUIyoushouldputonlythemostcommonfieldsthatshouldbevisiblefortheagentallthetime(likethenameofthecampaign,thecalledphonenumberandanyotherfieldthatisimportantforyouractivity)4.
CampaignUsethe"Campaigns"form:clickonthe+signtoaddanewrecord.
SetanynamethenassociateitwithascriptandaGUIandsetitstypeto"Callcenter(OUT)".
Therestofthefieldsareoptional.
5.
OperatorsFromthe"Usersanddevices"formyouneedtoaddyouragentswithusertypesetas"Operator".
Theseusersarelike"Endusers"withafewcallcenterspecificsettings.
Themostimportantfieldsherearethe"username"whichmustbeauniquestring,thepasswordandthecampaignwheretheoperatorisassigned.
6.
ClientsClientsareactuallythephonenumberstheagentshavetocallandtheyarestoredinthetb_cclienttable.
Usethe"Clients"formtoaddclientsandputitincampaigns.
Userscanbeinsertedinthefollowingways:manuallyfromtheClientformimportClientsbutton(Clientform->operations)usingtheExport/ImportwizardfromtheFilemenuworkingdirectlywiththedatabase(usetheSQLServerManagementStudio)Ontheclientformyoucanperformvariousfiltering,theonthe"Operations"formyoucanassignthelistedrecordtoacampaign.
Alsofromthisformyoucanviewdetailsabouteachusertogetherwithcampaignactivity(howmanytimesitwascalled,whenitwascalledlasttime,ifthe"offer"was"accepted"or"rejected"andotherdetails)7.
MAgentAftertheoperatorwilllogintotheMManageapplicationandopenthe"Questionnaire"theywillseetheGUIandScriptyouhavepreviouslyassignedforthecampaignandthecallsarestartedautomatically(bytheMAgentapplicationorbytheserversidepredictivedialer)8.
QuotasThismodulehavetobeusedonlyifyouneedtobuildrepresentativestatisticsoryouneedtotargetdifferenttypeofuserswithdifferentcampaigns.
9.
PresentationandchecklistsThesemoduleshavebeenbuiltforthespecificneedforinvitationbasedcampaigns.
(Whenclientsareinvitedtoaneventandyoucantrackthelocationsandinvitationsusingthesetwoform)10.
MonitoringUsethe"Callcenterstatistics"formtomonitorthecallcenteractivity.
Statisticsareavailableforcampaignsandagentswithdifferentgroupingortimeinterval.
AnycustomstatisticscanbeeasilywritteninSQLandstoredinthe"DirectQuery"formforquickaccess.
AgentwillbeabletoseetheirownstatisticsusingtheMAgentapplication.
Additionallyacallhistorycanbequeriedforeachclient(phonenumber)usingthe"ClientHistory"formorbyoperatorsfromtheMAgent(onlytheirownclients)TechnicaldetailsThetb_cclienttableisusuallyahugetablewhichcontainsallclientswithoneormoreassignedphonenumbersandoptionallyotherclientspecificdetailslikename,address,age,etc.
Youcancreateanynewfieldinthistablespecifictoyourneeds.
Afteryouhaveimportedyourclientstothistable,youcanmakevariousfilteringonitandassignapartofthemtoaspecificcampaign.
Forthisthetb_ccampaign_clientstableisused.
Allcampaignspecificfieldsshouldbeinthistableandclientrelatedpermanentfieldsintb_cclienttable.
Youcanputanyfieldfromthetb_cclientortb_ccampaign_clientsdirectlytotheMAgentQuestionnaireformtobeaccessiblebyoperators(read/writeorread-only)withtheGUIdesignerorthescripteditor.
Fieldscanbechangedalsofromthescriptautomatically(byusingSQLupdateactions)WhetheryouusetheautomaticdialerfunctionalityoftheMAgentorthepredictivedialer,thenextclienttobecalledisloadedfromtb_ccampaign_clientstableafterasophisticatedalgorithmwhichwilltakecareforalltheparametersyouhavedefinedongloballevel(Configurationsform)orcampaignlevel(Campaignform).
Themostimportantparametersarethefollowing:whetherthesystemmobileorlandlinenumbersarefavorized(ifbothareset;afterthefirstcalltoaclientusuallythenumberwherewehavereacheditlasttimeisfavorizedautomatically)howmuchtimeswealreadyhavecalledtheclientandwhenwasthelastcallwhetherwehavetoredialtheclient(redialsetbytheagents)whethertherecallscanbeassignedtoanyagentoronlyfortheagentwhomadethepreviouscall(orfirstwetrytheoriginalagent,thenaftersometimetheclientcanbeassignedtoanyotheragent-forexampleiftheoriginalagentisnotworkingforthecompanyanymore)anyquotayouhavedefineontheQuotasformclientcallorder(random,databaseorder,etc)anyotherconfigurationparameteryouhavespecifiedClientscanalsobemarkedas"robinson".
Thismeansthatacertainclientdoesn'ttoleratecallcenterdisturbsandthesystemwillmarkthemtobenotrecalledanymore.
Ifcallsareinitiatedbythepredictivedialer,theagentwillgetonlyconnectedcall(thedrawbackisthattheywillhearonlyashortbeepinsteadoftheringtoneandthentheyhavetoanswerimmediately)Thepredictivedialerisbasedonsophisticatedstatisticshistorytodeterminewhenandhowmuchcallitshouldinitiate.
Thisisdependingonthenumberofagent,numberofcurrentcalls,numberofpreviouscalls,ASR,ACDinthelast10minute/lasthour/lastday/lastmonthinaweightedcalculation,maxringtimeandwaittimesettingsandallotherpredictivedialersettingsyouset.
Thepurposetoreduceoperatorwaittimetominimumwithminimaloverdialing(whenthecallisconnectedbutthereisnofreeoperatoranymore).
Themoreoperatorsyouhave,thebetterthepredictivedialerwillwork.
Theresultofacallandtherelatedstatisticscanbeachievedbythefollowingways:Usingcompleted/accepted/rejected.
ThisisthemosteasiestandconvenientwaytostorethecallresultandcanbedonebyusingtheacceptandrejectscriptactionsordirectlyfromtheGUI(rejectbuttonforquickaccess).
Youcanalsomarkonescriptactiontobethe"competitionquestion"whichmeansthattheconversationhasarrivedtoapointwhenwecansaythatitwascompleted.
(forexamplethecallwasnotrejectedimmediatelybythecalledparty)Thiscanbethesameordifferentfromthe"accepted"action)Forthisyouhavebuilt-instatisticsintheMManageapplication.
OntheScriptformyoucanfindaspecialfieldnamed"endcode".
Insomeitemsyoucanfillthisvalueandthatwillmeanthedegreeinthescriptuntiltheconversationhasarrived.
Youcanmakeanyfurtherquerybasedonthisfield(tb_ccscript_processing.
endcode)Usingfieldsfromtb_ccampaign_clientstostoretheresult.
Forexampleifyousellproducts,youcanstorethepurchasedproductnameinaseparatefieldthenyoucanmakeyourreportsandstatisticsbasedonthisfield(ifemptytherewasnotproductsold…meansa"failed"call)Usingtb_ccscript_processingtable:eachscriptitemaccessedbytheagentcanbestoredinthistable("ivr_storecscriptanswers"globalconfigoption)andqueriedafteryourneeds.
Thiswillofferthemostdetailswiththecostofmorespaceandprocessingresourcesneeded.
Usingyourowntable(s)andfield(s).
Youcanaddanynewtabletothedatabaseandstoretheimportantresultsinthistableinsteadofusingthebuilt-intables.
Youcanalsouseanycombinationofthepreviousmethodstoachieveyourbusinessgoals.
Forexamplethemostimportantstatisticscanbebuiltaftertheaccepted/rejectedflagbutifmoredetailedstatisticsareneededyouwillbeabletousetheothermethodsanytime.
TestYoucanlaunchacampaignintestmode.
Forthisgotothecampaignsettings(Detailspage)andselectthe"Test"checkbox.
Thismeansthatthenumbersinthecampaignwillbecalledinanendlessloop(willberesetafterallnumbersarealreadycalled).
ForexampleyoucanaddafewtestnumberisthiscampaignandlaunchoneormoreMAgenttocallthesenumbers.
Neverenablethisoptionforlivecampaigns(becauseimportantdataislostwhentheresetismade).
AnothertestoptionistotestyourGUIandscriptwithouteventuallytomakeanoutgoingcall.
Forthisyouhavetoselectthe"Test"optionontheMAgentloginform.
IncomingcampaignsThisisdocumentedintheIVRguide.
Thebasicstepsarethefollowings:1.
Setuppropercallhandlingandrouting(Trafficsenders,SIPservers,Routing)2.
CreateaIVR(IVRform)3.
MakeacampaignandassigntheexistingIVRforit(Campaignsform)4.
CreateanIVRusersandassigntheIVRforit(UsersandDevicesform)5.
Createoperatorsandassignsomeoperatorstothiscampaign(UsersandDevicesform)6.
Operatorsnowcanlaunchtheclientapplicationandwaitforincomingcalls(MAgent)FormoredetailsusetheAdminGuideorcontactoursupport.
CopyrightMizutechSRL
zji怎么样?zji是一家老牌国人主机商家,公司开办在香港,这个平台主要销售独立服务器业务,和hostkvm是同一样,两个平台销售的产品类别不一平,商家的技术非常不错,机器非常稳定。昨天收到商家的优惠推送,目前针对香港邦联四型推出了65折优惠BGP线路服务器,性价比非常不错,有需要香港独立服务器的朋友可以入手,非常适合做站。zji优惠码:月付/年付优惠码:zji 物理服务器/VDS/虚拟主机空间订...
搬瓦工最新优惠码优惠码:BWH3HYATVBJW,节约6.58%,全场通用!搬瓦工关闭香港 PCCW 机房通知下面提炼一下邮件的关键信息,原文在最后面。香港 CN2 GIA 机房自从 2020 年上线以来,网络性能大幅提升,所有新订单都默认部署在香港 CN2 GIA 机房;目前可以免费迁移到香港 CN2 GIA 机房,在 KiwiVM 控制面板选择 HKHK_8 机房进行迁移即可,迁移会改变 IP...
企鹅小屋怎么样?企鹅小屋最近针对自己的美国cn2 gia套餐推出了2个优惠码:月付7折和年付6折,独享CPU,100%性能,三网回程CN2 GIA网络,100Mbps峰值带宽,用完优惠码1G内存套餐是年付240元,线路方面三网回程CN2 GIA。如果新购IP不能正常使用,请在开通时间60分钟内工单VPS技术部门更换正常IP;特价主机不支持退款。点击进入:企鹅小屋官网地址企鹅小屋优惠码:年付6折优惠...
mssql2005为你推荐
支持ipadapple.com.cn苹果官网怎么查序列号http500ZTCS500在哪能下载手机QQ?css加载失败css 无法加载企业建网站企业为什么要建网站文档下载怎么下载百度文档文档下载怎样把手机里的文件直接下载或复制到U盘里文档下载怎样在手机上建立word的文档? 需要下载什么软件?正大天地网二三线城市适合做生鲜b2b电商吗徐州商标介绍徐州的一种产品
vps论坛 plesk photonvps linkcloud 双11秒杀 佛山高防服务器 cn3 服务器托管什么意思 免费美国空间 息壤代理 免费邮件服务器 网购分享 我的世界服务器ip 德隆中文网 独立主机 永久免费空间 atom处理器 闪讯网 新疆服务器 .htaccess 更多