{"id":66001,"date":"2026-03-10T11:42:38","date_gmt":"2026-03-10T11:42:38","guid":{"rendered":"https:\/\/www.sogolytics.com\/help\/?page_id=66001"},"modified":"2026-03-12T07:07:35","modified_gmt":"2026-03-12T07:07:35","slug":"build-activity-using-a-file","status":"publish","type":"page","link":"https:\/\/www.sogolytics.com\/help\/build-activity-using-a-file\/","title":{"rendered":"Build Activity Using A File"},"content":{"rendered":"

Want to track important interactions related to your contacts? Activities allow you to store and manage transactional or event-based records associated with contacts in a Directory. With Activities, you can keep track of information such as purchases, service visits, support cases, or any other events connected to your contacts.<\/p>\n

\n For example:<\/span> A retail company maintains a Customer Directory<\/strong> containing customer contact details such as Name, Email Address, and Phone Number. The company wants to track customer purchases so they can later collect feedback about recent purchases. To do this, they create an Activity called Purchase History<\/strong> and import purchase records from an Excel file. Each record contains information such as Customer Email, Product Purchased, Purchase Date, Store Location, and Amount.
\n<\/span>\n <\/div>\n

To build an Activity using a File as the source, follow the steps below:<\/p>\n

    \n
  1. Open the Directory<\/strong> where you want to create the Activity.<\/li>\n
  2. Click the Activities<\/strong> tab next to the All Contacts<\/strong> tab.<\/li>\n
  3. Click + Add Activities<\/strong>.<\/li>\n
  4. In the dialog box that appears, enter a name for the Activity you want to associate with the selected Directory.<\/li>\n
  5. To create additional activities, click + Add Activity<\/strong>.<\/li>\n
    <\/i><\/p>\n

    A maximum of 50 activities can be added per directory.<\/p>\n<\/div>\n

  6. Once you have added the Activity name(s), click Save<\/strong>. The newly created Activities will appear under the Activities<\/strong> tab.<\/li>\n

    <\/p>\n

    \n For example:<\/span> Based on the example above, you may name the Activity Purchase History<\/strong>.
    \n<\/span>\n <\/div>\n
  7. Hover over the Activity into which you want to import records and select Import Records<\/strong>.<\/li>\n

    <\/p>\n

  8. Select From a file<\/strong> as the source for importing records. This option allows you to upload records using an Excel<\/strong> or CSV<\/strong> file. You can preview the uploaded file by clicking the eye icon<\/strong> next to the file, or delete it and upload a new one by clicking the delete icon<\/strong>.<\/li>\n

    <\/p>\n

    <\/i><\/p>\n

    \n

      \n
    • The maximum file size allowed for upload is 25 MB<\/strong><\/li>\n
    • Enable My file has a header<\/strong> if the first row of your file contains headers or labels for each column. When this option is enabled, the first row will be excluded from being imported as a record.<\/ul>\n<\/div>\n
    • Click Continue<\/strong>.<\/li>\n
    • Define Directory Lookup:<\/strong> In this step define a mapping rule that connects the Activity records with contacts in the parent Directory.<\/li>\n
      \n For example:<\/span> In the Purchase History example, the Email Address<\/strong> from the Customer Directory can be mapped to the Customer Email<\/strong> field in the Activity to link each purchase record to the correct customer.<\/span>\n <\/div>\n

      There are two types of Activity mapping:<\/p>\n

        \n
      • Respondent Mapping:<\/strong> This is used when the survey respondents are contacts in the same Directory where the Activity exists. To configure Respondent Mapping, follow the steps below:\n
          \n
        1. Select the Directory Field<\/strong> you want to use for the lookup.<\/li>\n
        2. Map it to the corresponding Activity Field<\/strong>.<\/li>\n<\/ol>\n
        3. Feedback Recipient Mapping:<\/strong> This is used when the feedback recipient belongs to a different Directory, such as employees, vendors, or service providers. To configure Feedback Recipient Mapping, follow the steps below:\n
            \n
          1. Toggle Create Feedback Recipient Mapping<\/strong>.<\/li>\n
          2. Select the Directory<\/strong> from which the feedback recipients will be pulled.<\/li>\n
          3. Choose the appropriate Directory Field<\/strong>.<\/li>\n
          4. Ensure it matches the corresponding Activity Field<\/strong>.<\/li>\n<\/ol>\n<\/ul>\n
            \n For example:<\/span> Continuing with the retail company example, the company may also want to collect feedback about the salesperson<\/strong> who assisted the customer during the purchase. In this case, the customer remains the respondent from the Customer Directory<\/strong>, while the salesperson belongs to a separate Salesperson Employee Directory<\/strong>– the Feedback Recipient Directory. <\/p>\n

            When importing the Purchase History activity file, the record may include a field such as Salesperson Email<\/strong> or Salesperson ID<\/strong>. This field can be mapped to the corresponding field in the Salesperson Directory<\/strong> to identify the salesperson associated with that purchase. This allows feedback to be directed to the correct salesperson based on the activity record.<\/p>\n


            \n<\/span>\n <\/div>\n

            \n<\/i><\/p>\n
            \n
              \n
            • While creating the Respondent Lookup<\/strong>, the parent Directory field selected for respondent mapping must exactly match one of the fields in the Activity.<\/li>\n
            • The Feedback Recipient directory must be different from the Respondent Directory.\n
            • Once the mapping is created, it cannot be edited later. If changes are required, you must delete the Activity and create a new one.<\/li>\n<\/ul>\n<\/div>\n<\/div>\n
            • Click Continue<\/strong>.<\/li>\n
            • Map Fields:<\/strong> In this step, define the field type<\/strong> for each imported field.<\/li>\n
              \n For example:<\/span> In the Purchase History scenario, the imported file may contain fields such as:<\/p>\n
                \n
              • Customer Email (Email)<\/li>\n
              • Product Purchased (String)<\/li>\n
              • Purchase Date (Date)<\/li>\n
              • Store Location (String)<\/li>\n
              • Amount (Number)<\/li>\n<\/ul>\n

                <\/span>\n <\/div>\n

                Available field types include:<\/p>\n

                  \n
                • String<\/strong> \u2013 Used for text-based information.<\/li>\n
                • Email<\/strong> \u2013 Used for storing email addresses.<\/li>\n
                • Number<\/strong> \u2013 Used for storing integer values.<\/li>\n
                • Date<\/strong> \u2013 Used for saving dates in the following formats: MM\/DD\/YYYY, DD\/MM\/YYYY, YYYY-MM-DD.<\/li>\n
                • Time<\/strong> \u2013 Used for saving time as hh:mm or hh:mm:ss.<\/li>\n
                • Date-Time<\/strong> \u2013 Used for saving date and time in the following formats:\n
                    \n
                  • MM\/DD\/YYYY hh:mm<\/li>\n
                  • DD\/MM\/YYYY hh:mm<\/li>\n
                  • YYYY\/MM\/DD hh:mm<\/li>\n
                  • MM\/DD\/YYYY hh:mm:ss<\/li>\n
                  • DD\/MM\/YYYY hh:mm:ss<\/li>\n
                  • YYYY\/MM\/DD hh:mm:ss<\/li>\n<\/ul>\n<\/li>\n
                  • Boolean<\/strong> \u2013 Used for saving Boolean values such as 1|0, Yes|No, Y|N, True|False. These values are normalized to True and False after importing.<\/li>\n
                  • Phone<\/strong> \u2013 Used for saving phone numbers. You can specify the country code by clicking the gear icon<\/strong> next to the Field Type column.<\/li>\n
                  • URL<\/strong> \u2013 Used for saving URLs.<\/li>\n<\/ul>\n<\/ul>\n

                    <\/p>\n

                    \n<\/i><\/p>\n
                    \nThe system may automatically detect some field types. For fields that are not recognized automatically, you can import them as Custom Fields<\/strong> and assign the appropriate field type.\n<\/div>\n<\/div>\n
                  • Click Continue<\/strong>. The mapped fields will be evaluated based on their defined field types, and valid records will be imported into the Activity.<\/li>\n","protected":false},"excerpt":{"rendered":"

                    Want to track important interactions related to your contacts? Activities allow you to store and manage transactional or event-based records associated with contacts in a Directory. With Activities, you can keep track of information such as purchases, service visits, support cases, or any other events connected to your contacts. To build an Activity using a File as the source, follow the steps below: Open the Directory where you want to create the Activity. Click the Activities tab next to the All Contacts tab. Click + Add Activities. In the dialog box that appears, enter a name for the Activity you want to associate with the selected Directory. To create additional activities, click + Add Activity. A maximum of 50 activities can be added per directory. Once you have added the Activity name(s), click Save. The newly created Activities will appear under the Activities tab. Hover over the Activity into which you want to import records and select Import Records. Select From a file as the source for importing records. This option allows you to upload records using an Excel or CSV file. You can preview the uploaded file by clicking the eye icon next to the file, or delete it and upload a new one by clicking the delete icon. The maximum file size allowed for upload is 25 MB Enable My file has a header if the first row of your file contains headers or labels for each column. When this option is enabled, the first row will be […]<\/p>\n","protected":false},"author":30,"featured_media":0,"parent":0,"menu_order":64,"comment_status":"closed","ping_status":"closed","template":"sogo_new_design.php","meta":{"footnotes":""},"categories":[456],"tags":[465,463],"yoast_head":"\nBuild a Directory Using a File | Sogolytics<\/title>\n<meta name=\"description\" content=\"Ready to get started with a new Directory? Staring with an Excel or CSV file makes it simple. To build a Directory using a File as the source, follow the steps below.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.sogolytics.com\/help\/build-activity-using-a-file\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Build a Directory Using a File | Sogolytics\" \/>\n<meta property=\"og:description\" content=\"Ready to get started with a new Directory? Staring with an Excel or CSV file makes it simple. To build a Directory using a File as the source, follow the steps below.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sogolytics.com\/help\/build-activity-using-a-file\/\" \/>\n<meta property=\"og:site_name\" content=\"Sogolytics\" \/>\n<meta property=\"article:modified_time\" content=\"2026-03-12T07:07:35+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sogolytics.com\/help\/build-activity-using-a-file\/\",\"url\":\"https:\/\/www.sogolytics.com\/help\/build-activity-using-a-file\/\",\"name\":\"Build a Directory Using a File | Sogolytics\",\"isPartOf\":{\"@id\":\"https:\/\/www.sogolytics.com\/help\/#website\"},\"datePublished\":\"2026-03-10T11:42:38+00:00\",\"dateModified\":\"2026-03-12T07:07:35+00:00\",\"description\":\"Ready to get started with a new Directory? Staring with an Excel or CSV file makes it simple. To build a Directory using a File as the source, follow the steps below.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.sogolytics.com\/help\/build-activity-using-a-file\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sogolytics.com\/help\/build-activity-using-a-file\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sogolytics.com\/help\/build-activity-using-a-file\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sogolytics.com\/help\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Build Activity Using A File\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sogolytics.com\/help\/#website\",\"url\":\"https:\/\/www.sogolytics.com\/help\/\",\"name\":\"Sogolytics\",\"description\":\"Sogolytics - Online Survey Tool\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sogolytics.com\/help\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Build a Directory Using a File | Sogolytics","description":"Ready to get started with a new Directory? Staring with an Excel or CSV file makes it simple. To build a Directory using a File as the source, follow the steps below.","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:\/\/www.sogolytics.com\/help\/build-activity-using-a-file\/","og_locale":"en_US","og_type":"article","og_title":"Build a Directory Using a File | Sogolytics","og_description":"Ready to get started with a new Directory? Staring with an Excel or CSV file makes it simple. To build a Directory using a File as the source, follow the steps below.","og_url":"https:\/\/www.sogolytics.com\/help\/build-activity-using-a-file\/","og_site_name":"Sogolytics","article_modified_time":"2026-03-12T07:07:35+00:00","twitter_card":"summary","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sogolytics.com\/help\/build-activity-using-a-file\/","url":"https:\/\/www.sogolytics.com\/help\/build-activity-using-a-file\/","name":"Build a Directory Using a File | Sogolytics","isPartOf":{"@id":"https:\/\/www.sogolytics.com\/help\/#website"},"datePublished":"2026-03-10T11:42:38+00:00","dateModified":"2026-03-12T07:07:35+00:00","description":"Ready to get started with a new Directory? Staring with an Excel or CSV file makes it simple. To build a Directory using a File as the source, follow the steps below.","breadcrumb":{"@id":"https:\/\/www.sogolytics.com\/help\/build-activity-using-a-file\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sogolytics.com\/help\/build-activity-using-a-file\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sogolytics.com\/help\/build-activity-using-a-file\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sogolytics.com\/help\/"},{"@type":"ListItem","position":2,"name":"Build Activity Using A File"}]},{"@type":"WebSite","@id":"https:\/\/www.sogolytics.com\/help\/#website","url":"https:\/\/www.sogolytics.com\/help\/","name":"Sogolytics","description":"Sogolytics - Online Survey Tool","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sogolytics.com\/help\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"}]}},"seo_meta_info":{"yoast_noindex":"","rankmath_noindex":"","yoast_title":"Build a Directory Using a File | Sogolytics","yoast_desc":"Ready to get started with a new Directory? Staring with an Excel or CSV file makes it simple. To build a Directory using a File as the source, follow the steps below.","rankmath_title":"Build Activity Using A File","rankmath_desc":"Want to track important interactions related to your contacts? Activities allow you to store and manage transactional or event-based records associated with contacts in a…"},"_links":{"self":[{"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/pages\/66001"}],"collection":[{"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/users\/30"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/comments?post=66001"}],"version-history":[{"count":8,"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/pages\/66001\/revisions"}],"predecessor-version":[{"id":66017,"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/pages\/66001\/revisions\/66017"}],"wp:attachment":[{"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/media?parent=66001"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/categories?post=66001"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/tags?post=66001"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}