SQL Reporting System in Multichannel Order Manager
The reporting needs of direct marketers are unique. No other business requires such a broad range of information - from the closest level of detail to keep track of the day-to-day operation to the highest level of trend analysis for strategic product, marketing and advertising decisions. Dydacomp's Multichannel Order Manager (formerly Mail Order Manager) and cloud hosted SiteLINK eCommerce software gives you the power to analyze at all levels with sales reporting options to support every area of your business operation.
Relational Database + SQL = Incredible Reporting Power!
The way a system stores and accesses information determines how quickly and flexibly you can create reports. The incredible power of Multichannel Order Manager's reporting functions is based on the combination of a 4th generation relational database for information storage and structured query language (SQL) for information access. M.O.M.'s relational database creates the "connections" between the individual files in your system, and SQL "supercharges" database access - no matter how big the report, M.O.M. processes it at the same super fast speed!
Track Advertising Results
Setup "source keys" for your online, mail, telemarketing, and retail campaigns. Then determine your most effective advertising based on sophisticated profit and response reports, including Revenue by Ad Source, URL, Downstream Reorder Analysis, Market Analysis, and Response Curve Forecasting
Study Product Performance
Report on product profit by individual product, channel, salesperson, customer type, website, catalog, advertising source, virtually any qualifier you want. Determine product catalog performance based on space-to-profit ratios. Display reports graphically with our built-in graphing feature.
Sales Commissions and Royalties Too
Multichannel Order Manager even gives you sales commissions reporting and royalties payment reporting by individual product. Setup commission and royalty rates based on gross, net or unit sales.
Powerful Query Screen
And, the powerful M.O.M. Report Query screens let you customize your report on-the-spot, even sort and sub-total using your choice of information as well as save most often used reports and set up automatic distribution of those reports through email.
View It, Print It, Graph It!
You can even use the new built-in graphing feature for your product profit reports to create bar charts, pie charts, column charts, line charts - almost any imaginable graph you want!
Custom Reporting Tool
You can download any report directly into your favorite spreadsheet or word processor. And, if you want to create your own report from scratch, you'll be glad to know that the most frequently used databases are fully referenced for you field-by-field in our data dictionary.
