QueryBob - E-Rate Data Source

Company:
User ID:
Password:
Destination

School Access Dashboard

Consultants may wish to offer this service, which is branded with the consultant's logo, to the schools/districts/libraries they serve. Entity Users can view their Request & Award histories, Budget/Spending data, etc.

You can offer your clients unlimited access to this tool for $5 per month (billed annually). Please contact QueryBob for full details and terms of this feature.

News Update 3/1/2023 -- FY 2023 470 Window Is Closed

The FY 2023 FCC Form 470 application filing window closed on February 28, 2023, with 21,622 applications certified in-window. (In FY 2022, there were just over 22,000 470s filed.) Some 470s filed after the closing of the window may still be approved, if the filing entity had a valid reason for filing late. NOTE: Form 470 applications are viewable in QueryBob the day after they are filed; however, depending on the certification time and other factors, application and RFP links may not be made available by USAC until an additional day after filing.

The Funding Year (FY) 2023 FCC Form 471 application filing window opened on Wednesday, January 18, 2023, at 12:00 noon ET and will close on Tuesday, March 28, 2023, at 11:59 p.m. ET.

QueryBob software is designed to support Service Providers, Consultants, State Coordinators, and Manufacturers. We welcome ideas on ways that QueryBob can better meet your E-Rate needs.

Always feel free to contact us at anybob@querybob.com with any questions or training needs!

E-Rate/ECF Stats as of 03/22/2023

FY 2022 Funding Wave 48 was released on March 16th for $131,292 – 2 FRNs were Funded, and 1 were Cancelled or Denied. As of March 22nd, 1,499 FRNs remained Pending.

FY 2021 Funding Wave 73 was released on March 8th for $0 – 0 FRNs were Funded, and 4 were Cancelled or Denied. As of March 22nd, 1,186 FRNs remained Pending.

In ECF Window 1, 20,230 Funding Requests were submitted for a total of $5,137,258,847.31. Of these, 6,908 ($1,512,565,744.36) were for Services, and 13,322 ($3,624,693,102.95) were for Equipment. The most recent funding wave (30) was released on March 13th for $455,590.68 – 13 FRNs were Funded, and 163 were Cancelled or Denied. As of March 22nd, 4,685 FRNs for $1,038,408,439.75 remained Pending.

In ECF Window 2, 6,476 Funding Requests were submitted for a total of $1,301,730,785.62. Of these, 1,517 ($369,328,768.66) were for Services, and 4,959 ($932,402,016.96) were for Equipment.

Year	470s	FRNs	Cat 1 FRNs	Cat 2 FRNs	Last Wave	Funded	Pending	Cancelled	Denied	Cat 1 Committed	Cat 2 Committed	Cat 1 Disbursed	Cat 2 Disbursed
2023	21,910	28,240	19,504	8,736	0	0	28,240	0	0	0	0	0	0
2022	22,058	56,460	35,413	21,047	48	52,565	1,499	1,846	550	1,516,768,925	1,322,934,030	435,867,125	287,339,625
2021	24,434	59,946	36,221	23,725	73	54,384	1,186	3,587	789	1,535,175,178	1,115,763,559	1,188,891,262	729,721,289
2020	26,931	78,545	41,014	37,531	112	72,481	417	4,741	906	1,580,462,108	928,158,046	1,272,904,411	646,663,837
2019	25,705	70,123	37,037	33,086	110	64,445	418	4,384	876	1,594,093,575	773,691,379	1,333,078,543	666,869,492
2018	26,915	74,515	49,100	25,415	112	67,104	767	4,822	1,822	1,762,047,406	527,118,913	1,531,552,332	466,956,571
2017	31,193	99,292	73,302	25,990	91	89,090	658	6,210	3,334	1,779,513,431	588,087,410	1,487,335,600	516,075,890

