MS Excel File

Every BEAT report includes a downloadable MS Excel file with the following worksheets:

Worksheet Description
all_domains_* A data table with all attributes, quality and graph metrics for ALL domains in the report
consider_for_backlinks A data table with all attributes, quality and graph metrics for ONLY the domains in the Consider for backlinks list
consider_for_backlinks_list_2 A data table with all attributes, quality and graph metrics for ONLY the domains in the Consider for backlinks (list 2) list
consider_disavowing A data table with all attributes, quality and graph metrics for ONLY the domains in the Consider disavowing list
metrics_br_graph_* General metrics about the graph of backlinks referral relationships for that report
metrics_lr_graph_* General metrics about the graph of links relationships for that report

* The report type (e.g., inner)

The all_domains_* worksheet

This worksheet (and the consider_for_backlinks, consider_for_backlinks_list_2, and consider_disavowing worksheets) contains the following columns:

Column Additional notes
Name The domain name
Sub-directory path An (optional) sub-directory path used to refine the referring domains data for that domain (this can only be used with domains of the types principal and competitor)
Type
Target competitors
Whitelist Filter for 'yes' to view only domains in the Whitelist
Ignore list Filter for 'yes' to view only domains in the Ignore list
Auto CD list Filter for 'yes' to view only domains in the Automatic consider disavowing list
Distance (lr)
Eco backlinks
Eco links
Eco rankvmax
Eco spam max
Eco PageRank (br)
Degree (lr)
Out degree (br)
In degree (br)
Closeness (lr)
Outward closeness (br)
Inward closeness (br)
Betweenness (lr)
Directed betweenness (br)
Meta data status 'OK' indicates all metadata was obtained for analysis; other values indicate errors obtaining the metadata
Meta title The domain's meta title text
Meta title common #
Meta title common
Meta title NSS
Meta description The domain's meta title text
Meta description common #
Meta description common
Meta description NSS
Consider for backlinks Filter for 'yes' to view only domains in the Consider for backlinks list
Consider for backlinks (list 2) Filter for 'yes' to view only domains in the Consider for backlinks (list 2) list
Consider disavowing Filter for 'yes' to view only domains in the Consider disavowing (list 2) list

The (lr) and (br) at the end of some column names denotes whether the value is calculated using the graph of links relationships, or the graph of backlinks referral relationships.

The metrics_br_graph_* worksheet

This worksheet contains a table of graph metrics about the graph of backlinks referral relationships for that report:

Metric Notes
Nodes The number of domains in the report
Edges The number of backlinks referral relationships in the report
Isolates The number of domains that are disconnected from the graph
Density A graph measure of how dense the graph is (on a scale from 0 to 1)
Density (exc. isolates) A graph measure of how dense the graph is, excluding any domains that are disconnected

A second table provides a count (and percentages) for each domain type.

The metrics_lr_graph_* worksheet

This worksheet follows the same format as the metrics_br_graph_* worksheet, but for the graph of links relationships for that report.