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”
Click “Generate File” and the Generating File Box will appear.
When the file is ready, 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” fileand 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).