QueryBob - E-Rate Data Source

Company:
User ID:
Password:
Destination

ECF Awards Report

Emergency Connectivity Fund applications are now being processed. View funding requests and current status in the ECF Awards Report, accessed through the QueryBob Standard Reports Dashboard.

Results can be filtered by Entity, Service Provider, State, Manufacturer, Consultant, Funding Status, Service Type or Product Type, and may be exported to Excel for further analysis.

News Update 4/22/2023 -- FY 2023 471 Window Is Closed

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.

Funding Requests for late-filed/out-of-window Forms 470 are still trickling in, but these are likely to have 'Pending' status at USAC for a longer period than those which were 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 06/01/2023

FY 2023 Funding Wave 5 was released on May 25th for $65,637,162 – 1,265 FRNs were Funded, and 59 were Cancelled or Denied. As of June 1st, 19,604 FRNs remained Pending.

FY 2022 Funding Wave 54 was released on May 10th for $321,246 – 5 FRNs were Funded, and 2 were Cancelled or Denied. As of June 1st, 1,436 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 May 26th for $106,680.70 – 6 FRNs were Funded, and 4 were Cancelled or Denied. As of June 1st, 3,696 FRNs for $737,134,122.55 remained Pending.

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

Year	470s	FRNs	Cat 1 FRNs	Cat 2 FRNs	Last Wave	Funded	Pending	Cancelled	Denied	Cat 1 Committed	Cat 2 Committed	Cat 1 Disbursed	Cat 2 Disbursed
2023	22,028	54,299	35,307	18,992	5	33,838	19,604	747	110	774,110,512	487,460,722	0	0
2022	22,058	56,503	35,456	21,047	54	52,429	1,436	2,090	548	1,525,044,769	1,308,448,461	634,167,997	402,047,441
2021	24,434	59,975	36,250	23,725	76	54,295	1,166	3,717	797	1,536,509,179	1,109,588,514	1,238,678,221	776,624,732
2020	26,931	78,548	41,017	37,531	114	72,345	411	4,886	906	1,579,529,514	928,157,486	1,287,347,976	654,516,179
2019	25,705	70,123	37,037	33,086	110	64,445	418	4,385	875	1,594,087,293	773,944,155	1,333,530,548	669,115,045
2018	26,915	74,515	49,100	25,415	112	67,102	767	4,824	1,822	1,762,140,094	527,118,325	1,531,620,002	467,125,253
2017	31,193	99,292	73,302	25,990	91	89,090	658	6,210	3,334	1,779,561,287	588,081,724	1,485,981,240	516,249,250

Recent E-Rate Funding Waves 2023
Wave #	Wave Date	Funded Amount	Funded Count	Not Funded Count
5	05/25/2023	$65,637,162	1,265	59
4	05/18/2023	$62,200,155	1,390	63
3	05/11/2023	$54,525,440	1,280	104
2	05/04/2023	$40,357,271	954	55
1	04/29/2023	$1,038,851,206	28,949	576

Recent E-Rate Funding Waves 2022
Wave #	Wave Date	Funded Amount	Funded Count	Not Funded Count
54	05/10/2023	$321,246	5	2
53	04/20/2023	$712,549	4	4
52	04/13/2023	$408,926	10	4
51	04/06/2023	$58,254	1	1
50	03/30/2023	$2,169,864	23	0

ECF Funding Waves
Wave #	Wave Date	Total Funded ($)	Services Funded ($)	Equipment Funded ($)	Total Funded (#)	Services Funded (#)	Equipment Funded (#)	Total Not Funded (#)	Services Not Funded (#)	Equipment Not Funded (#)
34	05/26/2023	$106,680.70	$42,000.00	$64,680.70	6	2	4	4	0	4
33	05/09/2023	$2,176,359.79	$1,901,548.45	$274,811.34	16	11	5	25	17	8
32	04/25/2023	$934,673.40	$934,673.40	$0.00	1	1	0	92	34	58
31	04/10/2023	$183,020.16	$14,254.56	$168,765.60	6	1	5	144	74	70
30	03/13/2023	$455,590.68	$124,534.68	$331,056.00	13	7	6	163	55	108
29	02/28/2023	$374,991.52	$87,761.52	$287,230.00	8	4	4	29	10	19
28	01/30/2023	$535,186.00	$114,925.90	$420,260.10	17	6	11	71	26	45
27	12/05/2022	$619,641.72	$115,213.44	$504,428.28	20	8	12	57	24	33
26	11/14/2022	$5,019,830.67	$3,690,146.67	$1,329,684.00	28	17	11	14	7	7
25	10/31/2022	$12,177,651.77	$1,971,679.82	$10,205,971.95	84	31	53	58	30	28
24	10/18/2022	$22,122,162.48	$4,660,075.78	$17,462,086.70	111	45	66	86	41	45
23	10/04/2022	$20,740,038.91	$7,140,044.45	$13,599,994.46	158	68	90	128	37	91
22	09/20/2022	$3,116,731.07	$340,533.35	$2,776,197.72	28	9	19	36	13	23
21	08/23/2022	$7,265,840.86	$5,523,100.51	$1,742,740.35	63	32	31	53	23	30
20	08/09/2022	$17,871,721.34	$10,305,747.52	$7,565,973.82	73	36	37	41	14	27
19	07/25/2022	$22,397,830.36	$8,901,542.82	$13,496,287.54	141	62	79	79	39	40
18	07/11/2022	$31,749,535.71	$10,948,167.56	$20,801,368.15	387	127	260	109	31	78
17	06/28/2022	$31,249,920.24	$7,466,740.61	$23,783,179.63	368	113	255	97	29	68
16	06/07/2022	$58,227,891.68	$12,413,059.14	$45,814,832.54	582	180	402	176	67	109
15	05/17/2022	$81,107,146.19	$24,640,307.46	$56,466,838.73	558	170	388	151	73	78
14	05/04/2022	$103,868,770.85	$32,570,640.17	$71,298,130.68	771	260	511	231	86	145
13	04/19/2022	$86,989,160.04	$39,278,354.49	$47,710,805.55	441	166	275	237	102	135
12	03/23/2022	$145,342,621.29	$59,604,491.13	$85,738,130.16	747	322	425	192	65	127
11	03/07/2022	$243,134,822.66	$65,347,685.79	$177,787,136.87	1,247	465	782	264	85	179
10	02/23/2022	$158,679,882.72	$32,959,855.18	$125,720,027.54	1,052	358	694	160	73	87
9	02/08/2022	$220,315,045.90	$54,937,646.25	$165,377,399.65	999	345	654	82	32	50
8	01/25/2022	$284,908,571.00	$54,245,202.91	$230,663,368.09	1,755	499	1,256	279	96	183
7	01/10/2022	$403,433,393.26	$137,833,531.37	$265,599,861.89	1,994	585	1,409	147	64	83
6	12/20/2021	$624,481,959.30	$167,447,792.39	$457,034,166.91	3,328	966	2,362	202	81	121
5	11/23/2021	$207,303,694.20	$45,724,559.71	$161,579,134.49	1,536	573	963	158	52	106
4	11/08/2021	$448,720,892.94	$133,423,417.40	$315,297,475.54	2,055	759	1,296	157	74	83
3	10/25/2021	$515,953,867.64	$215,956,072.28	$299,997,795.36	2,609	990	1,619	156	72	84
2	10/12/2021	$1,257,781,214.38	$346,862,117.22	$910,919,097.16	5,739	2,088	3,651	268	96	172
1	09/24/2021	$1,295,407,876.19	$170,648,774.56	$1,124,759,101.63	5,844	1,832	4,012	253	57	196

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.