POPULATE DATABASE
AMAZING!! - The most powerful moneymaking feature ever developed!
Lookup eligibility status for tens of thousands of units with a single click!



The Most Powerful Cellular Marketing Tools Available

The Populate Database function is available to all licensed users of the Wireless Marketing Wizard. It is also available during the software Demo period for some carriers. This function has the ability to lookup tens of thousands of units automatically.

This function is very powerful and useful. You can use it as soon as your Wizard software is licensed. With a little prep work and a single click; the Populate Database function will fill the Wizard database with eligibility status information for ALL of your existing customers.  The Wizard will then extract eligibility lists from your Wizard database and generate upgrade proposal worksheets! The potential for income is overwhelming!

This Wizard software function can lookup 10's of thousands of units in just hours and generate hundreds of perfect leads for your sales staff every month! Easily multiply your monthly upgrade/activation count. We have customers reporting they have tripled sales or more! There is NO ADDITIONAL CHARGE for this feature and it is already there waiting for your benefit!

You may then use “Data Extract’ functions in the Wizard to extract customers that are eligible for the 150 rebate over any date range you wish. These lists can be extracted each month or as often as you wish.

 
This system will extract rebate dates for all units on all accounts in your point of sale or other data storage systems. You can also create a spreadsheet with 2 columns, PTN and Account Number (PTN and Zip Code for E-Wave lookups) .

Populate Database Features

* All you need is a list of PTN's and Account Numbers (PTN (MIN / MDN) and Zip Codes for E-Wave lookups).
* Run as often as required for multiple data sources. -

*  The populate database function will look-up every unit on every account in your list.

* Try to combine lists at the procedure is smart and skips duplicate active units on the same account automatically.
* If a lookup fails on a specific PTN, and another PTN from the account is in the list, the Wizard will try the account lookup again.

* If an account lookup is successful and another PTN on the same account is in the list, it will be skipped as a single procedure looks up all account units. This saves time as repeated lookups on the same account are not performed unless the first PTN is no longer valid.

* The Wizard creates a log file that stores results from each account lookup. To view this file, see the “….CellRam_share//reports/marketing/Mass_results_file.txt file. (substitiute your actual Data Storage Folder for "c\cellram_share\" if required)

 

Data Preparation The Wizard requires is a text file with PTN’s and Account numbers in list form. This called an ASCII file or a text file. It is also call a “tab delimited” text file. This can easily be created from an Excel file. Many POS/database systems can export this data in this required format.

For data in Excel:

If your data is in excel, you can save an Excel file as a text file.

First:

Create the spreadsheet with 2 columns and no headings. Place PTN’s in the first column and account number in the second.

  Click “File – Save As”
  In the files type area, select ‘txt’  - “tab delimited text”

Pay attention to where the file is being saved on your drive so you can locate it for the Wizard.

Run the
Populate Database
Function
Click the “Data Extract Menu’ button
  Click the red “Populate Database’ button

Select Carrier

This dialog may not appear if you have the Wizard set up to function for a single carrier only. .

Enter Access Password

This password is supplied freely. It is there to prevent use by unauthorized personnel.
  Click the “Local File’ button
Open Data File. Navigate to the folder where you saved the text file explained above and open it.
The Wizard will TAKE OFF! Have lunch or leave work and have dinner. The next day, there will be LOADS of sales leads.

Use the Data Extract Menu to Extract Leads Lists

Use The Active Sheet List to market to customers. 


Please contact support@cellram.com or 508-888-3764 for more information and instructions.

 

Inc.
Custom Business Software since 1992

Support: 508-888-3764
Sales: 888-429-4626

Sales Email:   Sales@CellRam.com
Support Email:  Support@CellRam.com
Ideas Email:  Develop@CellRam.com