Follow

Exports

Exports

The Exports page shows all saved campaign exports and user exports. You can run, copy, edit, or delete a saved export. You can also run and schedule a new user export or campaign export directly from the Exports page.

User exports enable you to estimate campaign reach and see a list of campaign recipients. Campaign exports enable you to slice and dice campaign performance, and create customized graphs.

Saved Exports

The Exports page shows your saved exports in two tables: Recurring and One-time.

  • The Recurring table lists saved exports that are set to run more than once, on a weekly or monthly schedule.
  • The One-time table lists saved exports that run once.

If there are no saved exports, the tables do not display on the Exports page but links are provided so you can create a new campaign export or user export.

The exports in the table are listed by creation date, starting with the most recent date.

Note: The Exports page lists all saved one-time exports; however, a maximum of 10 saved recurring exports are shown. After 14 days, Kahuna removes the export from the server.

Note: If you have enabled the Campaign Completion notifications on the Accounts tab of the Settings page, Kahuna sends an email after your campaign launches with a link to a CSV file that lists the people included in the campaign. This user export is not listed in the One-time table.

The Recurring and One-time tables provide the following information about each export.

Name

This icon indicates a campaign export. To the right of the icon is the export name. Under the name, you see a message indicating that the export is scheduled. If the export is not scheduled, you see the export type.

This icon indicates a user export. To the right of the icon is the export name. Under the name, you see a summary of the export that shows the user segments and any additional filters.

Kahuna provides a name automatically when you create an export. The name includes a timestamp so that the name is unique. You can edit the export name in the Schedule dialog.

Created

The day and time the export was created.

Repeats

Shows if the export is scheduled to run weekly or monthly. Recurring exports only.

Last Run

The last day and time when Kahuna ran the export.

Next Run

Shows the day and time the export is scheduled to run next. Recurring exports only.

Status

The possible status of an export is:

  • Not started
  • Running
  • Failed
  • Done
Download

This icon displays if the export has run at least once. Click the icon to download the saved export file so that you can view it.

Run Now

This icon displays if the export has not yet run or if the export is edited after it runs. Click the icon to run the export now.

Actions

Click then select from the following actions.

  • Run now runs the saved export now. Kahuna runs the export and sends you an email with a link to download the export file, which is in CSV format. Running the export now does not affect the export schedule.
  • Edit lets you edit the name of the saved export, the information in the export, or the schedule. The changes take effect the next time the export runs.
  • Copy copies the saved export. You can use this as the basis for a new export.
  • Delete deletes the saved export.

Export Users

You can create a user export from the Exports page to estimate campaign reach and see a list of campaign recipients. You can select a user segment and add filters to obtain more specific user information. Currently, Kahuna provides two built-in segments: Newbie and Engaged.

Kahuna saves all exports in either the Recurring table or the One-time table on the Exports page.

To export user information
  1. On the top right of the Exports page, click the People export link. The New Export page opens.

  2. Select a built-in segment (Newbie or Engaged) on which you want to base the user export.

    To export all users, click Continue without a segment.

    To export Dormant users or Passersby, click Continue without a segment, then add filters, described in the next step. (Currently, Kahuna does not provide a built-in segment for Dormant users or Passersby.)

  3. If you do not want to include any filters, go to the next step.

    If you want to include filters, select the filters on which you want to refine your search. The filters panel is described in Segments & Filters.

    To export Dormant users, add these filters: Onboarded=Yes, Last Visit=more than 14 days ago.

    To export Passersby, add these filters: Onboarded=No, Last Visit=more than 14 days ago.

  1. Either run the export now or schedule the export.

    • To run the export now, click Run now. Kahuna saves the export with a unique name on the Exports page, runs the export, and sends an email with a link to download the exported file.

    • To schedule the export to run weekly or monthly, or on a particular date, click Schedule. The Schedule dialog opens.

      1. In the Run on field, enter the date you want the schedule to start. You can click the calendar to select the date.
      2. Select the Recurrence:

        • Select Do not repeat to run the export one time only on the date specified in the Run on field.
        • Select Run weekly to run the export once a week starting on the date specified in the Run on field.
        • Select Run monthly to run the export once a month starting on the date specified in the Run on field.
      3. Kahuna provides a default name for the export based on the options selected and adds a timestamp. You can edit the name of the export. The name must be unique.

      4. Click Save and run to save the export and run it now. Kahuna saves the export on the Exports page, runs the export, and sends an email with a link to download the exported file. The export runs again at the scheduled time.

        Click Save to save the export only. Kahuna saves the export on the Exports page, then runs the export at the scheduled time and sends an email with a link to download the exported file.

        You can edit, copy, delete, or run a saved export from the Exports page.

