Shop / Business / Marketing / The Local Marketing Handbook

Marketing · Nº 48

The Local Marketing Handbook

Google, Your Neighborhood, and Referrals for Brick-and-Mortar Businesses

Saturday you're turning people away. Tuesday morning you could hear a pin drop.

24 tools, a spreadsheet, and one neighborhood barbershop worked through from the customer map to the weekly routine, so you market to the people who can actually walk in.

You get 24 tools to map where your customers come from, fill out your Google profile, put a code on every flyer, team up with your neighbors, run a referral program, and aim your ads at your radius. Plus a 5-tab spreadsheet, filled in with the example.

1ready-made spreadsheet
15templates to adapt
24tools

A book explains the method. This handbook puts it to work: the tool, a worked example, and a spreadsheet with your numbers.

Secure checkout by Digistore24Money-back guaranteeLifetime access

One-time payment of $29.00. The order form shows the final amount, with any taxes for your country, before you pay.

Digital delivery: PDF handbook, spreadsheet and access on the Consylion platform.

14-day money-back guarantee: if it isn't what you expected, request a full refund within 14 days of purchase.

Your order is processed by Digistore24, our authorized reseller. By purchasing, you accept the terms of use and purchase · refund policy.

You printed a stack of flyers and have no idea if a single customer came from them. You paid for an ad, and half the people who saw it live across town. Your Google profile still shows photos from the week you opened. Saturday there's a line out the door, Tuesday morning the chairs sit empty, and every new marketing idea gets tried once, never counted, and quietly forgotten.

THE SPREADSHEET

Local marketing spreadsheet

Use the completed example as a reference and enter your business data in the marked fields. Check the instructions and the calculations before you make a decision.

The Local Marketing Handbook · The spreadsheet on screen
The spreadsheet on screen
The Local Marketing Handbook · Simulation with the example data
Simulation with the example data

SOUND FAMILIAR?

Three situations this handbook solves

Before you print another batch of flyers

You give each batch its own code and its own drop spot. Whoever's at the front desk asks every new customer how they heard about you. Thirty days later you know which spot brought people in, and you stop paying for the rest.

The shop next door wants to team up

Instead of a handshake and a stack of coupons, you set the rules on paper and count the coupons on each side every month. If it isn't paying off after 90 days, you end it politely, numbers in hand.

Monday, 9 a.m., your one marketing hour

You open the weekly list: reply to messages, post the week's photo, enter the flyer and referral codes, check the coupons at your neighbors, change the sidewalk sign. One hour, the same list every week, and marketing doesn't stop when the shop gets busy.

INSIDE

What you'll find in each tool

Five parts, in the order the work happens. Find your radius and your empty hours. Get found on the map, with a complete profile kept fresh every week. Make the street and your front door work for you. Bring in your neighbors, local events, and referrals. Then add radius ads, a slow-hour offer, a local calendar, and a one-hour weekly routine. Every tool has a step by step, a worked example, and an exercise.

The Local Marketing Handbook · The tool: the idea, where it comes from, and the diagram
The tool: the idea, where it comes from, and the diagram
The Local Marketing Handbook · The step-by-step and the hands-on exercise
The step-by-step and the hands-on exercise
The Local Marketing Handbook · Illustrative example with numbers
Illustrative example with numbers: Barbearia Pequizeiro, a fictional neighborhood barbershop with 4 chairs. Tadeu, the owner, cuts at the first chair. Bruna, at the front desk, runs the schedule, the messages, and the Google profile. Their slow hours and their numbers run through every tool.
The Local Marketing Handbook · The diagram in detail
The diagram in detail

WHAT YOU GET

Everything included in your purchase

  • The Local Marketing Handbook in PDF: 24 tools, each with a step by step, a worked example, and an exercise
  • The local marketing spreadsheet in Excel and Google Sheets, with 5 working tabs, filled in with the example barbershop
  • The Template kit: 15 ready-to-use texts, including the flyer with a code, the referral card, and the Monday list
  • 2 worksheets to fill in (door count and radius review) and a 30-day plan laid out week by week
  • Access to your handbook on the Consylion platform
The Local Marketing Handbook · What lands in your library
What lands in your library
The Local Marketing Handbook · The final checklist
The final checklist

Full table of contents

The 24 tools, in the order you'll use them

