Table of Contents

Using Sonar's FCC Broadband Label Generation Tool

Jennifer Trower Updated by Jennifer Trower

Read Time: 10 mins

How to Create FCC Broadband Labels from Sonar

  1. In Sonar, go to Reports > Accounts and run the FCC Broadband Consumer Labels report.
  2. Click the three dots menu in the top right of the report tile and select Download Data.
  3. Select CSV format from the selection list (the default), then click Advanced data options.
  1. Ensure the data values are set to Unformatted and then click Download.
  1. Open the CSV file (a spreadsheet application is recommended for this) and complete the blank columns as necessary for each data service.
You may delete rows for which you do not need to generate an FCC Broadband label, but be sure to keep the header row — the label generator software uses it to check file integrity.
  1. Save the completed file in CSV format, then upload it to fcclabels.sonar.expert.
  2. Download the generated labels and review them.
    If you have any service or fee descriptions, which are longer than the label can accommodate, you may need to shorten the descriptions and then regenerate the labels.

Data Entry Guide

Some columns in the CSV will be populated from Sonar, but others will require data entry. Fortunately, many of the fields which require data to be entered will have the same value for all data services. This allows you to enter data once and then copy down the column.

Column

Field

Format

Data provided in Sonar report?

Notes

A

company_name

Text, e.g., “Sonar Software”

Yes

The rows in the report will be grouped by company for ease of data entry.

Note: if you have multiple companies set up in Sonar and data services which are not assigned to a specific company, the data service will be repeated in the report, once for each company.

B

discounts_and_bundles_url

URL, e.g., https://www.sonar.software/bundles

No

Enter the URL of the company webpage which describes the discounts and bundles available for your data services.

C

acp

Text, either “Yes” or “No”

No

This field indicates if the company participates in the Affordability Connectivity Program.

Enter “Yes” if the company does participate in the ACP, or “No” if they do not.

D

customer_support_url

URL, e.g., https://www.sonar.software/support

No

Enter the URL of the company’s customer support site.

E

customer_support_phone

Phone Number, e.g., 123-456-7890

No

Enter the company’s customer support phone number

F

network_management_url

URL, e.g., https://www.sonar.software/network

No

Enter the URL of the company’s network management policy page.

G

privacy_policy_url

URL, e.g., https://www.sonar.software/privacy

No

Enter the URL of the company’s privacy policy page.

H

fcc_id

Text, maximum 25 characters

No

Enter the company’s FCC ID Note: the label generator uses the company FCC ID as part of the Unique Plan Identifier.

I

data_service_id

Text, e.g., “123”, maximum 15 characters

Yes

The label report pre-populates this with the ID of the data service record in Sonar, but you can change it to whatever you need, so long as it is a combination of letters and numbers (e.g., SONAR123). The label generator will left-pad the ID with zeros to the required 15 characters for the Unique Plan ID.

J

data_service_name

Text, e.g., “MaxSpeed 100”

Yes

The report populates this with the name of the data service in the Sonar app.

K

fixed_or_mobile

Text, e.g., “Fixed” or “Mobile”

Yes

For fixed plans, enter “Fixed”. For mobile plans, enter “Mobile”.

Note: the label notes whether the plan is Fixed or Mobile, both in the label heading and the Unique Plan Identifier.

L

data_service_price

Dollar amount, e.g., 70.95

Yes

This amount is pre-populated from the Sonar app. If you do need to enter a price manually in the label CSV file, enter dollars and cents up to two decimal places (that is, to the penny).

If you are charging a dollar rate with no cents (such as $50.00), you can just enter the whole number with no decimals (50).

Note: This is the regular service price after any introductory discount period is completed.

M

billing_frequency_in_months

Integer (Number of months), e.g., 1

Yes

The FCC requires all billing to be per month on the label, so if the frequency listed here is different from 1 (for example, twice a month would be 2), then the label generator will calculate the prices accordingly.

N

introductory_period_in_months

Integer (Number of months), e.g., 6

No

Enter how long (in months) the introductory period is for the data service. If there is no introductory service, leave this field blank.

O

introductory_price_per_month

