With Bid Board Pro, subcontractors can import their bidding history so you can take full advantage of Bid Board Pro’s full suite of bid analytics tools.
The bid analytics tools in Bid Board Pro allow you to track hit rates, team performance and overall business health in real-time.
Free trials and Bid Board Pro customers
For Bid Board Pro trials, we offer a limited bid import service so that you and your team can more easily evaluate if Bid Board Pro is right for you. We recommend selecting up to 100 of the most recent bids you’re tracking in your bid log today. This will ensure a quick import and allow you to start using the analytics tools right away during your trial period.
For Bid Board Pro customers, we offer a full bid import at anytime.
Please contact your Account Executive or click here to reach our sales team for more information on how to get started.
Preparing your spreadsheet to import your bids
There are five steps you need to take to get your bid spreadsheet ready for import:
- Get your import template Google spreadsheet from your BuildingConnected rep
- Add your current bid tracking spreadsheet to the import template spreadsheet for reference
- Map your data to match the correct format
- Fix any errors that appear in the template
- Validate errors to ensure they are fixed.
Step 1: Get your Google spreadsheet from your sales rep
Your sales rep will add you as a collaborator to a Google spreadsheet. Using Google instead of Microsoft Excel means you and your account executive can easily collaborate. Check your inbox for an email notification. You can also add your colleagues by using the share button in the top right corner.
Step 2: Add your spreadsheet for reference
Copy and paste your current bid tracking spreadsheet into the tab labeled “Scratch worksheet (paste your spreadsheet here)”. This tab is blank and will be used for you to reference your original spreadsheet.
Step 3: Map your data to the right format
BuildingConnected supports a wide variety of data types, but it needs to be formatted correctly to be successfully imported. Use this section as a guide to make sure your data is ready for the import.
To make this easier, we have an “Import Sheet” tab in the spreadsheet that has special formatting rules that ensures your data is ready for importing. The easiest way to add data to the “Import Sheet” is to use the formulas and drag down to apply to the entire column.
Getting Data from your Reference Spreadsheet to your Import Spreadsheet.
- Type “=” into the first cell under the header (cell A2) of a field in the import spreadsheet. These categories are for general information you’d have on your bid sheet, such as project name or opportunity number.
- Click on scratch spreadsheet and find the field that matches up. Click on the first cell you want to copy and hit enter.
- Go back to your import spreadsheet and drag that cell down. Your data will populate into our template. Green means the data is formatted correctly, errors will show up in red.
Step 4: Fix any errors
If you have questions about any errors, ask your account executive and they can help you get them resolved.
Once your data is formatted correctly, it’s ready for import! Reach out to your account rep and they will take it from there.
How to ensure fields are correct
Selecting which fields to import into Bid Board Pro is important because it will determine what you are able to report. Review the Field Glossary section below to see all the fields available for import.
If you have any questions on which fields you should be including, please reach out to your Account Executive or Customer Success Manager.
In order for the import to be successful, we require the fields below. Each line in your spreadsheet needs to include the following:
- Project Name
- Your Owning Office
“Owning office” can be a company division or a regional branch. Work with your sales rep to make sure this is filled out correctly. Use the name found in your BuildingConnected settings.
If you are importing bids you have submitted, we also require:
- Either a due date or a submitted date
- Either an assignee or a “Submitted by”
This is the data about the project in general. We will add your bid information afterward. These fields are technically optional, but we recommend you provide as much data as possible to get the most out of our analytics and reporting tools, and so Bid Board is the most useful tool it can be for you.
- Opportunity number
- Full street address
- Client company name
- Client email address
- Assigned user
- Date Due
- Property owner
- ROM $
- Project size (sq ft)
- Date invited
- Market sector
- Custom tags
None of these are required, but we strongly recommend you include client email address.
Providing client information helps us keep our network of construction professionals accurate, so users like you always have the most up-to-date contact information on all your clients.
Make sure the client's name is complete and unambiguous. If you don’t have the client's name, leave it blank. If you bid to multiple clients, make a new row for each client. We will mark the ones that won later.
Bid information fields:
BuildingConnected tracks each bid and any revisions you submit or report on a project. There are some rules in the data here to make sure this is clean and reliable.
- Proposal or budget: Indicate whether the bid was a proposal or a budget.
- Assigned user field: Add the full name of whoever was assigned to the project. If that employee no longer works there, add an executive, manager, or owner. You can add the former employee's name to “Notes or Tags”.
- Submitted by: Allows you to track if the estimator assigned to the project and the person who sent in the proposal is different
- Project Status: For any project you bid, we require a few extra fields. In the below example, see that the “declined” project is green and there are no errors. The next row was “Bid” and so we need to know a few things about it.
- Due date: Indicate when your bid is due.
- Date proposal submitted: Provide a date on which the bid was sent. We’ll use the “Due Date” field if you don’t have a different date.
- Proposal amount: You do not need to provide a proposal amount, but if you do it must be a valid currency amount. If you bid for multiple scopes of work on the same project, enter each bid as a separate row.
- Submitted by: Each bid needs a user to send it. Add the employee who sent or submitted the bid to the “Submitted by” column. If the “Assigned user” is filled out and was also the sender, leave “Submitted by” blank.
- Property owner: Indicate the property owner or client.
Your data should look something like this when you’re done.
Have other fields you need to track? There are two good areas to do this:
- Notes: This is a free text field. This is helpful because it provides you the flexibility to put in whatever you want.
- Custom tags: Tags are comma-separated items. You can build reports using the “Custom tags” field which makes it powerful. For example, if you also have a salesperson on a project you can add this person’s name to “Custom tags” to quickly make reports off them.