Posts Tagged ‘marketing campaigns’

Microsoft Excel “custom functions” can be used to carry out many tasks related to address and zip code information, such as importing demographic data, checking address accuracy, even calculating driving time and distance. Custom functions, also referred to as User Defined Functions (UDFs), perform complex calculations or tasks and are used in cell formulas just like standard Excel functions such as SUM or AVERAGE. In this article we will discuss how custom functions can also be used for identifying zip codes within a specified distance or “radius”.

Zip codes can be extremely useful for analyzing demographic information, and can help you better target customers and plan marketing campaigns. For example, identifying zip codes within a specified radius of potential new store locations can help you select a location most accessible to your customer base. But instead of drawing circles on a map, a much easier approach is to use a custom function within Excel that will identify the zip codes for you.

How would a custom function like this work? Let’s say you are evaluating a possible store location in zip code 07470 and need a list of all zip codes within a 10 mile radius. To use a custom function named RADIUS, simply input a formula in a worksheet cell like this: “= RADIUS (Zip Code, Radius Distance)”. For this case the formula is “= RADIUS (“07470″, 10)”, and the worksheet will display all zip codes within 10 miles of 07470.

The formula can be tailored to output the data as a string of zip codes listed in a single cell, or as an array with individual results in multiple cells in the spreadsheet. To return a formula as an array in Excel, simply highlight the destination range with your mouse, then hold down the Ctrl and Shift keys and press Enter. The returned data can also include the distance as well as the zip code and sort these by closeness to the target zip code. Additional options can be added to have the distance returned in kilometers or miles.

The custom function automates the process of finding all zip codes that fall within the given radius by searching a local zip code database and performing distance calculations based on latitude and longitude. All of these actions occur in the background, so the user works entirely within Excel and sees only the resulting list of zip codes displayed in their worksheet – there is no need to learn a new application or import a zip code list from a web page.

A big advantage of custom functions is their ability to process large amounts of data in a spreadsheet format. To perform zip code radius calculations for a list of zip codes in column A, for example, simply input the appropriate custom function formula in cell B1, such as: “= RADIUS (A1, 10)” where “A1″ is the worksheet cell location of the first zip code. Then just copy and paste this formula as needed in column B; in this way you can perform radius calculations for literally thousands of zip codes, without the time-consuming manual input required for other programs.

There are other useful Excel custom functions that complement zip code radius calculations by calculating the distance between two given zip codes. The custom function formula in this case would be something like “= DISTANCE (Zip Code 1, Zip Code 2)”. The calculated distance can be “as the crow flies” or can be estimates of actual driving distance or time.

A zip code radius function is one more good example of how Excel custom functions can be used to automate complicated tasks with no need to learn a new application or even leave the familiar environment of Excel. From checking the accuracy of mailing lists to identifying zip codes within a specified radius, custom functions can be valuable tools for analyzing zip code and address information in Excel.

Author: Betty Hughes
Article Source: EzineArticles.com
Provided by: Pressure cooker

Today, small and mid-size business owners are using open source CRM software to help streamline their business processes with the expectation of generating more sales opportunities. Open source CRM solutions should be able to manage existing customers, facilitate prospecting, generate online sales leads, launch and track marketing campaigns, analyze customer needs and preferences, integrate with existing applications and provide secure access to company data from any computer with an Internet connection and a browser.

Here are a few keys to selecting the right CRM solution:

• Ensure the CRM software you choose has the ability to capture all relevant customer and sales related information. At a minimum, your CRM solution must be able to easily record all interactions with your customers. One of the major benefits of CRM software is in its ability to help collect, store and share data to all appropriate areas in your business — in real-time.

• Before you deploy a CRM tool you must first understand your existing sales and marketing workflow. Your CRM tool must be able to integrate with your existing processes or your sales and marketing team will not use it.

• It is imperative to understand the level of customization you will require. Do you have the required technical skills on staff to implement modifications? Does the CRM tool provide an API (application programming Interface) for extending the platform? Will custom changes prevent future upgrade options? Answering these questions in advance will save you time and money later.

• Determine if the CRM tool can integrate with applications used by your staff. For example, you must know whether the CRM tool can share or exchange data with your email client (e.g. Outlook or Thunderbird). You must also know if the CRM tool provides an easy to use import or export function for data mining and other sales analysis functions.

• Determine the level of support you will require. Most open source providers make their money on service and support rather than software sales. Therefore, you should investigate the various levels of support provided by the open source vendor.

• Research the level and quality of third party extensions. Quite often companies are able to find free or low cost extensions and avoid the expense of internal development. Third party extensions can add needed functionality and save your business time and money. For example, third party payment modules have become a necessary component for accepting electronic payment at the point of sale.

While there are many open source CRM products to choose from here are my top six:

1. SugarCRM
2. vtiger CRM
3. SplendidCRM
4. CentricCRM
5. XRMS CRM
6. ZOHO CRM

Be sure to test drive multiple open source CRM tools before deciding which open source CRM application to deploy.

Author: Ricky Bracken
Article Source: EzineArticles.com
Provided by: Import duty tariff