Date Operators
It is important to understand the Date Operator being used on the report. This drives all the underlying data that is compiled, back to the Date Operator set within each report.
Many data misconceptions are due to a misunderstanding of the Date operator.
Date Operators
Date Operator are the dates of different actions that can occur on a customer, order, subscription or shipment level.
Example: Acquisition Date is when the customer was first Acquired vs Shipped Date is when the shipment of the product was sent. These are two different date types that will return different data.
Each report uses a specific Date Operator to get the underlying data in which that report is compiled. For example, if one report uses Subscribed Date and another different report uses Shipped Date, the underlying data returned will change. The Date Operator within each report is fixed.
Having the ability to digest data using different Date Operator will allow the end user to answer very specific questions on program and customer behavior, as well as pinpoint any problem areas quickly within the business.
Date Operator used within Sublytics reporting:
Initial | |||
Ad Spend Date | the date in which the spend occurs, as is reported through your connected marketing source. Reports that use this date operator include: Ad Spend Report | ||
Acquired Date | The date in which a new customer is acquired. This is determined by the first time that a new, unique customer record is created. The data is reflective of all revenue processed for that subscription through today’s date. Reports that use this date operator include: Customer Lifetime Value Report | ||
Click Date | The date in which the first click on the Vrio pixel is recorded. The data is reflective of all activity since the first click. Reports that use this date operator include: Website Activity Report | ||
Order Creation Date | The date in which the original order was added to the customer's cart. The data is reflective of all activity for that order through today’s date Reports that use this date operator include: Sales Funnel Report | ||
Original Attempt Date | The date in which the first click on the Vrio pixel is recorded. The data is reflective of all activity since the first click. Reports that use this date operator include: Website Activity Report | ||
Subscribed Before Date | The date in which a subscription was created, including all dates prior. Reports that use this date operator include: Active Subscriptions Report | ||
Subscribed Date | The date in which a new subscription was acquired. The data is reflective of all revenue processed for that subscription through today’s date. Reports that use this date operator include: Subscription Report | ||
Scheduled | |||
Item Scheduled Date | The date in which a shipment is created for a single Item. This date could be in the past or future. For future shipments, all prepaid subscriptions will be reflected. For renewing subscriptions, only the upcoming renewal cycle will be reflected. Reports that use this date operator include: Inventory Forecasting Report | ||
Scheduled Charge Date | The date in which a charge is scheduled to be processed. This can include recurring and non-recurring offers. Reports that use this date operator include: Revenue Forecasting Report | ||
Shipment Scheduled Date | The date in which a shipment is created. Reports that use this date operator include: Shipments by Scheduled Report | ||
Activity | |||
Cancel Date | The date in which a subscription was cancelled. This could be due to a customer actively cancelling or passively cancelling through a series of declined credit card attempts. Reports that use this date operator include: Cancellation Report | ||
Dispute Date | The date in which a dispute (Chargeback, alert, refund, void) was initiated. This is not based on when the dispute was physically marked in Vrio, it is the date that was set as the dispute date. Someone could mark a Chargeback on 2/01 but that Chargeback was initiated on 1/15. If they set the chargeback date as 1/15, that is what Vrio will use as the Dispute Date. Reports that use this date operator include: Disputes by Dispute Date Report | ||
Event Date | The date in which an event fired from Vrio to an external data source through a configured connection. Reports that use this date operator include: Events Report | ||
Order Modification Date | The date in which a modification was made to the order. Modifications can include: skips, unskips, swaps, cancels, reactivations or adjustments. Reports that use this date operator include: Order Activity Report | ||
Processed Date | The date in which a transaction is processed. Transactions could include: charges, refunds, voids, alerts or chargebacks. Reports that use this date include: Profit & Loss - Cash Report | ||
Responder Date Created | |||
Charge (Sale) Date | The date in which the original sale was processed. The data is reflective of all adjustments processed for that sale through today’s date. For Recurring Offers, each Cycle has a unique Sale Date Reports that use this date operator include: Sales Report | ||
Shipment Shipped Date | The date in which a shipment is marked as shipped. Reports that use this date operator include: Shipments by Shipped Report | ||
Subscription Activity | The date in which a change is made to the subscription status. This could include: subscription creation or churn. Reports that use this date operator include: Net Subscription Report |
Updated 22 days ago