Recent E-Rate Funding Waves 2022
Wave #	Wave Date	Funded Amount	Funded Count	Not Funded Count
48	03/16/2023	$131,292	2	1
47	03/09/2023	$5,006,984	74	5
46	03/02/2023	$7,602,683	18	12
45	02/23/2023	$8,118,433	40	7
44	02/16/2023	$2,355,184	40	11

Recent E-Rate Funding Waves 2021
Wave #	Wave Date	Funded Amount	Funded Count	Not Funded Count
73	03/08/2023	$0	0	4
72	02/24/2023	$238,757	33	1
71	02/01/2023	$464,557	2	0
70	01/04/2023	$1,827,544	83	2
69	12/07/2022	$15,732,538	47	0

ECF Funding Waves
Wave #	Wave Date	Total Funded ($)	Services Funded ($)	Equipment Funded ($)	Total Funded (#)	Services Funded (#)	Equipment Funded (#)	Total Not Funded (#)	Services Not Funded (#)	Equipment Not Funded (#)
30	03/13/2023	$455,590.68	$124,534.68	$331,056.00	13	7	6	163	55	108
29	02/28/2023	$374,991.52	$87,761.52	$287,230.00	8	4	4	29	10	19
28	01/30/2023	$535,186.00	$114,925.90	$420,260.10	17	6	11	71	26	45
27	12/05/2022	$619,641.72	$115,213.44	$504,428.28	20	8	12	57	24	33
26	11/14/2022	$5,019,830.67	$3,690,146.67	$1,329,684.00	28	17	11	14	7	7
25	10/31/2022	$66,055.77	$0.00	$66,055.77	2	0	2	2	0	2
24	10/18/2022	$165,255.76	$49,265.76	$115,990.00	4	2	2	2	2	0
23	10/04/2022	$730,058.26	$321,482.08	$408,576.18	15	7	8	7	4	3
22	09/20/2022	$774,702.33	$233,766.00	$540,936.33	4	1	3	2	2	0
21	08/23/2022	$4,428,052.86	$3,615,802.86	$812,250.00	11	8	3	14	10	4
20	08/09/2022	$17,871,721.34	$10,305,747.52	$7,565,973.82	73	36	37	41	14	27
19	07/25/2022	$22,382,705.35	$8,902,512.42	$13,480,192.93	142	63	79	78	38	40
18	07/11/2022	$36,152,299.50	$11,128,168.12	$25,024,131.38	389	128	261	107	30	77
17	06/28/2022	$31,339,707.30	$7,481,156.61	$23,858,550.69	368	113	255	97	29	68
16	06/07/2022	$58,478,774.70	$12,447,911.08	$46,030,863.62	589	183	406	169	64	105
15	05/17/2022	$84,552,563.71	$24,753,635.71	$59,798,928.00	559	170	389	150	73	77
14	05/04/2022	$103,814,915.83	$32,584,415.73	$71,230,500.10	775	260	515	227	86	141
13	04/19/2022	$87,305,580.45	$39,289,861.75	$48,015,718.70	442	166	276	236	102	134
12	03/23/2022	$145,781,850.75	$59,631,647.64	$86,150,203.11	750	322	428	189	65	124
11	03/07/2022	$244,540,681.26	$66,098,349.87	$178,442,331.39	1,256	469	787	255	81	174
10	02/23/2022	$161,708,329.89	$35,107,964.26	$126,600,365.63	1,060	361	699	152	70	82
9	02/08/2022	$220,782,312.02	$54,976,131.25	$165,806,180.77	1,003	347	656	78	30	48
8	01/25/2022	$286,543,756.48	$54,651,482.14	$231,892,274.34	1,770	505	1,265	264	90	174
7	01/10/2022	$403,396,473.99	$137,857,282.76	$265,539,191.23	2,006	591	1,415	135	58	77
6	12/20/2021	$625,793,726.03	$167,999,194.85	$457,794,531.18	3,339	971	2,368	191	76	115
5	11/23/2021	$207,815,693.12	$45,872,649.17	$161,943,043.95	1,549	578	971	145	47	98
4	11/08/2021	$452,543,174.96	$135,106,388.56	$317,436,786.40	2,084	771	1,313	128	62	66
3	10/25/2021	$517,184,703.44	$216,748,538.44	$300,436,165.00	2,622	995	1,627	143	67	76
2	10/12/2021	$1,261,556,022.35	$347,487,682.92	$914,068,339.43	5,774	2,105	3,669	233	79	154
1	09/24/2021	$1,297,754,285.78	$171,652,175.23	$1,126,102,110.55	5,862	1,837	4,025	235	52	183

