Screaming Frog Datenbank Kompendium

Mit diesem Kompedium bekommst Du einen vollständigen Überblick über die Datenstruktur der Datenbank des Screaming Frogs.

AHREFS_API

Die Tabelle “AHREFS_API” beinhaltet Werte, die über die API von AHREFS.com abgerufen werden können.

Feldname Datentype Beschreibung
ENCODED_URL
BACKLINKS_EXACT
REFDOMAINS_EXACT
AHREFS_RANK_EXACT
REF_PAGES_EXACT
PAGES_EXACT
TEXT_EXACT
IMAGE_EXACT
SITEWIDE_EXACT
NOT_SITEWIDE_EXACT
NO_FOLLOW_EXACT
DO_FOLLOW_EXACT
REDIRECT_EXACT
CANONICAL_EXACT
GOV_EXACT
EDU_EXACT
HTML_PAGES_EXACT
LINKS_INTERNAL_EXACT
LINKES_EXTERNAL_EXACT
REFCLASS_C_EXACT
REF_IPS_EXACT
LINKED_ROOT_DOMAINS_EXACT
TWITTER_EXACT
PINTEREST_EXACT
GPLUS_EXACT
FACEBOOK_EXACT
FACEBOOK_LIKES_EXACT
FACEBOOK_SHARES_EXACT
FACEBOOK_COMMENTS_EXACT
FACEBOOK_CLICKS_EXACT
FACEBOOK_COMMENTS_BOX_EXACT
TOTAL_SHARES_EXACT
MEDIAN_SHARES_EXACT
POSITIONS
POSITIONS_TOP3
POSITIONS_TOP10
TRAFFIC
TRAFFIC_TOP3
TRAFFIC_TOP10
COST
COST_TOP3
COST_TOP10
BACKLINKS_EXACT_HTTP_AND_HTTPS
REFDOMAINS_EXACT_HTTP_AND_HTTPS
AHREFS_RANK_HTTP_AND_HTTPS
REF_PAGES_EXACT_HTTP_AND_HTTPS
PAGES_EXACT_HTTP_AND_HTTPS
TEXT_EXACT_HTTP_AND_HTTPS
IMAGE_EXACT_HTTP_AND_HTTPS
SITEWIDE_EXACT_HTTP_AND_HTTPS
NOT_SITEWIDE_EXACT_HTTP_AND_HTTPS
NO_FOLLOW_EXACT_HTTP_AND_HTTPS
DO_FOLLOW_EXACT_HTTP_AND_HTTPS
REDIRECT_EXACT_HTTP_AND_HTTPS
CANONICAL_EXACT_HTTP_AND_HTTPS
GOV_EXACT_HTTP_AND_HTTPS
EDU_EXACT_HTTP_AND_HTTPS
HTML_PAGES_EXACT_HTTP_AND_HTTPS
LINKS_INTERNAL_EXACT_HTTP_AND_HTTPS
LINKES_EXTERNAL_EXACT_HTTP_AND_HTTPS
REFCLASS_C_EXACT_HTTP_AND_HTTPS
REF_IPS_EXACT_HTTP_AND_HTTPS
LINKED_ROOT_DOMAINS_EXACT_HTTP_AND_HTTPS
TWITTER_EXACT_HTTP_AND_HTTPS
PINTEREST_EXACT_HTTP_AND_HTTPS
GPLUS_EXACT_HTTP_AND_HTTPS
FACEBOOK_EXACT_HTTP_AND_HTTPS
FACEBOOK_LIKES_EXACT_HTTP_AND_HTTPS
FACEBOOK_SHARES_EXACT_HTTP_AND_HTTPS
FACEBOOK_COMMENTS_EXACT_HTTP_AND_HTTPS
FACEBOOK_CLICKS_EXACT_HTTP_AND_HTTPS
FACEBOOK_COMMENTS_BOX_EXACT_HTTP_AND_HTTPS
TOTAL_SHARES_EXACT_HTTP_AND_HTTPS
MEDIAN_SHARES_EXACT_AND_HTTPS
POSITIONS_EXACT_HTTP_AND_HTTPS
POSITIONS_TOP3_EXACT_HTTP_AND_HTTPS
POSITIONS_TOP10_EXACT_HTTP_AND_HTTPS
TRAFFIC_EXACT_HTTP_AND_HTTPS
TRAFFIC_TOP3_EXACT_HTTP_AND_HTTPS
TRAFFIC_TOP10_EXACT_HTTP_AND_HTTPS
COST_EXACT_HTTP_AND_HTTPS
COST_TOP3_EXACT_HTTP_AND_HTTPS
COST_TOP10_EXACT_HTTP_AND_HTTPS
BACKLINKS_SUB_DOMAINS
REFDOMAINS_SUB_DOMAINS
REF_PAGES_SUB_DOMAINS
PAGES_SUB_DOMAINS
TEXT_SUB_DOMAINS
IMAGE_SUB_DOMAINS
SITEWIDE_SUB_DOMAINS
NOT_SITEWIDE_SUB_DOMAINS
NO_FOLLOW_SUB_DOMAINS
DO_FOLLOW_SUB_DOMAINS
REDIRECT_SUB_DOMAINS
CANONICAL_SUB_DOMAINS
GOV_SUB_DOMAINS
EDU_SUB_DOMAINS
HTML_PAGES_SUB_DOMAINS
LINKS_INTERNAL_SUB_DOMAINS
LINKES_EXTERNAL_SUB_DOMAINS
REFCLASS_C_SUB_DOMAINS
REF_IPS_SUB_DOMAINS
LINKED_ROOT_DOMAINS_SUB_DOMAINS
POSITIONS_SUB_DOMAINS
POSITIONS_TOP3_SUB_DOMAINS
POSITIONS_TOP10_SUB_DOMAINS
TRAFFIC_SUB_DOMAINS
TRAFFIC_TOP3_SUB_DOMAINS
TRAFFIC_TOP10_SUB_DOMAINS
COST_SUB_DOMAINS
COST_TOP3_SUB_DOMAINS
COST_TOP10_SUB_DOMAINS
BACKLINKS_DOMAIN
REFDOMAINS_DOMAIN
DOMAIN_RATING
AHREFS_TOP
REF_PAGES_DOMAIN
PAGES_DOMAIN
TEXT_DOMAIN
IMAGE_DOMAIN
SITEWIDE_DOMAIN
NOT_SITEWIDE_DOMAIN
NO_FOLLOW_DOMAIN
DO_FOLLOW_DOMAIN
REDIRECT_DOMAIN
CANONICAL_DOMAIN
GOV_DOMAIN
EDU_DOMAIN
HTML_PAGES_DOMAIN
LINKS_INTERNAL_DOMAIN
LINKES_EXTERNAL_DOMAIN
REFCLASS_C_DOMAIN
REF_IPS_DOMAIN
LINKED_ROOT_DOMAINS_DOMAIN
POSITIONS_DOMAIN
POSITIONS_TOP3_DOMAIN
POSITIONS_TOP10_DOMAIN
TRAFFIC_DOMAIN
TRAFFIC_TOP3_DOMAIN
TRAFFIC_TOP10_DOMAIN
COST_DOMAIN
COST_TOP3_DOMAIN
COST_TOP10_DOMAIN

