\
|
|
|
Websites
|
|
Make an effective impression with well-presented data
|
|
|
Websites should impart information quickly, efficiently and clearly. Without the proper presentation of data, your website has failed its primary mission.
Information can take many forms and formats but, essentially, it is data found in your database. It can be of a textural form, an image or video, even a PDF.
Review these sites against the premise of "user's want to get in, find their data and get out". You'll find the information is clearly presented, intuitive and easily accessed.
|
|
|
|
Related Media and/or Information
|
|
Skene Memorial Library
My wife, who is a writer, and I built this website for the Skene Memorial Library, located in Fleischmanns NY. It was a lot of fun. The history is great -- and the postcard collection has some very graphic and early examples.
Make sure you visit the Digital Patchwork Quilt, a special section we developed to highlight the historical aspect of the Library.
|
|
|
CircaJerk
This is an collectibles site focusing on 1930-1970 Americana. The photographs are excellent and the quality itself is quite high.
I believe websites should reflect a personality -- and this one does!
|
|
|
Mosaic Science Magazine
This site contains all the early issues of Mosaic Science magazine, the well-respected publication of the National Science Foundation (NSF) from from the early 1970s through the early 1990s. If you think there's a science topic is new, it was probably written about in Mosaic long ago. They even discuss global warming here!
All the issues are available in PDF. There is no charge to download these back issues.
This site is completed but still lacks much data (March 2009).
|
|
|
Coins Only
This site, launched in early 2009, focuses on numismatic and bullion coins from the US and around the world.
If you've never looked closely at coins, here's an excellent opportunity to do so as the photography is excellent.
And if you wish to purchase gold or silver coins, you should call CoinsOnly.com. They are extremely reputable, reliable and fair. They have an Ebay store with nearly 8,000 positive reviews and 0 negatives. I have known the principal for nearly 20 years.
If you want a reliable and trusted precious metals dealer, visit this website.
|
|
|
Openear Center
The Openear Center is known throughout the world for its development work in sound healing and therapy involving music, from the classics to indiginous cultures.
Headed by Pat Moffit Cook, Ph.D., lectures and workshops are given around the world. They also offer challenging study trips in the Middle and Far East, including Turkey, Nepal, India and Tibet.
This particular site posed challenges involving scheduling issues and upscaling their site to include more graphics and video.
|
|
|
|
|
TrueValue Hardware
|
|
Award-winning database-driven marketing program
|
|
|
These bullets and screenshots represent the major work I managed on a recent position. The client was TrueValue Hardware and the web application developed encapsulated a wide range of processes. The principal focus was managing a Loyalty Program on behalf of 500+ TrueValue Hardware stores, nearly all owned individually.
The database imported tlog data for each store daily, managed the store's promotional mailings, handled all the customers of each store and, as well, directed the fulfillment of the rewards earned by any customer.
This all-inclusive, national marketing program won the 2006 International Gold ECHO Award for Direct Mail Marketing.
Here are a few of the numerous features contained within this web-based application -- and which I played an instrumental role in designing and developing:- over 3,000,000 customers
- 600+ individual stores
- Transaction logs for each store imported daily
- Extensive deduping of customers, distinguishing between duplicate records, relatives and friends at the same address
- Proximity calculations based on latitude-longitude of stores and customers
- USPS pre-sorting on all outgoing promotional mailings
- Selection of promotional mailings, including assignment of coupons, inhome dates, mailing limits and ongoing subscription-based mailings
- Rewards calculations based on incoming tlog data, cross-checked against ineligible, store-specific SKUs
- Seasonal, store-specific hours incorporated into mailings
- Theme- and Department-based promotional mailings
- Interaction with 3rd-party vendors to provide and/or exchange relevant store-specific data
- Mailing cost-calculator updated in real-time as features added to mailing
|
|
|
|
Related Media and/or Information
|
|
Kickoff Screen for Promotional Marketing
This screen is the kickoff page for selecting promotional mailings that a hardware store could select, eg, hardware, lawn & garden, tools, etc. These icons represented specific mailings while sidebar menus grouped mailings by category.
|
|
|
Mailing Summary screen
A promotional mailing, when all steps were completed, offered a summary screen of all the settings: quantity mailed and demographics, coupons and other peripherals, estimated cost and store settings.
|
|
|
Promotion-specific overview
This screen introduces a specific promotional mailing. It contains metrics on how the mailing has performed for other stores; details features and customize-able fields and provides an "umbrella" view of the mailing
|
|
|
Demographic selections
This step allowed the store to indicate which types of customers would be included in the mailing. These mailings allowed numerous feeds: existing customers, prospects, coupon redeemers, store-specific files, custom selections.
All of these feeds were balanced against the upper limit of how many actual pieces the store wanted to mail.
|
|
|
Coupon Selection
Coupons played a big role in promotional mailings. Stores could select from a single coupon, groups of coupons (if the mailing was multi-coupons) or even create their own.
|
|
|
Bullets
Optional features could be selected. Bullets were printed on the outside of the mailing piece.
|
|
|
Inhome Dates
The "in-home" date determined when a mailing would reach consumers. Inhome dates as far off as a year could be selected. Mailings were scheduled, often twice a month.
The black-backed grid overlying the main image is a cost-estimator for the mailing. As features and/or quantities are added to the maiing, the estimator would relect these charges automatically.
|
|
|
|
Mailing Summary screen
A promotional mailing, when all steps were completed, offered a summary screen of all the settings: quantity mailed and demographics, coupons and other peripherals, estimated cost and store settings.
|
|
|
Customer Search
Stores and Customer Service personnel used this screen to locate any customer. Stores could not see records from other stores although owners of multiple stores could skip between stores quickly.
|
|
|
Transaction Logs
Each day approximately 250,000 transaction records from all teh participating hardware stores were uploaded into our database. Points were awarded based on these records. Safeguards were installed to prevent excessive awards or mis-counting.
|
|
|
Store files
All out-going and incoming files were registered; thus, it was easy for a store to see what they had mailed and when. This registration of files made it easy to see if and when a customer was mailed because a similar "registry" was maintained for EVERY customer who ever received any mailing.
|
|
|
Order History
The Order History screen compiled a list of all the mailings and other orders, past and future, which a store had ordered. Stores could delete their future mailings (or modify them) if the mailing had not begun and gone to production.
|
|
|
Points
Points were the central focus of this application. Points were calculated on a complex mix of factors: was the item in a department that did not award points; how many points were awarded, by department, for each dollar spent; was the SKU ineligible; was the customer even allowed to earn points (Contractors were not allowed to earn points.).
|
|