Skip to main content
Act-On Software

Creating Exports in Data Studio

AUDIENCE: Administrators, Marketing Users
Requirements: Enterprise Account

Exports are the foundation of Data Studio. You can create a new export using these steps.

Open a New Export

  1. Navigate to Reports > Data Studio and select New Export
  2. Enter a Name and Description for this Export and click Next

Select Your Data

  1. Select a Data Set to work with:
    1. Email Messages
    2. Forms
    3. Landing Pages
    4. Media
    5. Webinars
    6. Webpages
    7. Lists/Segments
  2. Select the check boxes for actions you want to export
  3. Select additional data settings, such as ignoring your registered internal IPs
  4. Select any inclusive filters to apply and click Next
    Note: It is highly recommended to filter out data you will not be using. Data outside these filters will be excluded from the Export and cannot be retrieved later. However, limiting data with these filters will make reports much faster to generate and will cost fewer tokens.
    1. Click select under either Campaigns or Messages (or another content type based on your data set)
    2. Select the campaigns/content you would like to include 
  5. Choose how data is grouped and click Next
    1. Detailed log data provides a single line for every interaction, with no grouping (eg., for messages, a separate line for each open, click, etc.)
    2. Aggregated rolled-up data shows a single line for each check box you select (eg., for messages with Action Month selected, a single line for each month with only the totals shown for opens, clicks, etc.)
      • Blue/black attributes will always apply to all data points
      • Red attributes are shown for all standard fields used in your account – if you are not using this field across all of your marketing activities, you can still choose it but its totals might be blank
  6. Choose the fields to be used in your Export
    1. Choose the field from your selections in the last step
    2. Choose the filter logic (equals, contains, etc.) for how to use that fields

Generate the Export

  1. Select the schedule for the Export
    1. On demand
      You must manually click Generate each time you want to retrieve the data
    2. Daily/weekly
      Includes the last 7 days' data only
      Note: The time of day when you click Save will be used on future schedules
    3. Monthly
      On the first of the month, exports the last month’s data
  2. Choose delivery options
    1. Downloadable file, FTP, or a cloud storage option (these must be configured separately before exporting)
    2. Name for the file (append date if desired)
    3. Formats
      • CSV
      • CSV ZIP
      • CSV GZ
      • XLSX
        Note: The ZIP or GZ options are best if you are dealing with a large amount of data. If you are experiencing slowness or unresponsiveness upon export, make sure a zipped format is selected
    4. Email notification to as many recipients as you like – note that this is simply a statement that the export is complete, so recipients should be informed separately of how to access the data

 

  • Was this article helpful?
Support

Have a question about this topic?

Ask the community!