Weekly Search & Leads Report

A quiet holiday week — search kept growing underneath.

July 4 pulled overall traffic and new leads down from an unusually strong prior week. But the engine underneath got stronger: more people saw you, more clicked through, and rankings improved. And the people who started your lead form finished it nearly 9 times out of 10. Here's the full picture.

Search visibility · Google

Clicks

169
▲ 9%

Impressions

3,549
▲ 11%

Click rate

4.76%
▼ 2%

Avg position

9.8
▲ 0.3

Traffic & leads · Analytics

Sessions

465
▼ 28%

Users

410
▼ 20%

Leads

116
▼ 42%

New users

369
▼ 17%
01

Leads & enquiries

Where the traffic actually turned into leads this week.

Holiday effect

Leads are the number that matters here, so let's start there. You captured 116 leads this week vs 200 the week before (▼ 42%) — a real dip, but the prior week was an unusually strong baseline and the July 4 holiday pulled the whole site's traffic down with it (sessions 465 vs 645). The encouraging part: of the 131 people who started your lead form, 116 finished — an 89% completion rate, essentially flat with last week, so the form itself isn't leaking. And underneath the holiday quiet, organic search actually grew — clicks up 9% and impressions up 11%. Read it as a slow calendar week sitting on top of a healthy, strengthening search engine, not a problem with the funnel.

465
sessions
last wk: 645
488
template page views
last wk: 615
131
started the lead form
last wk: 223
116
leads captured
last wk: 200
02

What's moving

Every line item, this week vs last.

Line itemThis wkLast wkΔ
Leads · lead form
Leads (generate_lead)116200▼ 42%
Form starts131223▼ 41%
Form completion rate89%90%— flat
Traffic & engagement
Sessions465645▼ 28%
Template page views488615▼ 21%
Avg engagement / session33s34s— flat

Leads are your HubSpot LeadForm submissions, tracked as the generate_lead key event in GA4 (filtered to exceltrainingdesigns.com). Last week was an unusually strong baseline, and the US July 4 holiday pulled overall traffic down across the board this week. Form completion rate is leads ÷ form starts. All figures week-over-week vs 22–28 Jun.

03

Leading keywords

Your top search terms this week, by clicks.

1excel training templatesrising3 clickspos 5.3
2excel training designsbrand2 clickspos 1.0
3excel strength training template1 clickspos 3.6
4personal training excel templates free1 clickspos 3.3
5google sheets personal training template free1 clickspos 4.3
6free excel workout template1 clickspos 5.0
7excel workout1 clickspos 4.7
8exercise program template excel1 clickspos 8.5
04

Market context

Your standing in the wider search market, via SEMrush.

132
Keywords you rank for
Distinct Google searches your site appears for — your total search footprint. A current snapshot; SEMrush refreshes this monthly, so it doesn't move week to week.
$201/mo
Traffic value
What your organic traffic would cost to buy through Google Ads each month.
~84
Est. monthly visits
SEMrush's model of your monthly organic traffic — an outside estimate, useful for trend, not exact counts.
05

What's working

Standing strengths to protect.

✓

Search grew through a holiday week

Even as July 4 pulled overall traffic down, organic search moved the other way: 169 clicks (+9%) from 3,549 impressions (+11%), with average position improving to 9.8. More people saw you, and more of them clicked.

✓

Your lead form isn't leaking

Of the 131 people who started the form, 116 finished — an 89% completion rate, essentially flat with last week. The dip in leads was fewer visitors over the holiday, not a broken form.

✓

The free-template funnel is doing its job

Your free Google Sheets workout template post pulls 5.3% CTR at position 6.4, and the brand search “excel training designs” converts at position 1 — a clean top-of-funnel that feeds the lead form.

06

Priority fixes

Ranked by upside. Bars show each page's click rate against a realistic 3% target.

1Biggest leak

Your core template page is stuck on page 2

/templates/personal-training
Impressions
963
Click rate
3.32%
Position
16.7
Click rateTarget 3%

This is your highest-value offer page and it has real reach — 963 impressions — but it ranks at 16.7, deep on page 2, so almost none of that reach becomes a visit. Getting it onto page 1 is the single biggest lever you have on leads.

2High upside

Homepage sits just outside the top five

/
Impressions
2,099
Click rate
4.81%
Position
8.3
Click rateTarget 3%

Your most-seen listing by far — 2,099 impressions — but it averages position 8.3, just below the top five where the clicks concentrate. A small ranking gain here moves a lot of traffic.

3High upside

Excel workout plan post sits on the page-1 border

/blog/excel-workout-plan
Impressions
218
Click rate
2.75%
Position
10.6
Click rateTarget 3%

Right on the edge of page one at 10.6, with a below-average click rate. A modest refresh could tip it into the top ten and roughly double its clicks.

4Worst click rate

Training-volume post wastes a page-one ranking

/blog/calculate-training-volume-excel
Impressions
199
Click rate
1.01%
Position
7.3
Click rateTarget 3%

Only 2 clicks from 199 views despite a solid page-one position of 7.3 — your weakest click rate among pages with real reach. The ranking is already there; the listing just isn't earning the click.

This week's focus

Get your personal-training template page onto page 1.

It already pulls 963 impressions but ranks at 16.7 — page two — so most of that reach never becomes a visit or a lead. The demand is proven; you're just not visible enough to capture it. Strengthen the page and point internal links at it. No new traffic required — you're converting reach you already have.

32
clicks this week
→
pos 16.7
stuck on page 2
→
4%+
CTR once on page 1
=
~2×
clicks in reach