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

                                  • Debugging `try` blocks : Tip

                                    I find it annoying that if one line inside a `try` block has an error, the Deluge arser points the beginning of the block to the location of the error. BUT, if you temporarily comment out the initial `try {`  The parser goes through the whole block and
                                  • [Product Update] TimeSheets module is now renamed as Time Logs in Zoho Projects.

                                    Dear Zoho Analytics customers, As part of the ongoing enhancements in Zoho Projects, the Timesheets module has been renamed to Time Logs. However, the module name will continue to be displayed as Timesheets in Zoho Analytics until the relevant APIs are
                                  • Use approval workflow comments in record scripts

                                    Greetings, i'm running an approval workflow for my records, during approval/rejection there is a step where comments are entered. i want to add there comments to the record and to use them in various deluge scripts like sending emails and so on.  how
                                  • ZOHO Store

                                    Not able to make a payment We are using Zoho One, and we are from India. The payment currency, which shows for us, is in USD. But the system says we can choose Country/Region India if it shows INR only. Attaching screenshots for more info.
                                  • Support Migration into Aliases in Zoho Mail

                                    Hello Zoho Mail Team, How are you? We are in the process of migrating some of our users from Google Workspace (Gmail and Google Drive) to Zoho. During this process, we noticed that Zoho Mail currently only supports migration into a primary mailbox and
                                  • API for Z Workdrive Flow Make-Integromat ?

                                    We are zoho workdrive fans Also we would like to have an api to work with Zoho Flow or with Make better known by its old name INTEGROMAT Is it planned and when? 3 months -6 months or more?
                                  • Apps Pane no longer visible

                                    I have read all the info and help and nothing works, I do not have a "show apps" anywhere and I can no longer see my Apps pane in the left hand side of mail, please advise how to get this back
                                  • Canvas View - Print

                                    What is the best way to accomplish a print to PDF of the canvas view?
                                  • 5名限定 課題解決型ワークショップイベント Zoho ワークアウト開催のお知らせ(8/21)

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

                                    Hello form builders, We are excited to announce the launch of Inline OTP Verification in Zoho Forms, a smarter way to ensure the authenticity of the contact details you collect. Until now, OTP Verification in Zoho Forms worked as a pre-access step: respondents
                                  • Zoho Mail : Associate emails with Meeting records and allow multiple emails to be assocaited at once

                                    Is there a workaround that would allow either of these? I want to associate emails with Meeting records. I also would like to be able to select multiple emails at once for association with a record.
                                  • Create task from email

                                    Is there a way on mobile to create a task from an email? I use this feature a lot and when traveling now I read email on mobile. By the time I get to my office I forget about them since I didn't add it to a task. Is this feature missing on moble?
                                  • Zoho Socials - Unable to view Channels and SmartQ

                                    Hi, The channel Facebook has been added by the admin, however, it is not visible on the User level (employee). Other channels are visible. Also, we have the premium account, and SmartQ is not working. Can anyone help? Regards, Priyanka
                                  • Eliminating Manual Consolidation: Automating Currency Field Sync from Task to Project

                                    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:
                                  • We want to set the "Converted from Lead" value in Deals using a Workflow or via a Deluge script. How?

                                    For use in Zoho Analytics, we need the field "Converted from Lead" filled in our deal records. This field is empty everywhere, because we do not create deals directly when converting a lead to a contact. We want to do that using the API or a workflow
                                  • Sales Orders: Quoted_Items + items in another subform -> into Ordered_Items ?

                                    hello, When creating Sales Orders, is it posible to inherit/fill the Ordered_Items with all the items from Quoted_Items + all the items from a customized subform with similar fields? Since you can create a sales order in different ways (convert, new -
                                  • How to cancel the GSTR1 pushed to GSTN

                                    How to cancel the GSTR1 Pushed to GSTN, some rectifications to be done in HSN & SAC code
                                  • Zoho Books API — Invalid Operation Type / Scope does not exist

                                    Hello Team, We are unable to use the Zoho Books API from our registered application. We’ve already: Created a client in Zoho API Console using (Admin in Books) Generated the OAuth code and token successfully Used the correct scopes: ZohoBooks.fullaccess,ZohoOauth.userinfo.READ
                                  • Enhancements in Canvas

                                    Dear All, Greetings! Canvas lets you design the record details page to suit your brand or business preferences. We are glad to introduce the following enhancements to uplift your design experience. Reusable Components Style Presets Let's go! Reusable
                                  • Minimum order quantity

                                    Is there a way to enforce a minimum order quantity - ie has to have a minimum of 250?
                                  • 【Zoho CRM】ポータル機能のアップデート:UIとポータルの作成フローの変更

                                    ユーザーの皆さま、こんにちは。コミュニティチームの藤澤です。 今回は「Zoho CRM アップデート情報」の中から、ポータル機能のアップデートをご紹介します。 目次 概要 ユーザーグループの作成フローの変更 ユーザーグループ詳細画面内のタブについて 「タブと権限」タブについて 「設定」タブについて 概要 UIとポータルの作成フローが変更されました。ポータルの新機能に先立ち、UIを一部変更しました。タブやオプションの配置を見直し、機能へよりアクセスしやすくなっています。 また、「ポータルユーザーの種類」は今後、「ユーザーグループ」と呼称され、ページ上のボタンも「ユーザーグループを作成する」に変更されます。
                                  • Tax on Imported goods charged by Shipping Company

                                    Hi Folks, I imported goods from outside Canada, for better understanding I will give an example data. imported goods value: 2000$ The shipping company sent me an invoice containing the following information: Custom duty on imported goods: 400$ Administration
                                  • Prefilled Date fields auto-changed and then locked when using “Edit as new”

                                    If a document out for signature has date fields (not SignedDate fields) that were pre-filled before sending, and then you use “Edit as new” to create a new version of the same document, the value of those date fields gets automatically changed to today
                                  • Zoho Webinar via Social Media

                                    Hello, is it possible to stream a Zoho Webinar via Social Media like Linkedin or Facebook?
                                  • Add Hebrew & RTL Support to Feedback Widget

                                    Hello Zoho Desk Team, How are you? We are using Zoho Desk and would like to utilize the Feedback Widget. While Zoho Desk itself supports Hebrew and RTL, the Feedback Widget unfortunately does not. We kindly request that Hebrew and full RTL support be
                                  • OAUTH2 isn't working with Power Automate and N8N (Zoho Desk)

                                    Hello, I am trying to set up an OAuth2 connection to the Zoho Desk API, but the authentication flow fails immediately. I am experiencing this issue in two separate platforms: Microsoft Power Automate (using a Custom Connector) and n8n. Instead of being
                                  • Kit Items Breaking Automations - "Provide mapped components for all kit items"

                                    This has been brought up in other threads, but I believe this issue warrants its own topic. Whenever a sales document (Estimate, Sales Order, Invoice) is created or manipulated programmatically, trying to include a Kit as an Item throws this error: "Provide
                                  • Show item Cost value on Item screen

                                    The Item screen shows Accounting Stock and Physical Stock. It would be very helpful if value information could be displayed here as well, for instance Cost Price. Currently, to find the Cost Price (as used for inventory valuations) from inside the item
                                  • Mark shipment as delivered via api

                                    Hellloooo again Zoho guys !! More help required if you would be so kind, pleeeezz..... var options =        {         'method' : 'post',         'contentType' : 'application/json',         'muteHttpExceptions' : true       }; var myPackNo  = encodeURIComponent('###################');
                                  • Setting Alternative units for an item.

                                    Hello Team, How to create alternate units for an item. We are placing orders for stocks in boxes. One box contain 24 items. At the time of selling we have two categories of buyers wholesalers and retailers. So the sales will be in PCS and in boxes also.
                                  • Zoho Inventory search when adding items to SO/PO, etc.

                                    I do not see that Zoho Inventory searches within the item name for an item lookup. We have many products with variants. So when I search for a product, say a lighting system, and it comes in different sizes and colors, I can only get those products where
                                  • Item Group Attributes

                                    Hello, I would like to see more attributes under grouped items. We sell car parts, there are several suppliers for the same part but under different brands. We want to group them together but the attributes under groups are lacking. For example, the products
                                  • Remove HTML Format - Deluge

                                    Hello @all if you want to delete the HTML format from the text please follow the script. Data = "Text"; info Data..replaceAll("<(.|\n)*?>" , "").replaceAll("&nbsp;" , " "); Apart from this if you require anything please let me know Thanks & Regards Piyush
                                  • Using multiple languages in template

                                    I wanted to add the company name in the template in arabic. I found a way through the header and footer option, except when i print the quotation the arabic disappears both in the top and bottom of the page. I have attached pictures of the before and
                                  • ADDING 5% VAT TO PURCHASE ORDERS GENERATED ON ZOHO BOOKS UAE

                                    Please guide on how to add 5% VAT to Purchase Orders generated on ZOHO Books UAE edition.
                                  • Import from /csv file, some items fail with the error "Specify Tax Or Tax Exemption".

                                    Hello! I am trying to import a csv file of all of my expenses for a complete financial year. I get errors for some items with the error message "Specifiy Tax or Tax Exemption". These errors only occur on lines where I have "Postage" as the expense account.
                                  • About maximum number of requests per minute

                                    Hi, Our company has integrated Zoho inventory and we're using the shipping order creation and update functions and so on. Currently we're receiving "For security reasons you have been blocked for some time as you have exceeded the maximum number of requests
                                  • Approval - Report/Views

                                    Hi, On Zoho Desk - Is there a way to report on pending approvals, or a view or similar?
                                  • "Zoho CRM Integration" option is missing in Zoho Social Settings

                                    I am trying to integrate my Zoho Social account with my Zoho CRM account. I am on the Professional Trial plan and my user role is "Brand Admin". However, I cannot find the "Zoho CRM Integration" or "Lead Generation" option anywhere in my Zoho Social settings.
                                  • Zoho CRM still doesn't let you manage timezones (yearly reminder)

                                    This is something I have asked repeatedly. I'll ask once again. Suppose that you work in France. Next month you have a trip to Guatemala. You call a contact there, close a meeting, record that meeting in CRM. On the phone, your contact said: "meet me
                                  • Next Page