Welcome to QueryBob

QueryBob provides easy access to E-Rate data via rich filtering tools designed for Service Providers, E-Rate Consultants, Manufacturers, and State E-Rate Coordinators.

Our databases are updated daily with new information directly from USAC. 470 Service Request details are uniquely interfaced with all relatable data from the 471 Funding Requests, to provide an integrated, filterable picture of current requests, past awards, contract expirations, budget limits, invoice line item details and disbursement history.

Information can be viewed through our dashboard and can be e-mailed, reported, exported, or mapped. We can also provide customized interfacing with your CRM - such as Salesforce; custom data views and custom reports to meet any special requirements that you may have.

We at QueryBob are not E-Rate Consultants, but we provide E-Rate data and assistance in understanding and filtering that data to help your organization successfully compete in the E-Rate world. If you are new to E-Rate we strongly suggest making use of the training materials available from the company administering the program for the FCC: Universal Service Administration Company (USAC) — Schools and Libraries Division (SLD). Contact us today to get started with QueryBob!

Please click the tab menus above to learn more about us and how we can help you!

Some of QueryBob's great features for Service Providers include:

470 Leads Process:

Filtered searching for Form 470s (leads) to match applicant requests with the products and services you sell. Queries may filter by E-Rate Category, location, size, RFPs, free-form keywords, or ad hoc searches – and many other factors.
Daily e-mail delivery of leads to sales teams. Form 470s posted in the prior 24 hours are delivered each morning as a list of who filed and for what services. The e-mail includes a link for each lead that points back to QueryBob's Form 470 detail for deeper review, such as available budgets and a snapshot of the applicant's 471 History – including contract expiration dates.
Pre-qualify Leads by logging into our webtools. Don't spin your wheels with every long-shot bid. Qualify requests by researching the requesting Entity.
- Our Entity Analysis page allows you to see the entire E-Rate history of a given Entity on a single page, giving you a more comprehensive view into an Entity's purchases and status.
- View Category 2 Budget information to check on a prospect's available funds. QueryBob updates data from USAC every night, so as FRNs move through the approval process, the Budget information is automatically refreshed.
- Use our Mapping features to check prospects' proximity to your network. *
- Review Line Item Data (available since FY2015), where you can see exactly what a prospect's current contract provides and what they pay for it.
Integration of 470 leads to CRMs such as Salesforce. *

FRN Status Information:

Daily E-Mail FRN Alerts are sent when funding requests of interest to you are updated at USAC. These may be based upon your SPIN(s). Or the BENs of your customers. Or the 470s you bid on, etc.
471 PDF reports to view selected awards by Service Provider for FRN or Line Item Data, which can be sorted in a variety of sequences and subtotaled on breaks. Reports may be sent by e-mail automatically either daily or weekly.
471 Query Export Wizards for FST and Item 21 data help you export query results. You select and arrange export fields as desired for prospecting or analysis. These exported query results may include FRN, FST, Line Item, and other related data points. The FST Export may also be sent by e-mail automatically either daily or weekly.
FRN Monitor (optional) is a powerful tracking tool useful to those managing large numbers of awards. The Monitor sends out an array of e-mail alerts about significant events in the funding process – including impending deadlines (last date to invoice, Form 486 is due, etc.), status changes, and disbursements – to assist your Sales Accounting office.

With the FRN Monitor, you have access to four additional Standard Reports:
- Entity Dashboard
- PIA Worksheet
- FRN Participants
- Disbursements

