Build an Opportunity and Bid Tracker for Marine Construction

 

Key Topics Covered in This Article

• Why marine construction companies need a managed opportunity and bid pipeline
• How to create a third Google Sheets tab for tracking every lead, RFP, RFQ, bid, and direct outreach opportunity
• Which core details to track, including client, opportunity type, status, submission date, follow-up date, and project value
• How to assign opportunity ownership, set bid or no-bid decisions, and manage proposal requirements
• Why related case studies, equipment, crews, and supporting documents should be linked to each opportunity
• How to organize proposal folders and record outcomes, award values, feedback, and reasons for lost bids
• How win rates, weighted pipeline value, sales cycles, and opportunity sources improve decision-making
• Why weekly reviews and clear next steps help contractors move from reactive bidding to a structured pipeline

Winning larger marine construction contracts requires more than responding to the occasional bid when it appears.

Contractors need a visible, organized pipeline.

Municipal projects, private waterfront developments, marina expansions, dredging contracts, seawall replacements, bridge-support work, and general contractor partnerships often develop over weeks or months. Some opportunities begin with a formal request for proposals. Others start through direct outreach, a referral, an engineering relationship, a prequalification process, or an early conversation with a developer.

Without a system, these opportunities are easy to lose.

A promising lead may be discussed during a phone call and never followed up. A bid may be identified too late for the company to gather the required documentation. A proposal may be submitted, but no one records the next step. A general contractor may request qualifications, and the request may sit in an inbox while the team focuses on current projects.

An opportunity and bid tracker creates a central system for managing this activity.

It should be built as a third sheet within the same Google Sheets workbook used for project history, equipment, crews, and marketing evidence.

The project sheet shows what the company has completed.

The equipment and crew sheet shows what the company can deploy.

The opportunity and bid tracker shows what the company is pursuing next.

Together, these sheets create a practical business-development control system.

Why Marine Contractors Need a Pipeline

Many contractors operate reactively.

They hear about a project, decide whether to bid, rush to collect the required materials, submit a proposal, and then wait for a response. Once that bid is complete, the process starts over with the next opportunity.

This creates several problems.

The company may pursue work that is not a good fit simply because it is available. Strong opportunities may receive too little attention because the team is already overloaded. Follow-ups may be inconsistent. Proposal deadlines may be missed. Management may not know how much potential revenue is moving through the pipeline.

A managed pipeline provides visibility.

It helps the company answer questions such as:

• How many active opportunities are being pursued?
• Which bids are due soon?
• Which prospects need follow-up?
• What is the total potential contract value?
• Which opportunities match the company’s strongest experience?
• Which proposals require case studies or equipment documentation?
• Which clients have not responded?
• Which markets are producing the most opportunities?
• What percentage of submitted proposals are being won?
• Why are opportunities being lost?

These answers help the company make better decisions.

The goal is not simply to submit more bids. It is to pursue the right opportunities with a more disciplined process.

Create a Third Sheet in Google Sheets

Add a third tab to the master workbook and name it something clear, such as:

• Opportunity and Bid Tracker
• Business Development Pipeline
• Proposal Tracker
• Sales and Contract Opportunities

Each row should represent one opportunity.

That opportunity may be:

• A formal invitation to bid
• A request for proposals
• A request for qualifications
• A direct outreach target
• A referred project
• A general contractor partnership
• A municipal capital project
• A private development
• An emergency-response agreement
• A recurring maintenance contract
• A subcontracting opportunity
• A prequalification opportunity

The tracker should include both formal bids and earlier-stage opportunities.

This is important because many valuable contracts are influenced before the official bid is released. A contractor that only tracks public solicitations may miss the relationship-building period that occurs months earlier.

Opportunity Name

The first column should identify the opportunity clearly.

Use a name that allows anyone reviewing the sheet to understand what the project involves.

Examples include:

• Bay Harbor Municipal Dock Replacement
• Waterfront Development Seawall Package
• Port Maintenance Dredging Contract
• Marina Expansion Pile Installation
• Bridge Rehabilitation Marine Support
• County Shoreline Stabilization RFP
• Emergency Marine Response Agreement
• General Contractor Waterfront Prequalification

Avoid vague names such as “City Bid” or “New Project.”

When available, include the formal solicitation number in a separate column.

Useful fields may include:

• Opportunity name
• Bid number
• Internal tracking number
• Project name
• Contract package

A consistent naming system makes it easier to search the tracker and connect opportunities to proposal folders.

