Exports Guide

  • Updated

Overview

Exports allow you to download a CSV file of all subscriptions, orders, or audit logs.

How do I set it up?

  1. Go to your Skio Dashboard
  2. Click on Tools on the left-hand menu
  3. Click Export
  4. Select the type of export you want to receive and enter your email
  5. Click Export and wait to receive the CSV in your inbox (timing can vary depending on how large the export is).

Export options

You can choose to export either active subs or inactive subs.

  • Active subs: Will include subscriptions in dunning. See Dunning for more information.
  • Inactive subs: Will include cancelled subscriptions and paused subscriptions. See Pausing Subscriptions for more information.

Subscription exports

The export will produce one row for each subscription line. Because it is possible to have multiple products (lines) on one subscription, the total number of rows will not equal the total number of subscriptions for your store.

Export fields

Field Name

Description

status

ACTIVE: The subscription will renew in the future on the nextBillingDate.

FAILED: The subscription is in Dunning because the last billing attempt failed.

CANCELLED: The subscription is cancelled and will not renew.

statusContext

CHURNED: The subscription was passively cancelled because we had more than the configured number of failed billing attempts.

DUNNING: The subscription is in the dunning process. This statusContext will only be present when status is equal to FAILED.

 

subscriptionLineQuantity

The quantity of products for this subscription line.

subscriptionLinePrice

The per-unit price for this subscription line. To calculate the order value for this subscription line, you must multiply subscriptionLineQuantity with subscriptionLinePrice.

Order exports

This export will produce one line for each order in the selected time period. This will include all recurring and new subscription orders. Each order will be one line in the file and includes the order number, total price, user email, and more. 

Audit log exports

The export allows selected audit log events to be downloaded as a CSV file. This will contain the date of the event, the event type (what was selected on the export page), the user email, the subscription ID, and when the subscription was created. 

The following events are available to be exported: 

Loyalty events

  • Loyalty tier reward discount

  • Loyalty tier reward free shipping

  • Loyalty tier reward free product

  • Loyalty tier reward credit multiplier

  • Loyalty tier reward content

  • Loyalty tier reward fixed credit

  • Loyalty tier reward credit

  • Loyalty tier reward give credit

Referral events

  • Referral referrer reward generated

  • Referral code generated

  • Referral referee joined

Subscription product and status events

  • Subscription product skip status updated

  • Failed to skip product when creating order

  • Subscription status updated to under review

  • Subscription under review status cleared

  • Subscription payment method was set

  • Subscription paused

  • Subscription unpaused

  • Subscription created

  • Subscription cancelled

  • Subscription ship now

  • Subscription merged

  • Subscription billing auto merged

  • Subscription billing auto merged into

  • Subscription billing attempt for auto merge

  • Subscription marked for expiry

  • Subscription activated

  • Subscription split

  • Subscription interval/date update

Payment method events

  • Payment method updated through skio

  • Payment method revoked through skio

  • Payment method added through skio

  • Payment method updated

  • Payment method created

  • Update payment method email sent

  • Backup payment method was used for billing

  • Backup payment method was set

User account events

  • User removed from the blacklist

  • User added to the blacklist

  • User was not billed because they exceeded the site's spend limit

  • User was not billed because they are on the blacklist

  • Logged in

Tier events

  • Tier upgraded

  • Tier downgraded

  • Tier changed

  • Tier expiry changed

Credit events

  • Credit increased

  • Credit decreased

  • Credit expired

  • User applied credit discount to subscription

  • User redeemed credits for product

  • User generated discount with credits

  • User placed order with credit discount

  • User removed credit discount

  • Journey action finished awarding credit

Quick actions

  • Quick action to add multiple product variants taken

  • Quick action to change interval taken

  • Quick action to delay taken

  • Quick action to upgrade one time order to subscription taken

  • Quick action to pause subscription taken

  • Quick action to reset payment method taken

  • Quick action to skip taken

  • Quick action to award credit taken

  • Quick action to apply discount taken

  • Quick action to add/change subscription credit card taken

  • Quick action to get back in stock item taken

  • Quick action to get now taken

  • Quick action to reactivate taken

  • Quick action to set backup payment method taken

  • Quick action to swap product taken

  • Quick action to unpause subscription taken

  • Quick action to send test email taken

  • Quick action page viewed

  • Quick action stack taken

  • Quick action to add one time upsell taken

  • Quick action to add product variant taken

Banner actions

  • Banner action to update interval taken

  • Banner action to swap variant taken

  • Banner action to add product variant taken

  • Banner action to apply discount taken

  • Banner action to get now taken

  • Journey banner action successfully added

Journey actions

  • Journey action finished swapping variants

  • Journey action finished bundle expansion

  • Journey action finished adding discount

  • Journey action finished removing products

  • Journey action finished changing subscription interval

  • Journey override next billing date

  • Journey action finished swapping static boxes

  • Journey action finished overriding billing date to fixed date

  • Journey action finished pausing subscription

  • Journey action finished removing discount

  • Journey action finished adding product

  • Journey action finished updating product price

  • Journey action finished swapping dynamic boxes

  • Journey action finished overriding delivery price

  • Journey action finished removing box products

  • Journey notification action successfully triggered

  • Journey send postscript message action successfully triggered

  • Journey action finished sunsetting prepaid

  • Journey delayed next billing date

Automation actions

  • Automation action finished swapping variants

  • Automation action finished swapping back variant

  • Automation action finished bundle expansion

  • Automation action finished removing discount

  • Automation action finished adding discount

Bulk operations

  • Bulk operation finished pausing subscription

  • Bulk operation finished cancelling subscription

  • Bulk operation finished resetting delivery price override

  • Bulk operation finished awarding credit

  • Bulk operation joined segment

  • Bulk operation left segment

  • Bulk operation applied

Skio SMS events

  • Skio SMS interaction started

  • Skio SMS thread has reached expiry

  • Skio SMS add product attempted

  • Skio SMS subscription pause attempted

  • Skio SMS product swap attempted

  • Skio SMS subscription skip attempted

  • Skio SMS change next billing date attempted

  • Skio SMS winback flow completed

  • Skio SMS Gorgias handoff requested

  • Skio SMS message received but feature disabled

External platform events

  • Rejoiner event triggered

  • Cordial event triggered

  • Insider event triggered

  • Bloomreach event triggered

  • Rebuy event triggered

  • Listrak event triggered

  • Sendlane event triggered

  • Iterable event triggered

  • Canopy event triggered

  • ActiveCampaign event triggered

  • Yotpo Email & SMS event triggered

  • Ometria event triggered

  • Klaviyo event triggered

Product & box events

  • Subscription product variants swapped

  • Box created

  • Box deleted

  • Box changed

  • Dynamic box deleted

  • Dynamic pricing box changed

  • Dynamic box created

  • One time add on

  • Order upgrade one time billing subscription created

  • Prepaid cycles completed changed

  • Prepaid product swap

  • productsUpdated

  • Shipping Price Overridden

General events

  • Redact customer info

  • orderPlaced

  • Manual subscription created

  • Discount code applied

  • Discount code removed

  • Fulfillment order deleted

  • Billing attempt

  • Billing attempted

  • Address changed

  • Address created

  • Login code sent

  • Sent 3DS verification

 

Share this

Was this article helpful?

1 out of 1 found this helpful