ALT_TEXT_OVER_X_CHARACTERS_TRACKING

Feldname Datentype Beschreibung
COST_TOP10_DOMAIN
BAD_SRC_COUNT

AMP_VALIDATION_DATA

Feldname Datentype Beschreibung
ENCODED_URL
HAS_ERROR
DOCTYPE_IS_VALID
CONTAINS_HEAD
CONTAINS_BODY
CONTAINS_CANONICAL
CHARSET_IS_VALID
VIEWPORT_IS_VALID
AMP_SCRIPT_IS_VALID
AMP_BOILERPLATE_IS_VALID
CONTAINS_DISALLOWED_TAGS

CHROME_CONSOLE_DATA

Feldname Datentype Beschreibung
ENCODED_URL
COMPRESSED_JSON
NUM_ERRORS
NUM_WARNINGS
NUM_INFO
NUM_DEBUG
NUM_ISSUES

CUSTOM_EXTRACTION

Feldname Datentype Beschreibung
ENCODED_URL
EXTRACTOR_IDX
MATCHED

CUSTOM_FILTER_MATCHES

Feldname Datentype Beschreibung
ENCODED_URL
FILTER_IDX
NUM_MATCHES

DUPLICATES_H1

Feldname Datentype Beschreibung
DUPLICATE_KEY
ENCODED_URL

DUPLICATES_H2

Feldname Datentype Beschreibung
DUPLICATE_KEY
ENCODED_URL

DUPLICATES_META_DESCRIPTION

Feldname Datentype Beschreibung
DUPLICATE_KEY
ENCODED_URL

DUPLICATES_META_KEYWORDS

Feldname Datentype Beschreibung
DUPLICATE_KEY
ENCODED_URL

DUPLICATES_TITLE

Feldname Datentype Beschreibung
DUPLICATE_KEY
ENCODED_URL

DUPLICATES_URL

Feldname Datentype Beschreibung
DUPLICATE_KEY
ENCODED_URL

GA4

Feldname Datentype Beschreibung
GA4_KEY
ENCODED_URL
SESSIONS
SCREENPAGEVIEWS
ENGAGEDSESSIONS
ENGAGEMENTRATE
CONVERSIONS
EVENTCOUNT
TOTALREVENUE
ADDTOCARTS
CHECKOUTS
ECOMMERCEPURCHASES
ITEMLISTCLICKEVENTS
ITEMLISTCLICKTHROUGHRATE
ITEMLISTVIEWEVENTS
ITEMPROMOTIONCLICKTHROUGHRATE
PROMOTIONCLICKS
PROMOTIONVIEWS
ITEMSPURCHASED
ITEMREVENUE
ITEMVIEWEVENTS
ITEMSADDEDTOCART
ITEMSCHECKEDOUT
ITEMSCLICKEDINLIST
ITEMSCLICKEDINPROMOTION
ITEMSVIEWED
ITEMSVIEWEDINLIST
ITEMSVIEWEDINPROMOTION
PURCHASEREVENUE
SHIPPINGAMOUNT
TAXAMOUNT
TRANSACTIONS
TRANSACTIONSPERPURCHASER
EVENTCOUNTPERUSER
EVENTVALUE
EVENTSPERSESSION
CARTTOVIEWRATE
PURCHASETOVIEWRATE
PURCHASERCONVERSIONRATE
TOTALADREVENUE
SCREENPAGEVIEWSPERSESSION
PUBLISHERADIMPRESSIONS
PUBLISHERADCLICKS
ADUNITEXPOSURE
AVERAGEPURCHASEREVENUEPERPAYINGUSER
AVERAGEREVENUEPERUSER
AVERAGEPURCHASEREVENUE
AVERAGEPURCHASEREVENUEPERUSER
AVERAGESESSIONDURATION
BOUNCERATE
SESSIONCONVERSIONRATE
SESSIONSPERUSER
TOTALUSERS
NEWUSERS
ACTIVE1DAYUSERS
ACTIVE7DAYUSERS
ACTIVE28DAYUSERS
ACTIVEUSERS
DAUPERMAU
DAUPERWAU
FIRSTTIMEPURCHASERCONVERSIONRATE
FIRSTTIMEPURCHASERS
FIRSTTIMEPURCHASERSPERNEWUSER
TOTALPURCHASERS
USERCONVERSIONRATE
USERENGAGEMENTDURATION
WAUPERMAU

