Build Your Project and Marketing Control Sheet

 

Key Topics Covered in This Article

• How to build a master Google Sheet that connects project performance, equipment, case studies, marketing, and proposals
• Why each row should represent one marine construction project or major job
• Which core project details to track, including client, project type, location, scope, and status
• How planned versus actual schedule, budget, delays, and safety data provide measurable proof of performance
• Why contractors should document the equipment and crews used on each project
• How case study links, photos, testimonials, and completion documents create an accessible capability database
• How proposal and marketing tracking reveals which projects help win new work
• Why filters and standardized dropdowns make project information easier to search, compare, and reuse

Marine construction companies complete valuable work every day, but much of that experience is often scattered across emails, folders, bid files, accounting systems, employee phones, and old project documents.

One project manager may remember which crane barge was used on a seawall job. Another employee may know where the completion photos are stored. Someone in estimating may remember that the project finished ahead of schedule, while the safety manager may have the incident data in a separate file.

The problem is not usually a lack of experience. It is a lack of organized access to that experience.

A project and marketing control sheet solves this problem by creating one central record of the company’s completed and ongoing work.

This can be built in Google Sheets and maintained as a practical capability database. Each row represents one project or major job. Each column captures a specific piece of information that may later be needed for marketing, proposals, estimating, qualification packages, internal planning, or business development.

The goal is not to create a complicated software system. The goal is to make your company’s experience searchable, measurable, and reusable.

When a municipality, developer, engineer, or general contractor asks whether you have completed a similar scope, your team should be able to answer quickly with specific proof.

What the Master Control Sheet Should Track

The master sheet should bring together four areas that are often managed separately:

• Projects and outcomes
• Case studies
• Equipment used
• Marketing and proposals

These categories connect operations with business development.

Project teams generate the experience. Marketing and estimating teams use that experience to win future work. A well-designed sheet ensures that information moves from completed projects into proposals, capability statements, website pages, and client presentations.

Without this system, valuable project history may be forgotten or underused.

A strong project may be completed successfully, but if no one records the scope, results, equipment, and photos, it may never become a case study. It may not be included in future proposals, even when it closely matches a new opportunity.

The control sheet prevents that loss.

Use One Row for Each Project or Major Job

Each row in the sheet should represent one complete project, contract, or major work package.

Examples may include:

• Municipal Dock Replacement – Bay Harbor
• Seawall Construction – Waterfront Development
• Marina Piling Installation – Coconut Grove
• Maintenance Dredging – Industrial Canal
• Shoreline Stabilization – Public Park
• Emergency Bulkhead Repair – Commercial Terminal
• Marine Demolition – Bridge Rehabilitation Project
• Floating Dock Installation – Private Marina

The naming format should be clear and consistent.

A useful format includes the project type and location or client reference. This makes the project easier to identify when filtering or searching the sheet.

Avoid vague project names such as “Dock Job” or “Project 2025-14.” Internal job numbers can still be included in a separate column, but the project name should immediately tell the reader what the work involved.

Consistency matters because the sheet may eventually contain hundreds of projects.

Project Name

The first core column should be the project name.

This should be the same name used in proposals, internal folders, and project documentation whenever possible.

Examples include:

• Municipal Dock Replacement – Bay Harbor
• Seawall Construction – Waterfront Development
• Pile Driving Support – Port Expansion
• Emergency Dredging – Marina Entrance Channel

A clear project name improves internal communication and makes the database easier to search.

You may also add a separate project number column if your company uses job codes. This allows accounting, operations, and marketing records to be connected.

Client

The client column identifies who hired the company.

This may be:

• A municipality
• A state or federal agency
• A private developer
• A general contractor
• An engineering firm
• A marina
• A port authority
• A utility company
• A waterfront property owner
• An industrial facility

Recording the client helps the company analyze which client categories generate the most work.

It also makes it easier to find relevant experience for a new opportunity.

For example, if a city issues a request for qualifications, your team can filter the sheet to show other municipal projects. If a large general contractor requests marine support, you can identify similar GC partnerships.

The client column may also include the primary contact, but contact information is usually better stored in separate columns.

Useful additions include:

• Client contact name
• Contact title
• Email
• Phone number
• Reference approved
• Permission to publish project

The last two fields are especially important. Some clients may allow the company to name the project publicly, while others may require confidentiality.

Project Type

The project type column should use standardized categories.

Examples include:

• Dock construction
• Piling installation
• Seawall construction
• Bulkhead repair
• Dredging
• Shoreline stabilization
• Marine demolition
• Bridge support
• Marina construction
• Underwater repair
• Environmental restoration
• Emergency marine response