Part 1 · Part 1 · Your radius

  1. 01
    The customer mapPlot your last 200 customers and find the radius almost all of them come from
  2. 02
    Empty hours in the scheduleOccupancy by day and hour, so your marketing fills the slow times, not the rush
  3. 03
    Who walks past your doorCount who walks by, who looks, and who actually comes in
  4. 04
    The competitors in your radiusWho's chasing the same customer a few blocks away, with price, rating, and hours

Part 2 · Part 2 · Get found on the map

  1. 05
    A complete Google Business ProfileCategory, services, hours, photos, and attributes, field by field
  2. 06
    Photos and posts every weekFifteen minutes a week so your profile never looks abandoned
  3. 07
    The same details everywhereName, address, phone, and hours that match on every map and app
  4. 08
    The profile dashboardThe month's searches, directions, calls, and messages, read in 20 minutes

Part 3 · Part 3 · The street and the door

  1. 09
    A storefront you can read from the sidewalkName, service, and an open sign people can read from across the street
  2. 10
    Window and sidewalkWhat stays in view, and the sidewalk sign that makes people stop
  3. 11
    Tracked flyersA code and a place for every batch, so you know what each flyer customer costs
  4. 12
    A street promotion with a targetOne promotion outside the shop, with a cost, a target, and a count
  5. 13
    Neighborhood mediaRadio, sound trucks, and signs, tested with a code before they become a habit

Part 4 · Part 4 · Neighbors, events, and referrals

  1. 14
    Partnerships with neighborsA cross-coupon with the businesses on your street, with rules and a count
  2. 15
    Neighborhood eventsTournaments, festivals, and fairs where your customers already are
  3. 16
    Your shop as a gathering placeA reason for customers to stay, come back, and bring someone along
  4. 17
    A referral program with a rewardA card with a code and a reward for both sides, within your margin
  5. 18
    Neighborhood groups and communitiesThe neighborhood association and residents' groups, without spamming anyone

Part 5 · Part 5 · Ads, calendar, and routine

  1. 19
    Radius adsAds shown only to people who live or work a short trip from your door
  2. 20
    An offer to fill the empty hoursThe offer that brings people in on Tuesday morning without touching Saturday
  3. 21
    The local calendarThe dates that matter in your town and neighborhood, planned ahead of time
  4. 22
    New customers who come backHow many customers from each tactic come back within 45 days
  5. 23
    The local marketing weekOne hour a week with a fixed list, so marketing never stalls
  6. 24
    The radius reviewEvery three months, redo the map and decide which tactics stay, change, or go

Who it's for

It's for you if

  • You run a brick-and-mortar business and nearly every customer lives or works a few minutes away
  • You've tried flyers, ads, or partnerships and can't tell which ones brought anybody in
  • Some hours of your week sit empty while others are packed
  • You want a marketing routine that fits into one hour a week, not your whole weekend
  • You run a barbershop, salon, repair shop, clinic, gym, restaurant, or neighborhood store

It's not for you if

  • You need your overall marketing strategy, positioning, and budget. Start with The Marketing Handbook
  • You sell online to customers all over the country. That's The Digital Marketing Handbook
  • You want to run paid ad campaigns in depth. See The Paid Ads Handbook
  • You're hoping for a promise of new customers or a top spot on Google. This handbook organizes and measures your local marketing

Frequently asked questions

I don't run a barbershop. Will this work for my business?

If your customers come to your door, yes. The example is a barbershop, but every tool shows how it applies to services, retail, manufacturing and distribution, and independent professionals. You swap in your own street, hours, and numbers.

I don't keep customer records. Can I still make the map?

Yes. For two weeks, ask for the neighborhood or street at the counter and mark each answer. The map comes out approximate, but it's enough to show your radius.

Do flyers even work anymore?

It depends on where they go. With a code on every batch, you find out in about 30 days which spots bring in customers, and you cut the ones that don't. The handbook doesn't ask you to believe in flyers. It asks you to count them.

Won't a slow-hour offer cheapen my service?

Not if it has a clear rule for which days and hours it covers, and your busy times stay at full price. Customers understand that Tuesday morning isn't Saturday afternoon.

How much time does this take?

About 2 hours and 24 minutes of reading, or 6 minutes per tool, plus the exercises. Once it's running, the routine is one hour a week with a fixed list, plus about three hours each quarter for the radius review.

What do I get, and in what formats?

Each handbook is a PDF of about 100 pages with 24 to 27 tools. Every tool has step-by-step instructions and a worked example. You also get the handbook's spreadsheet in Excel (.xlsx), which opens in Google Sheets too, with the example already filled in. The message, policy, and clause templates are in the Template Kit inside the PDF, ready to copy and adapt. Read it in the member area or download the files.