GOOGLE_ANALYTICS

Feldname Datentype Beschreibung
GA_KEY 
ENCODED_URL 
GA_SESSIONS 
GA__NEW_SESSIONS 
GA_USERS 
GA_NEW_USERS 
GA_BOUNCE_RATE 
GA_PAGE_VIEWS_PER_SESSSION 
GA_AVG_SESSION_DURATION 
GA_GOAL_CONVERSION_RATE_ALL 
GA_GOAL_COMPLETIONS_ALL 
GA_GOAL_VALUE_ALL 
GA_GOAL_1_COMPLETIONS 
GA_GOAL_2_COMPLETIONS 
GA_GOAL_3_COMPLETIONS 
GA_GOAL_4_COMPLETIONS 
GA_GOAL_5_COMPLETIONS 
GA_GOAL_6_COMPLETIONS 
GA_GOAL_7_COMPLETIONS 
GA_GOAL_8_COMPLETIONS 
GA_GOAL_9_COMPLETIONS 
GA_GOAL_10_COMPLETIONS 
GA_GOAL_11_COMPLETIONS
GA_GOAL_12_COMPLETIONS
GA_GOAL_13_COMPLETIONS
GA_GOAL_14_COMPLETIONS
GA_GOAL_15_COMPLETIONS
GA_GOAL_16_COMPLETIONS
GA_GOAL_17_COMPLETIONS
GA_GOAL_18_COMPLETIONS
GA_GOAL_19_COMPLETIONS
GA_GOAL_20_COMPLETIONS
GA_GOAL_1_VALUE 
GA_GOAL_2_VALUE 
GA_GOAL_3_VALUE 
GA_GOAL_4_VALUE 
GA_GOAL_5_VALUE 
GA_GOAL_6_VALUE 
GA_GOAL_7_VALUE 
GA_GOAL_8_VALUE 
GA_GOAL_9_VALUE 
GA_GOAL_10_VALUE 
GA_GOAL_11_VALUE 
GA_GOAL_12_VALUE 
GA_GOAL_13_VALUE 
GA_GOAL_14_VALUE 
GA_GOAL_15_VALUE 
GA_GOAL_16_VALUE 
GA_GOAL_17_VALUE 
GA_GOAL_18_VALUE 
GA_GOAL_19_VALUE 
GA_GOAL_20_VALUE
GA_GOAL_1_CONVERSION_RATE 
GA_GOAL_2_CONVERSION_RATE 
GA_GOAL_3_CONVERSION_RATE 
GA_GOAL_4_CONVERSION_RATE 
GA_GOAL_5_CONVERSION_RATE 
GA_GOAL_6_CONVERSION_RATE 
GA_GOAL_7_CONVERSION_RATE 
GA_GOAL_8_CONVERSION_RATE 
GA_GOAL_9_CONVERSION_RATE 
GA_GOAL_10_CONVERSION_RATE 
GA_GOAL_11_CONVERSION_RATE 
GA_GOAL_12_CONVERSION_RATE 
GA_GOAL_13_CONVERSION_RATE 
GA_GOAL_14_CONVERSION_RATE 
GA_GOAL_15_CONVERSION_RATE 
GA_GOAL_16_CONVERSION_RATE 
GA_GOAL_17_CONVERSION_RATE 
​​GA_GOAL_18_CONVERSION_RATE 
GA_GOAL_19_CONVERSION_RATE 
GA_GOAL_20_CONVERSION_RATE 
GA_PAGE_VIEWS 
GA_UNIQUE_PAGE_VIEWS 
GA_AVG_TIME_ON_PAGE 
GA_ENTRANCES 
GA_ENTRANCE_RATE 
GA_EXITS 
GA_EXIT_RATE 
GA_PAGE_VALUE 
GA_TRANSACTIONS 
GA_TRANSACTION_REVENUE 
GA_TRANSACTIONS_PER_SESSION 
GA_REVENUE_PER_TRANSACTION 
GA_IMPRESSIONS 
GA_AD_CLICKS 
GA_AD_COST 
GA_CPM 
GA_CPC 
GA_CTR 
GA_COST_PER_TRANSACTION 
GA_COST_PER_GOAL_CONVERSION 
GA_COST_PER_CONVERSION 
GA_ROAS 
GA_AVG_PAGE_LOAD_TIME 
GA_AVG_REDIRECTION_TIME 
GA_AVG_SERVER_RESPONSE_TIME 
GA_AVG_PAGE_DOWNLOAD_TIME 
GA_ADSENSE_REVENUE 
GA_AD_UNITES_VIEWED 
GA_ADS_VIEWED 
GA_ADSENSE_ADS_CLICKED 
GA_ADSENSE_PAGE_IMPRESSIONS 
GA_ADSENSE_EXITS 
GA_ADSENSE_VIEWABLE_IMPRESSIONS_ 
GA_ADSENSE_COVERAGE 
GA_ADSENSE_CTR 
GA_ADSENSE_ECPM 
GA_SOCIAL_ACTIVITIES 
GA_SOCIAL_INTERACTIONS