Standardized categories make filtering much easier.

If employees enter different terms for the same work, the database becomes less useful. For example, one person may enter “pile driving,” another may enter “piling,” and another may enter “dock piles.”

A dropdown list can prevent this problem.

Google Sheets allows you to create data-validation dropdowns so users select from approved project types. This improves consistency while still allowing additional notes in a separate field.

For projects involving multiple scopes, you can either create a primary project type and secondary project type column or allow multiple selections through a controlled format.

Location

The location column should identify where the work occurred.

This may include:

• City
• County
• Port
• Waterway
• State
• Region

A project located at a major port may be recorded differently from one completed at a private waterfront property.

The level of detail should match how your company sells its services.

A local contractor may only need city and county. A regional contractor may want city, state, and operating region. A company working across multiple coastlines may also track the nearest mobilization point or service territory.

Location data helps answer several strategic questions:

• Where has the company completed the most work?
• Which regions generate repeat clients?
• Where does the company already have strong project experience?
• Which areas may support future expansion?
• Which projects demonstrate familiarity with a specific port or waterway?

Location also strengthens proposals. Buyers often prefer contractors with experience in the same region because they understand local site conditions, permitting expectations, weather patterns, and mobilization requirements.

Scope Summary

The scope summary should provide a short description of the work performed.

It does not need to include every technical detail. It should be long enough to explain what the company was responsible for.

For example:

“Removed the existing timber dock, installed concrete piles, constructed a new fixed dock, added utilities, and restored the surrounding shoreline.”

Another example might be:

“Provided crane barge, tug support, pile-driving equipment, and marine crews for the installation of steel pipe piles supporting a new waterfront structure.”

A strong scope summary should answer:

• What was built, repaired, removed, or installed?
• What services did the company provide?
• What major equipment or methods were used?
• What portion of the project was the company responsible for?

This field can later be used as the starting point for case studies, proposals, website content, and qualification packages.

Keep the wording factual and specific. Avoid overly promotional language in the database itself.

Project Duration: Planned Versus Actual

Schedule performance is one of the most valuable metrics to track.

Create separate columns for:

• Planned start date
• Actual start date
• Planned completion date
• Actual completion date
• Planned duration
• Actual duration
• Schedule variance

This information helps demonstrate whether the company consistently completes projects on time.

A project that finished five days early is stronger proof than a general claim that the company is reliable.

Schedule information also supports internal analysis. Management can identify which project types are most likely to experience delays and which crews or methods produce the best results.

When delays occur, add a delay-reason column.

Possible reasons may include:

• Weather
• Client change
• Permit delay
• Material delay
• Equipment issue
• Unforeseen site condition
• Environmental restriction
• Third-party scheduling conflict

Separating contractor-controlled delays from external delays provides a more accurate view of performance.

Budget: Estimated Versus Actual

Cost performance should also be tracked when appropriate.

Useful columns include:

• Estimated project value
• Final contract value
• Estimated internal cost
• Actual internal cost
• Change-order value
• Estimated margin
• Actual margin
• Budget variance

Some companies may limit access to financial columns. Google Sheets permissions can be used to protect sensitive data or create a separate management-only version.

Even if detailed cost information is restricted, marketing teams should know whether the project was completed within the approved budget and whether significant change orders occurred.

This information can support statements such as:

• Completed within budget
• Reduced costs through alternative means and methods
• Avoided additional mobilization
• Managed owner-directed changes without affecting the final schedule

Financial data also helps management identify which project types are most profitable.

A high-revenue project is not always a high-margin project. The control sheet can reveal which services generate the strongest financial results.

Safety Incidents

Safety should have dedicated columns rather than being buried in project notes.

These may include:

• Total work hours
• Recordable incidents
• Lost-time incidents
• Environmental incidents
• Near misses
• Safety status
• Site-specific safety requirements

For many projects, the strongest result will be zero recordable incidents.

That should be documented.

A project profile that states the company completed several thousand work hours without a recordable incident is more credible than simply saying safety was a priority.

The sheet can also track whether the project required specialized safety procedures, such as:

• Over-water work
• Commercial diving
• Crane operations
• Confined-space entry
• Night operations
• Active vessel traffic
• Contaminated material handling
• Environmental monitoring

This information can later be used to match past experience with future project requirements.

Delays

Add a column for total delay days and another for the primary delay reason.

Tracking delays helps the company distinguish between schedule problems and unavoidable external conditions.

For example, a project may have experienced 10 delay days due to owner-requested design changes. Another may have lost six days to severe weather.

Without context, a delayed completion date may appear negative. With clear documentation, the company can explain what happened and how the team responded.