Client

The client column should identify the organization issuing or influencing the work.

This may be:

• A municipality
• A county
• A state agency
• A federal agency
• A port authority
• A private developer
• An engineering firm
• A general contractor
• A marina
• A utility
• A property-management company
• An industrial waterfront operator

For subcontracting opportunities, the direct client may be the general contractor even if the owner is a municipality or developer.

It may therefore be useful to track both.

Suggested columns include:

• Client organization
• Project owner
• General contractor
• Engineering firm
• Primary contact
• Contact title
• Contact email
• Contact phone

This helps the company understand who controls the opportunity and who should receive follow-up.

Opportunity Type

The type column should identify how the opportunity entered the pipeline.

Recommended categories include:

• RFP
• RFQ
• Invitation to bid
• Direct outreach
• Referral
• General contractor request
• Prequalification
• Negotiated opportunity
• Existing client expansion
• Emergency request
• Public bid
• Private bid

Use a dropdown list to keep entries consistent.

Opportunity type matters because different opportunities require different strategies.

A public low-bid project may be primarily driven by price, bonding, compliance, and submission accuracy.

An RFQ may place greater emphasis on experience, personnel, case studies, and technical qualifications.

A direct outreach opportunity may require relationship-building and education before a formal scope is developed.

A general contractor request may require a fast capability response, equipment availability, pricing, and proof of similar subcontracting experience.

Tracking the type helps the company evaluate which channels produce the best results.

Status

The status column is the center of the pipeline.

It should show the current stage of each opportunity.

Basic status options may include:

• Identified
• Researching
• Contacted
• Qualification submitted
• Bid decision pending
• Preparing proposal
• Proposal submitted
• Interview scheduled
• Negotiating
• Won
• Lost
• On hold
• Cancelled
• No response

A simpler system may use only:

• Identified
• Contacted
• Proposal submitted
• Won
• Lost

However, larger contractors will usually benefit from more detail.

The status should reflect a clear next step.

For example, an opportunity listed as “Contacted” should also have a follow-up date. An opportunity listed as “Preparing proposal” should have a submission deadline and an assigned owner. A proposal listed as “Submitted” should have a recorded follow-up plan.

An opportunity should never remain in the tracker without a current status and next action.

Date Identified

Add a column showing when the opportunity first entered the pipeline.

This helps measure how long opportunities remain active and whether the company is identifying work early enough.

For formal bids, the date identified may be the date the solicitation was discovered.

For direct outreach, it may be the date the company added the target to the pipeline.

For referrals, it may be the date the referral was received.

This field can later help management analyze sales-cycle length.

A municipal RFP may move from identification to award in 90 days. A private development may remain active for a year before construction begins. A general contractor request may move from initial contact to subcontract award within two weeks.

Understanding these patterns improves forecasting.

Submission Date

The submission date column should record the required deadline for bids, proposals, qualifications, or pricing.

This is one of the most important fields in the tracker.

Missing a deadline may eliminate the company regardless of its qualifications.

Useful date columns may include:

• Questions due
• Pre-bid meeting
• Site visit
• Qualification deadline
• Proposal submission date
• Interview date
• Expected award date
• Expected project start

These dates should be entered as soon as the opportunity is identified.

Conditional formatting can be used to highlight approaching deadlines.

For example:

• Deadlines within seven days can be highlighted.
• Overdue tasks can be marked automatically.
• Opportunities without a submission date can be flagged.

A calendar view or Google Calendar reminders can also support the process, but the tracker should remain the central record.

Follow-Up Date

Every active opportunity should have a follow-up date.

This prevents proposals and conversations from disappearing after the initial contact.

Follow-up may involve:

• Confirming receipt of a proposal
• Asking whether additional information is needed
• Checking the award schedule
• Requesting feedback
• Following up with a general contractor
• Sending relevant project experience
• Scheduling a capability meeting
• Confirming prequalification status
• Revisiting a delayed project
• Maintaining contact with a future client

The follow-up date should be specific.

Avoid entries such as “next week” or “later.” Use an actual date.

It is also helpful to include:

• Last contact date
• Next follow-up date
• Contact method
• Follow-up notes
• Next action

This creates accountability.

The team can filter the sheet by follow-up date and see which opportunities require attention each day or week.

Related Case Studies

Every major opportunity should be linked to the most relevant completed projects.

Add a column labeled:

Related Case Studies