GOOGLE_SEARCH_CONSOLE

Feldname Datentype Beschreibung
GSC_KEY
ENCODED_URL
CLICKS
CLICKTHROUGH_RATE
IMPRESSIONS
POSITION

H1_STRING_SET

Feldname Datentype Beschreibung
ENCODED_URL

H2_STRING_SET

Feldname Datentype Beschreibung
ENCODED_URL

HTML_VALIDATION_DATA

Feldname Datentype Beschreibung
ENCODED_URL
INVALID_ELEMENTS_IN_HEAD
HEAD_NOT_FIRST_ELEMENT
MISSING_HEAD
MULTIPLE_HEADS
MISSING_BODY
MULTIPLE_BODIES
BODY_ELEMENT_PRECEDING_HTML
TITLE_OUTSIDE_HEAD
META_DESCRIPTION_OUTSIDE_HEAD
META_ROBOTS_OUTSIDE_HEAD
CANONICAL_OUTSIDE_HEAD
HREFLANG_OUTSIDE_HEAD

INLINKS_COUNT

Feldname Datentype Beschreibung
ENCODED_URL
NUM_HYPER_LINKS
NUM_UNIQUE_HYPER_LINKS
NUM_JS_UNIQUE_HYPER_LINKS
NUM_IMAGE_LINKS

LANGUAGE_ERROR

Feldname Datentype Beschreibung
ENCODED_URL
LANGUAGE_ERROR_DATA
LANGUAGE_CODE
SPELLING_ERRORS
GRAMMAR_ERRORS

LANGUAGE_ERROR_COUNTS

Feldname Datentype Beschreibung
SEGMENT
ID_KEY
ERROR_COUNT
URLS_AFFECTED
SAMPLE_URL

LINKS

Feldname Datentype Beschreibung
LINK_TYPE
SCOPE
ORIGIN
PATH_TYPE
ELEMENT_PATH
SRC_ID
DST_ID
ELEMENT_POSITION
ALT_TEXT
LINK_TEXT
HREF_LANG
NOFOLLOW
UGC
SPONSORED
TARGET
NOOPENER
NOREFERRER
IMAGE_DISPLAY_WIDTH
IMAGE_DISPLAY_HEIGHT
IMAGE_WIDTH_ATTRIBUTE
IMAGE_HEIGHT_ATTRIBUTE

LINK_SCORE

Feldname Datentype Beschreibung
ENCODED_URL
LINKSCORE

LOADED_RESOURCES

Feldname Datentype Beschreibung
ENCODED_URL
LOADED_RESOURCE

MAJESTIC_API

Feldname Datentype Beschreibung
ENCODED_URL
EXTERNAL_BACKLINKS_EXACT
REFERRING_DOMAINS_EXACT
TRUST_FLOW_EXACT
CITATION_FLOW_EXACT
REFERRING_IPS_EXACT
REFERRING_SUBNETS_EXACT
INDEXED_URLS_EXACT
EXTERNAL_BACKLINKS_EDU_EXACT
EXTERNAL_BACKLINKS_GOV_EXACT
REFERRING_DOMAINS_EDU_EXACT
REFERRING_DOMAINS_GOV_EXACT
TRUST_FLOWS_TOPICS_EXACT
ANCHOR_TEXT_EXACT
EXTERNAL_BACKLINKS_SUBDOMAIN
REFERRING_DOMAINS_SUBDOMAIN
TRUST_FLOW_SUBDOMAIN
CITATION_FLOW_SUBDOMAIN
REFERRING_IPS_SUBDOMAIN
REFERRING_SUBNETS_SUBDOMAIN
INDEXED_URLS_SUBDOMAIN
EXTERNAL_BACKLINKS_EDU_SUBDOMAIN
EXTERNAL_BACKLINKS_GOV_SUBDOMAIN
REFERRING_DOMAINS_EDU_SUBDOMAIN
REFERRING_DOMAINS_GOV_SUBDOMAIN
TRUST_FLOWS_TOPICS_SUBDOMAIN
ANCHOR_TEXT_SUBDOMAIN
EXTERNAL_BACKLINKS_DOMAIN
REFERRING_DOMAINS_DOMAIN
TRUST_FLOW_DOMAIN
CITATION_FLOW_DOMAIN
REFERRING_IPS_DOMAIN
REFERRING_SUBNETS_DOMAIN
INDEXED_URLS_DOMAIN
EXTERNAL_BACKLINKS_EDU_DOMAIN
EXTERNAL_BACKLINKS_GOV_DOMAIN
REFERRING_DOMAINS_EDU_DOMAIN
REFERRING_DOMAINS_GOV_DOMAIN
TRUST_FLOWS_TOPICS_DOMAIN
ANCHOR_TEXT_DOMAIN
EXTERNAL_BACKLINS_HTTP_AND_HTTPS
REFERRING_DOMAINS_HTTP_AND_HTTPS
REFERRING_IPS__HTTP_AND_HTTPS
REFERRING_SUBNETS_HTTP_AND_HTTPS
INDEXED_URLS__HTTP_AND_HTTPS
EXTERNAL_BACKLINKS_EDU_HTTP_AND_HTTPS
EXTERNAL_BACKLINKS_GOV_HTTP_AND_HTTPS
REFERRING_DOMAINS_EDU_HTTP_AND_HTTPS
REFERRING_DOMAINS_GOV_HTTP_AND_HTTPS