Researching Prospects:

Review prior years' FRNs for prospecting or analysis using the Line Item Data available since FY 2015. Search for specific equipment (ordered by service provider, manufacturer, type, category, or model number). Analyze prior years' purchases and identify prospective customers before new 470s are filed.
Standard Reports Menu enables quick access to Awards Summary, Budget Summary, and Line Item Detail reports. Pull spreadsheets with pre-set fields for Budget Summary and Line Item Detail. Awards Summary is in a 'drill down' format which easily copy/pastes to a spreadsheet.
Hardware Inventory Tool (New!) (optional) Category 2 providers will find this useful to identify prospects who favor your equipment brands and/or who have aging equipment in need of replacement. You can also review what your current customers have purchased in the past so you can suggest replacements before they file their next 470. (Optional separate purchase)
Find expiring contracts – both your own and your competitors' – to make a pitch for improvements prior to the Entity's filing of a Form 470.
Looking to expand into a new territory? Filter by state, zip code, or area code to review the purchase history of entities in the area and see what the competition has been offering. Use the information to create a filter in the 470 Query tool to watch for appropriate Form 470s from the probable best prospects in that area.

Custom Work:

Everyone's needs are a little different. Our team will be happy to hear about yours and, if possible, come up with a solution for you. We regularly do complex customizations of maps and exports, APIs for CRM integration, and special reports.

Examples of Custom Requests:

Complex integration with your CRM for Sales Leads
APIs to pull data into your internal systems for sales analysis
Mapping tools may be customized with your network map. (Private to your account)
Special Sales Reports by regions
Special Prospecting Reports
Management Analytic Reports
Your Custom Requests

So, ask us. We will give your request full consideration and a firm quote in advance of the work. Occasionally we like a request so much, we incorporate it into QueryBob as a feature for everyone, at no cost to you.

* Please click the Features Custom Tab above to learn more about these services and how we can help you!

Some of QueryBob's great features for Manufacturers include:

470 Leads Process:

Filtered searching for Form 470s (leads) to match applicant requests with your products. Tools allow for type of equipment requested, location, size, RFPs and similar factors, along with free-form keywords for ad hoc searches. Follow what is being requested to look ahead for supply needs.
Daily e-mail delivery of 470 leads to manufacturer sales teams and agents. The account may be set up to send leads to your own inside sales team and/or your Service Provider partners. Form 470s posted in the prior 24 hours are delivered as a list of who filed and for what services. The e-mail includes a link for each lead that points back to QueryBob's Form 470 detail for deeper review, such as available budgets and which manufacturers' gear entities have purchased in the past.
Pre-qualify leads by logging into our web tools:
- The Entity Analysis Report allows you to see a Filing Entity's entire E-Rate history on a single page.
- Use 471 History for fast look-up of Contract Expiration dates and a brief snapshot of an Entity's purchase history.
- Category 2 Budget information is available in multiple tools to check on a prospect's total and remaining funds. QueryBob updates data from USAC every night, so as FRNs move through the approval process the Budget information is automatically refreshed.
- Line Item Data has been available since FY 2015. QueryBob lets you see exactly what a prospect's current contract provides and what they pay for it.
Integration of 470 leads to CRMs such as Salesforce. *

FRN Status Information:

471 PDF reports to view selected awards by Manufacturer for FRN and/or Line Item Data, which can be sorted in a variety of sequences and subtotaled on breaks. Reports may be sent by e-mail automatically either daily or weekly.
471 Query export tools for FST and Item 21 data let you export query results for manufacturer awards with only the required fields (in your preferred order) for prospecting or analysis. These include FRN, FST, Line Item Data, and other related data points. The FST Export may also be sent by e-mail automatically either daily or weekly.
FRN Monitor (Optional) is a powerful tracking tool useful to those managing large numbers of awards. The Monitor sends out an array of e-mail alerts about significant events in the funding process – including impending deadlines (last date to invoice, Form 486 is due, etc.), status changes, and disbursements – to assist your Sales Accounting office.

