Mail Marketing Database

Mail Marketing Database

We have a basic database here but would like to see about having it improved by someone who knows what they are doing. It will need some basic report functions, easy bulk editing, multiple screens and will need to fully functional on IPads through the standard browser (no need for app) and on android phones through the browser. We have a budget and are flexible with timelines, within reason.  ***update** here is a summary that hopefully defines what we are looking for better:


We are looking to combine two daily functions of our business. One part of or business is direct mailing leads on a regular basis. Our leads come to us in two ways. We purchase records and those are delivered in CSV which we convert to excel, the second source is stuff we see out in the field while we go about our normal day. When a lead calls in off one of our mailing pieces it rings our cell phones directly and we need a way to search/update/make notes on a record while we are talking to them.

The purchased records are easily managed in excel, we have a master sheet and all new purchased records are copied to it as we buy them. On this sheet we track what the last mail piece they received and the last date we mailed them. By sorting we can see who's turn it is to receive mail, what was the last piece they received and we can then just copy the columns of data our bulk mail vendor requires to send our piece. The records contain 28 columns of data that is purchased and we have an additional 7 columns that we manually input depending on what the status of the record is in.

While going about our daily business we run across prospects that need to be added to our mailing list. We have been handling this by using Evernote on our Android phones or Ipads, creating a note, making a few notes and then eventually that record gets added to the excel sheet.

Thirdly, while out in the field we receive phone calls from people who received our mailing piece. If we are lucky we will make an Evernote note while on the phone, or we write notes down on a note pad and hopefully don't lose the thing. We send on average 2000 pieces of mail a month so when someone calls us and we are in the field we have no way of quickly retrieving their information so we end up having to ask questions for information that we already have and occasionally this turns off a prospect due to this fact.

So, we need an online custom database that imports all our excel records, is accessible in the field, has a very easy search function that will work on a smart phone or ipad, and the ability to upload photos of a prospect directly into it when we are manually inputting a new record from the field. This will need to be our mail campaign manager, note holder for individual leads and lead classification system to make follow up easy.

On the mail campaign side I need to be able to go into the database and say show me records that have not been mailed in XX days (generally 60-120) and then be able to narrow those results down based on any of the data fields to a specific 500-550 records for export to a defined spreadsheet for our bulk mail vendor. We track the last time they received mail and what mail piece was sent out. Our target is 500 +/- pieces of mail sent out every Friday.

When manually inputting while in the field this will generally be done on our Android phones so we will enter just a few pieces of information, snap a picture and then complete the research and data entry the next time we are at our desk. This needs to be easily and quickly done from the field and then when at our desks we need a easy search that displays the manually input records that need further research and data entry/updating.

Lastly we classify each record based on if they have ever called, we spoke to them and were told to go to hell, spoke to them and didn't make an offer, spoke to them and made an offer etc. If a formal offer was mailed to them we will upload it as a PDF to be stored with the record that way if we are in the field and they call back we can pull up the offer we sent out.

Looking around I found Zoho Creator and it looks like it will handle all of these needs. I created a ugly version and we are currently testing it out and we are able to do everything we need on our phones and computers in the fields. I'm not a programmer and have no interest in being one so I'm looking for someone who can take what I have already started, clean up the user interface, create an easy search function and a way to run the various searches. If Zoho Creator isn't the best solution I'm open to suggestions provided they are not tens of thousands dollars. Realistically we are only talking about 35-40 fields of information per record and a maximum of 20,000 records as we grow over time. We currently have just under 10,000 records and are adding/growing by about 800 a month.

Lastly, for backup purposes we would want an easy way to export the entire database in one run to a CSV file to be backed up to our carbonite account and my external HD.

This database only needs to handle two users.




















Budget : Reasonable | Duration : Weeks?