META_DESCRIPTION_STRING_SET

Feldname Datentype Beschreibung
ENCODED_URL

META_KEYWORD_STRING_SET

Feldname Datentype Beschreibung
ENCODED_URL

MISSING_ALT_ATTRIBUTE_TRACKER

Feldname Datentype Beschreibung
ENCODED_URL
BAD_SRC_COUNT

MISSING_ALT_TEXT_TRACKER

Feldname Datentype Beschreibung
ENCODED_URL
BAD_SRC_COUNT

MISSING_SIZE_ATTRIBUTES

Feldname Datentype Beschreibung
ENCODED_URL
BAD_SRC_COUNT

MOZSCAPE_API

Feldname Datentype Beschreibung
ENCODED_URL
CANONICAL_URL
PAGE_AUTHORITY_EXACT
MOZ_RANK_EXACT
MOZ_RANK_EXTERNAL_EQUITY_EXACT
MOZ_TRUST_EXACT
TIME_LAST_CRAWLED_EXACT
LINKS_EXACT
EXTERNAL_EQUITY_LINKS_EXACT
EQUITY_LINKS_EXACT
SUBDOMAINS_LINKING_EXACT
ROOT_DOMAINS_LINKING_EXACT
EXTERNAL_LINKS_EXACT
EXTERNAL_EQUITY_LINKS_SUB_DOMAIN
SUBDOMAINS_LINKING_SUB_DOMAIN
SPAM_SCORE_SUB_DOMAIN
MOZ_TRUST_SUB_DOMAIN
MOZ_RANK_SUBDOMAIN
MOZ_RANK_EXTERNAL_EQUITY_SUBDOMAIN
MOZ_RANK_COMBINED_SUBDOMAIN
LINKS_TO_SUBDOMAIN
ROOT_DOMAINS_LINKING_TO_SUBDOMAIN
EXTERNAL_LINKS_TO_SUBDOMAIN
DOMAIN_AUTHORITY_DOMAIN
EXTERNAL_EQUITY_LINKS_ROOT_DOMAIN
ROOT_DOMAINS_LINKING_DOMAIN
LINKING_C_BLOCKS_DOMAIN
MOZ_TRUST_DOMAIN
MOZ_RANK_DOMAIN
MOZ_RANK_EXTERNAL_EQUITY_DOMAIN
MOZ_RANK_COMBINED_DOMAIN
LINKS_TO_ROOT_DOMAIN
EXTERNAL_LINKS_TO_ROOT_DOMAIN

MULTIMAP_AMP_HTML_MISSING_NON_AMP_CANONICAL

Feldname Datentype Beschreibung
MULTIMAP_KEY
MULTIMAP_VALUE

MULTIMAP_AMP_HTML_NON_CONFIRMATION_CANONICAL

Feldname Datentype Beschreibung
MULTIMAP_KEY
MULTIMAP_VALUE

MULTIMAP_AMP_HTML_NON_INDEXABLE_CANONICAL

Feldname Datentype Beschreibung
MULTIMAP_KEY
MULTIMAP_VALUE

MULTIMAP_CANONICALS_PENDING_LINK

Feldname Datentype Beschreibung
MULTIMAP_KEY
MULTIMAP_VALUE

MULTIMAP_HREF_LANG_CANONICAL_CONFIRMATION

Feldname Datentype Beschreibung
MULTIMAP_KEY
MULTIMAP_VALUE

MULTIMAP_HREF_LANG_INCONSISTENT_LANGUAGE_CONFIRMATION

Feldname Datentype Beschreibung
MULTIMAP_KEY
MULTIMAP_VALUE

MULTIMAP_HREF_LANG_MISSING_CONFIRMATION

Feldname Datentype Beschreibung
MULTIMAP_KEY
MULTIMAP_VALUE

MULTIMAP_HREF_LANG_NON_200_LINK

Feldname Datentype Beschreibung
MULTIMAP_KEY
MULTIMAP_VALUE

MULTIMAP_HREF_LANG_NO_INDEX_CONFIRMATION

Feldname Datentype Beschreibung
MULTIMAP_KEY
MULTIMAP_VALUE

MULTIMAP_JAVASCRIPT_PAGES_WITH_BLOCKED_RESOURCES

Feldname Datentype Beschreibung
MULTIMAP_KEY
MULTIMAP_VALUE

MULTIMAP_PAGINATION_PENDING_LINK

Feldname Datentype Beschreibung
MULTIMAP_KEY
MULTIMAP_VALUE

MULTIMAP_PAGINATION_SEQUENCE_ERROR

Feldname Datentype Beschreibung
MULTIMAP_KEY
MULTIMAP_VALUE

NEAR_DUPLICATE