User Export File Description

The following tables provide the column definitions for the exported data.

Common Fields

Common fields are shown in every user export.

Field Name Description
Username

The username for the user in Kahuna. If no user credential is supplied, the device ID is shown.

Email

The email address for the user.

Total Events

The number of Kahuna events that the user has completed. For example, the user added an item to a cart.

Kahuna uses this field to determine the Top People in your namespace.

Segment

The Kahuna segment (engagement state) to which the user belongs at the time of the export: Newbie, Passerby, Dormant, or Engaged.

First Seen

The date that the user first became active in the app. the day is in m/d/y format.

Last Seen

The date that the user was last active in the app. The date is in m/d/y format.

iOS Push Enabled

If the user is iOS push enabled.

Android Push Enabled

If the user is Android push enabled.

Last Export for Onboard

The last date the user was selected for a newbie-targeted campaign.

Onboard by Campaign

The last date the user was sent a message from a newbie-targeted campaign.

Last Export for More Engaged

The last date the user was selected for an engaged-targeted campaign.

Last More Engaged

The last date the user was sent a message from a engaged-targeted campaign.

Last Export for Save

The last date the user was selected for a dormant- or passersby-targeted campaign.

Last Saved

The last date the user was sent a message from a dormant- or passersby-targeted campaign.

Last Device ID

The device ID for the last device on which the user was active in the app.

Last Device Name

The type of device on which the user was active in the app. This includes the model number; for example, iphone 6. If the user was last active on the web, this field lists website as the last device used.

Last App Name

The name of the app in which the user was last active.

Last App Version

The number version of the app that the user last used.

Last OS Name

The name of the operating system on which the user last accessed the app.

Last OS Version

The number version of the operating system on which the user last accessed the app. This might also contain the name of the operating system in parentheses; for example, (mac).

Present Value

The attribute used to determine the Top Purchasers and track the value for Conversion Campaigns.

Attributes

Certain attributes in the export are provided by Kahuna. Other attributes are custom events that you set.

Here are the attributes that Kahuna provides.

Field Name Description
First Name

The first name for the user.

kahuna_lang

The language reported by the operating system (iOS or Android).

This is not currently reported by the JavaScript SDK.

kahuna_tz

The timezone as reported by the operating system from the last app visit.

This is not currently reported by the JavaScript SDK.

Events

Certain events in the export are provided by Kahuna. Other events are custom events that you set.

Here are the events that Kahuna provides.

Field Name Description
k_user_credentials

An internal event used to send credentials to Kahuna.

k_user_location An internal event used to send location data to Kahuna.
k_push_clicked

If the user clicked a push message to open the app.

k_push_enabled

If the user has push enabled for the app.

k_user_attributes

The user attributes.

start android

The number of times Android activity was detected.

start ios

The number of times the app entered the foreground.

start web

The number of times web activity was detected.

Export Campaigns

You can create a campaign export from the Exports page. The campaign export is a CSV file containing more than 100 campaign metrics for select campaigns. Because the file contains very basic metrics, a data analyst must transform and aggregate the data to identify meaningful performance measures, comparisons, or trends. If you need guidance on how to transform and aggregate the raw data from your Kahuna Campaign Export, contact your Kahuna Customer Success Manager.

Kahuna saves all exports in either the Recurring table or the One-time table on the Exports page.