This field should include links to case studies, project profiles, evidence folders, or relevant rows in the project control sheet.

For example, a municipal dock replacement opportunity may link to:

• Public dock replacement completed ahead of schedule
• Marina pile installation completed with zero incidents
• Waterfront utility installation under restricted access

A seawall project may link to:

• Seawall installation under environmental constraints
• Emergency bulkhead stabilization
• Waterfront excavation and concrete wall construction

The objective is not to attach every case study the company has.

The objective is to identify the most relevant proof.

This gives the proposal team an immediate starting point. Instead of searching through old files, they can open the opportunity row and access the strongest project examples.

Link Equipment and Crew Capability

The tracker should also connect opportunities to the equipment and personnel required.

Useful columns include:

• Required equipment
• Proposed equipment
• Equipment availability confirmed
• Required crew
• Proposed superintendent
• Key personnel
• Availability confirmed
• Mobilization requirements

This allows the company to test capacity before committing to the work.

For example, if a dredging opportunity requires a specific dredge and support tug during a four-month period, the team can verify whether those assets are available.

If a proposal requires a superintendent with municipal seawall experience, the company can identify the best qualified person and confirm availability.

This prevents the business-development team from pursuing work that operations cannot realistically support.

Track Opportunity Value

Add columns for potential value.

These may include:

• Estimated contract value
• Expected subcontract value
• Estimated gross margin
• Probability of win
• Weighted pipeline value

Weighted pipeline value is calculated by multiplying the estimated opportunity value by the probability of winning.

For example:

• Estimated value: $2,000,000
• Win probability: 30%
• Weighted value: $600,000

This does not mean the company will receive $600,000. It provides a more realistic way to evaluate the pipeline than simply adding the full value of every opportunity.

Probability ranges may be assigned by stage.

For example:

• Identified: 10%
• Contacted: 20%
• Preparing proposal: 35%
• Proposal submitted: 50%
• Interview or negotiation: 70%
• Verbal award: 90%
• Won: 100%

These percentages should be adjusted based on the company’s actual experience.

Assign an Opportunity Owner

Every opportunity should have one person responsible for moving it forward.

Add a column labeled:

• Opportunity owner
• Proposal lead
• Business-development lead
• Responsible person

This person may be responsible for:

• Researching the project
• Coordinating the bid decision
• Collecting qualifications
• Managing the proposal schedule
• Contacting the client
• Confirming equipment and crew availability
• Organizing pricing
• Scheduling follow-ups
• Updating the tracker

Without ownership, opportunities often stall.

Several people may contribute, but one person should be accountable for the next step.

Add a Bid Decision

Not every opportunity should be pursued.

Add a column for:

Bid / No-Bid Decision

Possible options include:

• Bid
• No bid
• Pending review
• Partner only
• Monitor
• Future opportunity

The company should evaluate whether the opportunity fits its strategy and capacity.

Bid-decision criteria may include:

• Relevant experience
• Client relationship
• Project size
• Location
• Equipment availability
• Crew availability
• Schedule fit
• Bonding requirements
• Insurance requirements
• Profit potential
• Competition
• Payment risk
• Strategic value
• Probability of winning

A no-bid decision is not necessarily a failure.

It may protect the company from spending time on an opportunity that is poorly suited to its capabilities or resources.

A disciplined pipeline includes both pursuit and rejection decisions.

Track Proposal Requirements

Marine construction proposals may require substantial documentation.

The tracker can include fields for:

• Bonding required
• Insurance limits
• Bid bond
• Performance bond
• Payment bond
• Safety records
• Financial statements
• Equipment list
• Key-person resumes
• Project references
• Certifications
• MBE, DBE, or local participation requirements
• Site visit required
• Pre-bid meeting required

A proposal checklist link can be added to each opportunity row.

This helps the team identify missing requirements early.

For example, if a project requires a bid bond, the company should confirm bonding capacity before investing heavily in proposal preparation.

If a general contractor requires a specialized safety qualification, the company should know whether it can meet that requirement.

Link the Proposal Folder

Each opportunity should have its own Google Drive folder.

A recommended folder structure might include:

• Solicitation
• Addenda
• Questions
• Drawings
• Specifications
• Pricing
• Case studies
• Equipment
• Personnel
• Safety
• Submission files
• Correspondence
• Award information

Add a column labeled:

Opportunity Folder Link

This allows anyone reviewing the tracker to access the complete bid file with one click.