To leave a private message, please click the link for private response in post Action section.


      Zoho Campaigns Resources


        • Desk Community Learning Series


        • Digest


        • Functions


        • Meetups


        • Kbase


        • Resources


        • Glossary


        • Desk Marketplace


        • MVP Corner


        • Word of the Day


        • Ask the Experts


          Zoho CRM Plus Resources

            Zoho Books Resources


              Zoho Subscriptions Resources

                Zoho Projects Resources


                  Zoho Sprints Resources


                    Zoho Orchestly Resources


                      Zoho Creator Resources


                        Zoho WorkDrive Resources



                          Zoho CRM Resources

                          • CRM Community Learning Series

                            CRM Community Learning Series


                          • Tips

                            Tips

                          • Functions

                            Functions

                          • Meetups

                            Meetups

                          • Kbase

                            Kbase

                          • Resources

                            Resources

                          • Digest

                            Digest

                          • CRM Marketplace

                            CRM Marketplace

                          • MVP Corner

                            MVP Corner




                            Zoho Writer Writer

                            Get Started. Write Away!

                            Writer is a powerful online word processor, designed for collaborative work.

                              Zoho CRM コンテンツ








                                ご検討中の方

                                  • Recent Topics

                                  • Limitations on editing a message in Cliq

                                    Hi I've checked the documentations and there's no mention of how many times a message can be edited. When trying with code, I get various numbers such as ~1000 edits or so. Please mention if there's a limit on how many times one can change a message via
                                  • Narrative 10: Assignment Rules - Streamlining Ticket Management

                                    Behind the scenes of a successful ticketing system: BTS Series Narrative 10: Assignment Rules - Streamlining Ticket Management In the complex world of customer support, a flood of incoming tickets can hit the help desk in seconds. Businesses must do more
                                  • Free webinar! Digitize recruitment and onboarding with Zoho Sign and Zoho Recruit

                                    Hello, Tired of being buried in onboarding paperwork? With the integration between Zoho Sign and Zoho Recruit, a powerful applicant tracking system, you can digitize and streamline the entire recruitment and onboarding process, all from one platform.
                                  • Custom form - Duplicate Value Present

                                    I am new to Zoho People. I create a new form on Zoho People quite simple. A date (by default the current date) and a radio button with 3 options (Yes, No, Not applicable) I defined the date as ‘No duplicate’ as only one entry by date is allowed. I added:
                                  • Zoho API connection issues

                                    Hi, Today at around 1930 GMT our application started experiencing intermittent timeouts from the Zoho API. These intermittent timeouts are not enabling our app to work properly. The API connection was working just fine before. HTTPSConnectionPool(host='www.zohoapis.com',
                                  • Query Regarding our Partnership between AIC-JKLU and Zoho

                                    Dear Zoho Team, I am writing to raise a concern on behalf of AIC-JKLU, one of Zoho’s incubator partners. Recently, our startups have been facing difficulties while trying to get themselves onboarded on Zoho through our dedicated partner link. Unfortunately,
                                  • Disputed Purchase Invoices

                                    We have recently moved to Zoho Books from Sage. In Sage we were able to post a purchase/vendor invoice but mark it as on dispute. This would usually be a pricing query or if something was damaged. It would show in their ledger, so we could agree their
                                  • Getting events in the future

                                    Hi I am trying to get events in the future by calling this API Endpoint https://www.zohoapis.eu/crm/v8/Events?fields=Event_Title,Created_By,Created_Time,Start_DateTime But that gives me all events in the database. How do I make a query that returns all
                                  • Created Date/Invalid Fields

                                    Since Saturday we have suddenly had issues with our webhooks and data retrieval from CRM. Specifically how Created Date is handled. It appears there was some sort of change within CRM that broke a lot of our code that has been in place for several years.
                                  • Zoho Inventory. Preventing Negative Stock in Sales Orders – Best Practices?

                                    Dear Zoho Inventory Community, We’re a small business using Zoho Inventory with a team of sales managers. Unfortunately, some employees occasionally overlook stock levels during order processing, leading to negative inventory issues. Is there a way to
                                  • Problem for EU users connecting Zoho CRM through Google Ads for Enhanced conversions

                                    Has anyone else experienced this problem when trying to connect Zoho CRM through Google Ads interface to setup enhanced conversions? Did you guys get it fixed somehow? The Problem: The current Google Ads integration is hardcoded to use Zoho's US authentication
                                  • integration zoho form - drive

                                    I integrated my form with Google Drive. The report of user submissions from the Google Form becomes a Google Sheets table. When I used Google Forms for the same task, the summary sheet adapted to the form. For example, if I added a new field to the form,
                                  • add employees and customiz

                                    I want a Zoho software to track employees record. I logged in a demo so now I tried adding employee, first thing when I click on add employee it takes me to a page where it says add user maximum 10 users, my first doubt why users I don't want employees
                                  • Revenue Management: #9 Revenue Recognition in Media & Publishing

                                    Media & Publishing industry has evolved in recent times. It offers subscriptions, bundles digital and print access, runs sponsored content, and sometimes even sells ad spaces. If you run a media or publishing business, you will always get into a situation
                                  • Zoho CRM Community Digest - July 2025 | Part 2:

                                    Hello, Everyone! We’re closing out July with a can’t-miss highlight: Zoholics Europe 2025! Happening from September to October, it’s your chance to level up your CRM skills, covering everything from automation and CPQ to dashboards and advanced workflows.
                                  • How can I trigger a flow action only once while updating contact?

                                    Hi, we have a trigger to merge&mail file when the field YYY is filled out. For this acion I used "Create or update module entry". But unfortunately we get tens of email on a day with this merged file, because the contact is being regularly updated. The
                                  • Copy a Record Template from one Form to another

                                    I have a Creator application with several forms.  I developed a record template for one of the reports/forms but want to use most of it for another of the form/report combinations in the application. Is there a way to copy the template (code or otherwise) to another form?
                                  • Tip of the Week #70 – Create common team signatures for your shared inboxes

                                    Did you know that a small detail, such as an email signature, can make a big difference in how your brand is perceived? One simple yet smart way to enhance your team’s communication is by creating common team signatures for your shared inboxes. Instead
                                  • Enhanced data export features: XLSX format, custom character encoding, and selective record export

                                    Greetings all, Here are a few enhancements related to exporting CRM data, including the ability to export data in XLSX file format now. The Export feature under Data Administration now offers new options that expand its flexibility and enable users to
                                  • Tip #42 – How to manage data security with Privacy Settings – 'Insider Insights'

                                    Data privacy is a cornerstone of trust in remote support. Through Privacy Settings in Zoho Assist, you can set up how data is gathered, stored, and handled in your organization. These settings ensure compliance, data protection for sensitive details,
                                  • Zoho DataPrep and File Pattern configuration

                                    I'm using Zoho data prep to ingest data from One Drive into Zoho Analytics... The pipeline is super simple but I can't any way to get all the files that I need. Basically I need to bring all the files with a certain pattern and for that I'm using a regex
                                  • Introducing Dark Mode / Light Mode : A New Look For Your CRM

                                    Hello Users, We are excited to announce a highly anticipated feature - the launch of Day, Night and Auto Mode implementation in Zoho CRM's NextGen user interface! This feature is designed to provide a visually appealing and comfortable experience for
                                  • Quick Item Search & Auto-suggestion for Invoices

                                    Hi Team, I am facing an issue while creating invoices in Zoho Books. Currently, I have to type the full item name in the correct sequence and spelling for it to appear. For example, my item name is: "Distemper Acri Silk Special White 10kg" If I type something
                                  • Ticketbai! en el Pais Vasco

                                    Hola a todos, En enero de 2.022 se va a implantar en el país vasco un nuevo sistema de facturación, denominado ticketbai!, ¿hay alguna previsión de realizar las adaptaciones en zoho books o zoho invoices? Ignoro la cantidad de clientes que tienen estas
                                  • Zoho CRM mobile app feature update: home page widgets, field tooltips and user image upload

                                    Hello everyone! Your business doesn't pause when you're on the move, and neither should your CRM. That's why in our latest update, we've introduced a few new features to make your mobile CRM experience smoother and more efficient. Let's take a quick look
                                  • Zoho CRM Plain Text Template: Line Breaks and Formatting Issue

                                    Hello, I'm following the instructions to create email templates in Zoho CRM, but I'm having a problem with the plain text version. https://help.zoho.com/portal/en/kb/zoho-sign/integrations/zoho-apps/zoho-crm/articles/zoho-crm-email-templates#Steps_to_create_a_custom_email_template
                                  • Optimizing Task Handling: Auto-Remove Recurrence for cancelled Tasks.

                                    Hello Everyone, A Custom function is a user-written set of code to achieve a specific requirement. Set the required conditions needed as when to trigger using the Workflow rules (be it Tasks / Project) and associate the custom function to it. Requirement:
                                  • Important updates to your connectors

                                    Hello everyone, Greeting from Zoho Creator! We're excited to announce that we'll be rolling out significant backend updates to Zoho Creator's built-in connectors to enhance security by following the latest frameworks. The existing version of some of the
                                  • Create, collaborate, and manage agreements with Zoho Sign

                                    Agreements drive business. We launched Zoho Sign in 2017 as a simple digital signature tool to sign agreements from anywhere, at any time. Over the years, we've learned that most agreements go through last-minute changes before they're signed. Our users
                                  • Function #25: Automatically generate purchase orders from a sales order

                                    We kicked off the "Function Fridays" series with the goal of helping you automate your everyday accounting tasks. As we delve into today's post, I'm delighted to announce that we're here to present the 25th custom function in this series. While it is
                                  • Has Anyone successfully integrated Zoho and Sage Intact?

                                    Hey all, We’re evaluating Zoho One + Sage Intacct and I’m trying to connect with anyone who has actually implemented the two together.Specifically, I’d love to know: -- Which functions you kept in Zoho vs. Intacct (e.g., Product Catalog, AR/AP, invoicing,
                                  • DNS set up

                                    I want to create an email with my company domain. When I tried to add new record with cloudflare it didn't work. The DNS record can't be manually added. I followed the instruction but still can't add it. Could you help?
                                  • 5名限定 課題解決型ワークショップイベント Zoho ワークアウト開催のお知らせ (9/25)

                                    ユーザーの皆さま、こんにちは。Zoho ユーザーコミュニティチームの藤澤です。 9月開催のZoho ワークアウトについてお知らせします。 今回はZoomにて、オンライン開催します。 ▷▷参加登録はこちら:https://us02web.zoom.us/meeting/register/6OSF2Bh6TumsMIlDwaY_PQ ━━━━━━━━━━━━━━━━━━━━━━━━ Zoho ワークアウトとは? Zoho ユーザー同士で交流しながら、サービスに関する疑問や不明点の解消を目的とした「Zoho
                                  • hiding a topic from all but one segment (or list)

                                    My organization sends out a number of newsletters using Zoho Campaigns. One of those newsletters is for volunteers. In order to become a volunteer, a person has to first go through our volunteer orientation (training). After that, they can receive newsletters
                                  • How do I set up this automation correctly?

                                    When contacts enter my Subscribers list, I want it to reference a custom field to see if it is empty. Then I want it to do two things: If empty: Assign a tag based on a different custom field. If that custom field is empty, assign a different tag. If
                                  • Function #62: Display associated Quote on Invoice details screen

                                    Hello everyone! Today, we are sharing a Related List script that makes it easy to view and access the quote from which an invoice was created right from the invoice details screen. This Related List displays the Quote number and Amount, allowing you to
                                  • Custom confirmation message

                                    How can I change the message that users see after they submit the booking form? I have to confirm some details before their appointment is officially "confirmed", so I want to change it where it doesn't say their appointment is "confirmed" but rather
                                  • email forwarding not working

                                    Your email forwarding service does not work. I received the confirmation email and completed the confirmation, after that nothing and nothing since no matter what I have tried. Shame as everything else was smooth. I spose it's harder to run one of these web based internet mail services than you guys thought!!! can you fix the email forwarding asap PLEASE!
                                  • Desk x CRM Integration

                                    Howdy! We currently use SalesIQ but we are considering moving across to Desk as it seems to have more functionality that we want. One of the pulls is the ability for our customers to self serve. But, I might be getting over excited and not actually need
                                  • Function #53: Transaction Level Profitability for Invoices

                                    Hello everyone, and welcome back to our series! We have previously provided custom functions for calculating the profitability of a quote and a sales order. There may be instances where the invoice may differ from its corresponding quote or sales order.
                                  • Next Page