To export campaign data
  1. On the top right of the Exports page, click the Campaign data export link. The New Export dialog opens.

  2. Choose the type of campaign export you want to run:

    • Click All Campaigns to export all campaigns.
    • Click Campaign Types to select one or more campaign types, such as Adaptive, Trigger, and so on.
    • Click Custom to select specific campaigns.
  3. From the Created dropdown, select the time frame you want to use for the export. Kahuna only exports metrics for the campaigns that were created during that time frame.

  4. Select Include disabled to include metrics for campaigns that are disabled.
  5. Select the metrics you want to export:

    • Click All Metrics to export all metrics that Kahuna tracks for campaigns.
    • Click Custom to select specific metrics that Kahuna tracks for campaigns.
  6. Select how you want to split campaign metrics:

    • Click Totals Only to export the metric total for the timeframe selected.
    • Click Totals w/Old to export the metric total for the timeframe selected, including messages that were deleted after you launched a campaign.
    • Click By Day to split campaign metrics by day.
    • Click By Day w/Old to split campaign metrics by day, including messages that were deleted after you launched a campaign.
  1. Either run the export now or schedule the export.

    • To run the export now, click Run now. Kahuna saves the export with a unique name on the Exports page, runs the export, and sends an email with a link to download the exported file.

    • To schedule the export to run weekly or monthly, or on a particular date, click Schedule. The Schedule dialog opens.

      1. In the Run on field, enter the date you want the schedule to start. You can click the calendar to select the date.
      2. Select the Recurrence:

        • Select Do not repeat to run the export one time only on the date specified in the Run on field.
        • Select Run weekly to run the export once a week starting on the date specified in the Run on field.
        • Select Run monthly to run the export once a month starting on the date specified in the Run on field.
      3. Kahuna provides a default name for the export based on the options selected and adds a timestamp. You can edit the name of the export. The name must be unique.

      4. Click Save and run to save the export and run it now. Kahuna saves the export on the Exports page, runs the export, and sends an email with a link to download the exported file. The export runs again at the scheduled time.

        Click Save to save the export only. Kahuna saves the export on the Exports page, then runs the export at the scheduled time and sends an email with a link to download the exported file.

        You can edit, copy, delete, or run a saved export from the Exports page.

    1. To export information about either users who have opted out of receiving messages or inactive email addresses, click export opt-out & bounce information at the bottom of the dialog. A response message appears.

      Note: You cannot schedule or rename this type of export.

    2. Check your email for a message from Kahuna, then open the message.
    3. In your Kahuna email, click the link to download your export. A response message appears.

Note: It can take approximately 20 minutes to generate and email the export. Also, the exported data might vary slightly from the data displayed on the All Campaigns page.

  1. When the download is complete, open the export file, which is in CSV format.
Campaign Export File Description

The following tables provide the column definitions for the exported data.

Column Name

Description
All Campaign Channels A comma separated list of all the channels for the campaign, such as push, email, in_app, facebook.
Date When exporting By Day, the day for the row of metrics.
Campaign Title The title of the campaign as seen on the All Campaigns page of the Kahuna application.
Campaign Tags A comma-separated list of one or more string tags for the campaign.
Campaign ID The internal unique identifier for the campaign.
Campaign Type

The campaign type, such as adaptive, scheduled, trigger, or auto.

Note: Auto campaigns are lifecycle campaigns. Trigger campaigns are conversion campaigns.

Schedule A JSON representation of the campaign delivery schedule. For example, {"frequency": "asap"} represents an ASAP scheduled campaign. This does not represent the start time of the campaign but the delivery schedule of a message after the campaign has launched.
Enabled State

True if the campaign is enabled or active.

False if the campaign is disabled or canceled.

Segment The targeted segment of users for the campaign.
Days in Segment

The number of days users must be in the segment to qualify for the campaign.

Note: For lifecycle campaigns only.

