kmLearning Center
  • EMAIL MARKETING
    • GROUPS >
      • Manage Groups >
        • Archive
        • Export Group
        • Search Groups / Profiles >
          • Merge Profile
        • Seed List
        • Edit Profile
        • Standard Profile Fields
        • User Defined Fields (UDFs) >
          • Group Config
        • Subscriber Count
      • Add Group
      • Add Emails
      • FILTERS >
        • Smart Filters
        • Custom Filters
        • Copy Filter
      • IMPORT DATA >
        • Manual Import
        • API Import
        • FTP Import
      • SUPPRESSION >
        • PERSONALIZATION >
          • CodeSnippets
          • PURLs
        • Group Suppression Types
        • Opt-out Levels
        • Opt-out Preference
        • Master Suppression
        • Suppression Reasons
        • Error/Bounce Messages
    • Content / Messages >
      • MANAGE CONTENT >
        • Create Content >
          • WYSIWYG Editor. >
            • ALT Text for Images
            • Encoded URLs
            • RSS Feed
          • Design Templates >
            • Responsive Design
          • HTML Upload
          • Preheader Text
      • MANAGE MESSAGES >
        • Create Message >
          • Message Template Categories
        • Dynamic Tags
        • Link Source >
          • Link Alias
        • Message Types
        • Message Type Priority
    • Folders
    • BLASTS / REPORTING >
      • BLASTS >
        • Campaign Types >
          • Quick Test Blast
        • Set Up Blast >
          • Blast Fields
          • DEFINE RECIPIENTS >
            • Select Group(s)
            • Select Suppress Group(s)
            • Using Filters
          • DEFINE MESSAGE >
            • Blast Envelope >
              • Adding / Editing Blast Envelopes
              • Emojis in Subject Lines
            • Dynamic Personalization
          • Social Integration Options
          • Message Summary
          • SCHEDULE / SEND >
            • Tracking Options
            • Opt-out Preference
            • Google Image Cache Buster
            • Schedule Report
            • Email Preview
            • Schedule Blast
        • TRIGGERED EMAILS >
          • Message Triggers >
            • Use Case for Message Triggers
          • Smart Segment Filters
        • Campaign Item Templates
        • Manage Campaigns
      • REPORTING >
        • Report Categories
        • BLAST REPORTS >
          • A/B Summary Report
          • Blast Reporting
          • Campaign Report Definitions
          • Blast Report Samples
          • Campaign Statistics Report
          • Champion Audit Report
          • Click-Through Reports
          • Delivery Report
          • Emails Delivered by Percentage Report
          • Email Fatigue Report
          • Email Performance by Domain
          • Email Preview Report
          • How Opens are Tracked
          • Individual Blast Report
          • Link Report
          • Performance by Day & Time Report
          • Top Evangelists Report
          • Undeliverable Report
          • Unsubscribe Reason Report
        • GROUP REPORTS >
          • Audience Engagement Report
          • Click Report (Advertiser Click)
          • Campaign Item (Blast) Statistics Report
          • Group Attribute Report
          • Group Statistics Report
          • List Size Over Time Report
          • Master Suppression Source Report
          • Subscriber On/Off Report
          • Flash Report
        • Scheduled Reports
        • TRACKING & ANALYTICS >
          • Conversion Tracking
          • Google Analytics >
            • Google Analytics Domain Selection
          • Omniture Tracking
          • Topic Codes
    • ADMIN / CHANNEL MGMT >
      • Landing Pages >
        • Subscription Management Page
        • Unsubscribe Landing Page
        • Forward to a Friend Landing Page
        • Report Abuse Landing Page
        • Update Email Landing Page
        • Search Email
        • Change Email Address
        • Custom Unsubscribe Page
      • Salesforce Integration
      • Message Threshold
      • Gateway
    • EMAIL RESOURCES >
      • Email Marketing API
      • EMAIL BEST PRACTICES >
        • Advanced List Hygiene
        • Anti-Spam Legislation >
          • UNITED STATES
          • CANADA
          • EUROPE >
            • E-Privacy Directive
            • DPA: Data Protection Act
          • Legislation by Country
        • Email Client Support
        • Email Design Basics
        • Elements of an Engaging Email
        • Best Practices to Improve Email Campaign Performance
        • Supported Languages
        • What to Test for Best Results
        • Whitelisting
        • 5 Basics to Maintaining Email Reputation
        • 5 Tips for Mobile Friendly Email Design
      • DELIVERABILITY >
        • Deliverability Terms
        • Best Practices for Deliverability
        • KM Deliverability Services
        • SPAM >
          • Anti-Spam Legislation
          • SPAM Trigger Words
          • SPAM Avoidance Tips
          • Spam Scoring
      • DIGITAL EDITIONS >
        • Digital Edition Requirements
  • MARKETING AUTOMATION
    • Marketing Automation Overview >
      • Define Your Goal
      • Logging In
      • Home Screen Navigation
      • Add New Automation >
        • Building Automation >
          • Automation Controls
          • Automation Canvas
          • Control Properties
  • FORM DESIGNER
    • Form Designer Introduction
    • Logging In
    • Form Home Page
    • Adding A New Form >
      • Initial Set Up >
        • Auto-Submit Form
      • Form Properties
      • Subscriber Login
      • CSS/Styles
      • Form Controls >
        • Querystrings
      • Rules
      • Notifications
      • 3rd Party Output
      • Double Opt-In
      • Summary
  • UAD
    • Dashboard
    • AUDIENCE VIEWS >
      • Consensus
      • Recency
      • Product
      • Cross Product
      • Record
      • Brand
    • Sales View
    • Markets >
      • Creating Markets
      • Market Comparison
      • Market Use Case Example
    • FILTERS >
      • Standard Filters >
        • Circulation Filter
        • Activity Filter
        • Adhoc Filter
        • Saved Filters
        • Reading Filter Results
        • DOWNLOAD / EXPORT >
          • Data Masking
          • Download/Export Records
          • Download Template Setup
      • UAD REPORTING >
        • CrossTab Report
        • Demographic Reports >
          • Product Report - Pubcode
        • Geographic Reports
        • Company View
        • Email View
      • View Filters
      • Scheduled Export
      • Filter Comparison
      • Filter Category
      • Filter Segmentation
      • Question Category
    • CAMPAIGNS >
      • View Campaigns
      • Campaign Comparison
    • TOOLS >
      • GeoCoding
      • Summary Report
      • Record View Setup
      • Brand Setup
      • User Brand Setup
      • Download Template Setup
      • Merge Subscriber
      • CrossTab Report Setup
      • UserData Mask Setup
      • Custom Scoring
    • UAD RESOURCES >
      • UAD API Documentation
      • Merge/ Purge Process
      • Settings for Opening Docs in Excel
      • USE CASE EXAMPLES >
        • Click Criteria
        • Date Created - Adhoc
        • Deliver Integrated Data to Advertisers
        • Demographic Comparison-Consensus vs Recent Data
        • Email and Website Behavior
        • Event Attendance Analysis
        • GeoLocation-Event Planning
        • Highest Clicked Topic
        • Job Title [Function]
        • Nth Query
        • Product Count - Adhoc
        • Product Cross-Engagement
        • Subscriber Score
        • Topic Interest
        • URL Clicks
  • AMS
    • AMS >
      • SUBSCRIBER RECORDS >
        • Search Records
        • Edit Records
        • Unsubscribe/Reactivate
        • Free/Paid
        • New Record
        • Potential Match
        • Add/Remove Records
        • View Batch History
      • AMS REPORTING >
        • Reporting Tool
        • Report Builder
        • AMS Report Examples
      • OPEN / CLOSE IMPORTS >
        • Open/Close
        • AMS Filters >
          • Creating Filters
          • Save Filters
        • Imports
        • File Validator
        • File Mapper Wizard
        • File Status
        • Edit File Mapping
        • Add Remove
        • Issue Splits
        • Complimentary Imports
      • Wave Mailings
      • Logging Out
      • AMS RESOURCES >
        • Code Sheet Viewer
        • Append/Update Process
        • Record Removal Process
  • DATA COMPARE
    • Navigating Data Compare
    • Add A New File
    • Mapping Columns
    • View Downloads
    • UAD Examples
  • DOMAIN TRACKING
    • Domain Tracking 101 >
      • Additional Data Points
      • How Domains are Tracked
      • GDPR Features for Domain Tracking
  • RESOURCES
    • GDPR Resources >
      • ECN/UAD/AMS File Imports/Exports/APIs
    • Additional Premier Training >
      • Training Checklist
      • Training Methodology
    • CLIENT IMPLEMENTATION >
      • Email Account Structure Guidelines
      • Dimension Mapping
      • System Maintenance
      • Product Inventory
    • Client Webinars
    • Glossary
    • Single Sign-On >
      • Best Practices
      • Admin Roles Defined
      • User Permission Glossary
      • User Role Types >
        • Predefined Customer Roles >
          • EMAIL ROLES
      • Navigating Accounts
      • Edit Your Profile
      • Users - View, Edit & Add
      • Roles - Creating & Customizing
    • Manage Preferences
    • Product Release >
      • Release Notes, December 2018
      • Feature Release 09/21/18
      • May 2017 Product Release
      • February 2017 Product Release
      • November 2016 Product Release
      • October 2016 Product Release
      • September 2016 Release
      • August 2016 Product Release
      • June 2016 Product Release
      • Feb 2016 Product Release
      • 2014-2015 Product Releases
    • Supported Browsers
  • SUPPORT
    • KM Support Portal Instructions
    • KM Support Portal FAQs
  • EMAIL MARKETING
    • GROUPS >
      • Manage Groups >
        • Archive
        • Export Group
        • Search Groups / Profiles >
          • Merge Profile
        • Seed List
        • Edit Profile
        • Standard Profile Fields
        • User Defined Fields (UDFs) >
          • Group Config
        • Subscriber Count
      • Add Group
      • Add Emails
      • FILTERS >
        • Smart Filters
        • Custom Filters
        • Copy Filter
      • IMPORT DATA >
        • Manual Import
        • API Import
        • FTP Import
      • SUPPRESSION >
        • PERSONALIZATION >
          • CodeSnippets
          • PURLs
        • Group Suppression Types
        • Opt-out Levels
        • Opt-out Preference
        • Master Suppression
        • Suppression Reasons
        • Error/Bounce Messages
    • Content / Messages >
      • MANAGE CONTENT >
        • Create Content >
          • WYSIWYG Editor. >
            • ALT Text for Images
            • Encoded URLs
            • RSS Feed
          • Design Templates >
            • Responsive Design
          • HTML Upload
          • Preheader Text
      • MANAGE MESSAGES >
        • Create Message >
          • Message Template Categories
        • Dynamic Tags
        • Link Source >
          • Link Alias
        • Message Types
        • Message Type Priority
    • Folders
    • BLASTS / REPORTING >
      • BLASTS >
        • Campaign Types >
          • Quick Test Blast
        • Set Up Blast >
          • Blast Fields
          • DEFINE RECIPIENTS >
            • Select Group(s)
            • Select Suppress Group(s)
            • Using Filters
          • DEFINE MESSAGE >
            • Blast Envelope >
              • Adding / Editing Blast Envelopes
              • Emojis in Subject Lines
            • Dynamic Personalization
          • Social Integration Options
          • Message Summary
          • SCHEDULE / SEND >
            • Tracking Options
            • Opt-out Preference
            • Google Image Cache Buster
            • Schedule Report
            • Email Preview
            • Schedule Blast
        • TRIGGERED EMAILS >
          • Message Triggers >
            • Use Case for Message Triggers
          • Smart Segment Filters
        • Campaign Item Templates
        • Manage Campaigns
      • REPORTING >
        • Report Categories
        • BLAST REPORTS >
          • A/B Summary Report
          • Blast Reporting
          • Campaign Report Definitions
          • Blast Report Samples
          • Campaign Statistics Report
          • Champion Audit Report
          • Click-Through Reports
          • Delivery Report
          • Emails Delivered by Percentage Report
          • Email Fatigue Report
          • Email Performance by Domain
          • Email Preview Report
          • How Opens are Tracked
          • Individual Blast Report
          • Link Report
          • Performance by Day & Time Report
          • Top Evangelists Report
          • Undeliverable Report
          • Unsubscribe Reason Report
        • GROUP REPORTS >
          • Audience Engagement Report
          • Click Report (Advertiser Click)
          • Campaign Item (Blast) Statistics Report
          • Group Attribute Report
          • Group Statistics Report
          • List Size Over Time Report
          • Master Suppression Source Report
          • Subscriber On/Off Report
          • Flash Report
        • Scheduled Reports
        • TRACKING & ANALYTICS >
          • Conversion Tracking
          • Google Analytics >
            • Google Analytics Domain Selection
          • Omniture Tracking
          • Topic Codes
    • ADMIN / CHANNEL MGMT >
      • Landing Pages >
        • Subscription Management Page
        • Unsubscribe Landing Page
        • Forward to a Friend Landing Page
        • Report Abuse Landing Page
        • Update Email Landing Page
        • Search Email
        • Change Email Address
        • Custom Unsubscribe Page
      • Salesforce Integration
      • Message Threshold
      • Gateway
    • EMAIL RESOURCES >
      • Email Marketing API
      • EMAIL BEST PRACTICES >
        • Advanced List Hygiene
        • Anti-Spam Legislation >
          • UNITED STATES
          • CANADA
          • EUROPE >
            • E-Privacy Directive
            • DPA: Data Protection Act
          • Legislation by Country
        • Email Client Support
        • Email Design Basics
        • Elements of an Engaging Email
        • Best Practices to Improve Email Campaign Performance
        • Supported Languages
        • What to Test for Best Results
        • Whitelisting
        • 5 Basics to Maintaining Email Reputation
        • 5 Tips for Mobile Friendly Email Design
      • DELIVERABILITY >
        • Deliverability Terms
        • Best Practices for Deliverability
        • KM Deliverability Services
        • SPAM >
          • Anti-Spam Legislation
          • SPAM Trigger Words
          • SPAM Avoidance Tips
          • Spam Scoring
      • DIGITAL EDITIONS >
        • Digital Edition Requirements
  • MARKETING AUTOMATION
    • Marketing Automation Overview >
      • Define Your Goal
      • Logging In
      • Home Screen Navigation
      • Add New Automation >
        • Building Automation >
          • Automation Controls
          • Automation Canvas
          • Control Properties
  • FORM DESIGNER
    • Form Designer Introduction
    • Logging In
    • Form Home Page
    • Adding A New Form >
      • Initial Set Up >
        • Auto-Submit Form
      • Form Properties
      • Subscriber Login
      • CSS/Styles
      • Form Controls >
        • Querystrings
      • Rules
      • Notifications
      • 3rd Party Output
      • Double Opt-In
      • Summary
  • UAD
    • Dashboard
    • AUDIENCE VIEWS >
      • Consensus
      • Recency
      • Product
      • Cross Product
      • Record
      • Brand
    • Sales View
    • Markets >
      • Creating Markets
      • Market Comparison
      • Market Use Case Example
    • FILTERS >
      • Standard Filters >
        • Circulation Filter
        • Activity Filter
        • Adhoc Filter
        • Saved Filters
        • Reading Filter Results
        • DOWNLOAD / EXPORT >
          • Data Masking
          • Download/Export Records
          • Download Template Setup
      • UAD REPORTING >
        • CrossTab Report
        • Demographic Reports >
          • Product Report - Pubcode
        • Geographic Reports
        • Company View
        • Email View
      • View Filters
      • Scheduled Export
      • Filter Comparison
      • Filter Category
      • Filter Segmentation
      • Question Category
    • CAMPAIGNS >
      • View Campaigns
      • Campaign Comparison
    • TOOLS >
      • GeoCoding
      • Summary Report
      • Record View Setup
      • Brand Setup
      • User Brand Setup
      • Download Template Setup
      • Merge Subscriber
      • CrossTab Report Setup
      • UserData Mask Setup
      • Custom Scoring
    • UAD RESOURCES >
      • UAD API Documentation
      • Merge/ Purge Process
      • Settings for Opening Docs in Excel
      • USE CASE EXAMPLES >
        • Click Criteria
        • Date Created - Adhoc
        • Deliver Integrated Data to Advertisers
        • Demographic Comparison-Consensus vs Recent Data
        • Email and Website Behavior
        • Event Attendance Analysis
        • GeoLocation-Event Planning
        • Highest Clicked Topic
        • Job Title [Function]
        • Nth Query
        • Product Count - Adhoc
        • Product Cross-Engagement
        • Subscriber Score
        • Topic Interest
        • URL Clicks
  • AMS
    • AMS >
      • SUBSCRIBER RECORDS >
        • Search Records
        • Edit Records
        • Unsubscribe/Reactivate
        • Free/Paid
        • New Record
        • Potential Match
        • Add/Remove Records
        • View Batch History
      • AMS REPORTING >
        • Reporting Tool
        • Report Builder
        • AMS Report Examples
      • OPEN / CLOSE IMPORTS >
        • Open/Close
        • AMS Filters >
          • Creating Filters
          • Save Filters
        • Imports
        • File Validator
        • File Mapper Wizard
        • File Status
        • Edit File Mapping
        • Add Remove
        • Issue Splits
        • Complimentary Imports
      • Wave Mailings
      • Logging Out
      • AMS RESOURCES >
        • Code Sheet Viewer
        • Append/Update Process
        • Record Removal Process
  • DATA COMPARE
    • Navigating Data Compare
    • Add A New File
    • Mapping Columns
    • View Downloads
    • UAD Examples
  • DOMAIN TRACKING
    • Domain Tracking 101 >
      • Additional Data Points
      • How Domains are Tracked
      • GDPR Features for Domain Tracking
  • RESOURCES
    • GDPR Resources >
      • ECN/UAD/AMS File Imports/Exports/APIs
    • Additional Premier Training >
      • Training Checklist
      • Training Methodology
    • CLIENT IMPLEMENTATION >
      • Email Account Structure Guidelines
      • Dimension Mapping
      • System Maintenance
      • Product Inventory
    • Client Webinars
    • Glossary
    • Single Sign-On >
      • Best Practices
      • Admin Roles Defined
      • User Permission Glossary
      • User Role Types >
        • Predefined Customer Roles >
          • EMAIL ROLES
      • Navigating Accounts
      • Edit Your Profile
      • Users - View, Edit & Add
      • Roles - Creating & Customizing
    • Manage Preferences
    • Product Release >
      • Release Notes, December 2018
      • Feature Release 09/21/18
      • May 2017 Product Release
      • February 2017 Product Release
      • November 2016 Product Release
      • October 2016 Product Release
      • September 2016 Release
      • August 2016 Product Release
      • June 2016 Product Release
      • Feb 2016 Product Release
      • 2014-2015 Product Releases
    • Supported Browsers
  • SUPPORT
    • KM Support Portal Instructions
    • KM Support Portal FAQs
