{"id":16331,"date":"2022-09-15T13:08:50","date_gmt":"2022-09-15T17:08:50","guid":{"rendered":"https:\/\/certek.com\/kb4\/?p=16331"},"modified":"2023-11-10T13:49:56","modified_gmt":"2023-11-10T18:49:56","slug":"exporting-customer-emails","status":"publish","type":"ht_kb","link":"https:\/\/certek.com\/kb4\/knowledge-base\/exporting-customer-emails\/","title":{"rendered":"Exporting Customer Emails"},"content":{"rendered":"\n

Artisan can store customer contact information, such as an email, in a customer record. This is especially helpful if you want to import this information into a marketing service or email program.\u00a0<\/p>\n\n\n\n

To learn how to export and import emails into specific email programs<\/strong>, click here<\/a><\/strong>.<\/p>\n\n\n\n

There are two ways to export customer emails in Artisan:\u00a0<\/p>\n

    \n
  1. Exporting from a customer list. Use the “Power Search Filter<\/strong>” to narrow down your results, add the “Email<\/strong>” column, and then click the “Export<\/strong>” button.<\/li>\n
  2. Running Artisan’s “Customer Email Export Report.<\/strong>“<\/li>\n<\/ol>\n

    For detailed instructions on both methods, please keep reading.<\/p>\n

    \n

    Export by Using a Customer List<\/h3>\n

    Open the “Customer Records<\/strong>” list.<\/p>\n

    It’s a good idea to narrow down your search results to only show customers with an email address. On the “Customer Search Filters<\/strong>” tab, select email addresses “Are Present<\/strong>.” Click “Show Matches<\/strong>.”<\/p>\n

    \"\"<\/a><\/p>\n

    Right-click, select “Configure Columns.” <\/strong>Scroll down and add the “Email<\/strong>” column. You can use the “Move Up<\/strong>” and “Move Down<\/strong>” buttons to change the location of this column on your screen.<\/p>\n

    \"\"<\/a><\/p>\n

    Click on the “Export List<\/strong>” button or F9<\/strong> on your keyboard.<\/p>\n

    \"\"<\/a><\/p>\n

    Select “Current Displayed Fields<\/strong>.”<\/p>\n

    \"\"<\/a><\/p>\n

    Choose the file type. Usually, email programs require .CSV.<\/p>\n

    \"\"<\/a><\/p>\n

    Choose where to save the file.<\/p>\n

    \"\"<\/a><\/p>\n

    \n

    Accessing the Report<\/h3>\n

    There are two ways you can access this report. From the top of the screen, click on \u201cReports<\/strong>,\u201d \u201cCustomer Reports<\/strong>,\u201d and \u201cCustomer Email Export Report<\/strong>.\u201d<\/p>\n

    \"\"<\/a><\/p>\n

    Or, from the \u201cMain Menu<\/strong>,\u201d click on \u201cReports<\/strong>.\u201d<\/p>\n

    \"\"<\/a><\/p>\n

    Select \u201cCustomer Reports<\/strong>.\u201d<\/p>\n

    \"\"<\/a><\/p>\n

    Click on \u201cCustomer Email Export Report<\/strong>.\u201d<\/p>\n

    \"\"<\/a><\/p>\n

    Either way, you\u2019ll end up at the following screen.<\/p>\n

    \"\"<\/a><\/p>\n

    \n

    Report Fields<\/h3>\n

    Select (Customer Types) – <\/strong>This field contains your list of customer types (ex. retail and wholesale). Select one to only view customers in that category or leave it set to \u201call\u201d to include every customer type.<\/p>\n

    Whose (Birthdays and Anniversaries) – <\/strong>Use these two fields to narrow down any customer birthdays or anniversaries. This is especially helpful if you\u2019re planning on sending out special discounts to customers based on these criteria. Based on how often they\u2019ve purchased from you, you can see if they might be more inclined to purchase from you again soon, and what items they might be interested in.<\/p>\n

    Who Purchased Specific Items or Dollar Amount Between Dates<\/strong><\/p>\n

    You can further narrow down the report parameters here. There are plenty of options to \u201cmix and match\u201d your results. For example, you can include customers who purchased at least five items since May 3, 2022. Or, as another example, you can look for customers who purchased more than $50 worth of items in the last three months. These fields truly allow you to be as specific as possible.<\/p>\n

    You can even look for customers who bought items with specific descriptions or one of your own custom fields.<\/p>\n

    To narrow or expand your report, you may choose to include or exclude keywords and locations. You can also narrow down email parameters and define your report by when the customer was added to Artisan.\u00a0<\/p>\n

    \n

    Example Report<\/h3>\n

    \"\"<\/a><\/p>\n

    Click image to expand<\/em><\/p>\n

    In this example, we decided to list all of our customers. Artisan separated their information into customers, including full name, business name, email, and first and last name.<\/p>\n

    To export this report, click on the purple export icon.\u00a0<\/p>\n

    \"\"<\/a><\/p>\n

    Or go to “Report<\/strong>” and “Export<\/strong>.”<\/p>\n

    \"\"<\/a><\/p>\n

    Select the file type you want to export the report as. Most email and marketing services require files in a comma-separated (CSV) file format.<\/p>\n

    \"\"<\/a><\/p>\n

    \u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"

    Artisan can store customer contact information, such as an email, in a customer record. This is especially helpful if you want to import this information into a marketing service or email program.\u00a0 There are two ways to export customer emails in Artisan:\u00a0 Exporting from a customer list. Use the “Power…<\/p>\n","protected":false},"author":17,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_eb_attr":"","_monsterinsights_skip_tracking":false,"footnotes":"","_members_access_role":[],"_members_access_error":""},"ht-kb-category":[339],"ht-kb-tag":[],"class_list":["post-16331","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-customer-reports"],"_links":{"self":[{"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb\/16331","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/users\/17"}],"replies":[{"embeddable":true,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/comments?post=16331"}],"version-history":[{"count":12,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb\/16331\/revisions"}],"predecessor-version":[{"id":21311,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb\/16331\/revisions\/21311"}],"wp:attachment":[{"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/media?parent=16331"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb-category?post=16331"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb-tag?post=16331"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}