Kristi Smith Consulting | Business Solutions That Make Sense
  • Home

4 Ways to tidy-up your data entry standards - Repost for spring cleaning

4/23/2012

 
Picture

Since we are encouraging spring database cleaning this month, we thought this blog we posted earlier this year on 4 easy steps to clean out your database would be a helpful reminder.

One really great way to get the most out of ACT!, is to standardize your company’s usage.  Do you have data entry standards?  Here’s a great way to set some:


1) Toss the empties
Empty fields just tempt users to stow away data that doesn’t seem to have a home.  Then the data, sitting in a mislabeled field, is report resistant—it isn’t organized so it won’t come up in a field search, and can’t be pulled into a report for analysis.

2) House the homeless
Look around your database.  Just sift through some entries.  Do you see a pattern in the data that is being tossed into “catch-all” fields?  Create new fields to accommodate data you want to collect regularly, and move  the data into the properly labeled fields where they belong.

3) Consult the staff
You may think you know what needs to go and what should stay, but maybe your staff thinks differently.  Have a quick meeting about your current ACT! usage, what people are using, what they aren’t, and what they wish they could do differently.  You should decide who is responsible for filling out which fields, and set up a standard by which people assign tasks to each other to facilitate smooth workflow.

4) Idiot-proof it
Where possible, consider setting up activity series to encourage the steps in a workflow plan.  Every time someone adds a new prospect, does that mean your salesperson should make a call?  Or if every time a support contract has an expiration date, should a renewal request call be made 8 months later?  Set it up so ACT! asks you to schedule these things.

There are a number of ways to get your data to work for you--do you have any suggestions for keeping a clean database?  Tell us about it in the comments!

ID/status spring cleaning

4/12/2012

 
Spring! A time when we open up the doors and let fresh air into our homes, welcome the nice change in weather, and say good riddance to cold weather and our winter clothes.

And your database isn’t too different. It can do with a little airing out, too.

We have given a lot of advice on how to clean up your database, but today I want to focus specifically on cleaning up contacts by ID/status.

The ID/status field is often used to track a database user’s relationship to a contact, basically by labeling the relationship. This way, you can keep your vendors straight from your clients, and your prospects separate from your networking contacts, while keeping them all in the same, convenient place. This way you can then pull up contacts by ID/status and review the relationships you have, and review which contacts you should reach out to again, which need a new ID/status, and which you may not need anymore.

We recommend you consider doing this now in preparation for summer. Some businesses slow down this time of year, or people cut their hours to spend more time outdoors. If you fall into this category, cleaning your database and renewing some of your connections in your downtime, may be a valuable way to spend your summer.

For instance, run a search in your database for everyone labeled a prospect. This is something that should be done with frequency if possible, but if you don’t, now is a great time to pull up prospects in your database and think about which ones may benefit from a little more attention—perhaps they fell off your radar, or told you they would be in touch—now is the time to give them another call. And those who have told you they are not currently interested in your services should be marked as dead prospects, this way you know that they have told you no, so you do not risk becoming a nuisance they would not consider should they need services in the future.

After prospects are examined, networking contacts is another group who you may want to review. With whom have you lost touch who provides you with valuable leads and business advice? Schedule time to renew your networking relationships this summer.

Also think of reviewing your clients and vendors. If you haven’t worked with someone in a long time, are they still a client? Perhaps you may want to put some time and energy into reinvigorating some of those relationships. On the other side of the coin, if you know that a client is now firmly an ex-client, you would do best to mark them as such under ID/status, so you do not mistake them for active clients when you send out freebies, newsletters, and the like. And your vendors? You want to make sure that the ones you are actually using are marked correctly—that way you don’t mistakenly call the person you used 5 years ago rather than your current choice!

Have you reviewed your database by ID/statuses recently? What did you learn in the process? If you could use some help organizing your database, please give us a call, at 847-520-0560.
    Loading

    Picture
    Subscribe To Our Newsletter


    Archives

    September 2016
    August 2016
    July 2016
    June 2016
    May 2016
    April 2016
    March 2016
    February 2016
    January 2016
    December 2015
    November 2015
    October 2015
    September 2015
    August 2015
    July 2015
    June 2015
    May 2015
    April 2015
    November 2012
    October 2012
    September 2012
    July 2012
    June 2012
    May 2012
    April 2012
    March 2012
    February 2012
    January 2012
    November 2011
    October 2011
    September 2011
    August 2011
    July 2011
    June 2011
    May 2011
    April 2011
    March 2011
    February 2011
    January 2011
    December 2010
    November 2010
    August 2010
    April 2010
    February 2010
    January 2010
    December 2009


    Categories

    All
    8x8
    ACT! 2011
    ACT! 2013
    ACT! Activities
    ACT! Add On
    ACT! And Outlook Integration
    ACT! Backups
    Act! Connect
    Act! Customization
    Act! Database Maintenance
    ACT! Dynamic Groups
    Act! Emarketing
    Act! Features
    ACT! For Events
    ACT! For Mobile Devices
    Act! For Web
    Act! Personal Info Tab
    Act! Personalization
    Act! Premium
    Act! Premium Cloud
    Act! Promotions
    ACT! Reports
    ACT! Searches
    ACT! Social Media
    Act! Technical Support
    ACT! Tip
    Act! Update
    Act! V16
    Act! V17
    Act! V18
    Automated Marketing
    Automation
    Browser Issues
    Business Ethics
    Business Hours
    Business Humor
    Business Intelligence
    Business Tools
    Call Lists
    Chrome
    Cloud Communications
    Cloud Hosting
    Contact Layout
    Contacts
    Content Marketing
    CRM Integration
    Customer Appreciation
    Customer Relationships
    Customer Retention
    Database Conversion
    Digital Marketing
    DIY
    Drip Marketing
    Duplicate Entries
    Efficiency
    Email
    Email Marketing
    Events
    Export
    Exporting To Excel
    FAQ
    Favorite Contacts
    Favorite Lookup
    Fill The Pipeline
    Filtering
    History List
    Holidays
    How To
    Import
    Integration
    Intuit
    Labor Day
    Leads In ACT!
    LinkedIn
    Microsoft Office
    Mobility
    Newsletter
    Opportunities
    Organization
    Outlook Integration
    Payment Processing
    PayPal
    Payroll
    Productivity
    Prospects
    Queries
    QuickBooks Online
    QuickBooks Payments
    QuickBooks Payroll
    Relationship Building
    Sales Pipeline
    Sales Review
    Slack
    Social Media
    Social Media Marketing
    Spring
    Strategic Planning
    Subscription
    Summer Projects
    Swiftpage
    Sync ACT! To Mobile
    Task List
    Technical Issue
    Technical Support
    Trade Shows
    Training
    Upgrade
    Upgrade ACT!
    Voice Over Ip
    VOIP
    Web API
    Web Browsers
    Webinar
    Web Info Tab
    Windows 10
    WuFoo

Kristi Smith Consulting     |    (847) 520-0860    |    info@kristismith.com


This Web site is owned by Kristi Smith Consulting, LLC. Kristi Smith Consulting, LLC is independent from Swiftpage and is not authorized to make any statement, representation or warranties or grant any license or permission on behalf of Swiftpage regarding any product, service or Web site content. Certain materials made available on or through this Web site are owned by Swiftpage and cannot be used without the prior written permission of Swiftpage; such materials have been released to KSC as a Swiftpage Authorized Business Partner and are used with permission from Swiftpage ACT! LLC. | www.swiftpage.com | All images displayed are the property of Kristi Smith Consulting and may not be copied or used without prior written authorization from a Kristi Smith Consulting administrator.