Data Collection

Objective: The objective of this step is to use our key words to collect data on who in the government is buying our products and services


Step 1: Create a folder for each of the products or services you are considering, so in our example we would create a folder for "Cyber training" "Penetration testing" and "Network configuration"


Step 2: Then go to USAspending.gov

Step 3:  In the search bar, in the upper right corner, type in your first key phrase, (including any quotation marks), and click "Go."


Step 4: The search will return every contract from the past ten years with that phrase in the contract description.

Step 5:  Hit the "Download" button.

 

A dialogue box will pop up as USASpending creates the file.

 

 

Click "Generate File" and the Generating File Box will appear:

 

When the file is ready, this box will pop up. Click the link to download the file. Once the download is complete, open the downloaded folder.


Step 6 (If you are on a Mac):  Double click on the downloaded folder and select the "Contracts.csv" file. Rename the file Contract-1, Contract-2, etc. so that the files don't overwite each other when you add them to the folders you created.

Then copy the file using [Cmd+C] and paste it into the folder you created [Cmd+V] for this product or service. You may see other files in this folder, such as "Subawards" or "Support." DO NOT copy those to your folder, only copy the "Contract" file.

Step 6 (If you are on Windows):  Double click the downloaded folder, then go to the top and select "Extract."

Once all the files are extracted a window should pop up. Select the "Contracts.csv" file and rename it Contract-1, Contract-2, etc. so that the files don't overwrite each other when you add them to the folder.

Then copy the Contracts file using [Ctrl+C] and paste it into the folder you created [Ctrl+V] for this product or service. You may see other files in this folder, such as "Subawards", or "Support." DO NOT copy those to your folder, only copy the "Contract" file.


Step 7: Repeat this process for all of your key words adding the contract.csv files to the correct folders.


Now that we have all the data in one place we need to aggregate it into one place.

Step 8: So go into your Worksheet and click on Get Data in the upper left and select one of the folders that you built for one of the products or services you are considering, DON'T double click into the folder, just click on it. Then click OK


Step 9: Click the "Format Data" button and add the name of this group of products or services.

Step 10:  Then repeat for each folder (all the folders will be in the same worksheet).


 

Interview with Founders

 

Topic: How did you plan your business?