Our first out of state client, Ohio Gold & Coins, located in Painesville, Ohio, is a precious metals and coins shop. Our client created a Facebook group named Pee-Wee's Playhouse during the pandemic, where he hosts weekly live streams to buy precious metals and coins.
The main focus was to create an invoice generator for online Facebook Live, Pee-Wee's Playhouse. With our data scientist's help, we created a Google Sheet with complicated formulas to auto-generate invoices in record time. Auto-generating invoices saved massive amounts of time for our client and streamlined his entire Facebook Live process, making it easier for the customers and the client.
Another vital service we provided to Ohio Gold & Coins was technological consulting. We advised our client on recommended technical solutions to solve some of his Facebook live problems. Our tech solutions helped our client streamline his online business and save an extreme amount of time.
A simple, useful feature was linktr.ee. This feature was a link to all our client's payment methods that customers could click and pay. Customers were exceedingly happy and loved the new system. Linktr.ee helped streamline the entire process for the customer and saved our client time.
Aggregate Customer Database
Through using a combination of formulas, a full-scaled customer database with the ability to search any customer's email, Facebook profile, address, or number. This helped save our client not only time but implement it into his shipping account which became automated. Now with a click of a button, he can print shipping labels.
WORK HOURS SAVED ANNUALY
IN AUTOMATICALLY GENERATED INVOICES EVERY WEEK
AGGREGATE CUSTOMER DATABASE CREATED
Let’s Talk Numbers
WHAT WE DID
The main automation feature created was an invoice generator. Combining complex Google Sheet formulas, this feature will save our client hundreds of work hours.
Through using a combination of formulas, a full-scaled customer database with the ability to search any customer's email, Facebook profile, address, or number.
Another feature was live-updating totals for customers' purchases. This feature allowed customers to see a live calculation of their purchases during our client's live stream by searching their name.