Run a Batch Process to Lookup Your Existing Phone Numbers

Textey now includes functionality to help you eliminate wasted messages, conserve your message balance, and ultimately save money through identifying landline phone numbers and badly formatted phone numbers and preventing you from sending text messages to them.  However, for these features to work the most fundamental step is to perform a lookup on each of your phone numbers.  Performing a lookup means that Textey processes the phone number and stores information about that phone number in your Salesforce org. This information is then used by various Textey components.

When you first install Textey (or upgrade to version 3.12 or higher) you will not have any Phone Number Lookup data in your org.  This means that the Textey components cannot infer any information about your phone numbers.  So, the first step is to run an initial batch process to gather up your phone numbers and process them through the Textey lookup service.  Once this process is complete you will have Phone Number Lookup records in your org that provide carrier information about each phone number.

Let's take a look at how this initial batch process works.

Step 1: Find New Numbers


When you click the Find New Numbers button you will be presented with an option to select the objects you want Textey to include when searching for new phone numbers.  This list includes standard objects such as Accounts, Contacts, Leads, Cases, and Opportunities.  Any custom objects that have been configured for texting will also be available to select.  The objects that you select will be the only objects included when searching for phone numbers.  Another option you can choose is the age of any existing Phone Number Lookup records that you want to exclude.  By default, Textey will place a 6-month expiration date on the record so that you know how long ago you last looked up the phone number.

Once you've made the above choices you will click the Run button.  This will begin the process of finding any new phone numbers in your org that have not been looked up yet.  Keep in mind that this process is not yet sending the phone numbers to the Textey lookup service, we're just trying to identify any numbers that need to be looked up.  You will see a progress bar that shows how the process is progressing. 

There are a few points to consider here:

  • This process will create Phone Number Lookup records in your org.  
  • There will only be one (1) Phone Number Lookup record for each unique phone number that is found.  If you have a particular phone number that exists on more than one record, there will only be one Phone Number Lookup record created for that phone number.
  • This process will normalize the phone numbers into E.164 format which means that if you've entered the same phone number in multiple variations, Textey should be able to account for that and still only create one Phone Number Lookup record.  For example, Textey will treat 555-555-5555, (555) 555-5555, 555.555.5555, 5555555555 to be the same phone number and put it into the format of +15555555555.
  • The Status of these Phone Number Lookup records will be set to "New".
  • Any phone numbers that are found to exist on a record that has opted-out (Do Not SMS = true) will be flagged.  This will prevent them from being looked up in the subsequent step.

Step 2: Purchase Lookups


After you run the first step to find new phone numbers you will need to ensure that you have an adequate amount of phone number lookup credits on your balance.  Each phone number that is successfully looked up will deduct one (1) lookup credit from your balance.  You can easily purchase lookups by clicking the Purchase Lookups button shown above.  If you do not have an adequate amount of lookup credits on your balance you won't be able to proceed to Step 3.

Step 3: Lookup Numbers


The final step in the process is started by clicking the Lookup Numbers button.  At this point, all of the phone numbers that have been calculated as part of the Ready to Lookup set will be processed through the Textey lookup service.  The results will be updated back onto the Phone Number Lookup records that were created in Step 1.  

The length of time that it takes this process to complete will depend on the amount of phone numbers that are being processed.  For large datasets > 100K phone numbers, it could take several hours to complete.  You will see the job progress information in the middle of the page once this job starts.  You can always leave the page and come back to monitor the progress.  You will also receive an email notification once it has completed.


Was this article helpful?
0 out of 0 found this helpful



Article is closed for comments.