Price (e.g., ###.##), e.g., 50.00

No

Enter the introductory price per month in dollars and cents up to two decimal places (that is, to the penny).

If you are charging a dollar rate with no cents (such as $50.00), you can just enter the whole number with no decimals (50). If there is no introductory service, leave this field blank.

P

contract_duration

Integer (Number of months), e.g., 12

No

Enter the contract duration in months. If there is no contract required with this data service, leave blank.

Q

contract_url

URL, e.g., https://www.sonar.software/contracts

No

Enter the URL where the contract details may be found. If there is no contract required with this data service, leave blank.

R

monthly_fee_name_1

Text (e.g., “Modem rental”)

No

If there are any additional monthly service fees attached to the data service, they may be listed here (see below for a note on how to add additional monthly fees to the CSV.) Important: the CSV file must at minimum contain the monthly_fee_name_1 column.

Do not delete this column if you don’t need it; just leave it blank.

FCC description of additional monthly fees: These fees include all charges that providers impose at their discretion, i.e., charges not mandated by a government. Providers must give each fee a simple, accurate, easy-to-understand name, thus enabling consumers to understand which charges are part of the provider’s rate structure, and which derive from government assessments or programs. Further, the requirement allows consumers to more meaningfully compare providers’ rates and service packages, and to make more informed decisions when purchasing broadband services. Providers must list fees such as monthly charges associated with regulatory programs and fees for the rental or leasing of modem and other network connection equipment.

S

monthly_fee_price_1

Price (e.g., ###.##), e.g., 100.00

No

Enter the monthly price corresponding to the monthly fee name above. Important: the CSV file must at minimum contain the monthly_fee_price_1 column.

Do not delete this column if you don’t need it; just leave it blank. If you need to list more than one monthly fee, add more columns to the CSV directly after the provided monthly fee name and price columns, and number them accordingly. For example, if you have two additional monthly fees as part of a data service, you would add four additional columns so that the entire monthly fee section in the CSV shows: monthly_fee_name_1,monthly_fee_price_1,monthly_fee_name_2,monthly_fee_price_2 If you do not need to add monthly fees for any other data services in your CSV, you can just leave them blank for those rows where they are not applicable.

T

onetime_fee_name_1

Text (e.g., “Technician visit”)

No

If there are any additional one-time service fees charged when the data service is first purchased, they may be listed here (see below for a note on how to add additional one-time fees to the CSV).

Important: the CSV file must at minimum contain the onetime_fee_name_1 column. Do not delete this column if you don’t need it; just leave it blank.

FCC description of additional one-time fees: Include the name and cost of each one-time fee assessed by the provider when the consumer signs up for service. This section will identify one-time fees such as a charge for purchasing a modem, gateway, or router; an activation fee; a deposit; an installation fee; or a charge for late payment. The provider must also identify any one-time fees that will be imposed if the customer cancels their broadband service before the end of a contract term (e.g., an early termination fee) and provide a link to a full explanation of when such a fee is triggered.

U

onetime_fee_price_1

Price (e.g., ###.##), e.g., 100.00

No

Enter the one-time price corresponding to the one-time fee name above. Important: the CSV file must at minimum contain the onetime_fee_price_1 column.

Do not delete this column if you don’t need it; just leave it blank. If you need to list more than one one-time fee, add more columns to the CSV directly after the provided one-time fee name and price columns, and number them accordingly, following the same conventions as for additional monthly fees above. As with additional monthly, fees, if you do not need to add one-time fees for any other data services in your CSV, you can just leave them blank for those rows where they are not applicable.

V

early_termination_fee

Price (e.g., ###.##), e.g., 100.00

No

If there is a fee for terminating the data service before the arranged date, enter a fee here, otherwise leave it blank.

W

dl_speed_in_kbps

Formats: Integer, e.g., 100000, interpreted as Kbps and will be converted to Mbps with 1 place decimal precision (e.g., 1.5 Mbps not 1.50 Mbps)

Decimal, e.g., 1.5, interpreted as Mbps and will be converted to 1 place decimal precision.

Yes

Any decimals ending in .0 are converted to whole numbers (e.g., 100.0 Mbps is displayed as 100 Mbps) This field will be pre-populated from the data service fields in Sonar.

X

ul_speed_in_kbps

Formats: Integer, e.g., 100000, interpreted as Kbps and will be converted to Mbps with 1 place decimal precision (e.g., 1.5 Mbps not 1.50 Mbps)

Decimal, e.g., 1.5, interpreted as Mbps and will be converted to 1 place decimal precision.

Yes

Any decimals ending in .0 are converted to whole numbers (e.g., 100.0 Mbps is displayed as 100 Mbps) This field will be pre-populated from the data service fields in Sonar.

Y

latency_in_ms

Integer (Milliseconds), e.g., 120

No

Enter the average latency in milliseconds.

Z

data_included_in_monthly_price

Integer (GB), e.g., 1000

Yes

This field will be pre-populated if you have attached an overage service to the data service. Otherwise, you may enter the details manually.

If the data service is unlimited, leave this field blank.

AA

overage_fee

Price (e.g., ###.##), e.g., 5.00

Yes

This field will be pre-populated if you have attached an overage service to the data service. Otherwise, you may enter the details manually.

If the data service is unlimited, leave this field blank.

AB

overage_data_amount

Integer (GB), e.g., 5

Yes

This field will be pre-populated if you have attached an overage service to the data service. Otherwise, you may enter the details manually.

If the data service is unlimited, leave this field blank.

Generated Label Usage Information

  • The generated labels are text-based SVGs (not paths). This makes them both machine-readable and readable by screen readers, per the FCC standards.
  • The SVGs have all the required styles and font import directives included. There is no need to write additional CSS on any webpages to style the labels.
    • In order for the labels’ styles to be used by the web browser, the SVGs need to be copied and pasted directly into the webpage displaying them.
Using an <img> tag or other linking will ignore the styles and result in incorrect formatting.
  • The labels will resize automatically to the size of their parent container when placed in a webpage.
If you need to import the SVGs into graphics editing software like Illustrator or Photoshop, ensure you have the Roboto and Roboto Flex fonts installed first. These are available for free from https://fonts.google.com.

How did we do?

Account Groups: Overview & Example Use Cases

CPUC Fixed Broadband Deployment by Address

Contact