Airship is a platform for customer engagement, lifecycle marketing, analytics, and data solutions. It can help marketers to activate and engage customers by providing notification and messaging solutions, targeting, and campaign management tools. With this integration, you can ingest your customer information opt-in devices, static lists, and reports.



Prerequisites

Limitation

The Airship application has a limitation that Data Object “Static Lists” does not work with the Bearer Token Authentication method, despite Airship API document stated that it is supported. See this link: https://docs.airship.com/reference/security/api-security/.

About Incremental Data Loading


Obtaining List Names

  1. Navigate to your project within Airship.
  2. Under Audience, select List:

  3. Make note of the list names that you might want to import into Treasure Data.

Use the TD Console to Create Your Connection

Create a New Connection

In Treasure Data, you must create and configure the data connection before running your query. As part of the data connection, you provide authentication to access the integration.

  1. Open TD Console.

  2. Navigate to Integrations HubCatalog.

  3. Search for Airship and then click Create Authentication.

  4. The following dialog opens.

  5. Enter the Base URL:

  6. Choose one of the following authentication methods:

    1. In the Airship project dashboard, select the Settings > APIs & Integrations.

    2. Enter the App key, App secret, and App master secret.


    1. In the Airship project dashboard, select the Settings > APIs & Integrations > Tokens.

    2. Create a new token and grant Audience Modification or All-access Role.



  7. Enter a name for your connection.

  8. Select Continue.

Transfer Your Airship Account Data to Treasure Data

After creating the authenticated connection, you are automatically taken to Authentications. Search for the connection you created. 

  1. Select New Source.

  2. Type a name for your Source in the Data Transfer field

  3. Select Next.
    The Source Table dialog opens.
  4. Edit the following parameters:

    Parameters

    Description

    Data Source

    Data type to import:

    • Reports

    • Named Users

    • Static Lists

    Data Objects

    Report type to import, show if the data type is Reports:

    • Custom Event Report

    • Opt-in Report

    • Opt-out Report

    • Time In App Report

    • Web Response Report

    • Response List

    • Device Report

    • Experiment Overview Report

    Start Time
    (Required when select Reports Data Source)

    For UI configuration, you can pick the date and time from the supported browser, or input the date that suits the browser expectation of date-time. For example, on Chrome, you will have a calendar to select Year, Month, Day, Hour, and Minute; on Safari, you need to input the text such as 2020-10-25T00:00.

    For CLI configuration, we need a timestamp in RFC3339 UTC "Zulu" format, accurate to nanoseconds, for example: "2014-10-02T15:01:23Z".

    End Time
    (Required when select Reports Data Source)

    For UI configuration, you can pick the date and time from the supported browser, or input the date that suits the browser's expectation of date-time. For example, on Chrome, you will have a calendar to select Year, Month, Day, Hour, and Minute; on Safari, you need to input the text such as 2020-10-25T00:00.

    For CLI configuration, we need a timestamp in RFC3339 UTC "Zulu" format, accurate to nanoseconds, for example: "2014-10-02T15:01:23Z".

    Precision

    The granularity of results to return

    • Daily

    • Hourly

    • Monthly

    Incremental Loading

    Import new data only from the last run. See About Incremental Loading.

    Until
    (Required when select Device Report Data Source)

    Only import data until this date

    Push ID
    (Required when select Experiment Overview Report Data Source)

    Format: UUID
    Returns statistics and metadata about an experiment

    Named User ID
    (show if Named Users Data Source)

    If left blank, retrieve the full list of all the named users

    List Name
    (Required when select Static Lists Data Source)

    Download the contents of a static list



Data Settings

  1. Select Next.
    The Data Settings page opens.

  2. Skip this page of the dialog.

Data Preview 



Data Placement