DocumentationAnalyticsExport Guide

Data Warehouse request general settings

Last update: Thu Oct 10 2024 00:00:00 GMT+0000 (Coordinated Universal Time)

CREATED FOR:

  • User
  • Admin

There are various configuration options available when creating a Data Warehouse request. The following information describes how to configure general settings for the request.

For information about how to begin creating a request, as well as links to other important configuration options, see Create a Data Warehouse request.

To configure general settings for a Data Warehouse request:

  1. Begin creating a Data Warehouse request in Adobe Analytics by selecting Tools > Data Warehouse > Add.

    For additional details, see Create a Data Warehouse request.

  2. On the New Data Warehouse request page, select the General settings tab.

    Report destination tab

  3. Complete the following fields:

    table 0-row-2 1-row-2 2-row-2 3-row-2 4-row-2 layout-auto
    Option Function
    Request name This name appears on the main Data Warehouse page when managing requests.
    Date ranges

    Select the date range to be included in the report.

    You can choose custom dates, or a preset date range. Preset ranges are relative to the date the report is sent.

    The following preset options are available:

    • Today
    • Yesterday
    • Last 7 days
    • Last 30 days
    • This week
    • Last week
    • Last 2 weeks
    • Last 3 weeks
    • Last 4 weeks
    • This month
    • Last month
    • Last hour
    Granularity

    The time granularity. Valid values are None, Hour, Day, Week, Month, Quarter, and Year.

    Reporting granularity requires additional processing time. If you are reporting monthly granularity for an entire year, your reports process much faster if you submit a report request for each month.

    Note: When applying granularity in a Data Warehouse request, the ‘Date’ column is added to the report. Depending on the granularity selected, the date format changes, as follows:

    • Hourly granularity:

      • Format: mmmm d, yyyy Hour H
      • Example: January 1, 20XX, Hour 0

    • Daily granularity:

      • Format: mmmm d, yyyy
      • Example: January 1, 20XX

    • Weekly granularity:

      • Format: Week w, yyyy
      • Example: Week 1, 20XX

    • Monthly granularity:

      • Format: mmmm yyyy
      • Example: January 20XX

    • Quarterly granularity:

      • Format: q Quarter yyyy
      • Example: 1st Quarter 20XX

    • Yearly granularity:

      • Format: yyyy
      • Example: 20XX
    Make available to users in your organization

    All data warehouse requests are visible only to you and any system administrators. Enable this option if you want to make the request visible to everyone in your organization.

    Enabling this option is useful if you want other users in your organization to help create or update the request.

  4. Continue configuring your Data Warehouse request on the Build your report tab. For more information, see Build a report for a Data Warehouse request.

recommendation-more-help
6b7d49d5-f5fe-4b7f-91ae-5b0745755ed2