Researching Prospects:

Review prior years' FRNs using the Line Item Data available since FY 2015. Using the 471 Query tool, you can see exactly what a prospect's current contract provides and what they pay for it. Search for specific equipment (ordered by service provider, manufacturer, type, category, or model number). Analyze prior years' results.
Standard Reports Menu enables quick access to Awards Summary, Budget Summary, and Line Item Detail reports. Pull spreadsheets with pre-set fields for Budget Summary and Line Item Detail. Awards Summary is in a 'drill down' format which easily copy/pastes to a spreadsheet.
Hardware Inventory Tool (New!) (optional add-on) is useful to find Prospect Entities who favor your equipment brands and/or who have aging equipment in need of replacement. You can also review what your current customers have purchased in the past so you can suggest replacements before they file their next 470.

Custom Work:

Examples of Custom Requests:

APIs to pull Equipment Data into your internal systems for sales analysis
Complex integrations with your CRM for 470 sales leads
Mapping for Requests and Sales
Sales Reports by Service Provider/Agents
Prospecting for equipment over 5 years old
Analytic Reports comparing other manufacturers
Your Custom Ideas

* Please click the Features Custom Tab above to learn more about these services and how we can help you!

Some of QueryBob's great features for Consultants include:

FRN Status Information:

The 471 Query Tool: This is our basic search tool and allows you to query FRN information. Use this to review prior year results for prospecting or analysis and review of Service Providers' pricing. You may also search for specific equipment filtered by manufacturer, type, category, or model number. Queries may be ad hoc or saved for repeated use.

Within this tool are also:
- Daily e-mail notice of Funding Request updates at USAC. These may be based, for example, on your CID, the BENs of your Customers, or a list of FRNs. The 471 Query tool is also capable of sending weekly or monthly disbursement summaries for FRNs you are tracking.
- 471 PDF reports with your branding to view selected awards by CID or BEN. These may be for FRN or Line Item Data, which can be sorted by a variety of criteria and subtotaled on breaks. Reports may be sent by e-mail automatically either daily or weekly.
- 471 Export tools allow you to save the results of a query (search) into customized spreadsheets. For awards from 2015 and forward, Line Item data can be exported through the Item 21 Export. The FST Export (detailed data for awards from 2016 and forward) may also be configured to deliver the export spreadsheet via a daily or weekly e-mail.
The optional FRN Monitor is a powerful tracking tool developed for our consultant clients. The Monitor can send an array of e-mail alerts about significant events in the funding process, including impending deadlines (last day to invoice, Form 486 is due, etc.), status changes, and disbursements.

This tool is bundled with several additional Reports in our Standard Reports Menu:
- The Entity Dashboard allows you to view and filter funding commitments (471), category 2 budgets, and application (470) information for a Filing Entity. The Category 2 Budget information is the most detailed in QueryBob.
- The PIA Worksheet reporting tool allows you to generate a PIA Worksheet for a specific Filing Entity or Beneficiary. Enter the entity's ID # to view available budget amounts and the funding request Line Item Data for all Beneficiaries associated with that Filing Entity, or all requests involving that Beneficiary. If the requested Filing Entity is a consortium, information for constituent recipients will be shown.
- The FRN Participants tool allows you to generate a detailed Participant Report for FRNs associated with a designated Filing Entity or Beneficiary. If the requested Filing Entity is a consortium, information for constituent recipients will be shown. Select a category and/or year to limit results as needed.
- Disbursements (New!) can generate a Detailed Disbursement Report for a Filing Entity or a specific FRN, either with or without a specific date range.

470 Information and Notices:

The 470 Query tool can send daily or weekly notification e-mails based on different filters and includes special update e-mails for RFP changes to any Form 470s referenced in previous notification e-mails.
The 470 Query tool also gives you filtered searching for Form 470s to research 470s and related information filed by your clients or prospects. This tool allows for searches for Category 1 or 2, location, size, RFPs, CID, and other factors, along with free-form keywords for ad hoc or saved searches.
The FRN Monitor includes the option to send you a 470 Alert when a Monitored Entity files a Form 470.