The folder name should match the opportunity name used in the tracker.

Consistent naming reduces confusion and makes the system easier to maintain.

Record the Result

When an opportunity is won or lost, update the status and record the result.

Useful columns include:

• Final status
• Award date
• Award value
• Winning bidder
• Final price
• Loss reason
• Client feedback
• Next opportunity
• Debrief completed

Loss reasons may include:

• Price
• Qualifications
• Bonding
• Schedule
• Equipment availability
• Relationship
• Incomplete submission
• Project cancelled
• Client selected incumbent
• No award
• Unknown

Avoid treating every lost bid as simply “price.”

The company should request feedback when possible.

A lost opportunity can still provide valuable information about the market, competitors, client expectations, and proposal quality.

Measure Win Rate

The tracker allows the company to calculate key business-development metrics.

These may include:

• Opportunities identified
• Opportunities pursued
• Proposals submitted
• Contracts won
• Contracts lost
• Overall win rate
• Win rate by project type
• Win rate by client type
• Win rate by region
• Win rate by opportunity source
• Average contract value
• Average sales cycle
• Total pipeline value
• Weighted pipeline value

For example, the company may discover that it wins 40% of direct general contractor opportunities but only 8% of open public bids.

It may find that marina projects have a strong win rate, while dredging opportunities consume significant proposal time with limited results.

These insights help management focus resources.

Review the Pipeline Weekly

The opportunity tracker should be reviewed on a regular schedule.

A weekly review may take 20 to 30 minutes.

During the review, the team should ask:

• Which deadlines are approaching?
• Which opportunities need follow-up?
• Are any proposals at risk?
• Is equipment availability confirmed?
• Are the right case studies linked?
• Has a bid decision been made?
• Are client contacts current?
• Have any projects been delayed or cancelled?
• Which opportunities should be removed?
• Where should the company focus next?

The review should lead to specific actions.

Each active opportunity should leave the meeting with a clear owner, status, and next step.

Use Filters for Fast Pipeline Management

Google Sheets filters make the tracker easier to use.

Teams can filter by:

• Status
• Submission date
• Follow-up date
• Opportunity type
• Client
• Project type
• Region
• Opportunity owner
• Estimated value
• Win probability
• Bid decision
• Equipment requirement

For example, a proposal manager can filter for submissions due in the next 14 days.

A business-development manager can filter for opportunities that have been contacted but have no proposal yet.

An operations manager can filter for bids requiring crane barges during a specific quarter.

A company owner can filter for opportunities valued above a certain amount.

The tracker becomes a decision-making tool rather than a static list.

Move From Reactive Bidding to a Managed Pipeline

Reactive bidding puts the company in a constant rush.

Opportunities are discovered late. Deadlines control the schedule. Proposal materials are gathered from scratch. Follow-ups are inconsistent. Management lacks visibility into future work.

A managed pipeline changes the process.

The company identifies opportunities earlier, evaluates fit, assigns responsibility, confirms capacity, links relevant proof, tracks deadlines, and follows up consistently.

This creates better preparation.

It also allows the company to become more selective.

Instead of bidding on whatever appears, management can prioritize projects that align with the company’s experience, equipment, crews, location, margins, and growth goals.

Why This Works

An opportunity and bid tracker creates structure around business development.

It helps the company see what is available, what is active, what is due, and what requires attention.

It connects opportunities to the project case studies, equipment, crews, and documentation needed to pursue them effectively.

It also creates accountability.

Each opportunity has a status, a deadline, a follow-up date, an owner, and a next step.

That reduces the chance that valuable work will be forgotten or handled too late.

Most importantly, the tracker turns bidding into a measurable process.

The company can analyze where opportunities come from, which types of work it wins, which clients respond, why bids are lost, and where resources should be focused.

Build a Repeatable Business-Development System

Larger marine construction contracts are rarely won through a single last-minute action.

They are usually the result of early identification, disciplined qualification, relevant proof, accurate capacity planning, strong proposals, and consistent follow-up.

A third Google Sheet can help manage that entire process.

Create one row for every opportunity. Track the opportunity name, client, type, status, submission date, follow-up date, related case studies, equipment needs, crew requirements, value, and owner.

Link every row to its supporting proposal folder and update the result when the opportunity is won or lost.

Over time, this becomes more than a bid list.

It becomes the company’s managed pipeline.

That pipeline helps the business move away from reactive bidding and toward a more strategic, predictable, and scalable contract-acquisition process.