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

                                  • Issue with Save & Share Link – Works for Others but Not Creator

                                    I’ve enabled the "Save and Share" feature in Zoho Forms, and it works correctly for all users accessing the public link—except for me (the form creator). Issue Details: When I save and share the link, recipients see a “no permission” error. The form is
                                  • Save the pdf report from a registration form in a Folder

                                    Through Zoho Forms I created a registration form with quite a lot of rules to handle different variables (TEAM types, payment in installments, etc.), and the result is pretty good. The automatic PDF that is sent to the respondent upon submission is already
                                  • zoho forms integration to zoho work drive

                                    Scenario: A user fills out a Zoho Form, entering details such as email, mobile number, and other required information, and uploads supporting documents like PAN, Aadhaar, etc. Upon submission, the data is available in Zoho Forms Reports. Requirement:
                                  • Zoho Forms to Zoho CRM Integration failed - can I restart it?

                                    The integration of Zoho Form to Zoho CRM has failed. Is there a way for me to restart it for the impacted entry?
                                  • insert an equation, but in document, it shows an image not available.

                                    I'm new to Zoho writer and used Zoho writer in desktop app version . When I inserted an equation, I got an image not available sign. Any help is appreciated. Thanks, Charles
                                  • Zoho Desk Android app update - Swipe action customization

                                    Hello everyone! We have brought in support for the swipe action customization in latest version(v2.9.13) of the Zoho Desk Android app update, enabling you to configure left and right swipe gestures on tickets to carry out the actions swiftly without opening
                                  • Import KB template OR Export template for zoho desk?

                                    Greetings. Can you tell me if there is a way to get an EXPORT of my KB articles? OR is there a template you supply for importing KB articles into my zoho desk? I am looking for a method of understanding what fields can be imported, and what their possible
                                  • XML format to import knowledgebase into Zoho Desk

                                    Hi, We just started to use Zoho Desk and want to import our knowledgebase from our old support system (Freshdesk) to Zoho Desk. Can anyone give us information about the format of xml file to import? There is no explanation on the related page.
                                  • Zoho Desk integration with Power BI

                                    Hi, I want to be able to create a Power BI report which has live updates of ticket data from zoho desk, is this possile at all? Thanks Jack
                                  • Arranging Ticket Templates

                                    Is there any way to arrange our ticket templates? It doesn't look very organised when it's just arranged according to when they were created. We want the list to look more organised, by arranging/grouping them by topics, or even just by alphabetical
                                  • What they mean with "Portal"?

                                    I just downloaded this app to take my personal notes on digital art studio because it seemed to me the most comfortable app to do it, I use it very often, what do they mean by “no activity on your portal”? I have about 1 year of work here and I don't
                                  • Inactive User Auto Response

                                    We use Zoho One, and we have a couple employees that are no longer with us, but people are still attempting to email them. I'd like an autoresponder to let them no the person is no longer here, and how they can reach us going forward. I saw a similar
                                  • favorites no longer listed

                                    Hello, I can no longer navigate to my Favorites from the pulldown at the top of my grid view (see attached screenshot). I wasn't able to find it anywhere! Please help me display my Favorites. Thank you!
                                  • Notecards Disappeared

                                    Got a new phone. Downloaded and signed in Zoho Notebook. Not finding the Note cards. Just Empty Note books. Frustrating.
                                  • Table Errors

                                    Hello, I'm new to Zoho Notebook and using it on several Mac/Apple devices. My question is regarding tables: Why do they become broken, and how to fix the error without retyping all my data? (Please see the screenshot attached.)
                                  • Online Calculator with Zoho Forms?

                                    I'd like to build a custom calculator on my website. Zoho Forms seems to offer all the fields for basic calculations performed live without pressing any "Calculate" buttons. Unfortunately, there is still that "Submit" button at the bottom. There is nothing
                                  • Zoho Tables instead of Zoho Creator Spreadsheet reports <3

                                    That would make my day for sure. Zoho Creator is create, but miss data entering as AirTable/Spreadsheet can. Seeing Zoho putting effort in this makes me think maybe one day we could see a similar interface for Zoho Creator spreadsheet reports. B.
                                  • Zoho Sheet - Desktop App or Offline

                                    Since Zoho Docs is now available as a desktop app and offline, when is a realistic ETA for Sheet to have the same functionality?I am surprised this was not laucned at the same time as Docs.
                                  • Notebook Stack

                                    Hi Everyone I Hope you´re fine, I´m sorry if this idea was posted before (I made a search but I haven´t find anything related). So, Having the possibility of stacking notebooks would be an interesting way to order notebooks that correspond to the same
                                  • Writing on sketch cards is bugged when zoomed in

                                    When zoomed in, it writes a noticeable distance above or to the side of where you're actually trying to write. The further you're zoomed in, the more noticeable it is. Zooming is also entirely absent on the desktop version.
                                  • Swipe between notes on iPhone

                                    It'd be convenient if I could move from one note to the next in a notebook simply by swiping left to right.
                                  • Sales IQ chat is not working in signed android apk

                                    I have integrated ZOHO sales IQ support chat and i have followed each step and its working fine in my development build but when i create signed APK for it. Chat does not work in it and showing awaiting for detail. I previously asked the same query but
                                  • COQL order by COUNT not working

                                    Dear community, I am trying to get a list of deal amounts per planner working on it and sorted to get see who has the least amount of deals. For some reason, I am unable to use sort by in combination with a COUNT. My original code was: query = "select
                                  • I want to duplicate a report and name it something else

                                    Hi, I have created a report, and now want to reproduce it and call it something else. so that I will end up with TWO separate reports with different titles. Please tell me how do I copy / reproduce a report please
                                  • Zoho CRM: Sales Rep Professional Certification Program on Coursera

                                    We are happy to share that we have published the Zoho Sales Representative Professional Certificate in partnership with Coursera, a leading platform for online learning and career development that offers access to courses and degrees from leading universities
                                  • OS X Notebook quits immediately upon launch

                                    NoteBook for OS X (Sequoia, but also under Sonoma) always quits immediately upon launch (so I cannot use the "Attach user log" option). I've restarted my MacBook but the problem persists. If it helps, attached is a diagnostic report from Library>Log
                                  • Can External users upload files or images to WorkDrive?

                                    I want to know if it is possible for someone externally through a link and PW be able to upload files and images onto WorkDrive?
                                  • Multi-line fields character limits

                                    Is there a way to set the character limit higher on multi-line fields so that we are not losing information pasted into the field? When the text is entered or pasted, there is no error to say that the text is too large. After saving and going back to view most of the text is gone.   Also, when viewing the resume, the text is not wrapped in the multi line fields and can t be read without scrolling across the page.
                                  • Taz bot not working — What should I do to resolve this issue?

                                    I am experiencing issues with the Taz bot in Zoho Cliq—not receiving responses or it does not seem to work as expected. Could you please explain why the Taz bot might not be functioning and what steps I should take to resolve this issue? Thank you!
                                  • OneNote Migration

                                    I am trying to migrate two notebooks from OneNote. For five days now I have had no notification that migration has completed and the migration page show 50% complete - one notebook completed one not finished. It just stays like this. I am unable to cancel
                                  • Set various time slot reminders for task and event

                                    Hi I would like known if there is possibility to set various time reminders for a task or event like we have the possibility to do in google calendar or google task. For example I'am creating an event or task and I want to be alerted before 30min and
                                  • Zoho Calendar not functioning---cannot edit, add attendees, etc.

                                    Hello, My calendar is acting strange. I'm using Chrome as my browser and pop ups are not blocked (the calendar worked fine yesterday). When creating an event, I'm not able to "edit" the event and add attendees, etc. The link is non-responsive. I cannot
                                  • Unable to send message; Reason:554 5.1.8 Email Outgoing Blocked

                                    Hi, I sent few emails and got this: Unable to send message; Reason:554 5.1.8 Email Outgoing Blocked And now I have few days since I cant send any email. Is there something wrong I did? Also can someone fix this please
                                  • Spilt Axis for stacked column and line graph

                                    Each month around this time I prepare a business review deck. One of the biggest annoyances I have with Zoho, also happens to be something that most other platforms have provided for a long time now, and that is being able to create a chart with stacked
                                  • Pin a note on top

                                    Dear Zoho Notebook Team, Please highly consider adding ability to pin a note on top and arrange pinned notes. I have a lot of notes that I want to pin important ones on top and this feature is missing badly. Thank you.
                                  • Windows 11 app ver 2.2.8

                                    I have been trialing Zoho Notes syncing between my PC and iphone. No problems with iphone but the Windows 64 bit app ver 2.2.8 was very buggy and would lock up completely, needing a Control Alt Delete etc to close it down. It seemed to be connected to
                                  • Deluge Script: Onboarding → Access Form

                                    Hello everyone, Edit: Sorry, I think I put this topic in the wrong section. I’ve recently run into an issue that’s been giving me a bit of a headache for the past few weeks. Context: This is my first time using Deluge to create a script, but it’s not
                                  • Windows Device Authentication

                                    We have recently started using ManageEngine, and my boss saw a device management feature in the Zoho One directory. We thought it would either help give us more intergration into Zoho one through bringing ManageEngine services through Zoho one. Or, it
                                  • How can I change spell check language?

                                    I cannot find the way to change spell check language. My "display language" is English, and I want to have the same one for Spell Check, but it is Russian!!! How can I change it? In one of your explanations you mentioned that I have to choose it from
                                  • Mail is so slow - doesn't even work!

                                    Mail has been getting slower and slower - and today it's not even pulling up emails in either Inbox or Unread. This is beyond frustrating since email is a big part of business. Sent a request through the useless help portal - no response. Called the useless
                                  • Next Page