For your spreadsheet data to be correctly interpreted by Reportei, you need to classify the type of each column\/row <\/strong>depending on how your spreadsheet is structured. This step ensures that the data can be read, grouped, and correctly displayed in charts, tables, metrics, and filters.<\/p>\n

However, before starting the configuration, it is important to check two fundamental points in your spreadsheet.<\/p>\n

1. Identify the format of the spreadsheet<\/strong><\/span><\/span><\/h3>\n

First, you need to check how the data is arranged in your spreadsheets. To do this, see which of the following structures your spreadsheet falls into:<\/p>\n

\n
• Vertical spreadsheets<\/strong> In this structure, titles should be in the first row<\/strong> with the data below them.<\/li>\n
• Horizontal spreadsheets<\/strong> Structure where titles are in the first column<\/strong> with data laid out beside them in the subsequent columns.<\/li>\n<\/ul>\n

  \n

  2. Decimal separator<\/strong><\/span><\/span><\/h3>\n

  Check if the decimal separator used in the spreadsheet, whether a dot or comma, is the same as configured in your project within Reportei.<\/p>\n

  If they are different, it will be necessary to adjust either the spreadsheet or the project settings <\/strong> so that they use the same separator.<\/strong><\/p>\n

  \u26a0\ufe0f Attention: Changing the project settings will impact all the reports and dashboards<\/strong> linked to it. Therefore, we recommend making the change in the spreadsheet.<\/em><\/p>\n

  Once this is done, we move on to the stage of identifying and classifying the types of columns.<\/p>\n

  \n

  Types of columns\/rows<\/strong><\/span><\/span><\/h2>\n

  During linking, you will need to indicate the type of each column\/row.<\/strong> If the spreadsheet fits the vertical format, the type classification will be based on each column. If it fits the horizontal format, the type classification will be based on each row of the spreadsheet.<\/p>\n

  Currently, it is possible to classify with the following types:<\/p>\n

  \n
  • Metric<\/li>\n
  • Dimension<\/li>\n
  • Date<\/li>\n
  • Dimension\/Metric<\/li>\n
  • Not identified<\/li>\n<\/ul>\n

    Metric type column<\/strong><\/span><\/span><\/h3>\n

    \n

    They are columns with numerical values that are typically used in calculations.<\/p>\n

    \n
    • Examples of use<\/strong>:\n
      \n
      • sum<\/li>\n
      • calculate average<\/li>\n
      • count<\/li>\n<\/ul>\n<\/li>\n
      • Examples of Metric type data:<\/strong>:\n
        \n
        • Invested amount <\/li>\n
        • Reach <\/li>\n
        • Clicks<\/li>\n<\/ul>\n<\/li>\n
        • Where it can be used<\/strong>:\n
          \n
          • Number widgets<\/li>\n
          • Graph series<\/li>\n
          • Numerical columns in tables<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n

            \n

            Dimension type columns<\/strong><\/span><\/span><\/h3>\n

            They are those columns used to group or filter the data,<\/strong> usually with texts or categories.<\/p>\n

            \n
            • Examples of data<\/strong>:\n
              \n
              • Campaign name<\/li>\n
              • Channel<\/li>\n
              • Ad type<\/li>\n<\/ul>\n<\/li>\n
              • Where it can be used<\/strong>:\n
                \n
                • Filters in number cards<\/li>\n
                • Grouping in graphs<\/li>\n
                • Text columns in tables<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n

                  \n

                  Columns with Dimension\/Metric type<\/strong><\/span><\/span><\/h3>\n

                  \n

                  They are columns that can be used both as metric and dimension,<\/strong> i.e., they can represent numerical values or categories.<\/p>\n

                  \n
                  • Examples of data<\/strong>:\n
                    \n
                    • Country<\/li>\n
                    • Traffic source <\/li>\n
                    • Device<\/li>\n<\/ul>\n<\/li>\n
                    • Where it can be used<\/strong>:\n
                      \n
                      • Anywhere dimensions or metrics are accepted.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n

                        \n

                        Date type columns<\/strong><\/span><\/span><\/h3>\n

                        \n

                        These are columns that contain date values.<\/p>\n

                        \n
                        • Examples of data<\/strong>:\n
                          \n
                          • Hiring date <\/li>\n
                          • Campaign date <\/li>\n
                          • Month<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n

                            Where it can be used<\/strong>:<\/p>\n

                            \n
                            • Period filters for reports, dashboards, widgets.<\/li>\n
                            • Time-based grouping in graphs<\/li>\n
                            • Display in table columns<\/li>\n<\/ul>\n

                              \n

                              Unidentified type columns<\/strong><\/span><\/span><\/h3>\n

                              When the system cannot automatically recognize the content of the column, it will come as Not identified type.<\/p>\n

                              These columns need to be reviewed and manually classified for use. Otherwise, columns classified with this type will be ignored in metric creation and data analysis.<\/p>\n

                              Final tip<\/strong><\/span><\/span><\/h2>\n

                              Correct classification of columns ensures accurate data interpretation in all visualizations. If any column is incorrectly classified or outdated, it may compromise data transfer. So, when importing your spreadsheet, pay attention to these points.<\/p>\n

                              \u26a0\ufe0f\u00a0Important<\/strong> After completing the data classification<\/strong> in Reportei, it will not be possible to edit it. Therefore, avoid making changes to the structure of the original spreadsheet,<\/strong> such as moving, adding, or deleting columns. These changes may compromise the correct reading of the data. If you need to make any structural adjustments, it will be necessary to perform a new integration of the spreadsheet<\/strong> with Reportei.<\/p>\n","protected":false},"excerpt":{"rendered":"

                              For your spreadsheet data to be correctly interpreted by Reportei, you need to classify the type of each column\/row depending on how your spreadsheet is structured. This step ensures that the data can be read, grouped, and correctly displayed in charts, tables, metrics, and filters. However, before starting the configuration, it is important to check […]<\/p>\n","protected":false},"author":9,"featured_media":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"inline_featured_image":false,"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"helpdesk_category":[4179],"helpie_tag":[],"helpie_add_tag":[],"helpie_up_tag":[],"class_list":["post-82677","pauple_helpie","type-pauple_helpie","status-publish","format-standard","hentry","helpdesk_category-google-sheets"],"_links":{"self":[{"href":"https:\/\/reportei.com\/en\/wp-json\/wp\/v2\/pauple_helpie\/82677","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/reportei.com\/en\/wp-json\/wp\/v2\/pauple_helpie"}],"about":[{"href":"https:\/\/reportei.com\/en\/wp-json\/wp\/v2\/types\/pauple_helpie"}],"author":[{"embeddable":true,"href":"https:\/\/reportei.com\/en\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/reportei.com\/en\/wp-json\/wp\/v2\/comments?post=82677"}],"version-history":[{"count":2,"href":"https:\/\/reportei.com\/en\/wp-json\/wp\/v2\/pauple_helpie\/82677\/revisions"}],"predecessor-version":[{"id":82709,"href":"https:\/\/reportei.com\/en\/wp-json\/wp\/v2\/pauple_helpie\/82677\/revisions\/82709"}],"wp:attachment":[{"href":"https:\/\/reportei.com\/en\/wp-json\/wp\/v2\/media?parent=82677"}],"wp:term":[{"taxonomy":"helpdesk_category","embeddable":true,"href":"https:\/\/reportei.com\/en\/wp-json\/wp\/v2\/helpdesk_category?post=82677"},{"taxonomy":"helpie_tag","embeddable":true,"href":"https:\/\/reportei.com\/en\/wp-json\/wp\/v2\/helpie_tag?post=82677"},{"taxonomy":"helpie_add_tag","embeddable":true,"href":"https:\/\/reportei.com\/en\/wp-json\/wp\/v2\/helpie_add_tag?post=82677"},{"taxonomy":"helpie_up_tag","embeddable":true,"href":"https:\/\/reportei.com\/en\/wp-json\/wp\/v2\/helpie_up_tag?post=82677"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}