QueryBob - E-Rate Data Source

Company:
User ID:
Password:
Destination

Hardware Inventory Tool

For customers with the need to view Category 2 purchases made by entities in the years since 2015. The (exportable) display includes all of a Filing Entity’s line item information (make, model #, count, cost, etc.). This is a simple targeted review of purchased equipment which may be due for replacement or upgrade. It is an optional feature purchased separately for $500.00 annually as an add-on to the Basic QB license.

News Update 11/7/2023 -- EPC Access Restored

Access to the E-Rate Productivity Center (EPC) has been restored following the transition of E-Rate invoicing related forms from legacy systems to EPC. Most Forms 470 filed today will have complete information loaded into QueryBob by tomorrow morning. For applications filed after 9:00 pm Eastern, it takes an additional day to obtain full information (RFP links, etc.) from USAC.

The FCC has noted that "to reduce the need for E-rate participants to request a waiver or extension of any filing deadline, entities and service providers with a deadline within EPC between October 31 and November 7, 2023, will now have until 11:59 p.m. ET on November 8, 2023, to submit their request or filing."

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 12/07/2023

FY 2023 Funding Wave 32 was released on November 30th for $18,667,354 – 109 FRNs were Funded, and 19 were Cancelled or Denied. As of December 7th, 3,587 FRNs remained Pending.

FY 2022 Funding Wave 65 was released on November 29th for $0 – 0 FRNs were Funded, and 3 were Cancelled or Denied. As of December 7th, 1,180 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 (37) was released on November 1st for $5,188,685.87 – 45 FRNs were Funded, and 58 were Cancelled or Denied. As of December 7th, 226 FRNs for $17,748,757.10 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	5,333	0	0	0		0	0	0	0	0	0	0	0
2023	22,048	54,739	35,704	19,035	32	49,048	3,587	1,678	426	1,403,609,648	1,037,726,773	163,746,703	267,381,055
2022	22,058	56,631	35,584	21,047	65	52,056	1,180	2,840	555	1,528,070,383	1,251,521,435	1,082,597,864	763,231,463
2021	24,434	59,998	36,273	23,725	83	53,993	1,011	4,194	800	1,535,384,220	1,087,428,237	1,267,146,110	860,849,525
2020	26,931	78,571	41,038	37,533	119	72,353	313	4,994	911	1,579,817,680	922,929,908	1,296,569,724	692,426,121
2019	25,705	70,123	37,037	33,086	110	64,443	418	4,387	875	1,594,008,246	774,661,225	1,333,172,079	672,664,733
2018	26,915	74,516	49,101	25,415	114	67,103	762	4,826	1,825	1,762,146,245	525,874,319	1,529,792,262	468,210,352
2017	31,193	99,292	73,302	25,990	93	89,094	636	6,210	3,352	1,779,371,218	588,067,709	1,485,954,243	517,279,175

Recent E-Rate Funding Waves 2023
Wave #	Wave Date	Funded Amount	Funded Count	Not Funded Count
32	11/30/2023	$18,667,354	109	19
31	11/22/2023	$41,320,400	250	19
30	11/16/2023	$41,247,319	237	42
29	11/09/2023	$17,220,308	226	29
28	11/02/2023	$15,406,024	276	31

Recent E-Rate Funding Waves 2022
Wave #	Wave Date	Funded Amount	Funded Count	Not Funded Count
65	11/29/2023	$0	0	3
64	11/17/2023	$1,400,368	28	9
63	10/25/2023	$1,850,590	25	0
62	10/11/2023	$1,729,290	18	4
61	09/27/2023	$946,985	24	1

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 (#)
37	11/01/2023	$5,188,685.87	$1,104,743.40	$4,083,942.47	45	12	33	58	13	45
36	10/18/2023	$53,291,033.40	$8,248,675.04	$45,042,358.36	346	89	257	162	34	128
35	10/04/2023	$37,032,083.99	$2,660,405.33	$34,371,678.66	347	63	284	169	43	126
34	05/26/2023	$40,887,426.69	$2,735,696.10	$38,151,730.59	348	79	269	154	32	122
33	05/09/2023	$23,701,116.64	$3,634,990.37	$20,066,126.27	224	63	161	146	48	98
32	04/25/2023	$68,948,020.70	$5,512,621.15	$63,435,399.55	268	79	189	192	57	135
31	04/10/2023	$47,078,648.30	$3,524,993.31	$43,553,654.99	352	92	260	280	114	166
30	03/13/2023	$56,805,383.00	$9,393,851.37	$47,411,531.63	258	94	164	207	64	143
29	02/28/2023	$13,928,229.91	$3,497,586.72	$10,430,643.19	99	34	65	53	18	35
28	01/30/2023	$29,158,371.45	$1,610,538.79	$27,547,832.66	181	59	122	127	43	84
27	12/05/2022	$21,992,795.23	$336,277.24	$21,656,517.99	37	16	21	81	29	52
26	11/14/2022	$20,242,179.10	$6,227,032.11	$14,015,146.99	109	49	60	30	14	16
25	10/31/2022	$12,162,620.91	$1,858,295.06	$10,304,325.85	89	32	57	53	29	24
24	10/18/2022	$21,801,068.03	$4,579,193.01	$17,221,875.02	105	40	65	92	46	46
23	10/04/2022	$19,358,982.48	$7,122,399.91	$12,236,582.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,418,381.79	$5,522,389.25	$1,895,992.54	69	31	38	47	24	23
20	08/09/2022	$18,147,001.50	$10,140,263.32	$8,006,738.18	73	36	37	41	14	27
19	07/25/2022	$63,477,152.82	$19,277,936.46	$44,199,216.36	145	64	81	75	37	38
18	07/11/2022	$31,369,775.35	$10,834,532.18	$20,535,243.17	382	124	258	114	34	80
17	06/28/2022	$30,617,960.32	$7,097,651.85	$23,520,308.47	361	111	250	104	31	73
16	06/07/2022	$58,070,627.00	$12,179,460.42	$45,891,166.58	579	178	401	179	69	110
15	05/17/2022	$80,791,663.19	$24,637,947.90	$56,153,715.29	554	169	385	155	74	81
14	05/04/2022	$103,071,875.98	$32,332,777.78	$70,739,098.20	758	252	506	244	94	150
13	04/19/2022	$86,889,573.08	$39,097,845.75	$47,791,727.33	432	160	272	246	108	138
12	03/23/2022	$128,637,880.87	$58,186,462.01	$70,451,418.86	739	319	420	200	68	132
11	03/07/2022	$239,424,949.78	$63,824,357.99	$175,600,591.79	1,213	449	764	298	101	197
10	02/23/2022	$152,321,466.70	$30,673,865.25	$121,647,601.45	1,011	341	670	201	90	111
9	02/08/2022	$215,093,790.40	$54,481,891.57	$160,611,898.83	972	334	638	109	43	66
8	01/25/2022	$281,763,282.99	$53,018,250.13	$228,745,032.86	1,719	483	1,236	315	112	203
7	01/10/2022	$399,317,688.32	$137,243,565.26	$262,074,123.06	1,942	565	1,377	199	84	115
6	12/20/2021	$569,511,926.70	$137,698,522.83	$431,813,403.87	3,254	930	2,324	276	117	159
5	11/23/2021	$201,552,767.01	$44,892,606.71	$156,660,160.30	1,499	559	940	195	66	129
4	11/08/2021	$431,087,852.11	$128,154,091.38	$302,933,760.73	1,986	724	1,262	226	109	117
3	10/25/2021	$510,207,609.60	$214,535,251.39	$295,672,358.21	2,530	952	1,578	235	110	125
2	10/12/2021	$1,204,159,219.41	$339,993,654.78	$864,165,564.63	5,614	2,031	3,583	393	153	240
1	09/24/2021	$1,153,143,050.15	$166,433,619.53	$986,709,430.62	5,727	1,776	3,951	370	113	257

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 (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.