Feldname Datentype Beschreibung
ENCODED_URL
CLOSEST_MATCH_PERCENTAGE
NUMBER_OF_NEAR_DUPLICATES
NEAR_DUPLICATE_INSTANCES

PAGE_SPEED_API

Feldname Datentype Beschreibung
ENCODED_URL
SF_REQUEST_STATUS_KEY
SF_REQUEST_ERROR_KEY
JSON_RESPONSE
PERFORMANCE_SCORE
TIME_TO_FIRST_BYTE_MS
FIRST_CONTENTFUL_PAINT
FIRST_CONTENTFUL_PAINT_SCORE
SPEED_INDEX
SPEED_INDEX_SCORE
LARGEST_CONTENTFUL_PAINT
LARGEST_CONTENTFUL_PAINT_SCORE
TIME_TO_INTERACTIVE
TIME_TO_INTERACTIVE_SCORE
FIRST_MEANINGFUL_PAINT
FIRST_MEANINGFUL_PAINT_SCORE
ESTIMATED_INPUT_LATENCY
ESTIMATED_INPUT_LATENCY_SCORE
FIRST_CPU_IDLE
FIRST_CPU_IDLE_SCORE
MAX_POTENTIAL_FIRST_INPUT_DELAY
MAX_POTENTIAL_FIRST_INPUT_DELAY_SCORE
TOTAL_BLOCKING_TIME
TOTAL_BLOCKING_TIME_SCORE
CUMULATIVE_LAYOUT_SHIFT
CUMULATIVE_LAYOUT_SHIFT_SCORE
TOTAL_OPPORTUNITY_SAVINGS_BYTES
TOTAL_OPPORTUNITY_SAVINGS_MS
TOTAL_REQUESTS
TOTAL_PAGE_SIZE
HTML_SIZE
HTML_COUNT
IMAGE_SIZE
IMAGE_COUNT
CSS_SIZE
CSS_COUNT
JAVASCRIPT_SIZE
JAVASCRIPT_COUNT
FONT_SIZE
FONT_COUNT
MEDIA_SIZE
MEDIA_COUNT
OTHER_SIZE
OTHER_COUNT
THIRD_PARTY_SIZE
THIRD_PARTY_COUNT
LOADING_EXPERIENCE_SCORE
LOADING_EXPERIENCE_FIRST_CONTENTFUL_PAINT_TIME
LOADING_EXPERIENCE_FIRST_CONTENTFUL_PAINT_CATEGORY
LOADING_EXPERIENCE_FIRST_INPUT_DELAY
LOADING_EXPERIENCE_FIRST_INPUT_DELAY_CATEGORY
LOADING_EXPERIENCE_LARGEST_CONTENTFUL_PAINT_TIME
LOADING_EXPERIENCE_LARGEST_CONTENTFUL_PAINT_CATEGORY
LOADING_EXPERIENCE_CUMULATIVE_LAYOUT_SHIFT
LOADING_EXPERIENCE_CUMULATIVE_LAYOUT_SHIFT_CATEGORY
LOADING_EXPERIENCE_INTERACTION_TO_NEXT_PAINT_CATEGORY
LOADING_EXPERIENCE_INTERACTION_TO_NEXT_PAINT_MS
LOADING_EXPERIENCE_TIME_TO_FIRST_BYTE_CATEGORY
LOADING_EXPERIENCE_TIME_TO_FIRST_BYTE_MS
ORIGIN_PERFORMANCE_SCORE
ORIGIN_FIRST_CONTENTFUL_PAINT
ORIGIN_FIRST_CONTENTFUL_PAINT_CATEGORY
ORIGIN_FIRST_INPUT_DELAY
ORIGIN_FIRST_INPUT_DELAY_CATEGORY
ORIGIN_LOADING_EXPERIENCE_LARGEST_CONTENTFUL_PAINT_TIME
ORIGIN_LOADING_EXPERIENCE_LARGEST_CONTENTFUL_PAINT_CATEGORY
ORIGIN_LOADING_EXPERIENCE_CUMULATIVE_LAYOUT_SHIFT
ORIGIN_LOADING_EXPERIENCE_CUMULATIVE_LAYOUT_SHIFT_CATEGORY
ORIGIN_LOADING_EXPERIENCE_INTERACTION_TO_NEXT_PAINT_CATEGORY
ORIGIN_LOADING_EXPERIENCE_INTERACTION_TO_NEXT_PAINT_MS
ORIGIN_LOADING_EXPERIENCE_TIME_TO_FIRST_BYTE_CATEGORY
ORIGIN_LOADING_EXPERIENCE_TIME_TO_FIRST_BYTE_MS
ELIMINATE_RENDER_BLOCKING_RESOURCES
DEFER_OFFSCREEN_IMAGES_MS
DEFER_OFFSCREEN_IMAGES_SIZE
EFFICIENTLY_ENCODE_IMAGES_MS
EFFICIENTLY_ENCODE_IMAGES_SIZE
PROPERLY_SIZE_IMAGES_MS
PROPERLY_SIZE_IMAGES_SIZE
MINIFY_CSS_MS
MINIFY_CSS_SIZE
MINIFY_JAVASCRIPT_MS
MINIFY_JAVASCRIPT_SIZE
REMOVE_UNUSED_CSS_MS
REMOVE_UNUSED_CSS_SIZE
REMOVE_UNUSED_JAVASCRIPT_MS
REMOVE_UNUSED_JAVASCRIPT_SIZE
NEXT_GEN_IMAGES_MS
NEXT_GEN_IMAGES_SIZE
TEXT_COMPRESSION_MS
TEXT_COMPRESSION_SIZE
PRECONNECT_MS
SERVER_RESPONSE_TIMES_SAVINGS_MS
SERVER_RESPONSE_TIMES_CATEGORY
REDIRECTS
PRELOAD
VIDEO_FORMAT_MS
VIDEO_FORMAT_SIZE
TOTAL_IMAGE_OPTIMIZATION_SAVINGS
LEGACY_JAVASCRIPT
EXCESSIVE_DOM_SIZE
JS_EXECUTION_TIME
JS_EXECUTION_TIME_CATEGORY
INEFFICIENT_CACHE_POLICY
MAIN_THREAD_WORK_MS
MAIN_THREAD_WORK_CATEGORY
TEXT_VISIBLE_DURING_LOAD
UNSIZED_IMAGES
LAYOUT_SHIFT_ELEMENTS