Goals The goals of the campaign. Typically, this is a single goal event name. If there is more than one goal, a comma-separated list is provided.
Filters A JSON encoding of the filters applied to select users for this campaign.
Created Date The time the campaign was created.
Created By The username of the campaign creator.
Modified Date The date the campaign was last modified.
Modified By The username of the person who last modified the campaign.
Campaign Delivered The total number of messages delivered; all campaign messages A-E.
Campaign Engaged The number of engaged users; all campaign messages A-E.
Campaign Goal 1/Primary Achieved The number of primary or conversion goals achieved; all campaign messages A-E.
Campaign Goal 2 Achieved The number of achieved for goal 2; all campaign messages A-E.
Campaign Goal 3 Achieved The number of achieved for goal 3; all campaign messages A-E.
Campaign Goal 4 Achieved The number of achieved for goal 4; all campaign messages A-E.
Campaign Goal 1/Primary Revenue The total revenue (if applicable) for goal 1; all campaign messages A-E.
Campaign Goal 2 Revenue The total revenue (if applicable) for goal 2; all campaign messages A-E.
Campaign Goal 3 Revenue The total revenue (if applicable) for goal 3, all campaign messages A-E.
Campaign Goal 4 Revenue The total revenue (if applicable) for goal 4; all campaign messages A-E.
Campaign Engagement Rate The engagement rate, all engaged/onboard/save over the total deliveries; all messages A-E.
Campaign Goal 1/Primary Conversion Rate The conversion rate, goal 1 over the total deliveries; all messages A-E.
Campaign Goal 2/Primary Conversion Rate The conversion rate, goal 2 over the total deliveries; all messages A-E.
Campaign Goal 3/Primary Conversion Rate The conversion rate, goal 3 over the total deliveries; all messages A-E.
Campaign Goal 4/Primary Conversion Rate The conversion rate, goal 4 over the total deliveries; all messages A-E.
Control Delivered The total number of virtual messages delivered for the control group.
Control Engaged The number of engaged users of the control group.
Control Goal 1/Primary Achieved The number of people in the control group that achieved goal 1.
Control Goal 2 Achieved The number of people in the control group that achieved goal 2.
Control Goal 3 Achieved The number of people in the control group that achieved goal 3.
Control Goal 4 Achieved The number of people in the control group that achieved goal 4.
Control Goal 1/Primary Revenue The total revenue for goal 1 of people in the control group.
Control Goal 2 Revenue The total revenue for goal 2 of people in the control group.
Control Goal 3 Revenue The total revenue for goal 3 of people in the control group.
Control Goal 4 Revenue The total revenue for goal 4 of people in the control group.
Control Engagement Rate The engagement rate, all engaged/onboard/save over the total virtual deliveries in the control group.
Control Goal 1 Conversion Rate The conversion rate of goal 1 over the total virtual deliveries of the control group.
Control Goal 2 Conversion Rate The conversion rate of goal 2 over the total virtual deliveries of the control group.
Control Goal 3 Conversion Rate The conversion rate of goal 3 over the total virtual deliveries of the control group.
Control Goal 4 Conversion Rate The conversion rate of goal 4 over the total virtual deliveries of the control group.
Control Opt-Out Uninstall The percentage of opt-outs and uninstalls in the control group.

Metrics for Each Campaign Message (A-E or Control)

A message is designated A-E. Each metric is labeled with A-E or CONTROL. Control is a special group that receives no message.

Column Name

Description

