Billing, reporting, user credits

SMS service providers require a way to keep track of all the SMS messages passing through their system. Ozeki SMS Gateway's billing and reporting features fullfill this need. Ozeki SMS Gateway also allow SMS service providers to setup user credit limits for users on a pre-paid and postpaid basis. Daily, weekly and mothly limits can be set up.

Monitor / log SMS traffic

How to setup SQL sms reporting
How to setup SQL reporting (to store SMS traffic in a Database server)
SQL reporting uses a database server to record all messages going through the system. You can use MS SQL, Oracle, MySQL and any other database system that provides connectivity on Windows. When you configure SQL reporting the Ozeki SMS Gateway software will insert a record when a message passes through the system, and it will update this record with time stamps, delivery references and status information as the message data changes.
How to setup SQL reporting
How to log SMS into txt
How to log SMS traffic into TXT files (SQL commands)
For large capacity systems database servers might not keep up with the SMS traffic. If your system sends several millions of SMS messages per day a standard MS SQL or Oracle database will not offer sufficient performance to log the status of each SMS in real time. For such systems Ozeki offers a mechanicsm to save the SMS traffic information into TXT files. These files can be imported into a database to generate billing and reporting information.
How to save the SMS log into an TXT file (with SQL commands)
How to log SMS into csv
How to log SMS traffic into CSV files
Comma Separated Values (CSV) files are simple text files, where each SMS takes up a line. This is an excellent format to log all SMS traffic passing through your system. The records in the CSV files contain the sender, recipient number, the messages text, the submit date, delivered date, the sender user account ID, and other relevant information that make reporting easy.
How to log SMS traffic into CSV files
How to log SMS into csv
How to display SMS traffic on charts (Pie chart, Bar chart)
If you wish to visually represent SMS traffic, the best tools are pie charts and bar charts. Learn how you can view the traffic information visually and how you can filter to a certain period or to a certain user or SMS service provider connection. This charts can also represent the SMS delivery success rate.
How to display SMS traffic on charts

Control costs / manage user credits

How to log SMS into csv
Setup a pre-paid or post-paid system with credit limits
SMS resellers often introduce user credit limits for safety reasons, to make sure costs don't spiral out of control. System administrators can setup pre-paid plans and add credits to user accounts manually, or setup daily/weekly/monthly credit limits for post-paid accounts. Credit limits can be used to cap the number of messages a user account can send during a given period. Multiple credit limits can be set for any account.
How add credit limits to a user account

More information