SITEMAP_RESULTS

Feldname Datentype Beschreibung
SITEMAP_URL
SRC
DST
HREF_LANG
PATH_TYPE
ELEMENT_PATH
ELEMENT_POSITION

TITLE_STRING_SET

Feldname Datentype Beschreibung
ENCODED_URL

UNIQUE_URLS

Feldname Datentype Beschreibung
ID
ENCODED_URL

URLS

Feldname Datentype Beschreibung
ENCODED_URL
RESPONSE_MSG
RESPONSE_CODE
RESPONSE_TIME_MS
MD5SUM
PAGE_SIZE
LAST_MODIFIED_DATE
CRAWL_DEPTH
IS_INTERNAL
CONTENT_TYPE
ORIGINAL_CONTENT
RENDERED_CONTENT
WORD_COUNT
WORD_COUNT_JS
SENTENCE_COUNT
AVG_WORDS_PER_SENTENCE
READABILITY_SCORE
CRAWL_COUNT
REDIRECT_COUNT
CRAWL_IN_ESCAPED_FRAGMENT_FORM
BLOCKED_BY_ROBOTS_TXT
MATCHED_ROBOTS_TXT_LINE
ROOT_URL
TEXT_TO_HTML_RATIO
NUM_INTERNAL_OUTLINKS
NUM_EXTERNAL_OUTLINKS
NUM_UNIQUE_INTERNAL_OUTLINKS
NUM_UNIQUE_EXTERNAL_OUTLINKS
NUM_JS_UNIQUE_INTERNAL_OUTLINKS
NUM_JS_UNIQUE_EXTERNAL_OUTLINKS
LOADED_AS_A_RESOURCE
IS_AMP_HTML
HAS_HSTS_HEADER
HAS_CSP_HEADER
HAS_NOSNIFF_HEADER
HAS_FRAME_OPTIONS_HEADER
HAS_STRICT_REFERRER_POLICY
HTTP_VERSION
BOOKMARK_VALID
TIMESTAMP
HTML_FORM_COLLECTION
HTTP_REQUEST_HEADER_COLLECTION
HTTP_RESPONSE_HEADER_COLLECTION
COOKIE_COLLECTION
NUM_TITLES
TITLE_1
TITLE_2
NUM_TITLES_JS
TITLE_JS_1
TITLE_JS_2
NUM_H1
H1_1
H1_2
H1_SOURCE_1
H1_SOURCE_2
NUM_H1_JS
H1_JS_1
H1_JS_2
H1_JS_SOURCE_1
H1_JS_SOURCE_2
NUM_H2
H2_1
H2_2
H2_SOURCE_1
H2_SOURCE_2
NUM_XROBOTS
X_ROBOT_TAG_1
X_ROBOT_TAG_2
X_ROBOT_TAG_3
X_ROBOT_TAG_4
X_ROBOT_TAG_5
X_ROBOT_TAG_6
X_ROBOT_TAG_7
X_ROBOT_TAG_8
X_ROBOT_TAG_9
X_ROBOT_TAG_10
X_ROBOT_TAG_11
X_ROBOT_TAG_12
X_ROBOT_TAG_13
X_ROBOT_TAG_14
X_ROBOT_TAG_15
X_ROBOT_TAG_16
X_ROBOT_TAG_17
X_ROBOT_TAG_18
X_ROBOT_TAG_19
X_ROBOT_TAG_20
SERIALISED_STRUCTURED_DATA
PARSE_ERROR_MSG
NUM_META
META_NAME_1
META_NAME_2
META_NAME_3
META_NAME_4
META_NAME_5
META_NAME_6
META_NAME_7
META_NAME_8
META_NAME_9
META_NAME_10
META_NAME_11
META_NAME_12
META_NAME_13
META_NAME_14
META_NAME_15
META_NAME_16
META_NAME_17
META_NAME_18
META_NAME_19
META_NAME_20
META_CONTENT_1
META_CONTENT_2
META_CONTENT_3
META_CONTENT_4
META_CONTENT_5
META_CONTENT_6
META_CONTENT_7
META_CONTENT_8
META_CONTENT_9
META_CONTENT_10
META_CONTENT_11
META_CONTENT_12
META_CONTENT_13
META_CONTENT_14
META_CONTENT_15
META_CONTENT_16
META_CONTENT_17
META_CONTENT_18
META_CONTENT_19
META_CONTENT_20
NUM_META_JS
META_NAME_JS_1
META_NAME_JS_2
META_NAME_JS_3
META_NAME_JS_4
META_NAME_JS_5
META_NAME_JS_6
META_NAME_JS_7
META_NAME_JS_8
META_NAME_JS_9
META_NAME_JS_10
META_NAME_JS_11
META_NAME_JS_12
META_NAME_JS_13
META_NAME_JS_14
META_NAME_JS_15
META_NAME_JS_16
META_NAME_JS_17
META_NAME_JS_18
META_NAME_JS_19
META_NAME_JS_20
META_CONTENT_JS_1
META_CONTENT_JS_2
META_CONTENT_JS_3
META_CONTENT_JS_4
META_CONTENT_JS_5
META_CONTENT_JS_6
META_CONTENT_JS_7
META_CONTENT_JS_8
META_CONTENT_JS_9
META_CONTENT_JS_10
META_CONTENT_JS_11
META_CONTENT_JS_12
META_CONTENT_JS_13
META_CONTENT_JS_14
META_CONTENT_JS_15
META_CONTENT_JS_16
META_CONTENT_JS_17
META_CONTENT_JS_18
META_CONTENT_JS_19
META_CONTENT_JS_20
NUM_METAREFRESH
METAREFRESH_CONTENT_1
METAREFRESH_CONTENT_2
META_FULL_URL_1
META_FULL_URL_2
METAREFRESH_PATH_TYPE_1
METAREFRESH_PATH_TYPE_2
METAREFRESH_ELEMENT_PATH_1
METAREFRESH_ELEMENT_PATH_2
METAREFRESH_ELEMENT_POSITION_1
METAREFRESH_ELEMENT_POSITION_2
METAREFRESH_SCOPE_1
METAREFRESH_SCOPE_2
IS_REDIRECT
IS_SELF_REF_META_REFRESH
IS_CANONICALISED
SIMILARITY_MATCH_PERCENTAGE
PDF_SUBJECT
PDF_AUTHOR
PDF_CREATION_DATE
PDF_MODIFIED_DATE
PDF_PAGE_COUNT
IMAGE_WIDTH
IMAGE_HEIGHT
SEGMENTS
IS_SOFT_404
LOREM_IPSUM_OCCURRENCES
PAGE_TRANSFER_SIZE
NON_SEQUENTIAL_H1
NON_SEQUENTIAL_H2
SOFTWARE_VERSION

