Combine columns when importing

there seems no way to import phone numbers from a .csv file where the area code is separated.

That is correct. However, it should be pretty easy to merge the two columns in Microsoft excel. Here are the instructions:

Use Excel Formula

1. Insert a new column to hold the full phone number. Here we refer to this new column as Phone column

2. In the first row, enter the formula =CONCATENATE(B2, C2)

Here we assume the area code is in column B, and the local number is in column C. The above formula simply combines the area code with the local number.

3. Select the new cell, and drag it down to copy the formula for the rest of column.

Use Flash Fill

The following is copied from Microsoft support site regarding Flash Fill:

Enter the full name in cell C2, and press ENTER.

Start typing the next full name in cell C3. Excel will sense the pattern you provide, and show you a preview of the rest of the column filled in with your combined text.

To accept the preview, press ENTER.

Concatenate data with Flash Fill

If Flash Fill doesn’t generate the preview, it might not be turned on. You can go to Data > Flash Fill to run it manually. To turn Flash Fill on, go to Tools > Options > Advanced > Editing Options > check the Automatically Flash Fill box.

Posted in Call Center Software, Tips & Tricks |

Election fundraising

It seems more and more organizations are employing active phone campaigns to raise fund for political campaigns. Maybe it is the current political environment that makes elections more competitive and contested. But in any case, organizations need good communications tools in order to be effective and efficient.

When customers come to Voicent, they usually share the following basic requirements:

1. Need automated dialing solutions that keep their volunteers efficient, and
2. Need data management capabilities to manage call list, voter database, etc.

Other requirements include tools for conducting opinion survey, voter alert and notifications, and an all-in-one solution that they can sign up and leave any time.

Voicent cloud solution is the perfect solution for these requirements and more. For example, text message capability that is fully integrated with the database and dialer tools.

Posted in Predictive Dialer, Use Case Scenario |

Cloud call center solutions continue growth trend

While most contact center solution is still on-premise base, last year we see major growth in the cloud contact center solutions. As of end of 2016, DMG estimated cloud contact solutions was at least $2.8 billions in revenue, which only counts about 11.4 % of total contact center seats. Given the benefits of a cloud solution – free ITs from support and maintain hardware and software with which they have little expertise, the growth potential is huge.

There are still challenges in the cloud solution, mainly security and regulatory compliance.

Posted in Predictive Dialer |