Additional Tools and Add-ons:

(New!) Our (optional) Hardware Inventory Tool streamlines your access to your clients' existing Category 2 purchases. The search filters are the same as those in our 471 Query Tool to find a group of Filing Entities. The display will be a list of Line Items (with Make, Model, and pricing information included) for each Beneficiary of the selected Filing Entity. Any selected Filing Entity's inventory can be exported to an Excel spreadsheet or displayed/saved as a PDF report.
Standard Reports Menu (included with Basic License) enables quick access to Awards Summary, Budget Summary, and Line Item Detail reports. Pull spreadsheets with pre-set fields for Budget Summary and Line Item Detail. Awards Summary is in a 'drill down' format which easily copy/pastes to a spreadsheet.
The Consultant Page Mapping feature (based on your CID) lets you visually locate unrepresented Prospects in your territory.
School Access Dashboard is an add-on option available to Consultants. This is a service allowing your clients to log in to access their own E-Rate information in our Entity Dashboard – which is branded with your logo.

Custom Work:

Examples of Custom Requests:

APIs to pull data into your internal systems
Reports by Service Provider or Manufacturer
CID-Wide reports on disbursements
CID-Wide equipment aging reports
Management Analytic Reports
Your Custom Ideas

Please click the Features Custom Tab above to learn more about these services and how we can help you!

Some of QueryBob's great features for Coordinators include:

FRN Status Information:

The 471 Query Tool: This is our basic search tool and allows you to query FRN information. Use this to review prior year results for prospecting or analysis and review of Service Providers' pricing. You may also search for specific equipment filtered by manufacturer, type, category, or model number. Queries may be ad hoc or saved for repeated use.

Within this tool are also:
- Daily e-mail notice of Funding Request updates at USAC. These may be based, for example, on BENs, SPINs, or a list of FRNs. The 471 Query tool is also capable of sending weekly or monthly disbursement summaries for FRNs you are tracking.
- 471 PDF reports to view selected awards. These may be for FRN or Line Item Data, which can be sorted by a variety of criteria and subtotaled on breaks. Reports may be sent by e-mail automatically either daily or weekly.
- 471 Export tools allow you to save the results of a query (search) into customized spreadsheets. For awards from 2015 and forward, Line Item data can be exported through the Item 21 Export. The FST Export (detailed data for awards from 2016 and forward) may also be configured to deliver the export spreadsheet via a daily or weekly e-mail.
The optional FRN Monitor is a powerful tracking tool developed for our consultant clients. The Monitor can send an array of e-mail alerts about significant events in the funding process, including impending deadlines (last day to invoice, Form 486 is due, etc.), status changes, and disbursements.

This tool is bundled with several additional Reports in our Standard Reports Menu:
- The Entity Dashboard allows you to view and filter funding commitments (471), category 2 budgets, and application (470) information for a Filing Entity. The Category 2 Budget information is the most detailed in QueryBob.
- The PIA Worksheet reporting tool allows you to generate a PIA Worksheet for a specific Filing Entity or Beneficiary. Enter the entity's ID # to view available budget amounts and the funding request Line Item Data for all Beneficiaries associated with that Filing Entity, or all requests involving that Beneficiary. If the requested Filing Entity is a consortium, information for constituent recipients will be shown.
- The FRN Participants tool allows you to generate a detailed Participant Report for FRNs associated with a designated Filing Entity or Beneficiary. If the requested Filing Entity is a consortium, information for constituent recipients will be shown. Select a category and/or year to limit results as needed.
- Disbursements (New!) can generate a Detailed Disbursement Report for a Filing Entity or a specific FRN, either with or without a specific date range.

470 Information and Notices:

