QueryBob - E-Rate Data Source

Company:
User ID:
Password:
Destination

2021 Cat 2 Budgets

For the 2021-2025 C2 budget cycle, spending constraints are applied at the Filing Entity level, rather than at the Beneficiary level. QueryBob reports official budget figures from USAC's Category Two Budget Tool where available and estimates based on Entity Tool data (enrollment, square footage, number of sites, etc.) where official budgets are missing. The Feature is included free with the Basic QB license.

News Update 7/4/2023 -- FY 2024 470 Window Is Open

The Funding Year (FY) 2024 FCC Form 470 application filing window opened on Saturday, July 1, 2023, and one Form 470 was filed on the first business day of the window. In FY 2023, just over 22,000 Forms 470 were filed.

The Funding Year (FY) 2023 FCC Form 471 application filing window closed on Tuesday, March 28, 2023, at 11:59 p.m. ET, with approximately 53,000 Funding Requests filed in-window.

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 10/01/2023

FY 2023 Funding Wave 23 was released on September 28th for $18,147,970 – 130 FRNs were Funded, and 31 were Cancelled or Denied. As of October 1st, 6,142 FRNs remained Pending.

FY 2022 Funding Wave 61 was released on September 27th for $946,985 – 24 FRNs were Funded, and 1 were Cancelled or Denied. As of October 1st, 1,262 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 (34) was released on September 20th for $40,969,265.95 – 347 FRNs were Funded, and 155 were Cancelled or Denied. As of October 1st, 1,314 FRNs for $269,989,621.07 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	606	0	0	0		0	0	0	0	0	0	0	0
2023	22,048	54,629	35,601	19,028	23	46,727	6,142	1,484	276	1,248,854,101	957,842,548	47,178,667	134,668,697
2022	22,058	56,607	35,560	21,047	61	52,234	1,262	2,567	544	1,529,583,071	1,279,445,953	952,448,007	666,145,812
2021	24,434	59,993	36,268	23,725	81	54,123	1,075	3,994	801	1,535,659,653	1,098,891,544	1,259,706,692	834,265,189
2020	26,931	78,570	41,037	37,533	118	72,406	321	4,937	906	1,581,214,769	929,097,388	1,295,724,680	677,811,515
2019	25,705	70,123	37,037	33,086	110	64,443	418	4,387	875	1,594,086,321	775,744,032	1,333,251,089	671,781,626
2018	26,915	74,515	49,100	25,415	112	67,101	767	4,825	1,822	1,762,055,333	527,092,068	1,531,545,366	467,524,802
2017	31,193	99,292	73,302	25,990	91	89,089	658	6,210	3,335	1,779,521,679	588,074,849	1,485,969,315	517,135,890

Recent E-Rate Funding Waves 2023
Wave #	Wave Date	Funded Amount	Funded Count	Not Funded Count
23	09/28/2023	$18,147,970	130	31
22	09/21/2023	$18,036,804	218	30
21	09/14/2023	$24,982,302	292	22
20	09/07/2023	$5,291,052	109	9
19	09/01/2023	$128,520,904	752	50

Recent E-Rate Funding Waves 2022
Wave #	Wave Date	Funded Amount	Funded Count	Not Funded Count
61	09/27/2023	$946,985	24	1
60	09/06/2023	$978,479	6	0
59	08/16/2023	$525,312	5	2
58	07/19/2023	$593,277	4	0
57	07/12/2023	$3,030,715	41	2

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 (#)
34	05/26/2023	$40,969,265.95	$2,757,797.70	$38,211,468.25	347	81	266	155	30	125
33	05/09/2023	$24,330,271.43	$3,685,472.27	$20,644,799.16	225	64	161	145	47	98
32	04/25/2023	$69,022,950.93	$5,537,288.35	$63,485,662.58	268	81	187	192	55	137
31	04/10/2023	$46,580,402.14	$3,766,889.55	$42,813,512.59	349	93	256	283	113	170
30	03/13/2023	$56,214,306.36	$9,386,914.17	$46,827,392.19	248	92	156	217	66	151
29	02/28/2023	$14,076,025.64	$3,519,456.72	$10,556,568.92	100	34	66	52	18	34
28	01/30/2023	$29,356,711.54	$1,640,010.79	$27,716,700.75	188	62	126	120	40	80
27	12/05/2022	$21,878,508.61	$336,277.24	$21,542,231.37	35	16	19	83	29	54
26	11/14/2022	$20,279,226.10	$6,227,032.11	$14,052,193.99	110	49	61	29	14	15
25	10/31/2022	$12,301,925.67	$1,997,599.82	$10,304,325.85	89	32	57	53	29	24
24	10/18/2022	$21,969,515.66	$4,646,931.29	$17,322,584.37	108	42	66	89	44	45
23	10/04/2022	$19,913,627.63	$7,122,399.91	$12,791,227.72	162	67	95	124	38	86
22	09/20/2022	$3,089,313.37	$340,533.35	$2,748,780.02	28	9	19	36	13	23
21	08/23/2022	$7,419,450.05	$5,523,100.51	$1,896,349.54	71	32	39	45	23	22
20	08/09/2022	$18,216,001.50	$10,189,263.32	$8,026,738.18	73	36	37	41	14	27
19	07/25/2022	$22,104,960.93	$8,861,582.82	$13,243,378.11	140	62	78	80	39	41
18	07/11/2022	$31,406,945.08	$10,856,281.98	$20,550,663.10	384	126	258	112	32	80
17	06/28/2022	$30,743,095.72	$7,112,952.25	$23,630,143.47	365	112	253	100	30	70
16	06/07/2022	$58,344,014.72	$12,332,539.14	$46,011,475.58	582	179	403	176	68	108
15	05/17/2022	$80,874,537.75	$24,640,307.46	$56,234,230.29	556	170	386	153	73	80
14	05/04/2022	$103,689,618.73	$32,457,510.82	$71,232,107.91	763	256	507	239	90	149
13	04/19/2022	$87,046,920.82	$39,270,893.49	$47,776,027.33	436	163	273	242	105	137
12	03/23/2022	$128,765,850.84	$58,188,245.61	$70,577,605.23	741	319	422	198	68	130
11	03/07/2022	$240,158,449.40	$64,022,009.00	$176,136,440.40	1,231	457	774	280	93	187
10	02/23/2022	$157,810,678.83	$32,908,925.30	$124,901,753.53	1,036	351	685	176	80	96
9	02/08/2022	$219,391,864.90	$54,736,072.77	$164,655,792.13	978	336	642	103	41	62
8	01/25/2022	$282,586,325.94	$53,067,942.70	$229,518,383.24	1,733	486	1,247	301	109	192
7	01/10/2022	$399,994,122.92	$137,387,787.71	$262,606,335.21	1,955	569	1,386	186	80	106
6	12/20/2021	$606,192,541.58	$159,209,569.88	$446,982,971.70	3,292	947	2,345	238	100	138
5	11/23/2021	$202,341,984.55	$45,144,725.23	$157,197,259.32	1,510	563	947	184	62	122
4	11/08/2021	$435,941,534.55	$128,772,511.41	$307,169,023.14	2,024	744	1,280	188	89	99
3	10/25/2021	$511,201,190.57	$214,736,980.77	$296,464,209.80	2,562	966	1,596	203	96	107
2	10/12/2021	$1,241,605,303.27	$340,786,010.48	$900,819,292.79	5,676	2,058	3,618	331	126	205
1	09/24/2021	$1,156,809,605.44	$168,145,521.60	$988,664,083.84	5,775	1,800	3,975	322	89	233

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.