Embedded Files
North American Broadcasting Company, Inc.
North American Broadcasting Company, Inc. - Streamlining RFPs and Promotions with Form Director
North American Broadcasting Company, Inc. - Streamlining RFPs and Promotions with Form Director
Quick facts
Quick facts
Location: Columbus, OH
Location: Columbus, OH
Industry: Broadcasting
Industry: Broadcasting
North American Broadcasting Company, Inc. is a locally owned Central Ohio company established in 1957, delivering four diverse radio stations catering to different demographics:
A leading marketing director faced challenges in managing requests for Proposals (RFPs) and promotional workflows due to manual data entry, inefficient communication, and lack of automation.
By implementing Form Director, he streamlined the entire process—automating proposal creation, calculating promotional values, generating documents, scheduling events in Google Calendar, and sending team notifications. This transformation saved time, improved accuracy, and enhanced team
About Company
About Company
North American Broadcasting Company, Inc. is a locally owned Central Ohio company established in 1957, delivering four diverse radio stations catering to different demographics:
🎸 WRKZ (99.7 The Blitz) – Active/Mainstream Rock
🎶 WJKR-FM (103.9 The Maverick) – Classic Hit Country
🎙️ WMNI-AM 920 (Fox Sports Radio Columbus) – All-Sports Station
🎵 WJKR-HD2 on 94.1FM (Star 94.1) – Lite Hits from the 80s, 90s, and Now
With a commitment to creative programming, effective advertising strategies, and deep local engagement, North American Broadcasting Company, Inc. thrives by providing innovative and impactful solutions to its listeners and advertisers.
The Challenge
The Challenge
Eric McGuire, Marketing Director at North American Broadcasting Company, Inc., faced significant inefficiencies in handling Request for Proposals (RFPs) from clients and concert promoters. The process required manually inputting information into multiple systems, leading to:
🔹 Cumbersome manual data entry across Google Sheets, Docs,
Calendar and Email
🔹 Time-consuming proposal creation, calculations, and formatting
🔹 Lack of automation in generating promotional copy and approvals
🔹 Inefficient team communication regarding promotion schedules
Seeking a Solution
Seeking a Solution
As the Marketing Director of a local radio station, Eric McGuire struggled with an inefficient, manual process for handling requests for Proposals (RFPs) from clients and concert promoters.
The workflow required entering data in multiple locations, manually calculating promotional values, creating proposal documents, drafting promotional copies, and scheduling events on the calendar—all of which were time-consuming, error-prone, and lacked consistency.
Eric needed a comprehensive, automated solution that could:
✅ Streamline the proposal process by generating documents automatically.
✅ Perform calculations for promotional values and ROI.
✅ Create promotional copy seamlessly.
✅ Sync with Google Calendar to schedule event dates.
✅ Automate email notifications to keep the team aligned.
While searching for a solution that integrates well with Google Workspace.
Form Director as a Solution
Form Director as a Solution
Eric discovered Form Director while searching for automation tools for Google Workspace.
After evaluating its features, he integrated Form Director into his workflow, automating multiple tasks.
How Eric Used Form Director
✅ Automated Proposal Creation:
Eric created a Google Form to collect all required RFP details. Form Director seamlessly connected the form fields to:
A Google Sheets template to format and calculate the proposal data.
A Google Docs template to generate a professional promotional copy.
📊 Advanced Data Calculation:
Form Director automatically calculated:
✔️ The total promotional value based on selected elements.
✔️ The ROI of the client’s investment, including prizes provided.
📑 Generated Documents & Notifications:
Once the form was submitted:
📄 A Google Sheets proposal was generated and formatted.
📝 A Google Docs promotional copy was created with placeholders filled dynamically.
📧 A PDF version of the proposal was emailed to Eric’s team and the client.
📅 Seamless Google Calendar Integration:
Eric used Form Director to auto-schedule promotions and events in their company Google Calendar, ensuring all team members had real-time access to event timelines.
🔔 Automated Team Communication:
Eric’s team received instant email notifications with all the necessary documents, ensuring everyone stayed informed about campaign details and deadlines.
Results
Results
With Form Director, Eric McGuire streamlined the RFP process, eliminating 80% of manual work and significantly improving efficiency.
✅ Automated Proposal Generation – Instantly creates Google Docs & Sheets for RFPs, eliminating repetitive tasks.
✅ Accurate ROI Calculations – Automatically tallies promotion values for clear client insights.
✅ Seamless Event Scheduling – Auto-updates Google Calendar with promotion & event dates.
✅ Improved Team Coordination – Automated email notifications ensure everyone stays informed.
✅ Faster Turnaround & Consistency – Reduced errors and ensured efficient approvals & execution.
Form Director helped Eric McGuire create a centralized, automated workflow, allowing the team to focus on strategic marketing instead of admin tasks. 🚀
Testimonial
Testimonial
I am the Marketing Director at a local radio station. I was looking for a way to streamline our RFP's(Request for Proposal) from clients and concert promoters. I found Form Director while looking for solutions. I thought I'd give it a try. I was blown away by the integration into Google Suite and some of the more advanced features of Form Director. After my initial evaluation of the application, I saw many ways it could help, so I started building.
I started with a simple Google form with fields for all the pertinent information needed for our Proposals. I was easily able to connect those form fields to Form Director. I then began creating templates for the information to flow to. There were 2 different documents I needed to create. I created a Google Sheets template to layout the client facing proposal. I used some of the advanced features of Form Director to calculate certain totals to be used in the proposal. It would add up the value of the promotions based on the elements I entered in the form. It was also able to add up the value of the promotional prizes the client was providing and assigned a value to that to show ROI on the proposal.
I also needed promotional copy created from the form info, so I made a Google Doc template crafting a sample copy paragraph with placeholders to be filled with the form information. Once those were created, I was able to successfully fill in a form and the system would create the proposal and the promotional copy. I also had the system email those documents to me along with a generated PDF (from the Sheets doc) that went to my team to notify them of the promotion and it's dates/times and details. I used the generated PDF to send to the promoter/client.
I also used Form Director to connect to our company promotional calendar on our Google Calendar. Form Director was able to put the dates and times of the event itself on the calendar, it also entered the dates and times of the promotions we are running for that event. My team then can see the promotional proposal, use the copy created, and see the promotion and event dates on the calendar.
I used to have to do all that by hand and it was very cumbersome to enter this info in so many different places and keep it all concise. Form Director was able to do that for me. Now, when I receive a proposal request, I simply put in the information from my form, click submit and all those processes are automated and notifications are sent and my team is all on the same page. It provides consistency and accountability at a level we have never had. I have many more ideas on how to integrate Form Director in our business workflow. I am excited to get started on those projects.
About Eric McGuire
About Eric McGuire
Eric McGuire is a seasoned Marketing & Promotions Director with over 26 years of experience in the radio broadcasting industry.
Currently leading the Marketing & Promotions Department at North American Broadcasting Company Inc., Eric specializes in digital strategy, brand management, promotions, and sales integration.
He has played a key role in developing marketing initiatives for multiple radio stations, integrating social media, digital platforms, web applications, and on-site events.
With expertise in creative direction, branding, event coordination, and audience engagement, Eric ensures that promotional campaigns are innovative, effective, and revenue-generating.
His background spans roles in digital brand management, creative direction, and market research, showcasing his deep understanding of brand positioning, audience targeting, and media strategy. With a strong focus on automation and efficiency, Eric continually seeks cutting-edge solutions to streamline workflows and enhance productivity in the media and entertainment industry. 🚀
About Jivrus Technologies and Form Director
About Jivrus Technologies and Form Director
Jivrus Technologies is a software products company focused on intelligent integration and hyper-automation. Our goal is to connect people and software platforms to streamline processes and drive growth. Our products are designed to provide a seamless and efficient user experience.
Form Director” is an add-on application for Google Workspace that directs your Google Form submissions to Google Workspace apps like Google Docs, Slides, Sheets, Calendar, Contacts, Tasks, etc, and external systems like Database, Trello, Slack, Asana, HubSpot, PayPal, Webhook, Insightly, Quickbooks & many more.
Conclusion
Conclusion
Form Director has revolutionized how Eric McGuire and North American Broadcasting Company, Inc. manage RFPs and promotional workflows.
By automating proposal creation, calculations, scheduling, and team communication, Form Director has saved countless hours and ensured accuracy across their operations. The seamless integration with Google Sheets, Docs, Calendar, and Email has eliminated manual inefficiencies, providing consistency, accountability, and streamlined collaboration.
With these improvements, Eric and his team can now focus on delivering impactful marketing campaigns rather than getting bogged down in administrative tasks. Form Director is the ultimate automation solution for businesses looking to enhance productivity and efficiency. 🚀
Form Director has revolutionized how Eric McGuire and North American Broadcasting Company, Inc. manage RFPs and promotional workflows.
By automating proposal creation, calculations, scheduling, and team communication, Form Director has saved countless hours and ensured accuracy across their operations. The seamless integration with Google Sheets, Docs, Calendar, and Email has eliminated manual inefficiencies, providing consistency, accountability, and streamlined collaboration.
With these improvements, Eric and his team can now focus on delivering impactful marketing campaigns rather than getting bogged down in administrative tasks. Form Director is the ultimate automation solution for businesses looking to enhance productivity and efficiency. 🚀
Report abuse