You may also include a mitigation summary.

This can describe actions such as:

• Added a second crew
• Extended work shifts
• Mobilized backup equipment
• Resequenced activities
• Coordinated revised access
• Accelerated material delivery

These details can become valuable proposal content because they demonstrate problem-solving ability.

Project Status

Use a standardized status column with dropdown options such as:

• Planned
• Bidding
• Awarded
• Mobilizing
• Ongoing
• Substantially complete
• Completed
• On hold
• Cancelled

This allows managers to quickly see where each project stands.

A separate marketing-status column should track whether the project has been converted into business-development material.

Options may include:

• Documentation needed
• Photos collected
• Case study drafted
• Case study approved
• Published on website
• Used in proposals
• Reference available

Separating operational status from marketing status is important.

A project can be completed operationally but still require photos, metrics, approvals, or a written case study before it becomes useful for marketing.

Equipment Used

Create columns that document the major equipment used on each project.

This may include:

• Crane barges
• Deck barges
• Spud barges
• Tugboats
• Push boats
• Excavators
• Pile-driving hammers
• Dredging equipment
• Workboats
• Survey vessels
• Pumps
• Diving systems

You may use one equipment-summary field or separate columns for asset categories.

A more advanced system can include asset IDs linked to a separate fleet sheet.

For example, the project row may identify Barge 104, Crane 22, and Tug Maria. The fleet sheet can then contain the specifications, maintenance status, photos, and availability of those assets.

Tracking equipment by project helps answer questions such as:

• Which equipment has supported similar scopes?
• Which assets are used most frequently?
• Which projects demonstrate a specific crane or barge capability?
• What equipment should be featured in a proposal?
• Which assets have generated the strongest returns?

This also helps connect marketing claims with actual operational history.

Case Study Status and Link

Every strong project should be evaluated as a potential case study.

Add columns for:

• Case study needed
• Case study drafted
• Internal review completed
• Client approval received
• Case study published
• Case study link

The case study link may point to:

• A Google Doc
• A shared project folder
• A PDF
• A website page
• A presentation
• A proposal example

This gives employees immediate access to the most useful documentation.

You may also include links to:

• Project photos
• Safety records
• Completion letters
• Client testimonials
• Drawings
• Schedule reports
• Final project reports

The objective is not to place every document directly into the spreadsheet. The sheet serves as the index that points users to the correct supporting material.

Marketing and Proposal Tracking

The control sheet should also record where each project has been used.

Helpful columns include:

• Used in capability statement
• Used in municipal proposal
• Used in GC proposal
• Used on website
• Used in presentation
• Used in social content
• Used in qualification package
• Proposal win associated with project

This reveals which projects are doing the most work for the company’s marketing.

Some case studies may appear repeatedly because they show strong results, attractive photography, or highly relevant experience. Others may be underused simply because employees do not know they exist.

Tracking usage makes the company’s marketing more intentional.

You can also record which proposals used a project and whether those proposals were successful.

Over time, this may reveal that certain project examples improve the company’s win rate for specific contract types.

Use Filters for Fast Decisions

Filters are one of the most useful features in Google Sheets.

Users should be able to filter the database by:

• Project type
• Client category
• Location
• Status
• Equipment used
• Contract value
• Completion year
• Safety performance
• Case study status
• Proposal usage

For example, an estimator preparing a dock-replacement proposal could filter for completed dock projects in the same region with zero safety incidents.

A business-development manager targeting port work could filter for port projects involving crane barges and pile driving.

A marketing employee could filter for completed projects that still need case studies.

The sheet becomes more valuable as more projects are added because the company can access years of experience in seconds.

Why This Matters

A project and marketing control sheet replaces vague claims with structured performance data.

Instead of saying, “We have completed many seawall projects,” the company can identify the exact projects, locations, scopes, durations, equipment, and results.

Instead of searching through folders for photos and completion records, employees can open the project row and follow the relevant links.

Instead of rewriting proposal content from memory, teams can use approved case studies and verified metrics.

The system provides:

• Structured performance data
• Immediate access to proof
• Stronger proposal inputs
• Better internal coordination
• Faster qualification responses
• More consistent marketing
• Clearer strategic insights

Most importantly, it becomes the company’s capability database.

The sheet shows not only what the company says it can do, but what it has already done.

That distinction matters in marine construction, where buyers are evaluating risk, capacity, and reliability.

A well-maintained control sheet allows the company to present its experience accurately and quickly. It connects operations, estimating, management, and marketing around one shared source of truth.

The result is stronger proposals, better case studies, faster decisions, and a more credible path to larger contracts.