URL_FILTER_KEYMAP_NORMAL

Feldname Datentype Beschreibung
ENCODED_URL
MAPPED_ENCODED_URL
DIFF_NEW_ENUM_MAP
DIFF_REMOVED_ENUM_MAP
DIFF_MISSING_ENUM_MAP
DIFF_ADDED_ENUM_MAP
ENUM_MAP
DIFF_PREVIOUS_ENUM_MAP
DIFF_PARITY_CURRENT_ENUM_MAP
DIFF_PARITY_PREVIOUS_ENUM_MAP

URL_FILTER_KEYMAP_POST_CRAWL_ANALYSIS

Feldname Datentype Beschreibung
ENCODED_URL
MAPPED_ENCODED_URL
DIFF_NEW_ENUM_MAP
DIFF_REMOVED_ENUM_MAP
DIFF_MISSING_ENUM_MAP
DIFF_ADDED_ENUM_MAP
ENUM_MAP
DIFF_PREVIOUS_ENUM_MAP
DIFF_PARITY_CURRENT_ENUM_MAP
DIFF_PARITY_PREVIOUS_ENUM_MAP

URL_FILTER_KEYMAP_SPELLING_AND_GRAMMAR

Feldname Datentype Beschreibung
ENCODED_URL
MAPPED_ENCODED_URL
DIFF_NEW_ENUM_MAP
DIFF_REMOVED_ENUM_MAP
DIFF_MISSING_ENUM_MAP
DIFF_ADDED_ENUM_MAP
ENUM_MAP
DIFF_PREVIOUS_ENUM_MAP
DIFF_PARITY_CURRENT_ENUM_MAP
DIFF_PARITY_PREVIOUS_ENUM_MAP

URL_INSPECTION

Feldname Datentype Beschreibung
ENCODED_URL
SF_REQUEST_STATUS_KEY
SF_REQUEST_ERROR_KEY
SUMMARY
COVERAGE_STATE
LAST_CRAWL_TIME
DAYS_SINCE_LAST_CRAWL
CRAWLED_AS
ROBOTS_TXT_STATE
PAGE_FETCH_STATE
INDEXING_STATE
USER_CANONICAL
GOOGLE_CANONICAL
MOBILE_USABILITY_VERDICT
MOBILE_USABILITY_ISSUES
AMP_RESULTS_VERDICT
AMP_ISSUES
RICH_RESULTS_VERDICT
RICH_RESULTS_TYPES
RICH_RESULTS_TYPE_ERRORS
RICH_RESULTS_TYPE_WARNINGS
JSON

URL_STRING_SET

Feldname Datentype Beschreibung
ENCODED_URL

WAITING_URLS

Feldname Datentype Beschreibung
LEVEL
ENCODED_URL
ROOT_URL
CRAWL_COUNT
REDIRECT_COUNT
ESCAPED_FORM