kmLearning Center
Sentry Page Protection
Please Wait...

Download/Export Records

Once your queries have been added, you may download or export any of the blue hyperlinked total counts that are listed in the filter list.
Picture
Click on the total count you wish to export or download to showcase your options.  From here you have three choices to retrieve your audience information: Export to Group, Download, or Save to campaign.  You may also type in (run an Nth) the desired total number of records to export, download or save.  Utilize the Promocode field (maximum of 10 characters) to label or tag your exported/downloaded records.

On each download screen, the Available Fields to download/export will be listed.  You are required to select which export fields you will want to include in the download/export before completing the download/export.  To include full demographic descriptions of the fields - choose a field labeled "DEMOGRAPHIC_DESCRIPTION."  This will give you the complete descriptions for what the demographic codes mean.  For example, Job Title code 607 = Construction Professional.
Or, choose a Download Template from the drop down list, to automatically select specific data fields to include in the download/export.  Reorganize the order of the selected data fields by moving the fields up or down the list.
Picture
Picture
​1.  Export to Group = export the records to the Email Marketing tool by specifying a promocode, job, and selecting a customer.  If used, the Promocode will show up in the Email Marketing tool as a UDF (User Defined Field).  Any additional export fields selected, beyond the Standard Profile Fields, will export to the Email Marketing tool as UDFs.  Once the export is complete, the screen will show what records were new, changed, duplicated, or skipped within the email group.  A skipped email address could be caused by either master suppression or if there is no email address for that record.  Include Email = YES (under the contact fields in the Standard Filters) in the filter to eliminate the chance of including blank emails in the download.

