{"id":7450,"date":"2024-06-05T19:27:08","date_gmt":"2024-06-05T17:27:08","guid":{"rendered":"https:\/\/searchstudies.org\/?page_id=7450"},"modified":"2024-08-27T19:10:57","modified_gmt":"2024-08-27T17:10:57","slug":"rat-data-structure","status":"publish","type":"page","link":"https:\/\/searchstudies.org\/de\/rat-software\/rat-data-structure\/","title":{"rendered":"RAT data structure"},"content":{"rendered":"

\n\n \"\" <\/div>\n<\/div><\/div>
\n
\n\n\t

Download study results as an Excel file. Here's what you will find in this file<\/h1>\n<\/div>\n<\/div><\/div><\/div><\/div><\/section>
<\/p>\n

The Result Assessment Tool allows for automatically scraping search results from search engines, classifying them with existing classifiers and having them assessed by human jurors. In the assessments, the study participants answer questions about the respective search result (e.g. whether the search result is relevant to the query).\u00a0<\/span><\/p>\n

When you download your data from RAT, the system generates a comprehensive Excel file. The structure and the variables in that file, which are described in the tables below, provide a detailed overview of the data. You can also\u00a0RAT sample output<\/a>\u00a0showing how the output looks like.<\/span><\/p>\n

The following table lists all possible variables in a RAT Dataset. The table is divided into four sections:<\/span><\/p>\n

    \n
  1. \u00a0<\/span><\/span>Main data (this is what is generated in all cases, regardless of which classifiers or assessments you use)<\/span><\/li>\n
  2. Source data (saved HTML source code and a screenshot of the search result)<\/span><\/li>\n
  3. Evaluation data (data generated by participants when answering questions about a particular search result)<\/span><\/li>\n
  4. Classification data (data generated with the help of a classifier, i.e., the SEO classifier)<\/span><\/li>\n<\/ol>\n

    \n<\/div><\/div><\/div><\/div><\/div><\/section>

    \n
    \n\n\t

    Main data<\/h3>\n<\/div>\n<\/div><\/div><\/div><\/div><\/section>
    <\/p>\n\n\n\n\n<\/colgroup>\n\n\n\n\n\n\n\n\n\n\n\n\n
    Variable<\/td>\nDescription<\/td>\nType<\/td>\n<\/tr>\n
    id<\/td>\nUnique identifier for each row in the table<\/td>\nnumber<\/td>\n<\/tr>\n
    query<\/td>\nKeywords of the query.<\/td>\ntext<\/td>\n<\/tr>\n
    url<\/td>\nURL of the search result.<\/td>\ntext<\/td>\n<\/tr>\n
    main<\/td>\nMain URL of the search result (e.g. google.com instead of google.com\/imghp?hl=en).<\/td>\ntext<\/td>\n<\/tr>\n
    search engine<\/td>\nName of the Search Engine<\/td>\ntext<\/td>\n<\/tr>\n
    position<\/td>\nRank position of the search result at the time of scraping.<\/td>\nnumber<\/td>\n<\/tr>\n
    title<\/td>\nTitle of the search result on the search engine result page, given by the search engine.<\/td>\ntext<\/td>\n<\/tr>\n
    description<\/td>\nDescription of the search result on the search engine result page, given by the search engine.<\/td>\ntext<\/td>\n<\/tr>\n
    ip<\/td>\nThe IP address of the search result.<\/td>\ntext<\/td>\n<\/tr>\n
    timestamp<\/td>\nThe timestamp of scraping.<\/td>\ntimestamp<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

    \n<\/div>\n

    \n\n\t

    Source data<\/h3>\n<\/div>\n
    <\/p>\n\n\n\n\n<\/colgroup>\n\n\n\n\n\n
    Variable<\/td>\nDescription<\/td>\nType<\/td>\n<\/tr>\n
    html<\/td>\nHTML source code<\/td>\ntext<\/td>\n<\/tr>\n
    screenshot<\/td>\nScreenshot from the search result<\/td>\nbyte<\/td>\n<\/tr>\n
    screenshot_timestamp<\/td>\nThe timestamp of the screenshot<\/td>\ntimestamp<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

    \n<\/div>\n

    \n\n\t

    Evaluation data<\/h3>\n<\/div>\n
    <\/p>\n\n\n\n\n<\/colgroup>\n\n\n\n\n\n\n\n
    Variable<\/td>\nDescription<\/td>\nType<\/td>\n<\/tr>\n
    participant<\/td>\nUnique identifier for the study participant<\/td>\nnumber<\/td>\n<\/tr>\n
    id_question<\/td>\nUnique identifier for the question asked<\/td>\ntext<\/td>\n<\/tr>\n
    question<\/td>\nText of the question<\/td>\ntext<\/td>\n<\/tr>\n
    value<\/td>\nAnswer of the participant to the question.<\/td>\ntext<\/td>\n<\/tr>\n
    question_timestamp<\/td>\nThe timestamp of the answer<\/td>\ntimestamp<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

    \n<\/div>\n

    \n\n\t

    Classification data<\/h3>\n<\/div>\n
    <\/p>\n

    \nPlease note that the table describes the output of the SEO classifier. Other classifiers will output different fields; see the documentation.<\/p>\n

    \n<\/div>

    <\/p>\n\n\n\n\n<\/colgroup>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
    seo_class<\/td>\nResult of classifying the probability of applying search engine optimization methods to the search result. (not optimized; probably not optimized; probably optimized; most probably optimized)<\/td>\ntext<\/td>\n<\/tr>\n
    seo_timestamp<\/td>\nThe timestamp of classification of SEO probability of the search result.<\/td>\ntimestamp<\/td>\n<\/tr>\n
    ads<\/td>\nMatches the domain to a list of websites that use ad services. (1 = match; 0 = no match).<\/td>\nnumber<\/td>\n<\/tr>\n
    canonical<\/td>\nCheck whether canonical links were found in the source code of the search result.<\/td>\nnumber<\/td>\n<\/tr>\n
    company<\/td>\nMatching the domain with a list of known companies. Check if the domain could be found.<\/td>\nnumber<\/td>\n<\/tr>\n
    description<\/td>\nCheck if a description was found in the source code.<\/td>\nnumber<\/td>\n<\/tr>\n
    external<\/td>\nCounter of external links in a document.<\/td>\nnumber<\/td>\n<\/tr>\n
    h1<\/td>\nCounter of h1 headings in a document.<\/td>\nnumber<\/td>\n<\/tr>\n
    https<\/td>\nCheck if the website uses https.<\/td>\nnumber<\/td>\n<\/tr>\n
    internal<\/td>\nCounter of internal links in a document.<\/td>\nnumber<\/td>\n<\/tr>\n
    keyword_density<\/td>\nCalculate the keyword density in a document.<\/td>\nnumber<\/td>\n<\/tr>\n
    keywords_in_source<\/td>\nCounter of keywords found in the source code.<\/td>\nnumber<\/td>\n<\/tr>\n
    keywords_in_url<\/td>\nCounter of keywords in the URL.<\/td>\nnumber<\/td>\n<\/tr>\n
    <\/td>\nCalculated loading time of a web page in seconds.<\/td>\nnumber<\/td>\n<\/tr>\n
    loading_time<\/td>\n<\/tr>\n
    micros<\/td>\nCheck whether microdata formats like JSON-LD are used in a document.<\/td>\nnumber<\/td>\n<\/tr>\n
    news<\/td>\nMatching the domain with a list of known news services. Check if the domain could be found.<\/td>\nnumber<\/td>\n<\/tr>\n
    nofollow<\/td>\nCounter of nofollow links in a document.<\/td>\ntext<\/td>\n<\/tr>\n
    not_optimized<\/td>\nMatching the domain with a list of known non SEO optimized documents.<\/td>\nnumber<\/td>\n<\/tr>\n
    <\/td>\ncounter of elements in a document with an og: tag.<\/td>\n<\/td>\n<\/tr>\n
    og<\/td>\nnumber<\/td>\n<\/tr>\n
    robots_txt<\/td>\nCheck if any references to SEO were found in the robots.txt file of a domain.<\/td>\nnumber<\/td>\n<\/tr>\n
    search_engine_services<\/td>\nMatching the domain with a list of known search engine services like books.google.com.<\/td>\nnumber<\/td>\n<\/tr>\n
    shops<\/td>\nMatching of the domain with a list of known shops.<\/td>\nnumber<\/td>\n<\/tr>\n
    <\/td>\nCheck whether a sitemap was used on the search results web page.<\/td>\n<\/td>\n<\/tr>\n
    sitemap<\/td>\nnumber<\/td>\n<\/tr>\n
    title<\/td>\nCheck whether a title was used on the search result web page.<\/td>\nnumber<\/td>\n<\/tr>\n
    <\/td>\nList of identified ad services found on the web page.<\/td>\n<\/td>\n<\/tr>\n
    tools ads<\/td>\nlist<\/td>\n<\/tr>\n
    tools analytics<\/td>\nList of identified analytics services found on the web page.<\/td>\nlist<\/td>\n<\/tr>\n
    <\/td>\nList of identified caching plugins found on the web page.<\/td>\n<\/td>\n<\/tr>\n
    tools caching<\/td>\nlist<\/td>\n<\/tr>\n
    tools content<\/td>\nList of identified content services found on the web page.<\/td>\nlist<\/td>\n<\/tr>\n
    tools seo<\/td>\nList of identified SEO plugins found on the web page.<\/td>\nlist<\/td>\n<\/tr>\n
    tools social<\/td>\nList of identified social plugins found on the web page.<\/td>\nlist<\/td>\n<\/tr>\n
    url_length<\/td>\nLength of the URL.<\/td>\nnumber<\/td>\n<\/tr>\n
    viewport<\/td>\nCheck if a viewport tag was found in the document<\/td>\nnumber<\/td>\n<\/tr>\n
    wordpress<\/td>\nCheck, if WordPress is used as CMS<\/td>\nnumber<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

    \n<\/div>

    <\/p>\n

    Further information about the implementation of the SEO classifier is available at\u00a0https:\/\/osf.io\/u8d62<\/a>.<\/span><\/p>\n

    \u00a0<\/span><\/p>\n

    \n<\/div>

    <\/p>\n

    Contact information for questions about the data set:\u00a0sebastian.suenkler@haw-hamburg.de<\/a>.<\/span><\/p>\n

    \n<\/div>

    <\/div><\/div><\/div>
    <\/div><\/div><\/div><\/div><\/section><\/p>","protected":false},"excerpt":{"rendered":"","protected":false},"author":3,"featured_media":6974,"parent":7271,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"yoast_head":"\nRAT data structure - Search Studies Research Group<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/searchstudies.org\/de\/rat-software\/rat-data-structure\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"RAT data structure - Search Studies Research Group\" \/>\n<meta property=\"og:description\" content=\"Download study results as an Excel file. Here’s what you will find in this file The Result Assessment Tool allows for automatically scraping search results from search engines, classifying them with existing classifiers and having them assessed by human jurors. In the assessments, the study participants answer questions about the respective search result (e.g. whether […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/searchstudies.org\/de\/rat-software\/rat-data-structure\/\" \/>\n<meta property=\"og:site_name\" content=\"Search Studies Research Group\" \/>\n<meta property=\"article:modified_time\" content=\"2024-08-27T17:10:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/searchstudies.org\/wp-content\/uploads\/2023\/12\/other.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"287\" \/>\n\t<meta property=\"og:image:height\" content=\"215\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data1\" content=\"5\u00a0Minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/searchstudies.org\/rat-software\/rat-data-structure\/\",\"url\":\"https:\/\/searchstudies.org\/rat-software\/rat-data-structure\/\",\"name\":\"RAT data structure - Search Studies Research Group\",\"isPartOf\":{\"@id\":\"http:\/\/searchstudies.org\/de\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/searchstudies.org\/rat-software\/rat-data-structure\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/searchstudies.org\/rat-software\/rat-data-structure\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/searchstudies.org\/wp-content\/uploads\/2023\/12\/other.jpg\",\"datePublished\":\"2024-06-05T17:27:08+00:00\",\"dateModified\":\"2024-08-27T17:10:57+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/searchstudies.org\/rat-software\/rat-data-structure\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/searchstudies.org\/rat-software\/rat-data-structure\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/searchstudies.org\/rat-software\/rat-data-structure\/#primaryimage\",\"url\":\"https:\/\/searchstudies.org\/wp-content\/uploads\/2023\/12\/other.jpg\",\"contentUrl\":\"https:\/\/searchstudies.org\/wp-content\/uploads\/2023\/12\/other.jpg\",\"width\":287,\"height\":215},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/searchstudies.org\/rat-software\/rat-data-structure\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/searchstudies.org\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"RAT Software\",\"item\":\"https:\/\/searchstudies.org\/rat-software\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"RAT data structure\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\/\/searchstudies.org\/de\/#website\",\"url\":\"http:\/\/searchstudies.org\/de\/\",\"name\":\"Search Studies Research Group\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\/\/searchstudies.org\/de\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"de\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"RAT data structure - Search Studies Research Group","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/searchstudies.org\/de\/rat-software\/rat-data-structure\/","og_locale":"de_DE","og_type":"article","og_title":"RAT data structure - Search Studies Research Group","og_description":"Download study results as an Excel file. Here’s what you will find in this file The Result Assessment Tool allows for automatically scraping search results from search engines, classifying them with existing classifiers and having them assessed by human jurors. In the assessments, the study participants answer questions about the respective search result (e.g. whether […]","og_url":"https:\/\/searchstudies.org\/de\/rat-software\/rat-data-structure\/","og_site_name":"Search Studies Research Group","article_modified_time":"2024-08-27T17:10:57+00:00","og_image":[{"width":287,"height":215,"url":"https:\/\/searchstudies.org\/wp-content\/uploads\/2023\/12\/other.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Gesch\u00e4tzte Lesezeit":"5\u00a0Minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/searchstudies.org\/rat-software\/rat-data-structure\/","url":"https:\/\/searchstudies.org\/rat-software\/rat-data-structure\/","name":"RAT data structure - Search Studies Research Group","isPartOf":{"@id":"http:\/\/searchstudies.org\/de\/#website"},"primaryImageOfPage":{"@id":"https:\/\/searchstudies.org\/rat-software\/rat-data-structure\/#primaryimage"},"image":{"@id":"https:\/\/searchstudies.org\/rat-software\/rat-data-structure\/#primaryimage"},"thumbnailUrl":"https:\/\/searchstudies.org\/wp-content\/uploads\/2023\/12\/other.jpg","datePublished":"2024-06-05T17:27:08+00:00","dateModified":"2024-08-27T17:10:57+00:00","breadcrumb":{"@id":"https:\/\/searchstudies.org\/rat-software\/rat-data-structure\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/searchstudies.org\/rat-software\/rat-data-structure\/"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/searchstudies.org\/rat-software\/rat-data-structure\/#primaryimage","url":"https:\/\/searchstudies.org\/wp-content\/uploads\/2023\/12\/other.jpg","contentUrl":"https:\/\/searchstudies.org\/wp-content\/uploads\/2023\/12\/other.jpg","width":287,"height":215},{"@type":"BreadcrumbList","@id":"https:\/\/searchstudies.org\/rat-software\/rat-data-structure\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/searchstudies.org\/"},{"@type":"ListItem","position":2,"name":"RAT Software","item":"https:\/\/searchstudies.org\/rat-software\/"},{"@type":"ListItem","position":3,"name":"RAT data structure"}]},{"@type":"WebSite","@id":"http:\/\/searchstudies.org\/de\/#website","url":"http:\/\/searchstudies.org\/de\/","name":"Search Studies Research Group","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/searchstudies.org\/de\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"de"}]}},"_links":{"self":[{"href":"https:\/\/searchstudies.org\/de\/wp-json\/wp\/v2\/pages\/7450"}],"collection":[{"href":"https:\/\/searchstudies.org\/de\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/searchstudies.org\/de\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/searchstudies.org\/de\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/searchstudies.org\/de\/wp-json\/wp\/v2\/comments?post=7450"}],"version-history":[{"count":12,"href":"https:\/\/searchstudies.org\/de\/wp-json\/wp\/v2\/pages\/7450\/revisions"}],"predecessor-version":[{"id":7688,"href":"https:\/\/searchstudies.org\/de\/wp-json\/wp\/v2\/pages\/7450\/revisions\/7688"}],"up":[{"embeddable":true,"href":"https:\/\/searchstudies.org\/de\/wp-json\/wp\/v2\/pages\/7271"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/searchstudies.org\/de\/wp-json\/wp\/v2\/media\/6974"}],"wp:attachment":[{"href":"https:\/\/searchstudies.org\/de\/wp-json\/wp\/v2\/media?parent=7450"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}