What Business Profile insights tell you
When someone types plumber near me into a phone, the first thing they see is usually not a website. It is a map with three or four businesses and, after a tap, a panel with a name, a star rating, opening hours and a row of buttons: call, directions, website. That panel is the Google Business Profile. For a local business it is often the busiest page it has, although it is not on its own website at all.
The profile comes with a report, usually called insights or performance. It counts how many people saw the profile and what they did next. Most owners look at it once, see a big number of views, feel reassured and close it again. That is a pity, because the report answers a much more useful question than how many people saw us: it tells you how many of them did something that can turn into a job, and how that differs between your locations.
This free lesson shows how to read the report with four columns and three formulas in Excel. The example is Brindlewick Plumbing & Heating, a fictional home-services company with eight branches. All branches, people and numbers are invented for learning, and every benchmark in this course is illustrative. You will use exactly the data of the lab above: one month, May 2026, one row per branch.
The four numbers: views, calls, direction requests and website clicks
The report contains more detail than anyone needs on a normal day. Four numbers carry almost all of the meaning, and they are the four data columns of the lab.
- Profile views. How often the profile was shown to a person in Search or Maps during the period. Think of it as the number of people who walked past the shop window and looked in.
- Calls. Taps on the call button of the profile. For a plumber this is the most direct route to a job: the customer has a problem now and wants to speak to somebody.
- Direction requests. Taps on the directions button. They matter most for businesses that customers visit, such as a showroom, a shop or a restaurant.
- Website clicks. Taps on the website link. These visitors want more information before they decide: prices, services, a booking form.
Calls, direction requests and website clicks have one thing in common. Each is a deliberate step by a person who has seen the profile and wants more. Together they are the actions. A view costs the searcher nothing; an action shows intent.
From counts to a rate: the action rate
Counts cannot be compared between locations. A branch in a town of 60,000 people will collect more views than a branch in a town of 15,000, however good or bad its profile is. To compare fairly you need a rate, a number that relates what happened to how often it could have happened.
The action rate does exactly that: action rate = total actions ÷ profile views, where total actions = calls + direction requests + website clicks. If a profile is viewed 3,150 times and people take 415 actions, the action rate is 415 ÷ 3,150 = 13.17%. Roughly every eighth viewer did something. The rate strips out the size of the town and leaves the part you can influence: how convincing the profile is to the people who see it.
A fully worked example: eight branches in May 2026
Here is the complete sheet of the lab. The first five columns are the data as exported from the profiles. The last three are calculated: total actions, action rate and the call share, which is explained further down.
| Branch | Profile views | Calls | Direction requests | Website clicks | Total actions | Action rate | Call share |
|---|---|---|---|---|---|---|---|
| Ashby Cross | 4,820 | 212 | 96 | 318 | 626 | 12.99% | 33.9% |
| Marlow Fen | 3,150 | 171 | 64 | 180 | 415 | 13.17% | 41.2% |
| Pine Quay | 6,240 | 198 | 142 | 402 | 742 | 11.89% | 26.7% |
| Stonebridge | 2,380 | 143 | 38 | 121 | 302 | 12.69% | 47.4% |
| Harrow Vale | 5,410 | 186 | 211 | 296 | 693 | 12.81% | 26.8% |
| Elm Harbor | 1,960 | 74 | 29 | 88 | 191 | 9.74% | 38.7% |
| Copper Hill | 3,720 | 205 | 71 | 207 | 483 | 12.98% | 42.4% |
| Larkfield | 2,890 | 98 | 57 | 164 | 319 | 11.04% | 30.7% |
| All branches | 30,570 | 1,287 | 708 | 1,776 | 3,771 | 12.34% | 34.1% |
Three formulas produce the calculated columns. They are written for row 4, the first branch, and copied down to row 11:
- Total actions (F4):
=C4+D4+E4or, shorter,=SUM(C4:E4).SUMadds every number in the range between the brackets, here the three cells from C4 to E4. - Action rate (G4):
=F4/B4. Total actions divided by profile views. Format the column as a percentage with two decimals. - Call share (H4):
=C4/F4. Calls divided by total actions, again formatted as a percentage.
Walk through the second row to see the logic. Marlow Fen had 171 calls, 64 direction requests and 180 website clicks, so its total actions are 171 + 64 + 180 = 415. With 3,150 views the action rate is 415 ÷ 3,150 = 13.17%. Now compare Pine Quay: 742 actions sound far better than 415, and in absolute terms they are. But Pine Quay needed 6,240 views to get them, which is an action rate of only 11.89%. Per person who saw the profile, the small branch does better than the big one.
The chart makes the ranking obvious. Six branches sit close together between about 11.9% and 13.2%, Larkfield follows at 11.04%, and Elm Harbor stands apart at 9.74%. That gap is worth money: if Elm Harbor reached the company rate with the same 1,960 views, it would collect about 51 more actions every month. Nothing in this sheet says why the rate is low. It may be missing photos, wrong opening hours, few reviews or a weak rank in Maps. The sheet tells you where to look first, and the later lessons give you the tools to look.
Call share: what kind of branch is it?
The action rate treats every action alike. The call share looks inside: call share = calls ÷ total actions. It shows which of the three buttons people prefer at each branch, and that says a lot about the kind of demand the branch serves.
Stonebridge has the highest call share at 47.4%: nearly every second action is a phone call, the pattern of a branch that lives on urgent repairs. Harrow Vale is the opposite. Its call share is only 26.8%, yet nobody would call it a weak branch, because 211 direction requests show that customers drive to its bathroom showroom. A low call share is not a fault. It is a description. It becomes a warning only when it does not fit the business: an emergency plumber whose profile produces mostly website clicks probably has a call button that is hard to find, or opening hours that show closed at the wrong time.
The company total: divide the sums
Management will ask for one number for the whole company. There are two ways to calculate it, and only one is right. The correct way adds up all actions and all views first and divides afterwards: =SUM(C4:E11)/SUM(B4:B11). For May 2026 that is 3,771 ÷ 30,570 = 12.34%.
| Method | Formula | Result | What it means |
|---|---|---|---|
| Divide the sums | =SUM(C4:E11)/SUM(B4:B11) | 12.34% | The share of all viewers who took an action. Correct. |
| Average the branch rates | =AVERAGE(G4:G11) | 12.16% | The rate of a typical branch, with every branch counted the same. |
The tempting shortcut is to average the eight branch rates in column G. It gives 12.16%, which looks close enough. It is still wrong as a company figure, because it gives Elm Harbor with 1,960 views the same weight as Pine Quay with 6,240. Here the difference is small. In a company with a few large and many tiny locations the two results can be far apart, and a report built on the wrong one will not match the totals in the platform.
Step by step in Excel
- Export or copy the insights of each profile for the same period and put them in one table: one row per branch, one column each for views, calls, direction requests and website clicks. Check that every branch covers the same dates.
- In F4 type
=C4+D4+E4and press Enter. Select F4 and drag the small square at the bottom right corner of the cell down to F11. Excel adjusts the row numbers automatically, so F5 becomes=C5+D5+E5. - In G4 type
=F4/B4, copy it down to G11 and format the column as a percentage with two decimals (Ctrl + Shift + % applies the percentage format, then add decimals). - In H4 type
=C4/F4, copy it down and format it as a percentage. - In B13 type
=SUM(B4:B11)for the total views. - In G13 type
=SUM(C4:E11)/SUM(B4:B11)for the company action rate. The first SUM covers a block of three columns and eight rows, which is perfectly fine: a range can be a rectangle. - Sort the table by the action rate or insert a bar chart, so the outliers stand out.
How to read the result
A table of rates is only useful if it leads to a decision. Four reading rules help.
- Compare branches with each other before you compare with the outside world. Published averages for action rates vary widely by industry, town size and counting method. Your own best branch is a more honest benchmark than a number from an article.
- Look at rate and volume together. Pine Quay has a below-average rate but the largest volume, so one extra percentage point there would add about 62 actions a month, more than the same improvement anywhere else.
- Read the mix before you judge. A showroom branch and an emergency branch should not have the same call share. Decide what the right mix for each location is, then check whether the profile delivers it.
- Watch the trend, not a single month. One month can be distorted by a cold snap, a local event or a week of wrong opening hours. Lesson 2 adds the time dimension.
Common mistakes and how to spot them
- Adding the views to the actions.
=B4+C4+D4+E4gives a huge number and an action rate above 100%. Views are the base of the rate, not part of the actions. - Dividing the wrong way round.
=B4/F4returns 7.7 instead of 13%. A rate of actions per view can never be larger than 1. - Using calls only.
=C4/B4is the call rate. It is a valid measure, but it ignores people who asked for directions or opened the website, and it makes showroom branches look bad. - Mixing up call share and call rate. The call share divides by actions, the call rate by views. Marlow Fen has a call share of 41.2% and a call rate of 5.43%.
- Averaging the rates for the total. As shown above, the company rate comes from the sums.
- Comparing different periods. A 31-day month against a 28-day month, or one branch with a week of missing data, produces differences that have nothing to do with the profile.
- Treating actions as customers. An action is a signal of interest. Some calls are wrong numbers, some website clicks are suppliers. Lesson 5 shows how to turn actions into leads, jobs and money.
Quick reference: formulas in this lesson
| Measure | Meaning | Formula in the lab |
|---|---|---|
| Total actions | Calls + direction requests + website clicks | =C4+D4+E4 or =SUM(C4:E4) |
| Action rate | Share of viewers who took an action | =F4/B4 |
| Call share | Share of calls in all actions | =C4/F4 |
| Total views | Views of all branches | =SUM(B4:B11) |
| Company action rate | All actions ÷ all views | =SUM(C4:E11)/SUM(B4:B11) |
Real-world uses
- Monthly branch report. One row per location, sorted by action rate. The two lowest rows get a profile check: hours, photos, categories, recent reviews.
- Before and after a change. Note the action rate before you add a booking link or new photos, and compare the same branch a month or two later. One profile compared with itself is the fairest test.
- Single-location businesses. With only one profile, the rows are months instead of branches. The formulas stay the same and the comparison is with your own history.
- Agency reporting. An agency that looks after many clients can compare action rates within one industry to find the profiles that under-perform.
What lessons 2 to 20 add
Lesson 1 is free. Lessons 2 to 20 are part of the full course. Each one has its own live sheet with a new data set from Brindlewick Plumbing & Heating, and each adds one piece to a complete local SEO workflow.
Lessons 2 to 5: understanding the insights. You split views into Search and Maps, mobile and desktop, and measure month-over-month growth. You separate brand searches from discovery searches with SUMIF. You analyse calls by hour, find the missed calls and put a value on them. Then you follow actions through leads and jobs to revenue and calculate what one call, one direction request and one website click is worth.
Lessons 6 and 7: rank grids and citations. You summarise a 7 × 7 local rank grid with the average rank and the share of points in the top 3, and turn it into a heat map. You compare the name, address and phone number of fourteen listings with a master record and calculate a consistency rate.
Lessons 8 to 11: reviews. You measure review velocity, a running total and the overall rating; count the rating mix and the reply rate; compare technicians by review requests and reviews per 100 jobs; and work out how many five-star reviews a branch needs to reach a target rating and how long that takes.
Lessons 12 to 15: service areas and ranks. You judge service-area pages by conversion rate and leads per 1,000 households, decide where the service area should end by calculating profit after travel, estimate clicks from keyword ranks with XLOOKUP and compare two rank grids before and after six months of work, including a head-to-head against a competitor.
Lessons 16 to 20: planning and reporting. You turn the citation audit into a prioritised plan with a budget, score profile completeness with a weighted checklist, forecast calls with FORECAST.LINEAR, build a what-if grid for the profit from local leads and finish with a scorecard per branch that combines SUMIFS, lead value, flags and a chart.
Summary
Business Profile insights become useful when counts turn into rates. Total actions are calls plus direction requests plus website clicks. The action rate, actions divided by views, makes branches of different size comparable; in the example it ranges from 9.74% at Elm Harbor to 13.17% at Marlow Fen, with a company rate of 12.34%. The call share describes what kind of demand a branch serves. And the company total is always calculated from the sums, never from an average of rates.
The lab at the top of this page holds the same eight branches. Type the five formulas there, let the Coach confirm each cell, and afterwards swap in the numbers from your own profile report: the layout works for any business with a profile.
Frequently asked questions
What is the action rate of a Google Business Profile?
The action rate is the share of profile views that led to an action: total actions divided by profile views. Total actions are calls plus direction requests plus website clicks. With 415 actions and 3,150 views the action rate is 13.17%.
How do I calculate the action rate in Excel?
Put views in column B and calls, direction requests and website clicks in columns C to E. Add the actions with =C4+D4+E4 or =SUM(C4:E4) in F4, then divide by the views with =F4/B4 and format the result as a percentage.
What is a good action rate for a local business?
There is no universal figure, because it depends on the industry, the town and how the platform counts. Compare your own locations with each other and each profile with its own history. In the fictional example of this lesson the branches lie between about 10% and 13%.
Why should I not average the action rates of my locations?
An average of rates gives a small location the same weight as a large one. For the company total, add up all actions and all views first and divide afterwards, for example =SUM(C4:E11)/SUM(B4:B11).
What does the call share tell me?
The call share is calls divided by total actions. It shows which button people prefer. A high call share is typical for urgent services, a high share of direction requests for places customers visit. It describes the kind of demand rather than the quality of the profile.
Are profile actions the same as customers?
No. An action is a sign of interest. Some calls are wrong numbers or existing customers, and not every website click becomes an enquiry. To get from actions to money you need a lead rate, a close rate and an average job value, which lesson 5 of the course covers.
Keep going: Local SEO & Google Business Profile: Profile Insights, Local Rank Grids, Citations, Review Velocity & Local Lead Value
This free lab is lesson 1 of 20. Unlock the other 19 hands-on labs, the final exam and your certificate for a one-time $9.90.
- Where the Views Come From: Search vs Maps, Mobile vs Desktop and Month-over-Month Growth
- Search Terms Report: Brand vs Discovery Searches with SUMIF, Shares of the Total and the Biggest Terms
- Calls from the Profile: Answered and Missed Calls by Hour, the Missed-Call Rate and the Value Lost
- What a Profile Action Is Worth: Lead Rate, Close Rate, Job Value and the Value per Call, Direction Request and Click
- Local Rank Grids: Average Map Rank, Points in the Top 3, Top-3 Share and a Heat Map of the Weak Side
- Citations and NAP Consistency: Comparing Name, Address and Phone with the Master Record and Scoring the Listings
- Review Velocity: New Reviews per Month, the Running Total, the Overall Rating and a 3-Month Pace
- Rating Mix and Review Replies: Counting Stars with COUNTIF, the Reply Rate, Reply Time and Unanswered Low Ratings
- Asking for Reviews: Request Rate, Request-to-Review Rate, Reviews per 100 Jobs and a Ranking per Technician
- Rating Targets: How Many 5-Star Reviews Lift the Average to the Target and How Long It Takes at the Current Velocity
- Service-Area Pages: Conversion Rate, Leads per 1,000 Households and County Totals with SUMIFS
- Drawing the Service Area: Drive Time, Travel Cost per Job, Profit After Travel and a Keep-or-Review Decision per Zone
- Keyword Rank Tracking: Rank Change, Click Share by Position with XLOOKUP, Estimated Clicks and a Weighted Average Rank
- Before and After: Comparing Two Rank Grids, Points Gained, the Top-3 Share and a Head-to-Head Against a Competitor
- Citation Clean-Up: Status Counts with COUNTIF, a Priority Score, Fix Hours and the Budget
- Profile Completeness: A Weighted Checklist Score per Branch, Missing Items and the Link to the Action Rate
- Forecasting Calls from the Profile: SLOPE, FORECAST.LINEAR, a Three-Month Outlook and a Staffing Check
- What-If Grid: Monthly Profit from Profile Leads by Close Rate and Job Value, Break-Even Close Rate and Return on Cost
- Final Project: Local SEO Scorecard per Branch with SUMIFS, Action Rate, Lead Value, a Review-Velocity Flag and a Chart