Attempted Count The number of attempted messages.
Bounced Count The number of bounced messages from email.
Clicks Count The number of clicks received for the message, email, or push.
Delivered Count The number of pushes or emails delivered for the message for the channel.
Ghost Delivered Count The number of ghost pushes delivered. A ghost push is a test push used to check for user uninstalls or opt-outs.
Not Reachable Count The number of unreachable people for the message.
Email Blocked The number of emails blocked because of a previous bounce, reject, or spam report.
Email Opens Count The number of email opens achieved for the message.
Email Unique Opens The number of unique email opens. For example, if a user opens the same email multiple times, this field shows only 1. If a user opens the same email four times and another user opens the same email five times, this field shows only 2.
Email Unique Clicks The number of unique email clicks. For example, if a user clicks the same link in an email multiple times, this field shows only 1. If a user clicks the same link in an email four times and another user clicks the same link in the same email five times, this field shows only 2.
Email Spam The number of spam reports from the email campaign.
Email Undelivered Count The number of emails rejected at the time of sending.
Email Unsubscribed The number of all unsubscribes for an email campaign.
In-App Available Count The number of in-app messages available for the message.
In-App Delivered Count The number of in-app messages delivered for the message.
In-App Not Reachable Count The number of in-app unreachable people for the message.
Message text/Email subject The message test for in-app or push, or the subject for the email channel.
Message deeplinks Additional parameters or deeplinks sent with the message
Missing Params Count The number of messages missing parameters for the message.
More Engaged Count The number of more engaged people for the message.
No Longer Valid Count The number of people who no longer meet the segment and filter criteria at the time of sending.
Onboards Count The number of onboards for the message. An onboard is a transition of a person from the newbie segment to the engaged segment.
Opt-Outs Count The number of people opting out for the message.
Provider Error Count All pushes dropped as a result of an unrecoverable error by the push provider for the message.
Rate Limited Count All pushes and emails blocked because of recent prior messaging to the person.
Saves Count All saved people: people transitioning from the dormant and passerby segment to the engaged segment.
Selected Count The people selected to be included for the message.
Ghost Selected Count The people selected for a ghost message for the message.
Uninstalled Count The number of uninstalled apps for the message, before the message delivery.
Unique Clicks The number of clicks received for the message, email or push.
Ghost Uninstalled Count The number of uninstalled apps for the message, after the message delivery.
Total Delivered Count The total number of deliveries for the message for all channels.
Total Engaged Count The total number of engaged people for the message for all channels.
Total Goal 1/Primary Achieved Count The total achieved count for goal 1, for the message, all channels.
Total Goal 2 Achieved Count The total achieved count for goal 2, for the message, all channels.
Total Goal 3 Achieved Count The total achieved count for goal 3, for the message, all channels.
Total Goal 4 Achieved Count The total Goal 4 Achieved Count (stat_goal_achieved4)
Total Goal 1/Primary Value Sum The total goal 1 value achieved count for the message, all channels.
Total Goal 2 Value Sum The total goal 2 value achieved count for the message, all channels.
Total Goal 3 Value Sum The total goal 3 value achieved count for the message, all channels.
Total Goal 4 Value Sum The total goal 4 value achieved count for the message, all channels.
Total OptOuts Count The total opt-outs count for the message, all channels.
Total Uninstalled Count The total uninstalled count for the message, all channels.
Message Engagement Rate The total engagement rate for the message, all channels.
Message Engagement Uplift The total uplift for the message (vs control), all channels.
Message Goal 1/Primary Conversion Rate The conversion rate for goal 1 for the message, all channels.
Message Goal 2 Conversion Rate The conversion rate for goal 2 for the message, all channels.
Message Goal 3 Conversion Rate The conversion rate for goal 3 for the message, all channels.
Message Goal 4 Conversion Rate The conversion rate for goal 4 for the message, all channels.
Message Goal 1/Primary Conversion Uplift The conversion uplift for goal 1 for the message (vs control), all channels.
Message Goal 2 Conversion Uplift The conversion uplift for goal 2 for the message (vs control), all channels.
Message Goal 3 Conversion Uplift The conversion uplift for goal 3 for the message (vs control), all channels.
Message Goal 4 Conversion Uplift The conversion uplift for goal 4 for the message (vs control), all channels.
Message Goal 1/Primary Value Uplift The goal 1 value uplift percentage for the message (vs control), all channels.
Message Goal 2 Value Uplift The goal 2 value uplift percentage for the message (vs control), all channels.
Message Goal 3 Value Uplift The goal 3 value uplift percentage for the message (vs control), all channels.
Message Goal 4 Value Uplift The goal 4 value uplift percentage for the message (vs control), all channels.
Opt-Out Uninstall The percentage of opt-outs and uninstalls, all channels.
Opt-out and Bounce File Descrption

The following table provides information about users who have opted out of receiving messages or inactive email addresses. This file is generated when you click export opt-out & bounce information at the bottom of the New Export dialog.

Column Name Description
Failed The message failed to send.
Hard_bounce An email account is invalid or no longer exists.
Reject The target email address is on a blacklist or the email domain is invalid. The email is not sent.
Soft_bounce A temporary error occurred. For example, the user's mailbox is full.
Spam A user marked the email as spam.
Unsub A user unsubscribed from your mailing list.
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments