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 1/18/2024 -- 471 Window Is OPEN

The FY 2024 Funding Request (471) Filing Window opened on January 17, 2024, at noon EST. The 471 Window will close on March 27, 2024, at 11:59 pm EST.

It takes time to process all the associated information from the 471s into QueryBob. For that reason, the Preview tool is available in the 471 Query tool if you need to see preliminary information on specific 471s. Full access to 471 information via QueryBob tools is usually available by 11:00 PM EST on the day after filing.

The last day to file a Form 470 in time to submit an associated 471 within the application window is February 28, 2024, at 11:59 pm EST.

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 04/25/2024

FY 2023 Funding Wave 52 was released on April 18th for $1,032,710 – 12 FRNs were Funded, and 4 were Cancelled or Denied. As of April 25th, 1,896 FRNs remained Pending.

FY 2022 Funding Wave 73 was released on April 19th for $738,725 – 20 FRNs were Funded, and 15 were Cancelled or Denied. As of April 25th, 1,097 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 (39) was released on January 12th for $122,645.30 – 4 FRNs were Funded, and 6 were Cancelled or Denied. As of April 25th, 212 FRNs for $16,513,717.06 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
2024	22,579	54,704	35,278	19,426	0	0	54,704	0	0	0	0	0	0
2023	22,048	54,923	35,886	19,037	52	50,454	1,896	2,030	543	1,486,395,893	1,097,161,038	504,964,431	512,782,912
2022	22,058	56,669	35,622	21,047	73	51,779	1,097	3,224	569	1,523,614,531	1,194,725,144	1,230,224,005	880,557,518
2021	24,434	60,000	36,274	23,726	91	53,793	967	4,436	804	1,535,879,546	1,063,789,516	1,277,798,242	900,820,572
2020	26,931	78,576	41,042	37,534	123	72,220	279	5,182	895	1,580,330,456	921,028,268	1,299,916,771	714,185,256
2019	25,705	70,124	37,038	33,086	113	64,442	409	4,397	876	1,591,346,259	774,631,476	1,349,622,407	675,242,159
2018	26,915	74,516	49,101	25,415	116	67,114	759	4,827	1,816	1,761,851,936	525,789,006	1,529,980,208	469,022,727
2017	31,193	99,292	73,302	25,990	94	89,116	633	6,211	3,332	1,779,642,536	587,965,275	1,486,113,020	517,278,253

Recent E-Rate Funding Waves 2023
Wave #	Wave Date	Funded Amount	Funded Count	Not Funded Count
52	04/18/2024	$1,032,710	12	4
51	04/11/2024	$6,618,958	17	4
50	04/04/2024	$5,007,681	12	7
49	03/28/2024	$1,691,379	29	8
48	03/21/2024	$1,648,247	16	15

