Why count how often your team reuses templates?
A marketing team that produces social posts, email headers, web banners and stories every week quickly notices a pattern: many requests look alike. The size is the same, the grid is the same, the logo sits in the same corner, and only the headline, the photo and the colour change. Designers who start from a blank file for each of them spend hours on decisions that were already made last week. Designers who start from a prepared layout, a template, spend those hours on the part that is actually new.
The template reuse rate turns that observation into a number: of all assets delivered in a period, how many were built from an approved template? It is one of the simplest and most useful measures of visual content production, because it needs nothing more than a list of finished assets and one extra column. It also leads straight to the next questions of this course: how long do assets take, how many revision rounds do they need, which sizes are missing from the library, and what does an asset cost in-house compared with a freelancer?
The example in this lesson is Northgrove Outfitters, a fictional online shop for outdoor gear with a small in-house design team and a few freelancers. All companies, people and numbers in this course are invented for learning; benchmarks are illustrative and are not official data from any platform or agency.
The core concept: what counts as "built from a template"
A template is a prepared file in the shared library with the size, grid, fonts, colours and logo position already fixed. The designer opens it, replaces the text and the photo, adjusts the colour and exports. The word reuse says that the same layout serves many assets. The measure is only meaningful if everybody counts the same way, so write the rule down before you count:
- The file started from an approved template in the library, not from an old campaign file copied by hand.
- Only text, photos, colours and small adjustments changed. If the layout was rebuilt, the asset counts as new work.
- The designer records the template name in the asset log. An empty cell is not allowed; a blank file is written as
None.
With this rule the measure has exactly one formula: template reuse rate = assets built from a template ÷ assets delivered.
A fully worked example: Northgrove Outfitters in October 2026
The design team logged 15 assets in October 2026 (a small sample for the lesson). For each asset the log has the asset number, the format and the template used. The fourth column, Reused?, is the flag that you calculate. It is the same data as in the lab above.
| Asset | Format | Template | Reused? |
|---|---|---|---|
| A-1001 | Social post | Social grid A | Yes |
| A-1002 | Social post | None | No |
| A-1003 | Email header | Email header v3 | Yes |
| A-1004 | Web banner | None | No |
| A-1005 | Story | Story frame | Yes |
| A-1006 | Social post | Social grid A | Yes |
| A-1007 | Social post | Social grid B | Yes |
| A-1008 | Web banner | Banner kit 2 | Yes |
| A-1009 | Email header | None | No |
| A-1010 | Story | Story frame | Yes |
| A-1011 | Social post | Social grid A | Yes |
| A-1012 | Web banner | None | No |
| A-1013 | Story | Story frame | Yes |
| A-1014 | Social post | None | No |
| A-1015 | Email header | None | No |
Count the flags: 9 assets were built from a template and 6 from a blank file. 9 ÷ 15 = 60%. Three out of five sounds decent; let us look at it by format before drawing a conclusion.
Step 1: flag every asset with IF
The IF function returns one answer when a test is true and another when it is false: =IF(test, answer if true, answer if false). Here the test is whether the template cell is not equal to the word None. The sign <> means "is not equal to".
- Reused? (D4):
=IF(C4<>"None","Yes","No"), copied down to D18. - Text in a formula is written in double quotes. "None" must be spelled exactly as in the log, otherwise every asset would count as built from a template.
- Some people prefer a flag of 1 and 0 because it can be added up. Both work; this lab uses Yes and No because they are easier to read in a list.
Step 2: count the assets and calculate the overall rate
Three counting functions do all the work in this lesson. They are worth learning properly because every later lab uses them.
- COUNTA(range) counts the filled cells in a range. Applied to the asset numbers it gives the number of assets delivered:
=COUNTA(A4:A18)returns 15. - COUNTIF(range, criterion) counts the cells that meet one condition.
=COUNTIF(C4:C18,"<>None")counts the assets whose template is not None and returns 9. - COUNTIFS(range1, criterion1, range2, criterion2) counts the rows that meet two or more conditions at the same time. You need it for the next step.
The overall rate is then one division: =COUNTIF(C4:C18,"<>None")/COUNTA(A4:A18) gives 9/15 = 60%. Format the cell as a percentage, otherwise Excel shows 0.6.
Step 3: the reuse rate per format with COUNTIFS
The overall rate hides differences. To compare formats, build a small table with one row per format. For each format you need two counts: all assets of that format and the ones built from a template.
- Assets (G4):
=COUNTIF($B$4:$B$18,F4)counts the rows whose format equals the format name in F4. - Reused (H4):
=COUNTIFS($B$4:$B$18,F4,$C$4:$C$18,"<>None")counts the rows with this format AND a template. - Reuse rate (I4):
=H4/G4.
The dollar signs lock the data ranges, so that they do not move when you copy the formula down to the other formats. The format name in F4 is a relative reference and moves from row to row; that is exactly what you want. The result for the four formats is in the next table.
| Format | Assets | Reused | Reuse rate |
|---|---|---|---|
| Social post | 6 | 4 | 66.7% |
| Email header | 3 | 1 | 33.3% |
| Web banner | 3 | 1 | 33.3% |
| Story | 3 | 3 | 100.0% |
| All formats | 15 | 9 | 60.0% |
How to read the result
Stories have a reuse rate of 100% (all 3 of them came from the story frame), and social posts follow with 66.7%. Email headers and web banners are at 33.3% each: only 1 of 3 email headers and 1 of 3 web banners used a template. That is where the next template would help most, provided those formats are requested often. With three assets per format the numbers are small, so treat them as a pointer to look closer, not as a verdict.
There is no universal good rate. A team that produces many similar social posts can reasonably reach a high rate, while a team that works mostly on one-off brand campaigns will stay low. Compare your own rate month by month and by format, and ask two questions when it changes: did the mix of requests change, or did the library change?
Common mistakes
- Counting every copied file as a template. A campaign file duplicated from last month is not an approved template. Keep the rule strict, or the rate will rise without any benefit.
- Dividing by the wrong base. The rate divides template assets by all assets delivered, not by the assets built from scratch. Template assets divided by scratch assets gives 9/6 = 150%, which is not a rate.
- Misspelling "None". The criterion
"<>None"is exact. If one designer writes "none " with a space, that row counts as a template. - Forgetting the dollar signs. Without
$B$4:$B$18the data range slides down when you copy the formula and the counts become too small. - Comparing formats with very few assets. One asset more or less moves a rate of three assets by 33 percentage points. Collect a quarter before you decide.
From reuse rate to time and money
The reuse rate is a means, not an end. Its value comes from the hours that templates save. Suppose an email header takes about two hours from a blank file and one hour from the template (illustrative numbers). Each reused header then saves one hour. Lesson 9 turns this into hours saved per template, the payback of the hours spent building it, and a ranking of templates by use. Lesson 5 puts a price on a designer hour, so that the saving can be shown in euros.
Templates also help quality. A template carries the brand rules, so a reused asset needs fewer revision rounds for logo, colour and font errors. Lessons 3, 12 and 13 look at revision rounds, their causes and the first-pass approval rate.
What you will practise in the lab
The lab above uses the 15 assets from the table. You flag each asset with IF, count the assets and the template assets with COUNTA and COUNTIF, calculate the overall reuse rate, and then build the per-format table with COUNTIF and COUNTIFS. Five tasks, about fifteen minutes. The Coach checks one cell per task and explains typical slips, for example a reversed test or a missing second condition.
What the rest of the course covers
This is lesson 1 of 20. The full course builds a small measurement system for visual content production, one practical question per lab:
- Turnaround Time per Asset: Calendar and Working Days, SLA Lookups, On-Time Flags and the Average per Format. You turn request and delivery dates into calendar and working days, compare them with the SLA of each format and calculate the average turnaround per format.
- Revision Rounds: Rounds per Asset, First-Pass Approval, Over-Scope Flags and the Average per Requesting Team. You flag assets that need more rounds than the brief includes, calculate the first-pass approval rate and the average rounds, and compare the requesting teams with AVERAGEIFS.
- Asset Library Coverage: Available vs Missing Assets by Format, Size and Collection, Overall Coverage and Gap Flags. You measure library coverage per format and size, per collection and overall, count the missing assets and flag the sizes that fall below a gap limit.
- In-House Cost per Asset: Monthly Cost Pool, Hourly Cost of Design Time, Tools and Overhead Share and Cost by Format. You add up the monthly cost of the in-house team, calculate the cost per asset and the hourly cost of design time, and build the cost per asset for each format.
- Freelance Cost per Asset: Expected Invoice, Rush Surcharge, Extra Rounds and the Average Cost per Format. You rebuild the expected freelance invoice from the price list, flag invoices that do not match, and calculate the average cost per asset overall and per format.
- In-House vs Freelance: All-In Freelance Cost, Cheaper Option per Format, Weighted Blend and the Break-Even Volume. You add the internal handling cost to freelance fees, choose the cheaper option for each format, weight the blended freelance cost by volume and find the break-even volume.
- Monthly Production Scorecard: Reuse Rate, Blended Cost per Asset, Freelance Share and a Trend Chart. You build a six-month scorecard with the reuse rate, the blended cost per asset and the freelance share, add a six-month total and chart the trend.
- Template Performance: Hours Saved per Asset, Rank by Uses, Top-3 Concentration and Payback of the Build Hours. You calculate the hours each template saves, rank the templates, measure how concentrated the use is and find how many uses pay back the build time.
- Turnaround Distribution: Median, 80th Percentile, Share within the SLA and a Histogram Chart. You describe the turnaround of 20 requests with the median, the 80th percentile and the share within the SLA, count requests per day and chart the distribution.
- Rush Requests: Lead Time, Rush Flags, the Rush Rate per Team and Highlighting with a Formula Rule. You calculate the lead time of each request, flag rush requests, measure the rush rate overall and per team, and highlight the rush rows with a formula rule.
- Causes of Revision Rounds: Hours Lost, Shares, a Cumulative Pareto Share and the Savings of a Better Brief. You turn revision rounds into hours lost per cause, calculate each cause's share and the cumulative share, estimate the savings of a better brief and chart the hours.
- First-Pass Approval and Quality: Rates per Producer, Weighted Group Rates, Brand-Check Fails and a Highlight Rule. You calculate first-pass rates and average rounds per producer, compare in-house and freelance with SUMIFS, count brand-check fails per 100 assets and highlight weak rates.
- Library Coverage Weighted by Demand: Requests without an Asset, SUMPRODUCT Coverage, the Top Gap and a Bar Chart. You weight library coverage by the requests per size, list the requests that found no asset, find the biggest gap with INDEX and MATCH and chart the gaps.
- Library Reuse Value: Cost per Use, Unused Assets, Money Tied Up and the Reuse Share. You calculate the cost per use of library assets, count the assets that were never used, add up what they cost and measure the share of reused assets.
- Capacity and Overload: Weekly Capacity, Demand Hours, Utilisation, Overload Hours and a Demand Chart. You compare weekly design demand with team capacity, calculate utilisation and overload hours, and chart the weeks that exceed capacity.
- Volume Forecast: Trend with SLOPE, FORECAST.LINEAR, Freelance Assets Needed above Capacity and the Freelance Budget. You measure the monthly growth of the asset volume, forecast the next three months, derive the freelance assets and cost above in-house capacity, and chart the result.
- Outsourcing What-If: Capacity Cut-Off, a Cost Grid with Mixed References, Cost per Asset and a Heat Map. You calculate the assets above capacity, fill a cost grid with one formula using mixed references, derive the cost per asset and highlight the grid with a colour scale.
- Data Quality Checks: Duplicate IDs, Missing Formats, Reversed Dates, Impossible Rounds and a Clean-Row Count. You test an asset log for duplicate IDs, missing formats, reversed dates and negative rounds, count the problem rows and highlight the duplicates.
- Final Project: The Visual Production Scorecard with Reuse, Turnaround, Cost per Asset, a Chart and a Target Flag. You complete a four-quarter scorecard with reuse rates, cost per asset for in-house and freelance work and the overall cost per asset, then chart the costs and flag missed targets.
Summary
The template reuse rate is the share of delivered assets that were built from an approved template. In the sheet you flag each asset with =IF(C4<>"None","Yes","No"), count the assets with COUNTA and the template assets with COUNTIF(…,"<>None"), and divide. At Northgrove Outfitters 9 of 15 October assets came from a template, a rate of 60%, with stories at 100% and email headers and web banners at 33.3%. COUNTIFS adds the format as a second condition and shows where a new template would help.
Now scroll up to the lab and build the sheet yourself. The Coach checks every step, and at the end you have a reuse report you can apply to your own asset log.
Frequently asked questions
What is a good template reuse rate?
There is no universal figure. A team with many similar social posts can reach a high rate, while a team doing mostly one-off brand campaigns will stay lower. Compare your own rate month by month and by format, and look for the formats where a new template would save the most time.
Should a copied campaign file count as a template?
No. Count only files that started from an approved template in the shared library and where just text, photos and colours changed. If copied files count, the rate rises without any real time saving.
Why use COUNTIFS instead of COUNTIF for the rate per format?
COUNTIF checks one condition. The reuse rate per format needs two at the same time: the format must match and the template must not be None. COUNTIFS accepts several range and criterion pairs and counts only the rows that meet all of them.
Can I use 1 and 0 instead of Yes and No for the flag?
Yes. A 1/0 flag can be added up directly with SUM, which makes the rate a simple division. This lab uses Yes and No because they are easier to read; the counts with COUNTIF give the same result.
How many assets do I need before the rate means something?
The more the better. With three assets in a format, one asset moves the rate by 33 percentage points. Use a full quarter, or at least a few dozen assets per format, before you decide to build or drop a template.
Does a higher reuse rate always mean lower cost?
Not automatically. Templates save time only if they are easy to find, fit the requests and are maintained. Check the turnaround time and the hours per asset next to the rate, as the next labs in this course show.
Keep going: Visual Content Production: Template Reuse, Turnaround Time, Revision Rounds, Asset Library Coverage & Cost per Asset
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.
- Turnaround Time per Asset: Calendar and Working Days, SLA Lookups, On-Time Flags and the Average per Format
- Revision Rounds: Rounds per Asset, First-Pass Approval, Over-Scope Flags and the Average per Requesting Team
- Asset Library Coverage: Available vs Missing Assets by Format, Size and Collection, Overall Coverage and Gap Flags
- In-House Cost per Asset: Monthly Cost Pool, Hourly Cost of Design Time, Tools and Overhead Share and Cost by Format
- Freelance Cost per Asset: Expected Invoice, Rush Surcharge, Extra Rounds and the Average Cost per Format
- In-House vs Freelance: All-In Freelance Cost, Cheaper Option per Format, Weighted Blend and the Break-Even Volume
- Monthly Production Scorecard: Reuse Rate, Blended Cost per Asset, Freelance Share and a Trend Chart
- Template Performance: Hours Saved per Asset, Rank by Uses, Top-3 Concentration and Payback of the Build Hours
- Turnaround Distribution: Median, 80th Percentile, Share within the SLA and a Histogram Chart
- Rush Requests: Lead Time, Rush Flags, the Rush Rate per Team and Highlighting with a Formula Rule
- Causes of Revision Rounds: Hours Lost, Shares, a Cumulative Pareto Share and the Savings of a Better Brief
- First-Pass Approval and Quality: Rates per Producer, Weighted Group Rates, Brand-Check Fails and a Highlight Rule
- Library Coverage Weighted by Demand: Requests without an Asset, SUMPRODUCT Coverage, the Top Gap and a Bar Chart
- Library Reuse Value: Cost per Use, Unused Assets, Money Tied Up and the Reuse Share
- Capacity and Overload: Weekly Capacity, Demand Hours, Utilisation, Overload Hours and a Demand Chart
- Volume Forecast: Trend with SLOPE, FORECAST.LINEAR, Freelance Assets Needed above Capacity and the Freelance Budget
- Outsourcing What-If: Capacity Cut-Off, a Cost Grid with Mixed References, Cost per Asset and a Heat Map
- Data Quality Checks: Duplicate IDs, Missing Formats, Reversed Dates, Impossible Rounds and a Clean-Row Count
- Final Project: The Visual Production Scorecard with Reuse, Turnaround, Cost per Asset, a Chart and a Target Flag