How do I know if it fits my business?

Each handbook's page shows the problem it solves, who it is for and who it is not for, the full table of contents, sample pages, and the company used in the examples. The examples come from small businesses in several industries, with illustrative numbers. If it is not a fit, you can ask for a full refund within 14 days of your purchase, as described in the Refund Policy.

What is the difference between a handbook, an area set, and the Series?

A handbook solves one problem. An area set brings together every handbook and spreadsheet in one of the 6 areas, for less than the price of 5 single handbooks. The Consylion Handbook Series brings together all 100 handbooks and 100 spreadsheets, for less than the price of 8 single handbooks, and includes the next handbooks in the Series. Products outside the Series, from Consylion Life or Consylion Business, have their own price. They are sold separately and are not part of an area set or the Series.

Do I need to read everything before I start?

No. Each tool works on its own. Open the table of contents, pick the tool for today's problem, and start there. You can also read it cover to cover.

Do I need to know Excel?

The basics are enough: open the file and fill in the marked fields. The formulas are already built, and the handbook's example is filled in for reference.

How do I pay, and when do I get access?

By card or bank transfer, as a one-time payment with no subscription. Once your payment is confirmed, you get access to the member area by email. Approved card payments are confirmed right away. Bank transfers are confirmed when the funds clear. If access does not arrive within 24 hours of confirmation, check your spam folder and write to team@consylion.org.

How long do I have access, and how can I use the files?

Access does not expire, and you can download the files for offline use. The license is individual. You may read the handbooks, print them for your own use, and fill in and adapt the spreadsheet and templates with your company's data. If you are a consultant, accountant, or manager, you may apply the tools with your clients and deliver the result of your work, not the files. You may not share, resell, or distribute the files or the access.

How do support and refunds work?

Support is by email at team@consylion.org, on business days, with a reply within 5 business days. It covers questions about access, files, and payment. It does not include consulting or advice on applying the material to your case. You can cancel within 14 days of your purchase, without giving a reason, and get the full amount back through the payment method you used. Send the request to the same email. The details are in the Refund Policy.

All 100 handbooks

CONSYLION HANDBOOK SERIES

The 6 departments of your business, for less than the price of 8 single handbooks.

This handbook solves today's problem. The Series solves the next one, and the one after that, with nothing more to pay.

  • 100 handbooks with 2,403 ready-made tools, to read on screen and download as PDFs
  • 100 spreadsheets for Excel and Google Sheets
  • 6 business areas
  • Lifetime access, unlocked once payment is confirmed
$2,900.00 if bought separately
$197.00
One-time payment · for less than the price of 8 single handbooks
See details

One-time payment of $197.00. The order form shows the final amount, with any taxes for your country, before you pay.

Digital delivery: PDF handbook, spreadsheet and access on the Consylion platform.

14-day money-back guarantee: if it isn't what you expected, request a full refund within 14 days of purchase.

Your order is processed by Digistore24, our authorized reseller. By purchasing, you accept the terms of use and purchase · refund policy.

Marketing · Nº 48

Market to the people who can actually walk in

Your customers live and work a few minutes from your door. This handbook gives you the tools, the spreadsheet, and a worked example to find them, show up where they look, count what each tactic brings in, and keep doing only what earns its place.

See all 100 handbooks · $197.00

Single handbook
$29.00
One-time payment
Secure checkout by Digistore24Money-back guaranteeLifetime access

One-time payment of $29.00. The order form shows the final amount, with any taxes for your country, before you pay.

Digital delivery: PDF handbook, spreadsheet and access on the Consylion platform.

14-day money-back guarantee: if it isn't what you expected, request a full refund within 14 days of purchase.

Your order is processed by Digistore24, our authorized reseller. By purchasing, you accept the terms of use and purchase · refund policy.

All 100 handbooks

Handbook Series

6 departments, 100 handbooks, 100 spreadsheets

$197.00 $2,900.00 separately

Money-back guarantee · Secure payment

One-time payment of $197.00. The order form shows the final amount, with any taxes for your country, before you pay.

Digital delivery: PDF handbook, spreadsheet and access on the Consylion platform.

14-day money-back guarantee: if it isn't what you expected, request a full refund within 14 days of purchase.

Your order is processed by Digistore24, our authorized reseller. By purchasing, you accept the terms of use and purchase · refund policy.