BEST PRACTICE:  when exporting to another software (ECN, Marketo), it is best to only include the code fields in the export, not the descriptions.
Picture
To view the counts prior to the export, select the Export to Group option (top left), then click on the Export Count button (bottom left button). By clicking on the Export Count button, the count totals will appear at the bottom of the download screen.  This gives you a snapshot of the totals prior to completing any export.
Picture
Sample download/export totals:
Picture
NOTE:  You can only export to customer accounts in the ECN Email Marketing tool that you have permission to access.  If you do not see a customer account in the list, contact your Admin to adjust your permissions.
2.  Download = download the total records or desired total records to an Excel XLS file.  If used, the Promocode field will be downloaded as a new column in the XLS document.  Check the "Include Query Details Header" box  to include all the query details of the filters chosen in the header of the Excel document; listing the total count, downloaded count, operation (Not In, Union, Intersect), products selected, and all filter criteria.  
  • NOTE:  If you are downloading with the intention of uploading the data to another software, the best practice would be not to include the query details header.
  • If you have issues downloading the file as an Excel document, click here and follow the steps.
Picture
Data that can also be included in any downloaded file are columns for:
  • Last Opened Date - latest date (activity date) of opening an email blast that has an associated publication (newsletter)
  • Last Opened Pubcode - specific product (newsletter) associated to the corresponding open date.
Picture
3.  Save to campaign = either save to an existing campaign that has already been created within the UAD, or choose to create a new campaign.  Name the filter to describe the criteria used to pull the subscribers and save the campaign within the UAD to be exported to Email Marketing or downloaded later.
Picture

Copyright © 2018 Knowledge Marketing, LLC., All Rights Reserved.                          Log Off                        
​Product Enhancement Request