|
|
|
| Back |
Home>>
Portfolio / Case Studies
>>Database Case Studies
|
|
|
MacBusiness Consulting Portfolio and Case Studies
Publication/Media Database for Public Relation Company
|
Problem/Need: Store and generate reports for clients showing the publication/media editorial history calendar and Ad Value. Track and store Physical issue library
Solution: Implementation of an Publication Database designed/programmed by MBC with the following function
KEY FUNCTIONS OF THE PUBLICATION DATABASE
- Store and Track Media/Publication and related data
- Generate Media Coordination worksheet and Profile
- Generate Publication Reports (i.e. by classification, name, etc.)
- Store and Track Editorial History for Each Publication, Issue and Client
- Generate Media Editorial Calendar History by client featuring each publication, Month, Year and Ad Value (show the $ value Editorials for clients
- Dynamically calculate US $ value of Ad Rates base on Yen Exchange Rate
- Store and Track Physical Publication Issue Library
- And much much more.
This database system is a successful MBC solution. References available upon request.
If you are interested in a demonstration, contact MBC at 808-739-9797
|
|
|
| Back |
Home>>
Portfolio / Case Studies
>>Database Case Studies
|
|
|
Home