The 470 Query tool also gives you filtered searching for Form 470s to research 470s and related information filed by your entities. This tool allows for searches for Category 1 or 2, location, size, RFPs, CID, and other factors, along with free-form keywords for ad hoc or saved searches.
The 470 Query tool can send daily or weekly notification e-mails based on those same filters and includes special update e-mails for RFP changes to any Form 470s referenced in previous notification e-mails.
The FRN Monitor includes the option to send you a 470 Alert when a Monitored Entity files a Form 470.

Additional Tools and Add-ons:

(New!) Our (optional) Hardware Inventory Tool streamlines your access to your entities' existing Category 2 purchases. The search filters are the same as those in our 471 Query Tool to find a group of Filing Entities. The display will be a list of Line Items (with Make, Model, and pricing information included) for each Beneficiary of the selected Filing Entity. Any selected Filing Entity's inventory can be exported to an Excel spreadsheet or displayed/saved as a PDF report.
Standard Reports Menu (included with Basic License) enables quick access to Awards Summary, Budget Summary, and Line Item Detail reports. Pull spreadsheets with pre-set fields for Budget Summary and Line Item Detail. Awards Summary is in a 'drill down' format which easily copy/pastes to a spreadsheet.
School Access Dashboard is an add-on option available to Consultants or Coordinators with the Monitor. This is a service allowing entities to log in to access their own E-Rate information in our Entity Dashboard – which is branded with your logo.

Custom Work:

Examples of Custom Requests:

APIs to pull data into your internal systems
State-Wide Reports by Service Provider or Manufacturer
State-Wide reports on disbursements
State-Wide equipment aging reports
Management Analytic Reports
Your Custom Ideas

Please click the Features Custom Tab above to learn more about these services and how we can help you!

Custom Services

Everyone's needs are a little different. Our team will be happy to hear about yours and, if possible, come up with a solution for you. We regularly do customizations of maps and exports, APIs for CRM integration, and special reports. Annual clients get 6 hours of custom work free as part of their annual license. Additional work beyond six hours is billable at $125 per hour.

For example, a common request is a CRM integration/interface. QueryBob will create a custom interface for easy input to SalesForce or other CRM applications. This is a custom design process, due to the nature of SalesForce and the data involved and is accomplished by one of the two following methods – depending on which one best meets your needs.

Attach a CSV or an Excel file to a daily email. This file would be formatted with the specific fields that you need to manually import into SF. Before import, you would be able to pre-qualify the leads and delete the leads that don't qualify.
Post directly to a SF Form to update your SF directly with leads from your daily e-mails. This would give you less of an opportunity to pre-qualify before updating SF. However, tightening the filters and keywords can get pretty precise in pulling the leads you want.

A QueryBob Daily E-mail is a saved search which filters the leads (E-Rate Form 470s) or FRNs (E-Rate Funding Request/awards) but which is additionally set up to email a summary of those items to you daily. With or without a customized interface for SalesForce, these may also include a spreadsheet of desired fields. The version set up for SalesForce inclusion requires that you give us an exact layout of fields/sizes required for your SF, allowing us to set up an export file to map fields to your file requirements. For example: Entity Number, Name, Address, City, State, Zip, Main Contact: E-Mail Address, Telephone. We can also provide a link field in the file that would point back to QueryBob for 471 History, current original 470 file, etc.

Once the best method for interface and desired fields have been chosen, we work with your SalesForce technology team to handle the technical details and develop the interface – which can be done quickly once the ground work has been laid.

So, ask us. We will give your request full consideration. Occasionally we like a request so well, we incorporate it into QueryBob at no cost.

Basic QueryBob License:

The basic license costs $250 per month (31 days) and provides access to our web-based products for one (1) state along with one (1) login user ID and includes the following basic features:

Form 470 Query Tool
Form 471 Query Tool (FRNs)
Standard Reports Menu
- Awards Summary
- Budget Summary
- Line Item Details

Functionalities of these tools include simple or complex searches, exports, company branded reports, mapping, and daily (or weekly) emails with sales leads, FRN changes or reports.

