Servpro WorkCenter Marketing Services

WorkCenter Marketing Route Cleanup Services 

Our Workcenter Services

If your franchise is like most across the country, your Marketing Reps are wasting countless hours each morning just re-arranging their route stops.

This wastes valuable time removing stops that are too far apart that results in extra windshield drive time and in-efficiency of their daily tasks.

OMO MARKETING HAS DEVELOPED A PROCESS TO “CLEAN UP” AND OPTIMIZE THE DAILY ROUTE MESS FACING YOUR MARKETING REPS. 

WORKCENTER OPTIMIZATION

OWNERS UNDERSTAND THE VALUE OF TIME.

The WorkCenter Marketing Route Planning application over time becomes less and less effective. How?  Turnover among Marketing Reps over time is the apparent cause.

OMO Marketing helps franchise owners straighten out the route mess with our proven method developed exclusively for Servpro franchise owners.

 WorkCenter Case Study

Servpro Brickell / Wynwood  Miami FL

 

PROBLEM: Newly hired Servpro Marketing Manager (SMM) observes the three SMR’s under his charge arrive every morning log into WorkCenter Marketing and spend an hour unraveling the routes stops for that day into something manageable. This goes on for two weeks until he starts to look for a solution.

EXISTING ROUTE EXAMPLE: The image on the right is an actual route in WorkCenter (Gables Route 2) which contains 17 route stops. Several pins do not show as they are so far away from the pins shown. This is a typical example of what each SMR experiences each day upon logging in prior to finding a solution.

FINANCIAL IMPACT: 

  • SMR salary $39K per year.
  • Time spent unraveling each days route, one hour.
  • $19.00 / hour multiplied by 5 hours wasted each week, $95.00.
  • Multiplied by 50 weeks per year equals $4,750.00.
  • Multiplied by 3 SMR’s costing the owner $14,250 per year.

This example also does not include the wasted “windshield driving time” for each SMR on a non-optimized route they created themselves. Would it be a safe assumption that another hour per day was being wasted?

This means the franchise owner was shelling out almost $30K in salaries due to the inefficiency of the route planning tool WorkCenter Marketing.

WorkCenter Case Study

Servpro Brickell / Wynwood  Miami FL 

SOLUTION: OMO Marketing created a solution to “clean up” the routes in WorkCenter Marketing for each territory in the two franchises. Servpro of Brickell has two territories and Servpro of Wynwood has one territory. OMO Marketing developed a solution to clean up, de-duplicate and optimize all the routes for each Marketing Rep. 

THE PROCESS:

  • EXPORT WorkCenter Businesses and Contacts to .csv file.
  • Scrub and de-duplicate the Business and Contact data.
  • Import Business and Contacts into GIS mapping software.
  • Create new routes in mapping software. The Blue Boundary identified as CG R5 is now the cleaned up Gables Route 2 in the image example shown above.
  • Export the newly cleaned up routes from the mapping program.
  • Re-enter the cleaned up routes back into WorkCenter Marketing.

This process must occur with outside tools as WorkCenter Marketing is not a true SQL database application according to multiple Servpro tech support resources we’ve spoken with. If WorkCenter Marketing was able to perform compound queries (look up more than one field at a time) and you would most likely get a result almost as optimized as what we’ve accomplished with our process. 

WorkCenter’s query ability is similar to performing a “Find” in Microsoft Excel. By pressing “Ctrl F on your keyboard, you can search for a single string of cell data. Unfortunately WorkCenter Marketing performs queries in a similar manner therefore limiting a franchises ability to easily clean up or optimize routes directly in WorkCenter Marketing. For instance, you cannot perform a query in WorkCenter Marketing that states: Search in Zip Code 33131 and return all Property Managers in the field: Title/Position.

WorkCenter Case Study

Servpro Brickell / Wynwood  Miami FL 

 

SOLUTION: OMO Marketing created a solution to “clean up” the routes in WorkCenter Marketing for each territory in the two franchises. Servpro of Brickell has two territories and Servpro of Wynwood has one territory. With SMM level knowledge of WorkCenter Marketing, OMO Marketing developed a solution utilizing the latest GIS mapping software tools. 

THE PROCESS:

  • EXPORT WorkCenter Businesses and Contact to .csv file.
  • Scrub and de-duplicate the WorkCenter data.
  • Import Business and Contacts into GIS mapping software.
  • Create new routes in mapping software. The Blue Boundary identified as CG R5 is now the cleaned up Gables Route 2 as shown above. (note: there are less routes stop due to a management decision to eliminate (inactivate) certain businesses discovered during the WorkCenter Marketing export, de-duplicate and review process)
  • This results in each SMR having additional time to truly prospect in a narrowly defined route area to uncover additional prospects. 
  • Export the newly cleaned up routes from the mapping program.
  • Re-enter the cleaned up routes back into WorkCenter Marketing.

As shown in the image, the Gables Route 2 is now completely optimized and all the route stops are concentrated in a tight geographical area. In metropolitan routes like shown here, the SMR drives to a central location, parks the car and walks the route on foot.

This process cleans up and optimizes each route for the SMR’s at this franchises saving them hours a week re-routing each days routes.

Now the SMR’s arrive, log into WorkCenter Marketing and are out the door within 10 minutes saving the franchise owner tens of thousands in salary, making each SMR more efficient and providing the Marketing Rep more time to uncover new prospects due to their newly optimized high concentrated routes!

Our Trademarked
Process & Workflow.

In hac habitasse platea dictumst. Vivamus adipiscing fermentum quam volutpat aliquam. Integer et elit eget elit facilisis. Lorem ipsum dolor sit amet, consectetur adipiscing elit.

In hac habitasse platea dictumst. Vivamus adipiscing fermentum quam volutpat aliquam. Integer et elit eget elit facilisis. Lorem ipsum dolor sit amet, consectetur adipiscing elit.
Project Research
In hac habitasse platea dictumst. Vivamus adipiscing.
Wireframes
In hac habitasse platea dictumst. Vivamus adipiscing.
Design
In hac habitasse platea dictumst. Vivamus adipiscing.
Development
In hac habitasse platea dictumst. Vivamus adipiscing.

Let’s Work Together

In hac habitasse platea dictumst. Vivamus adipiscing fermentum quam volutpat aliquam. Integer et elit eget elit facilisis tristique.