Recent E-Rate Funding Waves 2022
Wave #	Wave Date	Funded Amount	Funded Count	Not Funded Count
73	04/19/2024	$738,725	20	15
72	02/28/2024	$103,144	4	3
71	02/14/2024	$399,212	5	1
70	02/07/2024	$338,930	9	1
69	01/24/2024	$114,724	11	7

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 (#)
39	01/12/2024	$122,645.30	$0.00	$122,645.30	4	0	4	6	1	5
38	12/14/2023	$457,623.05	$62,231.20	$395,391.85	7	3	4	3	2	1
37	11/01/2023	$5,288,767.42	$1,114,870.20	$4,173,897.22	50	13	37	53	12	41
36	10/18/2023	$51,032,912.20	$7,656,545.24	$43,376,366.96	345	85	260	163	38	125
35	10/04/2023	$37,175,167.45	$2,660,405.33	$34,514,762.12	352	63	289	165	43	122
34	05/26/2023	$40,803,310.38	$2,758,181.60	$38,045,128.78	351	80	271	151	31	120
33	05/09/2023	$24,256,713.23	$3,778,974.53	$20,477,738.70	232	65	167	138	46	92
32	04/25/2023	$69,080,009.32	$5,655,931.75	$63,424,077.57	272	81	191	188	55	133
31	04/10/2023	$46,884,544.67	$3,511,373.31	$43,373,171.36	353	92	261	279	114	165
30	03/13/2023	$56,915,852.47	$9,354,450.69	$47,561,401.78	262	94	168	203	64	139
29	02/28/2023	$13,878,816.93	$3,497,586.72	$10,381,230.21	98	34	64	54	18	36
28	01/30/2023	$29,008,739.54	$1,610,538.79	$27,398,200.75	182	59	123	126	43	83
27	12/05/2022	$22,042,841.23	$376,861.24	$21,665,979.99	39	17	22	79	28	51
26	11/14/2022	$20,240,397.14	$6,227,032.11	$14,013,365.03	109	49	60	30	14	16
25	10/31/2022	$12,104,873.11	$1,801,787.06	$10,303,086.05	87	30	57	55	31	24
24	10/18/2022	$21,655,390.98	$4,579,193.01	$17,076,197.97	105	40	65	92	46	46
23	10/04/2022	$19,226,472.48	$6,992,049.91	$12,234,422.57	160	67	93	126	38	88
22	09/20/2022	$3,135,168.37	$376,533.35	$2,758,635.02	30	10	20	34	12	22
21	08/23/2022	$7,366,492.19	$5,522,389.25	$1,844,102.94	69	31	38	47	24	23
20	08/09/2022	$18,067,310.91	$10,131,713.32	$7,935,597.59	69	35	34	45	15	30
19	07/25/2022	$63,401,692.82	$19,277,936.46	$44,123,756.36	145	64	81	75	37	38
18	07/11/2022	$31,136,827.51	$10,966,955.18	$20,169,872.33	389	130	259	107	28	79
17	06/28/2022	$30,605,533.93	$7,097,651.85	$23,507,882.08	361	111	250	104	31	73
16	06/07/2022	$58,057,891.30	$12,179,460.42	$45,878,430.88	579	178	401	179	69	110
15	05/17/2022	$80,758,686.35	$24,605,601.90	$56,153,084.45	553	168	385	156	75	81
14	05/04/2022	$103,120,411.71	$32,331,977.41	$70,788,434.30	758	252	506	244	94	150
13	04/19/2022	$83,856,402.13	$36,161,671.55	$47,694,730.58	432	160	272	246	108	138
12	03/23/2022	$131,709,298.44	$61,236,432.96	$70,472,865.48	739	319	420	200	68	132
11	03/07/2022	$238,988,026.92	$63,861,931.11	$175,126,095.81	1,210	449	761	301	101	200
10	02/23/2022	$152,297,234.41	$30,673,855.47	$121,623,378.94	1,007	341	666	205	90	115
9	02/08/2022	$202,474,510.99	$54,406,041.03	$148,068,469.96	970	333	637	111	44	67
8	01/25/2022	$281,503,366.23	$52,984,293.59	$228,519,072.64	1,717	481	1,236	317	114	203
7	01/10/2022	$399,219,807.32	$137,153,168.26	$262,066,639.06	1,938	563	1,375	203	86	117
6	12/20/2021	$568,859,686.23	$137,485,116.95	$431,374,569.28	3,251	928	2,323	279	119	160
5	11/23/2021	$201,542,517.02	$44,885,406.71	$156,657,110.31	1,498	558	940	196	67	129
4	11/08/2021	$430,810,286.19	$128,019,091.38	$302,791,194.81	1,985	723	1,262	227	110	117
3	10/25/2021	$509,729,714.89	$214,495,025.19	$295,234,689.70	2,529	951	1,578	236	111	125
2	10/12/2021	$1,202,904,728.32	$339,513,735.22	$863,390,993.10	5,611	2,031	3,580	396	153	243
1	09/24/2021	$1,151,926,834.88	$166,423,011.53	$985,503,823.35	5,725	1,775	3,950	372	114	258

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.

Note: QueryBob's prices will be changing on May 1, 2024. The calculator below will show both current and new prices for your configuration choices. If you have questions about prices for specific features, please contact us at anybob@querybob.com.

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 (951) 523-0060 (Pacific Timezone)
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.