You may purchase a QueryBob license for as little as a single state for a single month, or as an annual license for your nationwide sales enterprise. Use the License Calculator below to figure your needs.

The following factors determine your price for QueryBob beyond the Basic License:

Additional States & Territories:
First state is included in the Basic License.
States 2-10: $15/month each
States 11-50* $10/month each
* States & Territories 51-56 are included with purchase of 50

Additional Users:
Each User ID will support a maximum of 5 concurrent logins.
Add additional User IDs for $30/month each.
Each User ID may log in, run queries, run reports, export data and receive individualized lead e-mails daily. Every User ID may have access to all purchased states for the account, or only those they need according to your company's requirements.

Length of License:
Monthly: Self-purchase by the month when needed via PayPal. (Sorry, invoicing unavailable for this option.)
Annual: : Year-round access for the cost of 10 months – a discount of 2 months. You will be invoiced for services, and payments can be made by check, ACH, or through PayPal as fits your company's needs.

Support:
All QueryBob licenses come with unlimited Help Desk support for initial setup, training, questions, and bug support. If needed, additional or custom work is available at $125 per hour (see Option 4).

Additional Options and Pricing: Outside of our Basic License, we offer additional options for enhanced FRN monitoring, researching, reporting, and custom APIs. The following may be added to your Basic QueryBob License for customers who need these services.

Option 1 – FRN Monitor, Additional Standard Reports ($1,250)
The FRN Monitor tracks a user-defined set of Funding Requests and is recommended for Consultants, State Coordinators, and large Service Providers who need to track the statuses of many FRNs. This tool provides additional alerts on changes to FRNs, as well as reminders of some crucial deadlines, such as 486 Service Start Date, Last Date to Invoice, funds remaining and not yet disbursed, and much more. All of your licensed users have access to the FRN Monitor and also can be set up to receive individualized e-mail FRN status reports.

With the FRN Monitor the Standard Reports menu includes 4 additional reports:

Entity Dashboard
PIA Review
FRN Participants
Disbursements Report

Option 2 – Hardware Inventory Tool ($500)
This feature may be purchased separately for $50.00 per month or $500.00 annually. This is for Service Providers and Consultants and allows searching by a single entity or a group of entities with the ability to see all of their Category 2 equipment purchases listed by site (2015-2020) or filing entity (2021+) and sorted by year. Includes manufacturer, model number, unit price, and quantity. Good for easy review of prior purchases that are likely to need replacement, etc.

Option 3 – School Access Dashboard – Consultants only (maximum of $60 per year per Entity)
Consultants may wish to offer access to their clients via our (branded with the consultant's logo) School Access Dashboard, which provides a school or library client direct access to their own information in the same format as the Entity Dashboard. Access for each Entity costs up to $60 per year at $5 per month for months actually used and will be billed on a quarterly basis. Please contact QueryBob for full details and terms of this feature.

Option 4 – Custom Work ($125 per hour)
Everyone's needs are a little different. Our team will be happy to hear about yours and, if possible, come up with a solution for you. We regularly do complex customizations of maps and exports, APIs for CRM integration, and special reports.
Examples of Custom Requests:

APIs to pull QB data into your internal systems
Complex integrations with your CRM
Mapping Tools
Special Sales Reports
Special Prospecting Reports
Analytic Reports
Your Custom Requests

Customization is billable at $125 per hour.

So, ask us. We will give your request full consideration. Occasionally we like a request so much, we incorporate it into QueryBob as a feature for everyone, at no cost to you.

End User Agreement:
Please read our User Agreement by clicking on this link.

QueryBob License Calculator

Number of User Accounts:
Number of States/Territories (1-56):
Number of Months*:
Include Monitor Functionality?
Include Hardware Inventory?
QueryBob License Cost:

To purchase a QueryBob license, or for more information,
call 540-486-1371 (Eastern Time Zone)
or email us at anyBob@querybob.com.

* QueryBob does not operate on calendar months, but allows you to purchase a "month" of 31 days as you need it.