Overview
Digital marketing extends far beyond SEO, paid advertising, video and websites. At its core, marketing equips customers with the information they need to make confident purchase decisions. Not all digital marketing agencies have the skills and talent to make this happen.
AllGood Coins, a precious metals and numismatics dealer, asked Media Relations Agency to develop a real-time pricing system for hundreds of coin products. The platform needed to operate seamlessly across staff computers, iPads and showroom TV displays.
We designed and implemented a fully customized, automated system tailored to their needs. The result is a versatile, client-owned system that eliminates reliance on middlemen or costly third-party subscription services.
The Challenge
Precious metals and coins prices fluctuate constantly in response to spot markets movements in gold, silver, platinum and palladium. AllGood Coins’ team needed immediate access to accurate buy/sell prices during live customer interactions. Our client also needed direct control over margin configuration and markup adjustments to protect profitability. Manual price entering was both inefficient and introduced the unnecessary risk of human error.
In addition to displaying on staff workstations, real-time pricing data also had to be professionally displayed on large-format showroom monitors, ensuring transparency and reinforcing credibility during the sales process.
Our Approach
Our digital marketing team applied our 30+ years of internet development to this project. After brainstorming ideas with the client, we moved forward with creating a three-part system.
- Google Sheets Backend
- Connects to Platform Gold API (wholesale precious metals pricing)
- Automatically pulls spot prices and product costs every 15 minutes
- Client controls custom markups for both buying (Bid) and selling (Ask)
- Easy product management: add UpstateID, product name and markups to start tracking
- Handles special pricing structures (e.g., junk silver conversions)
- Google Apps Script JSON Endpoint
- Serves real-time data from Google Sheets
- Provides spot prices, product lists, and categories
- Acts as bridge between spreadsheet and WordPress
- Custom WordPress Plugin (AGC Live Board)
- Three display modes:
- Desktop Mode: Full interactive board for staff on computers/iPads with category filtering
- TV Mode: Auto-rotating display for showroom monitors with progress indicator
- Mobile Mode: Responsive layout for phones
- Features:
- Live spot metal prices at top
- Clickable category filters (Gold, Silver, Platinum, Palladium, plus dropdown for other categories)
- Buy/Sell pricing columns
- Automatic refresh (configurable intervals)
- Professional branded design
- Coin-flip loading anima
- Three display modes:
Technical Highlights
- Cache-busting ensures real-time data (no stale pricing)
- TV mode rotates through products with animated gold progress bar
- Responsive design adapts to screen size
- Dark theme for TV displays, light theme for staff workstations
- Accessibility features (ARIA labels, semantic HTML)
Results
In just a couple of weeks from kickoff to deployment, Media Relations Agency gave AllGood Coins a real-time automated system that gives staff instant access to accurate pricing without manual lookups. The showroom TV displays give the client a more professional, tech-forward image.
The fully functional new system has built-in:
- Control: Client manages their own markups without developer intervention
- Accuracy: Automated system eliminates manual pricing errors
- Scalability: Easy to add new products by updating Google Sheet
- Flexibility: Same data source powers multiple display formats
Key Differentiators
- Client maintains ownership and control of pricing data
- No expensive third-party subscription services
- Flexible display options from single data source
- Built on familiar platforms (Google Sheets + WordPress)
- Custom solution tailored to specific workflow
