|
<< Click to Display Table of Contents >> Reports - Application Overview |
  
|
|
<< Click to Display Table of Contents >> Reports - Application Overview |
|
SOPRANO MEMS Reports provide an online view of your usage and messaging interactions, independent of whether access method was API or via SOPRANO MEMS web applications.
Applications within SOPRANO Mobile Enterprise Messaging Suite may be presented with a range of reporting features including:
•Graphical reports
•On-screen reports
•Filtered reports
•Schedule reports (Reports+)
•Real-time reports
•Application-specific reports (where applicable, ie SOPRANO MEMS StaffMatch/SOPRANO MEMS Reminder)
Reporting Requirements Specification Overview
The Reporting Requirements Specification defines the interface that is exposed to external systems, such as Business Intelligence/Data Warehouse Solutions as well as Enterprise Spreadsheet Applications for scheduled/exported Reports.
Key reports are available for:
The platform limits the number of rows returned in a file to 300,000. If you require Reporting with more rows than that please contact your support representative.
Reports
Typically, the standard message report is the only report feature deployed in the base of a SOPRANO MEMS install.
Message Report
•Tabular view of data (each message record)
•Greater than 1000 rows, reports will be delivered via email to the user
•Report preview for the first 50 rows of a large report is available
•Report filter by:
Message Type (SMS / Email* / Voice* / Location*)
Message Status
Submit / Received Date Range (Including Timezone)
Customer
User
Order Name
Address / Mobile Number
Cost Centre
Performance Report
•Graphical or List (Tabular) presentation of summary data
•Report Filter by:
Message Type (SMS / Email* / Voice*)
Message Status (MT / MO / ALL)
Submit / Received Date Range (Including Timezone)
Customer
User
Order Name
Cost Centre
Summary Interval (Second / Minute / Hour / Day), search range will change based on the resolution of the summary interval.
Reports+
'Reports+' includes all of the 'Reports' functionality plus the following:
Message Report
•Export Report Data.
Performance Report
•Export Report Data.
Additional Filter:
•Group By (When Rendering as a List, not graphical view)
Customer
User
Cost Centre ID
Country
Status
Scheduled Message Report
•Schedule a message to run immediately, once (at scheduled date), weekly or monthly.
•Report delivered to remote system or person via Email (up to two email addresses), HTTP or FTP
•Report filter by:
Message Type (SMS / Email / Voice / Location),
Message Status
Submit / Received Date Range (Including Timezone)
Customer
User
Order Name
Address / Mobile Number
Cost Centre
•Name the file that will be delivered to the remote person or system
•Zip the CSV file to be delivered to the remote person or system
Scheduled Performance Report
•Schedule a message to run immediately, once (at scheduled date), weekly or monthly.
•Report delivered to remote system or person via Email (up to two email addresses), HTTP or FTP
•Report filter by:
Message Type (SMS / Email / Voice / Location),
Message Status
Submit / Received Date Range (Including Timezone)
Customer
User
Order Name
Cost Centre
Group By (When Rendering as a List, not graphical view):
Customer
User
Cost Centre ID
Country
Status
•Name the file that will be delivered to the remote person or system
•Zip the CSV file to be delivered to the remote person or system
Summary Report - SMS by User (Only in existing customer)
•Submit / Received Date Range (Including Timezone)
•Export Report Data to CSV
•Tabular View (Including Status breakdown)
•Graphical View (Top 50 Users)
Summary Report - SMS by Order (only in existing customer)
•Submit / Received Date Range (Including Timezone)
•Export Report Data to CSV
•Tabular View (Including Status breakdown)
•Graphical View (Top 50 Order)
Summary Reports - SMS by Customer (include sub customer)
•Submit / Received Date Range (Including Timezone)
•Export Report Data to CSV
•Tabular View (Including Status breakdown)
•Graphical View (Top 50 Customers)
Summary Report - SMS by Cost Centre (only in existing customer)
•Submit / Received Date Range (including Timezone)
•Export Report Data to CSV
•Tabular View (Including Status breakdown)
•Graphical View (Top 50 Cost Centre)
Summary Report - Account Report
•Report Type : Address, License and User
•Customer Filter