Exporting FCC Reporting Data

Overview

Submitting data to the FCC can be time-consuming, but gaiia can help simplify the process. To match their requested format, you’ll need to combine data from gaiia with census tract data from the FCC.

This guide walks you through how to export, match, and format that data using spreadsheet tools like Google Sheets or Excel.

Step 1: Export your data from gaiia

1. Go to Analytics > Reports > Billing > Built in Reports > FCC Report Inputs.
2. Use the filters at the top to isolate the correct date range for the data you're submitting.
3. Click on the Export button at the top right of the screen.

Step 2: Match your addresses to FCC census tracts

1. Upload the file you downloaded from gaiia to the FCC’s batch address matching tool.
2. Use the settings: 
   Benchmark: Public_AR_Current
   Vintage: Census2020_Current
3. Click Get Results and download the output file.
4. Open the file in your spreadsheet tool of choice.
5. In column M (cell M1), use the following formula to concatenate the GEOID values:
   =I1 & J1 & K1. This gives you the 11 digit census tract code that you need for the FCC filing.

Step 3: Combine the census tracts with your gaiia export

1. Open a new spreadsheet workbook.
2. Import both the gaiia export (from Step 1) and the FCC export (from Step 2) as two separate sheets:
   • Sheet 1: gaiia export
   • Sheet 2: FCC census tracts
3. In the gaiia export sheet, add a new column titled Census Tract.
4. Use a function like VLOOKUP, XLOOKUP, or INDEX/MATCH to fetch the census tract using the gaiiaId as the unique identifier between the two sheets. 

Step 4: Format the final dataset for the FCC

1. Create a pivot table using your spreadsheet tool to match the format expected by the FCC.
2. Refer to the FCC’s formatting guide for exact output structure.