Nested record for AffluencerHub.discount_codes
Nested record for AffluencerHub.expenses
Nested record for AiVisibility.competitors_visibility
Nested record for CustomerJourney.items_purchased
Nested record for CustomerJourney.questions
Customer Support Agg Metrics Table (BETA)
Nested record for PixelOrder.products_info
Nested record for Refund.refund_order_adjustment
Nested record for Review.attributes_with_rating
Nested record for Review.reviewer_attributes
Date range for `@startDate`/`@endDate` SQL parameter substitution.
Error envelope returned for non-2xx responses (e.g. SQL syntax errors yield HTTP 400).
Query alias: 1 model declares _30DayListAttrition.
Query alias: 1 model declares _30DayListGrowth.
Query alias: 1 model declares _30DayListPersistence.
Query alias: 1 model declares _30DayLoyalCustomers.
Query alias: 1 model declares _30DayRecentJoiners.
Query alias: 1 model declares _customConversionName.
Query alias: 1 model declares _twentyEightDayClick.
Query alias: 1 model declares _twentyEightDayClickValue.
Query alias: 1 model declares _twentyEightDayViewValue.
Query alias: 7 models declare accountId.
Query alias: 2 models declare accountName.
Query alias: 1 model declares actionSource.
Query alias: 1 model declares actionType.
Query alias: 1 model declares activeSubscribers.
Query alias: 1 model declares activeSubscriptions.
Query alias: 1 model declares activeUsers.
Query alias: 2 models declare adBidAmount.
Query alias: 1 model declares adChangedNameFrom.
Query alias: 1 model declares adChangedNameTo.
Query alias: 1 model declares adCreated.
Query alias: 1 model declares addedToCartEvents.
Query alias: 1 model declares addedToCartItems.
Query alias: 2 models declare addresses.
Query alias: 2 models declare addToCartPercent.
Query alias: 4 models declare addToCarts.
Query alias: 1 model declares adIdsLast7Days.
Query alias: 1 model declares adIdsNext7Days.
Query alias: 4 models declare adImageUrl.
Query alias: 1 model declares adManagerUrl.
Query alias: 3 models declare adsetBidAmount.
Query alias: 1 model declares adsetBidAmountChangedFrom.
Query alias: 1 model declares adsetBidAmountChangedTo.
Query alias: 3 models declare adsetBidStrategy.
Query alias: 1 model declares adsetChangedNameFrom.
Query alias: 1 model declares adsetChangedNameTo.
Query alias: 1 model declares adsetCreated.
Query alias: 3 models declare adsetDailyBudget.
Query alias: 1 model declares adsetDailyBudgetChangedFrom.
Query alias: 1 model declares adsetDailyBudgetChangedTo.
Query alias: 3 models declare adsetLifetimeBudget.
Query alias: 6 models declare adsetName.
Query alias: 3 models declare adsetStatus.
Query alias: 1 model declares adsetStatusChangedFrom.
Query alias: 1 model declares adsetStatusChangedTo.
Query alias: 1 model declares adsetTargetCpa.
Query alias: 1 model declares adsetTargeting.
Query alias: 1 model declares adsetTargetRoas.
Query alias: 1 model declares adsetTargetRoasChangedFrom.
Query alias: 1 model declares adsetTargetRoasChangedTo.
Query alias: 1 model declares adStatusChangedFrom.
Query alias: 1 model declares adStatusChangedTo.
Query alias: 1 model declares affluencerSource.
Query alias: 2 models declare allConversions.
Query alias: 2 models declare allConversionValue.
Query alias: 1 model declares amazonEstimatedFees.
Query alias: 1 model declares amazonFulfillmentChannel.
Query alias: 1 model declares amazonFulfillmentStatus.
Query alias: 1 model declares amazonIsBusinessOrder.
Query alias: 2 models declare amazonMarketplaceId.
Query alias: 1 model declares amazonMarketplaceName.
Query alias: 1 model declares amazonRegion.
Query alias: 1 model declares amazonReportType.
Query alias: 1 model declares amazonTacos.
Query alias: 1 model declares amountSpent.
Query alias: 1 model declares amountTotal.
Query alias: 1 model declares amountType.
Query alias: 1 model declares annotationAuthor.
Query alias: 1 model declares annotationDescription.
Query alias: 1 model declares annotationTitle.
Query alias: 1 model declares aovLast7Days.
Query alias: 1 model declares aovNext7Days.
Query alias: 1 model declares assetType.
Query alias: 1 model declares assigneeUserId.
Query alias: 1 model declares assigneeUserName.
Query alias: 1 model declares attributesWithRating.
Query alias: 6 models declare attributionModel.
Query alias: 6 models declare attributionWindow.
Query alias: 1 model declares authorName.
Query alias: 1 model declares authorUsername.
Query alias: 1 model declares averagePagesPerSessions.
Query alias: 2 models declare averagePageViewsPerSession.
Query alias: 3 models declare averageSessionDuration.
Query alias: 1 model declares avgPurchasePrice.
Query alias: 2 models declare billingCity.
Query alias: 2 models declare billingCountry.
Query alias: 2 models declare billingCountryCode.
Query alias: 2 models declare billingProvince.
Query alias: 1 model declares blendedCpa.
Query alias: 3 models declare bounceRate.
Query alias: 1 model declares breakdown.
Query alias: 1 model declares breakdownCountryName.
Query alias: 1 model declares breakdownDimension.
Query alias: 1 model declares breakdownValue.
Query alias: 1 model declares campaignArchived.
Query alias: 1 model declares campaignBidAmountChangedFrom.
Query alias: 1 model declares campaignBidAmountChangedTo.
Query alias: 3 models declare campaignBidStrategy.
Query alias: 1 model declares campaignChangedNameFrom.
Query alias: 1 model declares campaignChangedNameTo.
Query alias: 1 model declares campaignCreated.
Query alias: 2 models declare campaignCreatedAt.
Query alias: 3 models declare campaignDailyBudget.
Query alias: 1 model declares campaignDailyBudgetChangedFrom.
Query alias: 1 model declares campaignDailyBudgetChangedTo.
Query alias: 13 models declare campaignId.
Query alias: 1 model declares campaignIdsLast7Days.
Query alias: 1 model declares campaignIdsNext7Days.
Query alias: 3 models declare campaignLifetimeBudget.
Query alias: 1 model declares campaignLifetimeBudgetChangedFrom.
Query alias: 1 model declares campaignLifetimeBudgetChangedTo.
Query alias: 10 models declare campaignName.
Query alias: 1 model declares campaignScheduledAt.
Query alias: 1 model declares campaignSendDate.
Query alias: 1 model declares campaignSendTime.
Query alias: 6 models declare campaignStatus.
Query alias: 1 model declares campaignStatusChangedFrom.
Query alias: 1 model declares campaignStatusChangedTo.
Query alias: 1 model declares campaignTargetCpa.
Query alias: 1 model declares campaignTargetRoas.
Query alias: 1 model declares campaignTargetRoasChangedFrom.
Query alias: 1 model declares campaignTargetRoasChangedTo.
Query alias: 4 models declare campaignType.
Query alias: 1 model declares campaignUpdatedAt.
Query alias: 1 model declares cancellationComments.
Query alias: 1 model declares cancellationReason.
Query alias: 2 models declare cancelledAt.
Query alias: 1 model declares cashTurnover.
Query alias: 2 models declare categoryId.
Query alias: 1 model declares categoryName.
Query alias: 1 model declares cdpSegmentSyncToFacebookStatus.
Query alias: 1 model declares cdpSegmentSyncToKlaviyoStatus.
Query alias: 2 models declare channelReportedAov.
Query alias: 1 model declares channelReportedConversionRate.
Query alias: 2 models declare channelReportedConversions.
Query alias: 4 models declare channelReportedConversionValue.
Query alias: 2 models declare channelReportedCpa.
channel reported onsite conversion value
Query alias: 1 model declares channelReportedOnsiteConversionValue.
Query alias: 1 model declares channelReportedOnsitePurchases.
Query alias: 3 models declare channelReportedRoas.
Query alias: 1 model declares channelReportedVisits.
Query alias: 1 model declares channelsLast7Days.
Query alias: 1 model declares channelsNext7Days.
Query alias: 3 models declare channelType.
Query alias: 1 model declares checkoutEventType.
Query alias: 2 models declare checkouts.
Query alias: 1 model declares citationOrder.
Query alias: 1 model declares citiesLast7Days.
Query alias: 1 model declares citiesNext7Days.
Query alias: 1 model declares cityFilter.
Query alias: 1 model declares clickDate.
Query alias: 1 model declares clicksUnique.
Query alias: 1 model declares cogsAdjusted.
Query alias: 1 model declares collectionId.
Query alias: 1 model declares collectionName.
Query alias: 1 model declares collections.
Query alias: 1 model declares commentId.
Query alias: 1 model declares commentText.
Query alias: 1 model declares competitorId.
Query alias: 1 model declares competitorName.
Query alias: 1 model declares competitorsVisibility.
Query alias: 1 model declares competitorUrl.
Query alias: 1 model declares containsProfanity.
Query alias: 1 model declares contributionMargin.
Query alias: 1 model declares contributionMarginPerItem.
Query alias: 1 model declares conversationId.
Query alias: 2 models declare conversionRate.
Query alias: 2 models declare conversions.
Query alias: 5 models declare conversionValue.
Query alias: 1 model declares coordinatesValidated.
Query alias: 2 models declare costOfGoods.
Query alias: 1 model declares costPerSession.
Query alias: 1 model declares countriesLast7Days.
Query alias: 1 model declares countriesNext7Days.
Query alias: 2 models declare countryCode.
Query alias: 1 model declares countryFilter.
Query alias: 1 model declares createdCdpSegment.
created post purchase survey description
Query alias: 1 model declares createdPostPurchaseSurveyDescription.
Query alias: 3 models declare creativeCtaType.
Query alias: 3 models declare creativeDistributionFormat.
Query alias: 3 models declare creativeFormat.
Query alias: 3 models declare creativeId.
Query alias: 3 models declare currencyRate.
Query alias: 1 model declares customAdSpend.
Query alias: 1 model declares customConversionId.
Query alias: 1 model declares customConversions.
Query alias: 4 models declare customerEmail.
Query alias: 2 models declare customerFirstName.
Query alias: 2 models declare customerFromCity.
Query alias: 2 models declare customerFromCountryCode.
Query alias: 2 models declare customerFromCountryName.
Query alias: 2 models declare customerFromStateCode.
Query alias: 7 models declare customerId.
Query alias: 2 models declare customerIdentity.
Query alias: 1 model declares customerIdentityType.
Query alias: 3 models declare customerIdKey.
Query alias: 1 model declares customerIds.
Query alias: 1 model declares customerJourneyEventType.
Query alias: 2 models declare customerLastName.
Query alias: 1 model declares customerPhone.
Query alias: 1 model declares customers.
Query alias: 3 models declare customerTags.
Query alias: 1 model declares customExclAdSpend.
Query alias: 2 models declare customExpenses.
Query alias: 2 models declare customGrossProfit.
Query alias: 2 models declare customGrossSales.
Query alias: 2 models declare customNetRevenue.
Query alias: 2 models declare customOrdersQuantity.
Query alias: 2 models declare customTotalItemsQuantity.
Query alias: 1 model declares deletedAt.
deleted post purchase survey description
Query alias: 1 model declares deletedPostPurchaseSurveyDescription.
Query alias: 3 models declare delivered.
Query alias: 1 model declares deviceModel.
Query alias: 2 models declare discountAmount.
Query alias: 5 models declare discountAmountForProduct.
Query alias: 2 models declare discountAmountForShipping.
Query alias: 3 models declare discountCode.
Query alias: 1 model declares discountCodes.
Query alias: 1 model declares discounts.
Query alias: 1 model declares discountType.
Query alias: 2 models declare displayName.
Query alias: 3 models declare dutiesDutyId.
Query alias: 3 models declare dutiesPrice.
Query alias: 3 models declare dutiesTaxLinesPrice.
Query alias: 1 model declares effectiveCpcBid.
Query alias: 1 model declares emailAddress.
Query alias: 1 model declares emailMarketingConsentCollectedFrom.
Query alias: 1 model declares emailMarketingConsentOptInLevel.
Query alias: 1 model declares emailMarketingConsentStatus.
Query alias: 1 model declares emailMarketingConsentUpdatedAt.
Query alias: 2 models declare emailSignupRate.
Query alias: 2 models declare emailSignups.
Query alias: 1 model declares engagements.
Query alias: 1 model declares entityName.
Query alias: 1 model declares estimatedFulfillmentDateStatus.
Query alias: 1 model declares estimatedShippingCosts.
Query alias: 1 model declares eventBody.
Query alias: 1 model declares eventCount.
Query alias: 36 models declare eventDate.
Query alias: 36 models declare eventDateDay.
Query alias: 36 models declare eventDateMonth.
Query alias: 36 models declare eventDateQuarter.
Query alias: 1 model declares eventDateTimezone.
Query alias: 36 models declare eventDateWeek.
Query alias: 36 models declare eventDateYear.
Query alias: 18 models declare eventHour.
Query alias: 3 models declare eventName.
Query alias: 1 model declares eventTime.
Query alias: 3 models declare eventTimestamp.
Query alias: 2 models declare eventType.
Query alias: 1 model declares eventValue.
Query alias: 1 model declares excludeProviders.
Query alias: 1 model declares executionId.
Query alias: 1 model declares fanRemoves.
Query alias: 1 model declares firstName.
Query alias: 1 model declares firstOrderDate.
Query alias: 1 model declares firstOrderId.
Query alias: 1 model declares firstUserPrimaryChannelGroup.
Query alias: 1 model declares flowActionArchived.
Query alias: 2 models declare flowActionId.
Query alias: 2 models declare flowActionName.
Query alias: 2 models declare flowActionStatus.
Query alias: 1 model declares flowActionUpdatedAt.
Query alias: 1 model declares flowArchived.
Query alias: 1 model declares flowCreatedAt.
Query alias: 2 models declare flowStatus.
Query alias: 2 models declare flowTriggerIsTw.
Query alias: 2 models declare flowTriggerMetricId.
Query alias: 2 models declare flowTriggerMetricName.
Query alias: 2 models declare flowTriggerOrganization.
Query alias: 2 models declare flowTriggerSonarEnabled.
Query alias: 1 model declares flowUpdatedAt.
Query alias: 1 model declares fromAgent.
Query alias: 1 model declares fulfillmentCosts.
Query alias: 3 models declare fulfillmentStatus.
Query alias: 1 model declares grossItemRevenue.
Query alias: 5 models declare grossProductSales.
Query alias: 2 models declare grossProfit.
Query alias: 1 model declares grossRevenue.
Query alias: 3 models declare handlingFees.
Query alias: 1 model declares helpfulCount.
Query alias: 1 model declares imageHeight.
Query alias: 1 model declares imagePosition.
Query alias: 1 model declares imageWidth.
Query alias: 9 models declare impressions.
Query alias: 1 model declares impressionsPaid.
Query alias: 1 model declares impressionsUnique.
Query alias: 1 model declares impressionsViral.
Query alias: 2 models declare includeAmazon.
Query alias: 1 model declares includeCustomAdSpend.
Query alias: 1 model declares includeFreeProducts.
Query alias: 1 model declares includeNonActiveProducts.
Query alias: 1 model declares includeProviders.
Query alias: 1 model declares inlinePostEngagement.
Query alias: 1 model declares inReplyToUserId.
Query alias: 1 model declares instanceCreatedDate.
Query alias: 1 model declares instanceEventDate.
Query alias: 1 model declares instanceEventDateEnd.
Query alias: 1 model declares instanceEventDateStart.
Query alias: 1 model declares integrationId.
Query alias: 1 model declares integrationShippingStatus.
Query alias: 1 model declares inventoryQuantity.
Query alias: 1 model declares isAdSpend.
Query alias: 2 models declare isFirstOrderInSubscription.
Query alias: 1 model declares isFromAgent.
Query alias: 3 models declare isGiftCard.
Query alias: 2 models declare isMentioned.
Query alias: 3 models declare isNewCustomer.
Query alias: 1 model declares isNewVisitor.
Query alias: 1 model declares isPublished.
Query alias: 1 model declares isRecommended.
Query alias: 2 models declare isRecurring.
Query alias: 2 models declare isSubscriptionOrder.
Query alias: 1 model declares isThreadStarter.
Query alias: 1 model declares isUtmValid.
Query alias: 1 model declares itemRevenue.
Query alias: 1 model declares itemsAddedToCart.
Query alias: 1 model declares itemsCheckedOut.
Query alias: 1 model declares itemsViewed.
Query alias: 1 model declares keywordCpcBid.
Query alias: 1 model declares keywordEffectiveCpcBid.
Query alias: 4 models declare keywordId.
Query alias: 1 model declares keywordMatchType.
Query alias: 1 model declares keywordQualityScore.
Query alias: 2 models declare keywordStatus.
Query alias: 1 model declares keywordSystemServingStatus.
Query alias: 2 models declare keywordText.
Query alias: 1 model declares klaviyoSalesPercentage.
Query alias: 4 models declare landingPage.
Query alias: 1 model declares lastOrderId.
Query alias: 1 model declares leadClickTs.
Query alias: 1 model declares linearWeight.
Query alias: 1 model declares longitude.
Query alias: 1 model declares marketplace.
Query alias: 1 model declares matchedKeyword.
Query alias: 1 model declares matchType.
Query alias: 1 model declares medianFirstResponseTime.
Query alias: 1 model declares medianResolutionTime.
Query alias: 1 model declares mentionText.
Query alias: 1 model declares mentionType.
Query alias: 1 model declares messageCopy.
Query alias: 3 models declare messageId.
Query alias: 2 models declare messageName.
Query alias: 1 model declares messagePreviewText.
Query alias: 1 model declares messageSubject.
Query alias: 1 model declares messageTemplateHtmlUrl.
Query alias: 2 models declare metafieldId.
Query alias: 2 models declare metafieldNamespace.
Query alias: 2 models declare metafieldType.
Query alias: 3 models declare msCountry.
Query alias: 1 model declares msCountryName.
Query alias: 2 models declare netDiscountAmountForProduct.
Query alias: 1 model declares netMargin.
Query alias: 1 model declares netProfit.
Query alias: 1 model declares netRevenue.
Query alias: 1 model declares newCustomerAov.
Query alias: 3 models declare newCustomerCogs.
Query alias: 1 model declares newCustomerCpa.
Query alias: 1 model declares newCustomerFulfillmentCosts.
Query alias: 1 model declares newCustomerGrossProfit.
Query alias: 3 models declare newCustomerOrderRevenue.
Query alias: 5 models declare newCustomerRoas.
Query alias: 5 models declare newCustomersPercent.
Query alias: 1 model declares newCustomerTotalItemsSold.
Query alias: 1 model declares newCustomerTotalOrderValue.
Query alias: 1 model declares newNeverSeenSubscribers.
Query alias: 1 model declares newSubscriptions.
Query alias: 3 models declare newVisitors.
Query alias: 2 models declare numberOfAds.
Query alias: 1 model declares numberOfItems.
Query alias: 1 model declares numberOfOrders.
Query alias: 1 model declares numOfCustomers.
Query alias: 1 model declares numOfOrders.
Query alias: 1 model declares objectType.
Query alias: 2 models declare oneDayClick.
Query alias: 2 models declare oneDayClickComments.
Query alias: 1 model declares oneDayClickConversionValue.
Query alias: 2 models declare oneDayClickLikes.
Query alias: 1 model declares oneDayClickLinkClicks.
Query alias: 1 model declares oneDayClickPurchases.
Query alias: 2 models declare oneDayClickReactions.
Query alias: 2 models declare oneDayClickShares.
Query alias: 2 models declare oneDayClickValue.
Query alias: 2 models declare oneDayView.
Query alias: 3 models declare oneDayViewConversionValue.
Query alias: 3 models declare oneDayViewPurchases.
Query alias: 2 models declare oneDayViewValue.
Query alias: 1 model declares onsiteConversionValue.
Query alias: 1 model declares onsiteOneDayClickConversionValue.
Query alias: 1 model declares onsiteOneDayClickPurchases.
Query alias: 1 model declares onsiteOneDayViewConversionValue.
Query alias: 1 model declares onsiteOneDayViewPurchases.
Query alias: 2 models declare onsitePurchases.
Query alias: 1 model declares onsiteSevenDayClickConversionValue.
Query alias: 1 model declares onsiteSevenDayClickPurchases.
Query alias: 1 model declares onsiteSevenDayViewConversionValue.
Query alias: 1 model declares onsiteSevenDayViewPurchases.
onsite twenty eight day click conversion value
Query alias: 1 model declares onsiteTwentyEightDayClickConversionValue.
Query alias: 1 model declares onsiteTwentyEightDayClickPurchases.
onsite twenty eight day view conversion value
Query alias: 1 model declares onsiteTwentyEightDayViewConversionValue.
Query alias: 1 model declares onsiteTwentyEightDayViewPurchases.
Query alias: 1 model declares opensUnique.
Query alias: 1 model declares orderAdjustmentAmount.
Query alias: 1 model declares orderAdjustmentTaxAmount.
Query alias: 1 model declares orderDate.
Query alias: 3 models declare orderName.
Query alias: 9 models declare orderRevenue.
Query alias: 1 model declares ordersCount.
Query alias: 1 model declares ordersCustomExpenses.
Query alias: 6 models declare ordersQuantity.
Query alias: 1 model declares orderTagsFilter.
Query alias: 1 model declares orderTagsLast7Days.
Query alias: 1 model declares orderTagsNext7Days.
Query alias: 3 models declare outboundClicks.
Query alias: 2 models declare outboundCtr.
Query alias: 1 model declares pagePermalink.
Query alias: 2 models declare pageViewEventId.
Query alias: 1 model declares pageViewNumber.
Query alias: 3 models declare paymentGatewayCosts.
Query alias: 1 model declares paymentGatewayName.
Query alias: 1 model declares pinnedEventDate.
Query alias: 3 models declare pixelConversionRate.
Query alias: 2 models declare pixelConversionValueDelta.
Query alias: 2 models declare pixelCostPerAddToCart.
Query alias: 2 models declare pixelCostPerEmailSignup.
Query alias: 2 models declare pixelCostPerNewVisitor.
Query alias: 2 models declare pixelCostPerVisitor.
Query alias: 3 models declare pixelNcAov.
Query alias: 2 models declare pixelNcConversionRate.
Query alias: 2 models declare pixelNewVisitorPercent.
Query alias: 3 models declare pixelProfit.
Query alias: 3 models declare pixelRoas.
Query alias: 2 models declare postPermalink.
Query alias: 1 model declares primaryEmail.
Query alias: 1 model declares processedAt.
Query alias: 1 model declares productAov.
Query alias: 1 model declares productDescription.
Query alias: 8 models declare productId.
Query alias: 1 model declares productIdsLast7Days.
Query alias: 1 model declares productIdsNext7Days.
Query alias: 1 model declares productImage.
Query alias: 2 models declare productImageUrl.
Query alias: 1 model declares productInventoryQuantity.
Query alias: 8 models declare productName.
Query alias: 3 models declare productNamePrice.
Query alias: 3 models declare productNameQuantitySold.
Query alias: 4 models declare productQuantitySoldInOrder.
Query alias: 3 models declare productSku.
Query alias: 1 model declares productsNames.
Query alias: 1 model declares productStatus.
Query alias: 1 model declares productSubscriberStatus.
Query alias: 4 models declare productTags.
Query alias: 3 models declare productType.
Query alias: 1 model declares promotionViews.
Query alias: 1 model declares promptText.
Query alias: 3 models declare propertiesName.
Query alias: 3 models declare propertiesValue.
Query alias: 1 model declares providerId.
Query alias: 2 models declare publisherId.
Query alias: 2 models declare publisherName.
Query alias: 1 model declares publisherStatus.
Query alias: 1 model declares purchaseFrequencyLast7Days.
Query alias: 1 model declares purchaseFrequencyNext7Days.
Query alias: 2 models declare purchases.
Query alias: 1 model declares qualityScore.
Query alias: 1 model declares queryParams.
Query alias: 1 model declares questions.
Query alias: 1 model declares questionType.
Query alias: 1 model declares reactivatedSubscribers.
Query alias: 1 model declares receiverEmail.
Query alias: 1 model declares receiverId.
Query alias: 1 model declares receiverName.
Query alias: 1 model declares recipients.
Query alias: 1 model declares recurringCadence.
Query alias: 1 model declares recurringIntervalLength.
Query alias: 1 model declares refundedOrders.
Query alias: 5 models declare refundMoney.
Query alias: 1 model declares refundOrderAdjustment.
Query alias: 1 model declares repeatCustomer.
Query alias: 1 model declares replyToPostId.
Query alias: 2 models declare reportType.
Query alias: 1 model declares responsePreview.
Query alias: 5 models declare returningCustomerOrders.
Query alias: 5 models declare returningCustomerRevenue.
Query alias: 5 models declare returningCustomersPercent.
Query alias: 1 model declares returnRate.
Query alias: 1 model declares revenueLast7Days.
Query alias: 1 model declares revenueNext7Days.
Query alias: 1 model declares revenuePerLinkClick.
Query alias: 1 model declares reviewerAttributes.
Query alias: 1 model declares reviewerCountryCode.
Query alias: 1 model declares reviewerCountryName.
Query alias: 1 model declares reviewerDisplayName.
Query alias: 1 model declares reviewerEmail.
Query alias: 1 model declares reviewerIsVerified.
Query alias: 1 model declares reviewerName.
Query alias: 1 model declares reviewerType.
Query alias: 1 model declares reviewerVerifiedStatus.
Query alias: 1 model declares reviewType.
Query alias: 1 model declares salesPlatformFilter.
Query alias: 1 model declares screenPageViews.
Query alias: 2 models declare searchAbsoluteTopImpressions.
Query alias: 2 models declare searchAbsoluteTopImpressionShare.
search budget lost absolute top impressions
Query alias: 2 models declare searchBudgetLostAbsoluteTopImpressions.
search budget lost absolute top impression share
Query alias: 2 models declare searchBudgetLostAbsoluteTopImpressionShare.
Query alias: 2 models declare searchBudgetLostTopImpressions.
Query alias: 2 models declare searchBudgetLostTopImpressionShare.
Query alias: 2 models declare searchImpressions.
Query alias: 2 models declare searchImpressionShare.
Query alias: 2 models declare searchRankLostImpressions.
Query alias: 2 models declare searchRankLostImpressionShare.
Query alias: 2 models declare searchRankLostTopImpressions.
Query alias: 2 models declare searchRankLostTopImpressionShare.
Query alias: 2 models declare searchTopImpressions.
Query alias: 2 models declare searchTopImpressionShare.
Query alias: 1 model declares secondaryEventDateEnd.
Query alias: 1 model declares secondaryEventDateStart.
Query alias: 1 model declares segmentBy.
Query alias: 1 model declares segmentCreatedDate.
Query alias: 2 models declare segmentId.
Query alias: 1 model declares segmentInstanceId.
Query alias: 2 models declare segmentName.
Query alias: 1 model declares senderEmail.
Query alias: 1 model declares senderName.
Query alias: 3 models declare sentiment.
Query alias: 1 model declares sessionCity.
Query alias: 1 model declares sessionCount.
Query alias: 1 model declares sessionCountry.
Query alias: 1 model declares sessionDefaultChannelGroup.
Query alias: 1 model declares sessionElapsedTime.
Query alias: 4 models declare sessionId.
Query alias: 4 models declare sessionPageViews.
Query alias: 1 model declares sessionSource.
Query alias: 1 model declares sessionSourceMedium.
Query alias: 1 model declares sessionStartTs.
Query alias: 2 models declare sevenDayClick.
Query alias: 2 models declare sevenDayClickComments.
Query alias: 1 model declares sevenDayClickConversionValue.
Query alias: 2 models declare sevenDayClickLikes.
Query alias: 1 model declares sevenDayClickLinkClicks.
Query alias: 1 model declares sevenDayClickPurchases.
Query alias: 2 models declare sevenDayClickReactions.
Query alias: 2 models declare sevenDayClickShares.
Query alias: 2 models declare sevenDayClickValue.
Query alias: 2 models declare sevenDayView.
Query alias: 1 model declares sevenDayViewConversionValue.
Query alias: 1 model declares sevenDayViewPurchases.
Query alias: 2 models declare sevenDayViewValue.
Query alias: 1 model declares shipmentDate.
Query alias: 1 model declares shipmentStatus.
Query alias: 2 models declare shippingCity.
Query alias: 3 models declare shippingCosts.
Query alias: 2 models declare shippingCountryCode.
Query alias: 2 models declare shippingCountryName.
Query alias: 1 model declares shippingDate.
Query alias: 1 model declares shippingPlatform.
Query alias: 3 models declare shippingPrice.
Query alias: 1 model declares shippingProviderId.
Query alias: 2 models declare shippingState.
Query alias: 2 models declare shippingStateCode.
Query alias: 2 models declare shippingZip.
Query alias: 26 models declare shopName.
Query alias: 1 model declares shopShipmentCost.
Query alias: 2 models declare shopTimezone.
Query alias: 3 models declare singleProductCost.
Query alias: 1 model declares smsMarketingConsentCollectedFrom.
Query alias: 1 model declares smsMarketingConsentOptInLevel.
Query alias: 1 model declares smsMarketingConsentUpdatedAt.
Query alias: 1 model declares sourceDomain.
Query alias: 4 models declare sourceName.
Query alias: 1 model declares sourceType.
Query alias: 1 model declares sourceUrl.
Query alias: 1 model declares spendType.
Query alias: 2 models declare stateCode.
Query alias: 1 model declares statisticPredictedSpendTier.
Query alias: 1 model declares storefrontUrl.
Query alias: 2 models declare subCategoryId.
Query alias: 1 model declares subCategoryName.
Query alias: 2 models declare subscribedToList.
Query alias: 1 model declares subscriptionFilter.
Query alias: 2 models declare subscriptionId.
Query alias: 1 model declares subscriptionInterval.
Query alias: 1 model declares subscriptionIntervalCount.
Query alias: 1 model declares surveyComment.
Query alias: 1 model declares surveyScore.
Query alias: 1 model declares surveyScoredAt.
Query alias: 1 model declares surveySentAt.
Query alias: 1 model declares surveyType.
Query alias: 1 model declares systemServingStatus.
Query alias: 1 model declares targetKey.
Query alias: 1 model declares targetValues.
Query alias: 1 model declares taxExempt.
Query alias: 1 model declares threeSecondVideoView.
Query alias: 1 model declares thruplays.
Query alias: 1 model declares ticketsClosed.
Query alias: 1 model declares ticketsCreated.
Query alias: 1 model declares ticketsReplied.
Query alias: 3 models declare timeOnSite.
Query alias: 1 model declares toCountry.
Query alias: 1 model declares toCountryName.
Query alias: 1 model declares topicName.
Query alias: 1 model declares totalCancelledSubscriptions.
Query alias: 1 model declares totalChurnedSubscribers.
Query alias: 1 model declares totalCosts.
Query alias: 1 model declares totalItemsSold.
Query alias: 1 model declares totalNewSubscribers.
Query alias: 1 model declares totalNewSubscriptions.
Query alias: 1 model declares totalOrderValue.
Query alias: 1 model declares totalPrice.
Query alias: 1 model declares totalRefundedCogs.
Query alias: 1 model declares totalRefundedPrice.
Query alias: 1 model declares totalRefundedShipping.
Query alias: 1 model declares totalRefundedTax.
Query alias: 3 models declare totalRevenue.
Query alias: 1 model declares totalRevenueFirstOrder.
Query alias: 1 model declares totalRevenueRecurring.
Query alias: 1 model declares totalSales.
Query alias: 1 model declares totalUsers.
Query alias: 1 model declares totalVideoView.
Query alias: 1 model declares transactions.
Query alias: 1 model declares tripleIds.
Query alias: 1 model declares twentyEightDayClick.
Query alias: 1 model declares twentyEightDayClickConversionValue.
Query alias: 1 model declares twentyEightDayClickLinkClicks.
Query alias: 1 model declares twentyEightDayClickPurchases.
Query alias: 1 model declares twentyEightDayClickValue.
Query alias: 2 models declare twentyEightDayView.
Query alias: 1 model declares twentyEightDayViewConversionValue.
Query alias: 1 model declares twentyEightDayViewPurchases.
Query alias: 1 model declares twentyEightDayViewValue.
Query alias: 1 model declares typeField.
Query alias: 1 model declares unhelpfulCount.
Query alias: 2 models declare uniqueCustomers.
Query alias: 3 models declare uniqueVisitors.
Query alias: 2 models declare unsubscribed.
Query alias: 6 models declare updatedAt.
Query alias: 1 model declares updatedIntegrationDescription.
Query alias: 1 model declares updatedIntegrationSource.
Query alias: 1 model declares updatedIntegrationTitle.
Query alias: 1 model declares updatedNewUserDescription.
updated post purchase survey description
Query alias: 1 model declares updatedPostPurchaseSurveyDescription.
Query alias: 1 model declares urlQueryParams.
Query alias: 2 models declare urlTemplate.
Query alias: 1 model declares useClickDate.
Query alias: 2 models declare utmMedium.
Query alias: 2 models declare utmSource.
Query alias: 1 model declares validEmailAddress.
Query alias: 1 model declares variantDescription.
Query alias: 7 models declare variantId.
Query alias: 1 model declares variantInventoryQuantity.
Query alias: 3 models declare variantName.
Query alias: 1 model declares variantPrice.
Query alias: 1 model declares variantPriceChangedFrom.
Query alias: 1 model declares variantPriceChangedTo.
Query alias: 1 model declares variantStockStatus.
Query alias: 1 model declares verifiedEmailAddress.
Query alias: 1 model declares videoDuration.
Query alias: 2 models declare videoP100Watched.
Query alias: 2 models declare videoP25Watched.
Query alias: 2 models declare videoP50Watched.
Query alias: 2 models declare videoP75Watched.
Query alias: 2 models declare videoP95Watched.
Query alias: 3 models declare videoUrlIframe.
Query alias: 2 models declare videoUrlSource.
Query alias: 1 model declares videoViews.
Query alias: 1 model declares viewsTotal.
Query alias: 1 model declares visibilityChangedAt.
Query alias: 1 model declares visibilityChangedBy.
Query alias: 1 model declares visibilityPercentage.
Query alias: 1 model declares visibilityStatus.
Query alias: 2 models declare websitePurchases.
Event Date - The date the activity occurred. Based on the shop time zone at the moment of the event (or the user time zone, if no sales platform is connected).
Event Day - The day the event occurred. Derived from event_date .
Event Week - The Sunday of the week during which the event occurred. Derived from event_date .
Event Month - The month during which the event occurred. Derived from event_date .
Event Quarter - The first month of the quarter during which the event occurred. Derived from event_date .
Event Year - The year during which the event occurred. Derived from event_date .
Account ID - The unique ID for the platform or channel account associated with the activity. Example values: act_2168791943307744 , 18ce55770zl , 1986494684391480
Action Source - The source or interface from which the action was initiated. Example values: Moby
Ad Changed Name From - The previous name of the ad before it was updated. Example value: Spring Campaign A
Ad Changed Name To - The updated name of the ad. Example value: Spring Campaign A v2
Ad Created - Indicates whether a new ad was created. Possible values: true , false
Ad Status Changed From - The prior status of the ad before the change. Example values: PAUSED , ACTIVE , IN_PROCESS , PENDING_REVIEW
Ad Status Changed To - The new status of the ad. Example values: PAUSED , ACTIVE , IN_PROCESS , PENDING_REVIEW
Ad Set Bid Amount Changed From - The previous bid amount (in cents) for the ad set, before the most recent change. By default shown in the shop's currency.
Ad Set Bid Amount Changed To - The updated bid amount (in cents) for the ad set, after the most recent change. By default shown in the shop's currency.
Ad Set Changed Name From - The previous name of the ad set. Example values: Interest - Teens
Ad Set Changed Name To - The updated name of the ad set. Example: Interest - Teen Girls
Ad Set Created - Indicates whether a new ad set was created. Possible values: true , false
Ad Set Daily Budget Changed From - The previous daily budget (in cents) set for the ad set, before the most recent change. By default shown in the shop's currency.
Ad Set Daily Budget Changed To - The updated daily budget (in cents) set for the ad set, after the most recent change. By default shown in the shop's currency.
Ad Set Status Changed From - The prior status of the ad set before the change. Example values: PAUSED , ACTIVE , IN_PROCESS
Ad Set Status Changed To - The updated status of the ad set. Example values: PAUSED , ACTIVE , IN_PROCESS
Ad Set Target ROAS Changed From - The previous target ROAS for the ad set, before the most recent change. By default shown in the shop's currency.
Ad Set Target ROAS Changed To - The updated target ROAS for the ad set, after the most recent change. By default shown in the shop's currency.
Annotation Author - The user who created the annotation.
Annotation Description - The message content of the annotation.
Annotation Title - The title of the annotation.
Campaign Bid Amount Changed From - The previous bid amount (in cents) for the campaign, before the most recent change. By default shown in the shop's currency.
Campaign Bid Amount Changed To - The updated bid amount (in cents) for the campaign, after the most recent change. By default shown in the shop's currency.
Campaign Changed Name From - The prior campaign name. Example value: June Evergreen
Campaign Changed Name To - The updated campaign name. Example value: June Evergreen V2
Campaign Created - Indicates whether a new campaign was created. Possible values: true , false
Campaign Daily Budget Changed From - The previous daily budget in cents) for the campaign, before the most recent change. By default shown in the shop's currency.
Campaign Daily Budget Changed To - The updated daily budget in cents) for the campaign, after the most recent change. By default shown in the shop's currency.
Campaign Lifetime Budget Changed From - The previous lifetime budget in cents) for the campaign, before the most recent change. By default shown in the shop's currency.
Campaign Lifetime Budget Changed To - The updated lifetime budget in cents) for the campaign, after the most recent change. By default shown in the shop's currency.
Campaign Status Changed From - The prior status of the campaign. Example values: Draft , ACTIVE , Sending , IN_PROCESS , Queued without Recipients
Campaign Status Changed To - The new status of the campaign. Example values: Draft , ACTIVE , Sending , IN_PROCESS , Queued without Recipients
Campaign Target ROAS Changed From - The previous target ROAS for the campaign, before the most recent change. By default shown in the shop's currency.
Campaign Target ROAS Changed To - The updated target ROAS for the campaign, after the most recent change. By default shown in the shop's currency.
CDP Sync to Facebook Status - The result of syncing the CDP segment to Facebook. Example values: disconnect_sync_to_facebook , sync_to_facebook
CDP Sync to Klaviyo Status - The result of syncing the CDP segment to Klaviyo. Example values: disconnect_sync_to_klaviyo , sync_to_klaviyo
Channel - The platform or channel that the activity occurred in. Example values: facebook-ads , shopify , triple-whale
Created At - The timestamp when the activity occurred. Example: 2025-05-28 17:17:34
Created CDP Segment - Indicates whether a CDP segment was created. Possible values: true , false
Created Survey Description - A message indicating that a post-purchase survey was created. Example value: Post Purchase Survey Created
Deleted Survey Description - A message indicating that a post-purchase survey was deleted. Example value: Post Purchase Survey Deleted
Entity Type - The type of entity that the activity occurred on. Example values: adset , ad , campaign , variant , cdp_segment
Entity ID - Unique identifier for the activity log entry. Example value: 23844267499760291
Entity Name - Name of the entity that the activity occurred on. Example values: Natural Woven Bundle , Meta Monday , BFCM Lost
Shop ID - The unique ID of the shop (often corresponds to the shop domain). Can be used to group or filter data by shop in multi-store reports. Example values: example-US.myshopify.com , example-EU.myshopify.com
Shop Name - The name of the shop. Can be used to group or filter data by shop in multi-store reports. Example values: example-US , example-EU
Updated Integration Description - A message indicating that an integration was updated. Example value: Facebook Ads Disconnected
Updated Integration Source - The integration source that was updated. Example value: facebook-ads
Updated Integration Title - The title of the message indicating that an integration was updated. Example: Integrations Updated
Updated New User Description - A message indicating that a user was updated.
Updated Survey Description - A message indicating that a post-purchase survey was updated. Example value: Post Purchase Survey Updated
Variant Price Changed From - The previous price of the product variant, before the most recent change. By default shown in the shop's currency.
Variant Price Changed To - The updated price of the product variant, after the most recent change. By default shown in the shop's currency.
Variant Stock Status - The inventory status of a product variant. Example values: out of stock , back in stock
Event Hour - The hour of the day the ad was run, according to a 24-hour clock. Based on the shop time zone at the moment of the event (or the user time zone, if no sales platform is connected). Example values: 07 , 16 , 21
Event Date - The date the ad was run. Based on the shop time zone at the moment of the event (or the user time zone, if no sales platform is connected).
Event Day - The day on which the event occurred. Derived from event_date .
Ad Account ID - The unique ID for the ad account associated with the ad. Assigned by the ad platform. Example values: act_2168791943307744 , 18ce55770zl , 1986494684391480
Ad Account Name - The name of the advertiser's account as defined in the ad platform. Example values: Example Shop , example_shop , ES - International
Actions - Actions tracked and reported by Facebook in response to an ad interaction (click or view), such as leads, checkouts, or game plays.
Ad Bid Amount - The bid amount for the ad. Example values: 15 , 28 , 30
Ad Copies - Array of all unique ad copy texts.
Ad Copy - The full text (copy) of the ad.
Ad ID - The unique ad ID. Assigned by the ad platform. Example value: 120210439891110007
Ad Image URL - The URL of the ad image. Example value: https://www.example.com/ad-image.jpg
Ad Name - The internal name of the ad within the ad platform. Example values: Kids Ad 1 , Blog 03/12/2023 , 10460_video_black_#5
Ad Post ID - The ID of the ad post. Example value: 123456789012345_987654321098765
Ad Status - The status of the ad. Example values: ACTIVE , PAUSED
Ad Title - The external, published title that viewers see when the ad is served. Example values: UP TO 50% OFF , The Hype Is Real , Trusted by 4 Million+ Women Worldwide
Ad Titles - Array of all unique ad titles.
Ad Type - The format of the ad. Example values: video , image , carousel , link , VIDEO , GRAPHIC Currently available for Meta and Axon.
Ad Set Bid Amount - The bid amount for the ad set. Example values: 25 , 35 , 40
Ad Set Bid Strategy - The bidding strategy for the ad set. Example values: LOWEST_COST_WITHOUT_CAP , LOWEST_COST_WITH_BID_CAP , COST_CAP , LOWEST_COST_WITH_MIN_ROAS
Ad Set ID - The unique ID for the ad set associated with the ad click. Assigned by the ad platform. Example value: 120210439890740003
Ad Set Name - The name of the ad set within a campaign. Example values: Broad Audience , Bracelets , Wellness
Ad Set Status - The status of the ad set. Example values: ACTIVE , PAUSED
Ad Set Targeting - Details on targeting parameters for the ad set, including specific audience segments. Learn more about ad set targeting data
Amazon Marketplace ID - The Amazon marketplace ID for the marketplace associated with the order. See list of marketplace IDs .
Amazon Report Type - The type of report generated for Amazon advertising activities (e.g. sponsored products, sponsored brands, sponsored display).
Amazon Standard Identification Number - The 10-character alphanumeric code that uniquely identifies a product on Amazon (unique per marketplace). Shows which specific product an Amazon ad or search keyword performance metric is associated with. Example values: B08N5WRWNW , B0CXYZ1234
Breakdown Dimension - The dimension used to break down the data. Example values: age — Audience age bucket. gender — Audience gender category. ageGender — Combination of age bucket and gender. country — Audience or delivery country. region — Sub-country region. dma — U.S. Nielsen Designated Market Area (media market). frequency — How many times a person saw the ad (bucketed). publisherPlatform — App or network where delivery occurred. platformPosition — Specific placement/slot within a platform surface. publisherPlatformPosition — Combination of platform and placement.
Breakdown Value - The value of the selected breakdown_dimension . Values differ by dimension and platform. Example values by dimension: age — 25-34 , 35-44 , 45-54 , 55-64 , 65+ gender — female , male , unknown ageGender — 25-34|female , 35-44|male , 65+|unknown country — US , CA , GB (The breakdown_country_name column provides the corresponding full country name. See list of countries .) region — California , New York , Washington, District of Columbia dma — Boston (Manchester) , Albany-Schenectady-Troy , Dallas-Ft. Worth frequency — 1 , 6-10 , 31+ publisherPlatform — facebook , instagram , messenger , audience_network , threads , unknown platformPosition — feed , facebook_stories , instagram_stories , messenger_stories , facebook_reels , instagram_reels , marketplace , right_hand_column , instream_video , search , video_feeds publisherPlatformPosition — facebook|feed , instagram|feed , facebook|facebook_stories , instagram|instagram_reels , facebook|right_hand_column
Breakdown Country Name - The country name for the ad breakdown. Only populated when breakdown_dimension is set to country . When no breakdown is set, or when a different breakdown dimension is selected, this column returns NULL. See list of countries . Example values: United States , Canada , United Kingdom
Campaign Bid Strategy - The bidding strategy for the campaign. Example values: LOWEST_COST_WITHOUT_CAP , LOWEST_COST_WITH_BID_CAP , COST_CAP , LOWEST_COST_WITH_MIN_ROAS
Campaign Created Date - The time the campaign was created. Formatted according to the ISO 8601 international standard. Example value: 2019-04-15 08:26:00 Currently available for Meta only.
Campaign ID - The unique ID for the marketing campaign associated with the ad. Assigned by the ad platform. Example values: 23852438666180053 , 531011533 , 20620285829
Campaign Name - The name of the marketing campaign associated with the ad. Example values: Catalog Retargeting , US Generic Search , Breakfast of Champions Campaign
Campaign Status - The status of the campaign. Example values: ACTIVE , PAUSED
Campaign Type - The type of campaign. Example values: PERFORMANCE_MAX , SEARCH , VIDEO , DEMAND_GEN
Channel - The platform through which the ad was delivered. Example values: facebook-ads , google-ads , tiktok-ads See full list of standardized ad channel IDs
Creative CTA Type - The type of call-to-action button displayed on the ad, indicating the action the advertiser wants users to take. Example values: SHOP_NOW , LEARN_MORE
Creative Distribution Format - The ad distribution format. Example values: Standard Ad , Dynamic Creative Ad , Unknown
Creative Format - The format of the ad creative. Example values: SHARE , VIDEO
Creative ID - The unique identifier assigned to the creative asset by the ad platform. Example value: 1326015151986179
Ad Platform Currency - The original currency used in the ad platform, before conversion to the shop's currency. All monetary values are automatically converted to the shop's selected currency for display. Example values: USD , GBP , EUR
Custom Conversions - Custom conversions defined by the user in the ad platform.
Destination URL - The destination URL where users land after clicking the ad. Currently available for Meta, Google, and Pinterest. Example value: https://www.myshop.com/products/ productA
Is UTM Valid - Indicates whether the UTM setup in the platform is valid. Possible values: true , false
URL Template - A template URL used to dynamically populate ad URLs with relevant tracking parameters. Example value: utm_source=facebook&utm_campaign={{campaign.name}}
Video URL - The direct link to the video ad hosted on the ad platform. Example value: https://www.youtube.com/embed/ abcdef12345
Video URL Iframe - The iframe embed code for displaying the video ad within a web page or app. Example value: https://www.facebook.com/plugins/ video.phpwidth=1080&href=https:// www.facebook.com/ 123456789/videos/987654321
Video URL Source - The direct file path to the hosted video source, typically used for playback. Example value: https://video-ord5-2.xx.fbcdn.net/o1/v/t2/f2/m69/example-video.mp4?_nc_ht=video-ord5-2.xx.fbcdn.net&_nc_cat=111& oh=1234567890abcdef&oe=67C3D77F
Ad Set Daily Budget - The daily budget (in cents) set for the ad set within a campaign. By default shown in the shop's currency. Example values: 1750 , 6000 , 40000
Ad Set Lifetime Budget - The total budget (in cents) set for the ad set within a campaign over its lifetime. By default shown in the shop's currency. Example values: 5000 , 10000 , 20000
Ad Set Target CPA - The cost per acquisition (CPA) goal defined at the ad set level. Represents the maximum amount the advertiser is willing to spend to generate a single conversion within this ad set. Currently available for Google Ads only.
Ad Set Target ROAS - The return on ad spend (ROAS) goal defined at the ad set level. Indicates the minimum amount of revenue the advertiser aims to generate for each dollar spent within this specific ad set. Currently available for Google Ads only.
All Conversion Value - Revenue generated from channel-reported conversions of all types (e.g. purchases, registrations, add-to-carts).
All Conversions - The total number of channel-reported conversions of all types (e.g. purchases, registrations, add-to-carts).
Campaign Daily Budget - The daily budget (in cents) for the campaign. Example values: 8000 , 10000 , 15000
Campaign Lifetime Budget - The lifetime budget (in cents) for the campaign. Example values: 5000 , 10000 , 20000
Campaign Target CPA - The cost per acquisition (CPA) goal defined at the campaign level. Represents the maximum amount the advertiser is willing to spend to generate a single conversion across the campaign. Currently available for Google Ads only.
Campaign Target ROAS - The return on ad spend (ROAS) goal defined at the campaign level. Indicates the minimum amount of revenue the advertiser aims to generate for each dollar spent across the entire campaign. Currently available for Google Ads only.
Clicks - Number of channel-reported clicks.
Currency Rate - The rate used to convert monetary values to the shop's currency. If no conversion was applied, the value is 1 . To convert back to the original currency, divide by this rate.
Channel-Reported Conversion Value - Revenue generated from channel-reported conversions (purchases).
Channel-Reported Conversions (Purchases) - Number of channel-reported conversions (purchases).
Engagements - Number of interactions with the ad (likes, shares, etc).
Follows - Number of new follows attributed to the ad.
Impressions - Number of channel-reported impressions.
Inline Post Engagement - Number of inline engagement (likes, shares, comments) with the ad.
One-Day Click Comments - Number of comments within one day of clicking the ad.
One-Day Click Conversion Value - The total value of channel-reported conversions (purchases) made within one day of clicking the ad.
One-Day Click Likes - Number of likes within one day of clicking the ad.
One-Day Click Link Clicks - Number of link clicks within one day of clicking the ad.
One-Day Click Conversions (Purchases) - Number of channel-reported conversions (purchases) made within one day of clicking the ad.
One-Day Click Reactions - Number of reactions within one day of clicking the ad.
One-Day Click Shares - Number of shares within one day of clicking the ad.
One-Day View Conversion Value - The total value of channel-reported conversions (purchases) made within one day of viewing the ad.
One-Day View Conversions (Purchases) - The total number of channel-reported conversions (purchases) made within one day of viewing the ad.
Onsite Conversion Value - Revenue from channel-reported conversions (purchases) made on the ad channel shop (e.g. Meta Shop, TikTok Shop).
Onsite One-Day Click Conversion Value - The total value of channel-reported conversions (purchases) made on the ad channel shop (e.g. Meta Shop, TikTok Shop) within one day of clicking the ad.
Onsite One-Day Click Conversions (Purchases) - The total number of channel-reported conversions (purchases) made on the ad channel shop (e.g. Meta Shop, TikTok Shop) within one day of clicking the ad.
Onsite One-Day View Conversion Value - The total value of channel-reported conversions (purchases) made on the ad channel shop (e.g. Meta Shop, TikTok Shop) within one day of viewing the ad.
Onsite One-Day View Conversions (Purchases) - The total number of channel-reported conversions (purchases) made on the ad channel shop (e.g. Meta Shop, TikTok Shop) within one day of viewing the ad.
Onsite Conversions (Purchases) - Number of channel-reported conversions (purchases) made on the ad channel shop (e.g. Meta Shop, TikTok Shop).
Onsite Seven-Day Click Conversion Value - The total value of channel-reported conversions (purchases) made on the ad channel shop (e.g. Meta Shop, TikTok Shop) within seven days of clicking the ad.
Onsite Seven-Day Click Conversions (Purchases) - The total number of channel-reported conversions (purchases) made on the ad channel shop (e.g. Meta Shop, TikTok Shop) within seven days of clicking the ad.
Onsite Seven-Day View Conversion Value - The total value of channel-reported conversions (purchases) made on the ad channel shop (e.g. Meta Shop, TikTok Shop) within seven days of viewing the ad.
Onsite Seven-Day View Conversions (Purchases) - The total number of channel-reported conversions (purchases) made on the ad channel shop (e.g. Meta Shop, TikTok Shop) within seven days of viewing the ad.
Onsite 28-Day Click Conversion Value - The total value of channel-reported conversions (purchases) made on the ad channel shop (e.g. Meta Shop, TikTok Shop) within 28 days of clicking the ad.
Onsite 28-day Click Conversions (Purchases) - The total number of channel-reported conversions (purchases) made on the ad channel shop (e.g. Meta Shop, TikTok Shop) within 28 days of clicking the ad.
Onsite 28-Day View Conversion Value - The total value of channel-reported conversions (purchases) made on the ad channel shop (e.g. Meta Shop, TikTok Shop) within 28 days of viewing the ad.
Onsite 28-day View Conversions (Purchases) - The total number of channel-reported conversions (purchases) made on the ad channel shop (e.g. Meta Shop, TikTok Shop) within 28 days of viewing the ad.
Outbound Clicks - Number of channel-reported outbound clicks.
Reach - The total number of unique individuals who saw the ad.
Search Absolute Top Impressions - The number of impressions your ads received in the absolute top position (the very first ad above organic results).
Search Budget Lost Absolute Top Impressions - The estimated number of absolute top impressions your ads missed due to low budget.
Search Budget Lost Top Impressions - The estimated number of top impressions your ads missed due to low budget.
Search Impressions - The total number of impressions your ads received on the Search Network.
Search Rank Lost Impressions - The estimated number of impressions your ads did not receive because Ad Rank was too low.
Search Rank Lost Top Impressions - The estimated number of top impressions your ads missed due to poor Ad Rank.
Search Top Impressions - The number of impressions your ads received in the top position (any position above organic results).
Seven-Day Click Comments - Number of comments within seven days of clicking the ad.
Seven-Day Click Conversion Value - The total value of channel-reported conversions (purchases) made within seven days of clicking the ad.
Seven-Day Click Likes - Number of likes within seven days of clicking the ad.
Seven-Day Click Link Clicks - Number of link clicks within seven days of clicking the ad.
Seven-Day Click Conversions (Purchases) - Number of channel-reported conversions (purchases) made within seven days of clicking the ad.
Seven-Day Click Reactions - Number of reactions within seven days of clicking the ad.
Seven-Day Click Shares - Number of shares within seven days of clicking the ad.
Seven-Day View Conversion Value - The total value of channel-reported conversions (purchases) made within seven days of viewing the ad.
Seven-Day View Conversions (Purchases) - The total number of channel-reported conversions (purchases) made within seven days of viewing the ad.
Ad Spend - Channel-reported ad spend, excluding any custom expenses marked as ad spend.
Three-Second Video View - The number of times a video ad was viewed for at least 3 seconds (thumbstop ratio).
Thruplays - The number of times a video ad was played to completion or for at least 15 seconds.
Twenty-Eight-Day Click Conversion Value - The total value of channel-reported conversions (purchases) made within 28 days of clicking the ad.
Twenty-Eight-Day Click Link Clicks - Number of link clicks within 28 days of clicking the ad.
Twenty-Eight-Day Click Conversions (Purchases) - Number of channel-reported conversions (purchases) made within 28 days of clicking the ad.
Twenty-Eight-Day View Conversion Value - The total value of channel-reported conversions (purchases) made within 28 days of viewing the ad.
Twenty-Eight-Day View Conversions (Purchases) - The total number of channel-reported conversions (purchases) made within 28 days of viewing the ad.
Video 100% Watched - The number of times a video ad was watched for 100% of the video.
Video 25% Watched - The number of times a video ad was watched for 25% of the video.
Video 50% Watched - The number of times a video ad was watched for 50% of the video.
Video 75% Watched - The number of times a video ad was watched for 75% of the video.
Video 95% Watched - The number of times a video ad was watched for 95% of the video.
Visits - Number of channel-reported visits. Currently available for Criteo only.
All Cost Per Acquisition (All CPA) - Cost per conversion of all types (e.g. purchases, registrations, subscriptions, applications). All CPA = Ad Spend / All Conversions
All Return on Ad Spend - Revenue generated per dollar spent on ads, for channel-reported conversions of all types (e.g. purchases, registrations, subscriptions, applications). All ROAS = All Conversion Value / Ad Spend
Average Order Value - The average order value as reported by the ad channel. Channel-Reported AOV = Channel-Reported Conversion Value / Number of Channel-Reported Conversions
Conversion Rate - The percentage of visits that convert into orders, as reported by the channel. Channel-Reported Conversion Rate = Number of Channel-Reported Conversions / Number of Visits
Cost Per Acquisition - The cost to acquire a single conversion, as reported by the channel. Channel-Reported CPA = Ad Spend / Number of Channel-Reported Conversions
Cost Per Click - The average cost for each ad click. CPC = Ad Spend / Clicks
Cost Per Mille - The cost for 1,000 ad impressions. CPM = Ad Spend / Impressions x 1000
Cost Per Outbound Click - Cost for each click leading out from the ad platform to an external website. CPOC = Ad Spend / Outbound Clicks
Cost Per Visit - The cost for each visit driven by ads. CPV = Ad Spend / Number of Visits
Click-Through Rate - The percentage of impressions that result in a click. Click-Through Rate (CTR) = Clicks / Impressions
Revenue Per Link Click - Average revenue generated from each outbound click on the ad. Revenue Per Link Click = Conversion Value / Outbound Clicks
Channel-Reported Return on Ad Spend - Revenue generated per dollar spent on ads, as reported by the channel. Channel-Reported ROAS = Channel-Reported Conversion Value / Ad Spend
Search Absolute Top Impression Share - The percentage of impressions your ads received in the absolute top location (the very first ad above organic results). Search Absolute Top Impression Share = Search Absolute Top Impressions / Impressions Note: Accurate only when grouping by ad set (ad group).
Search Budget Lost Absolute Top Impression Share - The percentage of absolute top impressions your ads did not receive because the campaign budget was limited. Search Budget Lost Absolute Top Impression Share = Search Budget Lost Absolute Top Impressions / Impressions Note: Accurate only when grouping by ad set (ad group).
Search Budget Lost Top Impression Share - The percentage of top impressions your ads did not receive because the campaign budget was limited. Search Budget Lost Top Impression Share = Search Budget Lost Top Impressions / Impressions Note: Accurate only when grouping by ad set (ad group).
Search Impression Share - The percentage of impressions your ads received on the Search Network out of the total impressions they were eligible to receive. Search Impression Share = Search Impressions / Impressions Note: Accurate only when grouping by ad set (ad group).
Search Rank Lost Impression Share - The percentage of impressions your ads did not receive because Ad Rank was too low. Search Rank Lost Impression Share = Search Rank Lost Impressions / Impressions Note: Accurate only when grouping by ad set (ad group).
Search Rank Lost Top Impression Share - The percentage of top impressions your ads did not receive because Ad Rank was too low. Search Rank Lost Top Impression Share = Search Rank Lost Top Impressions / Impressions Note: Accurate only when grouping by ad set (ad group).
Search Top Impression Share - The percentage of impressions your ads received in the top location (any position above organic results). Search Top Impression Share = Search Top Impressions / Impressions Note: Accurate only when grouping by ad set (ad group).
Action Type - The specific type of action tracked by Facebook Ads. This includes raw action names reported by various Facebook data sources, such as pixel events, app events, and unified totals. Example values: lead , omni_add_to_cart , offsite_conversion. fb_pixel_initiate_checkout ).
Action Display Name - The user-friendly name for the action, standardized across Facebook's reporting sources. Example values: achievements_unlocked , add_payment_info , add_to_cart , add_to_wishlist , app_activations , app_installs , applications_submitted , checkouts_initiated , contacts , donations , game_plays , leads , subscriptions , trials_started , tutorials_completed
One-Day View Actions - Number of times the action occurred within 1 day of viewing the ad. Example values: 2 , 5 , 14
Seven-Day View Actions - Number of times the action occurred within 7 days of viewing the ad. Example values: 3 , 8 , 21
Twenty-Eight-Day View Actions - Number of times the action occurred within 28 days of viewing the ad. Example values: 4 , 12 , 30
One-Day Click Actions - Number of times the action occurred within 1 day of clicking the ad. Example values: 2 , 5 , 14
Seven-Day Click Actions - Number of times the action occurred within 7 days of clicking the ad. Example values: 3 , 8 , 21
Twenty-Eight-Day Click Actions - Number of times the action occurred within 28 days of clicking the ad. Example values: 4 , 12 , 30
One-Day View Value Actions - Total monetary value attributed to the action when it occurred within 1 day of viewing the ad. Example values: 4500 , 12999 , 17500
Seven-Day View Value Actions - Total monetary value attributed to the action when it occurred within 7 days of viewing the ad. Example values: 6000 , 17000 , 22350
Twenty-Eight-Day View Value Actions - Total monetary value attributed to the action when it occurred within 28 days of viewing the ad. Example values: 9000 , 25000 , 31500
One-Day Click Value Actions - Total monetary value attributed to the action when it occurred within 1 day of clicking the ad. Example values: 4500 , 12999 , 17500
Seven-Day Click Value Actions - Total monetary value attributed to the action when it occurred within 7 days of clicking the ad. Example values: 6000 , 17000 , 22350
Twenty-Eight-Day Click Value Actions - Total monetary value attributed to the action when it occurred within 28 days of clicking the ad. Example values: 9000 , 25000 , 31500
Target Key - The targeting category key within the ad set (e.g., location, age, gender). Learn more about ad set targeting data Example values: age_min , age_max , geo_locations_countries , device_platforms , genders
Target Values - The specific values associated with the targeting category key, returned as an array. Learn more about ad set targeting data
Custom Conversion Name - The name of the custom conversion event, defined by the user in the ad platform. Example values: $65+ Purchase , NC Purchase , Over60Value
Custom Conversion ID - The unique ID of the custom conversion event, assigned by the ad platform. Example value: 358833132159405
One-Day Click Custom Conversions - Number of conversions (for the custom conversion event) within one day of clicking the ad.
Seven-Day Click Custom Conversions - Number of conversions (for the custom conversion event) within seven days of clicking the ad.
Twenty-Eight-Day Click Custom Conversions - Number of conversions (for the custom conversion event) within twenty-eight days of clicking the ad.
One-Day View Custom Conversions - Number of conversions (for the custom conversion event) within one day of viewing the ad.
Seven-Day View Custom Conversions - Number of conversions (for the custom conversion event) within seven days of viewing the ad.
Twenty-Eight-Day View Custom Conversions - Number of conversions (for the custom conversion event) within twenty-eight days of viewing the ad.
One-Day Click Custom Conversion Value - The total value of conversions (for the custom conversion event) within one day of clicking the ad.
Seven-Day Click Custom Conversion Value - The total value of conversions (for the custom conversion event) within seven days of clicking the ad.
Twenty-Eight-Day Click Custom Conversion Value - The total value of conversions (for the custom conversion event) within twenty-eight days of clicking the ad.
One-Day View Custom Conversion Value - The total value of conversions (for the custom conversion event) within one day of viewing the ad.
Seven-Day View Custom Conversion Value - The total value of conversions (for the custom conversion event) within seven days of viewing the ad.
Twenty-Eight-Day View Custom Conversion Value - The total value of conversions (for the custom conversion event) within twenty-eight days of viewing the ad.
Event Date - The date the affiliate event occurred. Based on the shop time zone at the moment of the event (or the user time zone, if no sales platform is connected).
Ad ID - The unique identifier of the tracking link under the campaign. Example values: link_abc123 , tracking_xyz789
Ad Name - The name of the tracking link under the campaign. Example values: homepage-banner , product-page-link , email-cta
Ad Status - Indicates whether this tracking link is active or inactive. Example values: active , inactive
Campaign ID - The unique identifier of the campaign or offer under the publisher. Example values: camp_12345 , offer_67890
Campaign Name - The name of the campaign or offer under the publisher. Example values: summer-promo-10% , holiday-sale-2024 , winter-clearance
Campaign Status - Indicates whether this campaign or offer is active or inactive. Example values: active , inactive
Publisher ID - The unique identifier of the affiliate partner or influencer. Example value: 208997
Publisher Name - The name of the affiliate partner or influencer. Example values: Karma Shopping LTD , NextGen Shopping, Inc. , tenere_team
Publisher Status - Indicates whether the partnership with this affiliate is active or inactive. Example values: active , inactive
Clicks - Number of clicks on the affiliate tracking link.
Conversion Value - Total revenue generated from purchases attributed to the affiliate.
Impressions - Number of times the affiliate tracking link was displayed or viewed.
Purchases - Number of purchases attributed to the affiliate.
Spend - Total amount spent on the affiliate partnership, including commissions, fees, or other costs.
Event Date - The date the order was placed. Based on the shop time zone at the moment of the event (or user time zone when no sales platform is connected).
Affluencer Source - How the affluencer profile was created. Example values: upload , client , auto_create , backfill
Discount Codes - A list of the discount codes associated with the affluencer.
Expenses - A list of expense records assigned to the affluencer.
Affluencer Links - A list of destination URLs tied to the affluencer, used for traffic and attribution.
Affluencer Name - The name of the affluencer. Example value: Jane Smith
Discount Code - The actual code used to attribute orders to the affluencer. Example values: JEN20 , UMICH , ARKNUTRITION
Discount Code Start Date - The start date the discount code is valid. Example value: 2024-08-02 00:00:00
Discount Code End Date - The end date the discount code is valid. Example value: 2025-08-02 00:00:00
Expense ID - A unique identifier for the expense. Example value: 37f1ad60-2ce9-4733-b6d9-4b3d13307e42
Expense Type - Indicates the category of the expense. Example values: per_order , fixed
Expense Amount Type - Indicates whether the expense is a percentage of sales or a fixed amount (currency). Example values: percentage , currency
Expense Is Recurring - Indicates whether this expense recurs on a regular cadence (e.g. monthly) or is a one-time expense. Possible values: true , false
Expense Recurring Cadence - Frequency of the recurring expense. Example values: one_time , week , month
Expense Start Date - The date the expense starts. Example value: 2023-07-22
Expense End Date - The date the expense ends (if applicable). Example value: 2025-01-01
Expense Amount - The value of the expense.
Expense Recurring Interval Length - Number of intervals between each recurring payment. For example, if recurring_cadence = week and recurring_interval_length = 2 , the expense recurs every two weeks.
Link ID - Unique identifier for the link, formatted: ${name}*${links.campaign}*${links.source}
Link Campaign - The name of the campaign the link is associated with (e.g. summer-launch , holiday-sale ).
Link Source - The traffic source where this link is shared. Example values: instagram , default
Link Storefront URL - The public-facing URL the affluencer is promoting Example value: https://www.instagram.com/example
Link URL - The fully generated tracking URL that includes affluencer and link identifiers. Example value: https://www.instagram.com/example?linkId=example_instagram&affluencerId=example
Event Date - The date the AI visibility prompt execution ran. Based on the shop time zone at the moment of the event (or the user time zone, if no sales platform is connected).
Competitors Visibility - Competitor visibility data for the prompt execution. Each record represents a competitor and whether they were mentioned in the LLM response.
Prompt Execution Timestamp - Timestamp of when the prompt execution ran (UTC). Example value: 2026-01-10 10:04:06
Prompt Execution ID - Unique identifier for a single prompt execution. Example value: 985c7f1d-0f6e-4ae5-bbbc-50f5b3c8353e
Is Mentioned - Whether the shop was mentioned in the response. Possible values: true , false
LLM - The LLM that was used for the prompt execution. Example values: chatgpt , gemini
Prompt ID - The prompt identifier associated with the execution. Example value: 29431f0b8fb1900972f8f121
Prompt Text - The prompt text used for the execution. Example values: What’s the best heritage flour for everyday baking? , What makes seed oil free bars better? , What features should I look for in skis for moderate skill level?
Response Preview - Preview of the LLM response (first 200 characters). Example value: Here are some of the best heritage flours you can use for everyday baking…
Cited Sources - Citations/sources returned by the LLM for the prompt execution. Each record represents one cited source.
Topic ID - The topic identifier associated with the prompt execution. Example value: 495be1b1787a86e9ae3dadd3
Topic Name - The topic name associated with the prompt execution. Example value: Flour , Seed Oil Free , Skis
Visibility Percentage - Percentage of prompt executions where the shop was mentioned in the LLM response. Visibility % = Number of Mentions / Number of Prompt Executions
Competitor ID - Unique identifier for the competitor. Example value: 6801a2f3c9e7b54d1023ef89
Competitor Name - Display name of the competitor. Example value: Acme Co
Competitor URL - URL of the competitor. Example value: https://acmeco.com
Competitor Is Mentioned - Whether this competitor was mentioned in the LLM response. Possible values: true , false
Cited Source Domain - Domain of a cited source. Example value: exampleshop.com
Cited Source URL - URL of a cited source. Example value: https://exampleshop.com/products/heritage-bread-blend-flour?utm_source=chatgpt.com
Citation Order - Order of the citation in the response (lower numbers appear earlier). Example value: 2
Include Amazon - Includes Amazon sales data in the results, in addition to the main sales platform. Possible values: true , false Defaults to false .
Event Hour - The hour of the day on which the order was placed, according to a 24-hour clock. Based on the shop time zone at the moment of the event (or the user time zone, if no sales platform is connected). Example values: 07 , 16 , 21
Event Date - The date the order was placed. Based on the shop time zone at the moment of the event (or the user time zone, if no sales platform is connected).
Event Day - The day on which the ad was run or the order was placed. Derived from event_date .
Blended Channel-Reported Conversion Value - Channel-reported conversion value across all marketing channels connected to Triple Whale.
Cost of Goods (COGS) - The cost of goods sold within the selected time frame (before refunds). Imported from the main sales platform, or edit these in Cost Settings > Cost of Goods.
Adjusted Cost of Goods (Adjusted COGS) - The cost of goods sold within the selected time frame, minus the cost of goods of refunded items in the selected time frame. Imported from the main sales platform, or edit these in Cost Settings > Cost of Goods.
Discounts - The total discount amount applied to the order, including shipping discounts.
Gross Sales - Gross sales revenue (before shipping, taxes, discounts, or refunds). Gross Sales = Product Price x Units Sold
Handling Fees - Handling fees (e.g. boxing, packaging, or “pick & pack” services) paid by the seller for orders in the selected time frame. Edit these in Cost Settings > Cost of Goods.
New Customer Orders - The total number of orders placed by new customers. Learn how Triple Whale classifies new/returning customers .
New Customer Revenue - The total revenue derived from orders by new customers. Learn how Triple Whale classifies new/returning customers .
Order Revenue - Revenue earned after shipping, taxes, and discounts (before refunds). Order Revenue = Gross Sales + Shipping + Taxes − Discounts
Orders - The total number of orders placed within the selected timeframe.
Order-Level Custom Expenses - Additional custom expenses associated with individual orders. Import these using the Enrich Orders Data API endpoint.
Orders > $0 - The total number of orders with a revenue greater than zero.
Payment Gateway Costs - Payment processing fees (not including currency conversion fees) paid by the seller. Edit these in Cost Settings > Gateway Costs.
Refunded Sales - Refunded sales amount for the selected time period. Calculated based on the refund date. Note that Triple Whale does not track refunds from third-party return management apps (e.g., Loop), so totals may vary from the sales platform.
Refunded Orders - The total number of orders refunded in the selected time frame.
Sessions - Total number of online store sessions. Note that Triple Whale defines and tracks sessions differently from the main sales platform so there may be variance between the two. Learn how Triple Whale defines and tracks sessions.
Shipping Costs - Shipping costs paid by the seller for orders within the select timeframe. Edit these in Cost Settings > Shipping.
Shipping Price - The total shipping price of the order (paid by the buyer), after shipping taxes and shipping discounts.
Blended Ad Spend - The reported ad spend of all marketing channels connected to Triple Whale, plus any Custom Expenses marked as Ad Spend.
Taxes - Amount customers paid in taxes (excluding refunded taxes).
Total Costs - The total cost to the seller, including COGS, fees, shipping, custom spend, handling, taxes, and order-level custom expenses, adjusted for refunds. Total Costs = COGS - Refunded COGS + Payment Gateway Costs + Shipping Costs + Custom Spend (excl. Custom Ad Spend) + Handling Fees + Taxes + Order-Level Custom Expenses
Total Sales - Total sales revenue kept by the business after shipping, taxes, discounts, refunded sales, refunded shipping, and refunded taxes. Revenue values are based on the order date; refund values are based on the refund date. Total Sales = Gross Sales + Shipping + Taxes − Discounts − Refunded Sales − Refunded Shipping − Refunded Taxes
Amazon Total Advertising Cost of Sale (Amazon TACoS) - Percentage of Amazon sales revenue spent on ads. Amazon TACoS = Amazon Ad Spend / Amazon Order Revenue
Blended Attributed Return on Ad Spend (BA ROAS) - Revenue attributed to ads relative to ad spend across all channels. Blended-Attributed ROAS = Blended Channel-Reported Conversion Value / Blended Ad Spend
Blended Cost per Acquisition (Blended CPA) - Average ad cost per non-zero order across all channels. Blended CPA = Blended Ad Spend / Number of Orders > $0
Cash Turnover - Cash generated after deducting key expenses from order revenue. Cash Turnover = Order Revenue - Shipping Costs - Payment Gateway Costs - Taxes - Blended Ad Spend - Refunds - Order-Level Custom Expenses
Cost per Session - Average ad cost per customer session. Cost Per Session = Blended Ad Spend / Number of Sessions
Gross Profit - Profit after deducting all costs to the seller. Gross Profit = Total Sales - Total Costs
Gross Revenue - Gross revenue kept by the business after shipping, taxes, discounts, and refunded sales (before refunded shipping or refunded taxes). Revenue values are based on the order date; refund values are based on the refund date. Total Sales = Gross Sales + Shipping + Taxes − Discounts − Refunded Sales
Klaviyo Sales Percentage - Share of total revenue attributed to Klaviyo. Klaviyo Sales Percentage = Klaviyo CV / Total Order Revenue
Marketing Efficiency Ratio (MER) - Ratio of ad spend to total revenue. MER = Blended Ad Spend / Order Revenue Note: For the inverse ratio (Order Revenue / Blended Ad Spend), see Blended ROAS.
New Customer Cost Per Acquisition (NCPA) - Average ad cost to acquire a new customer. NCPA = Blended Ad Spend / Number of New Customer Orders Learn how Triple Whale classifies new/returning customers .
Net Margin - Percentage of revenue remaining as profit. Net Margin = Net Profit / Order Revenue
Net Profit - Remaining revenue after deducting refunds, ad spend, and costs. Net Profit = Main Sales Platform Order Revenue (+ Amazon Product Sales) − Refunds − Ad Spend − Total Costs
Net Sales - Net sales revenue after discounts and refunded sales (before shipping or taxes). Net Sales = Gross Sales − Discounts − Refunded Sales
New Customer Return on Ad Spend (NC ROAS) - Revenue from new customers relative to ad spend. New Customer ROAS = New Customer Revenue / Blended Ad Spend Learn how Triple Whale classifies new/returning customers .
Profit on Ad Spend (POAS) - Profit generated per dollar of ad spend. POAS = (Total Sales - Total Costs) / Ad Spend
Blended Return on Ad Spend (Blended ROAS) - Revenue generated per dollar spent on ads. Blended ROAS = Order Revenue / Blended Ad Spend Note: For the inverse ratio (Blended Ad Spend / Order Revenue), see MER.
Ad ID - The unique ID of the ad associated with the creative asset. Example value: 220227808044480670
Asset ID - The unique ID of the asset used in the ad.
Asset Type - The type of asset used in the ad. Must be set to exactly one of: image , video , copy
Attribution Window - The time frame for attributing conversions to the ad. By default lifetime . Example values: 1_day , 7_days , 14_days , 28_days , lifetime
Channel - The platform through which the ad was delivered. Example values: facebook-ads , google-ads , tiktok-ads
Creative CTA Type - The type of call-to-action (CTA) used in the ad. Example values: Shop Now , Learn More , Sign Up
Creative Distribution Format - The ad creative distribution format. Example values: Standard Ad , Dynamic Creative Ad , Unknown
Attribution Model - The attribution model used. By default Triple Attribution . Possible values: Total Impact , Triple Attribution , Triple Attribution + Views , Clicks & Views , Linear All , Linear Paid , First Click , Last Click
Video Duration - The length of the video ad.
Video URL - The URL of the ad video. Example value: https://www.youtube.com/embed/example
Video URL Iframe - The iframe embed code for displaying the video ad within a web page or app. Example value: https://www.facebook.com/plugins/ video.phpwidth=1080&href=https:// www.facebook.com/123456789/videos/987654321
Pixel Cost of Goods - The cost of goods for Pixel-reported purchases within the selected time frame (before refunds). Imported from the main sales platform, or edit these in Cost Settings > Cost of Goods. Note that COGS for Pixel data is set at attribution time and does not get updated subsequently, so may vary from COGS data in the Orders table.
Pixel New Customer Cost of Goods - The cost of goods for Pixel-reported purchases by new customers within the selected time frame (before refunds). Imported from the main sales platform, or edit these in Cost Settings > Cost of Goods. Note that COGS for Pixel data is set at attribution time and does not get updated subsequently, so may vary from COGS data in the Orders table. Learn how Triple Whale classifies new/returning customers .
Pixel New Customer Conversion Value - Pixel-reported conversion value (order revenue) derived from New Customers. Learn how Triple Whale classifies new/returning customers .
Pixel New Customer Purchases - Number of Pixel-reported orders placed by New Customers. Learn how Triple Whale classifies new/returning customers .
Ads - Total number of ads containing the creative asset.
Pixel Conversion Value (CV) - Pixel-reported conversion value (order revenue) after shipping, taxes, and discounts (before refunds). Order Revenue = Gross Sales + Shipping + Taxes − Discounts
Pixel Purchases - The total number of Pixel-reported purchases (orders) within the selected timeframe. Note: This value is calculated based on the attribution model, and may be a fractional number.
Total Video View - The number of times a video ad was viewed for any amount of time.
Channel-Reported AOV - The average order value as reported by the advertising channel. Channel-Reported AOV = Channel-Reported Conversion Value / Number of Channel-Reported Conversions
Channel-Reported Cost Per Acquisition - The cost to acquire a single conversion, as reported by the channel. Channel-Reported CPA = Ad Spend / Number of Channel-Reported Conversions
Cost Per Click (CPC) - The average cost for each ad click. Cost Per Click (CPC) = Ad Spend / Clicks
Cost Per Mille (CPM) - The cost for 1,000 ad impressions. Cost Per Mille (CPM) = Ad Spend / Impressions x 1000
Pixel New Customer Cost Per Acquisition - The cost to acquire a new customer, as reported by Pixel. Pixel NCPA = Blended Ad Spend / Number of New Customer Orders Learn how Triple Whale classifies new/returning customers .
Pixel New Customer ROAS - Revenue from new customers relative to ad spend. Pixel NC ROAS = New Customer Pixel Conversion Value / Ad Spend Learn how Triple Whale classifies new/returning customers .
Pixel New Customers Percent - The percentage of Pixel-reported purchases made by new customers. Pixel New Customers % = Number of New Customer Pixel Purchases / Total Pixel Purchases Learn how Triple Whale classifies new/returning customers .
Outbound Click-Through Rate - The percentage of impressions that result in outbound clicks. Outbound CTR = Outbound Clicks / Impressions
Pixel AOV - The Pixel-reported average order value. Pixel AOV = Pixel Conversion Value / Number of Pixel Purchases
Pixel Cost Per Acquisition - The cost to acquire a purchase as reported by Pixel. Pixel CPA = Ad Spend / Number of Pixel Purchases
Pixel New Customer Average Order Value - The average order value for new customers as reported by Pixel. Pixel NC AOV = New Customer Pixel Conversion Value / Number of New Customer Pixel Purchases Learn how Triple Whale classifies new/returning customers .
Pixel Profit - The profit calculated as conversion value (order revenue) minus ad spend and cost of goods, as reported by Pixel. Pixel Profit = Pixel Conversion Value - Ad Spend - Pixel COGS
Pixel Return on Ad Spend - Pixel-reported revenue relative to ad spend. Pixel ROAS = Pixel Conversion Value / Ad Spend
Pixel Returning Customer Purchases - Number of Pixel-reported orders placed by Returning Customers. Learn how Triple Whale classifies new/returning customers .
Pixel Returning Customer Revenue - Pixel-reported conversion value (order revenue) derived from Returning Customers. Learn how Triple Whale classifies new/returning customers .
Pixel Returning Customers Percent - The percentage of Pixel-reported purchases made by Returning Customers. Pixel New Customers % = Number of Returning Customer Pixel Purchases / Total Pixel Purchases Learn how Triple Whale classifies new/returning customers .
Event Date - The date the CS event occurred. Based on the shop time zone at the moment of the event (or the user time zone, if no sales platform is connected).
Platform - The customer support platform through which the event was generated. Example value: gorgias
Event Created Date - The time the event was created, in UTC. Formatted according to the ISO 8601 international standard . Example value: 2026-02-28 22:25:32
Event ID - The unique identifier for the event, assigned by the CS provider. Example value: 15715626681
Event Type - The type of CS event. Example values: ticket-created , ticket-closed , ticket-reopened , ticket-message-created , ticket-updated , ticket-assigned , ticket-unassigned
Object ID - The ID of the object this event relates to (e.g., a ticket or message). Example value: 380365041
Object Type - The type of object this event relates to. Ticket for ticket lifecycle events (e.g., created, closed, reopened); TicketMessage for message events (e.g., a new message on a ticket). Example values: Ticket , TicketMessage
User ID - The ID of the user (agent) who triggered this event. NULL when the event was triggered automatically (e.g., by an automation rule). Example value: 416121112
Event Date - The date the CS message was received. Based on the shop time zone at the moment of the event (or the user time zone, if no sales platform is connected).
Message Body - The content of the message. Example value: Thank you for my shipment! Super happy with your product!
Channel - The channel through which the message was delivered. Example values: facebook-comment , instagram-mention , email , chat
Message Created Date - The time the message was created. Formatted according to the ISO 8601 international standard . Example value: 2019-04-15 08:26:00
Message Deleted Date - The time the message was deleted. Formatted according to the ISO 8601 international standard . Example value: 2019-04-15 08:26:00
Is From Agent - True if the message was sent by a customer support agent. Possible values: true , false
Is Public - True if the message is visible to customers (not just the support team). Possible values: true , false
Message ID - The unique message ID. Example value: 435397561
Attributed Orders - A list of order IDs associated with the message. Returned as an array of strings. Example value: ["3797121360046", "3797258330286"]
Attributed Product Names - The names of products mentioned in the message. Returned as an array of strings. Example value: ["Green Soft Socks 3-Pack", "Paring Knife Travel Case", "Gift Subscription"]
Receiver Email - The email address of the recipient of the message. Example value: [email protected]
Receiver ID - The unique identifier assigned to the message recipient. Example value: 123456789
Receiver Name - The full name of the recipient of the message. Example value: Jane Doe
Sender Email - The email address of the sender of the message. Example value: [email protected]
Sender ID - The unique identifier assigned to the message sender. Example value: 987654321
Sender Name - The full name of the sender of the message. Example value: John Smith
Message Sent Date - The time the message was sent. Formatted according to the ISO 8601 international standard . Example value: 2019-09-20 04:03:22
Attributed SKUs - The SKU identifiers of products mentioned in the message. Returned as an array of strings. Example value: ["GP-BACK-02", "A02630", "POP200NAVY"]
Message Subject - The subject line of the message. Example value: Wholesale Account Inquiry
Ticket ID - The unique identifier for the customer support ticket associated with the message. Example value: 68845382
Message Sent Via - The communication platform or method used to send the message. Example value: rule , helpdesk , email
Event Date - The date the CS ticket event occurred (e.g. the creation date for ticket-created events, the closed date for ticket-closed events). Based on the shop time zone at the moment of the event (or the user time zone, if no sales platform is connected).
Assigned Agent ID - The unique identifier of the assigned support agent. Example value: 161343771
Assigned Agent Name - The full name of the assigned support agent. Example value: Jane Doe
Channel - The channel through which the ticket was created. Example values: facebook-comment , instagram-mention , email , chat
Ticket Closed Date - The time the ticket was closed. Formatted according to the ISO 8601 international standard . Example value: 2019-04-15 08:26:00
Ticket Created Date - The time the ticket was created. Formatted according to the ISO 8601 international standard . Example value: 2019-04-15 08:26:00
Customer Email - The email address of the customer. Example value: [email protected]
Customer ID - The unique identifier assigned to the customer. Example value: 123456789
Event Type - The type of event related to the ticket. Example values: ticket-closed , ticket-reopened
From Agent - True if the event was initiated by a support agent. Possible values: true , false
Language - The language used in the ticket. Example values: en , it , ru
Ticket Priority - The priority level of the ticket. Example values: normal , high
Ticket Status - The current status of the ticket. Example values: open , closed
Subject - The subject line of the first message in the ticket. Example values: 4 native ways to sell on TikTok Shop , Re: Thanks For Reaching Out To Us!
Survey Comment - The customer's feedback from the post-resolution survey. Example value: Excellent and quick customer service!
Survey Score - The rating score given by the customer in a post-resolution survey. Example values: 1 , 3 , 5
Survey Scored Date - The time the survey was scored. Formatted according to the ISO 8601 international standard . Example value: 2019-04-15 08:26:00
Survey Sent Date - The time the survey was sent to the customer. Formatted according to the ISO 8601 international standard . Example value: 2019-04-15 08:26:00
Tags - Tags associated with the ticket, used for categorization. Example value: [{"id":"174296","name":"GMAIL-PROMOTIONS"},{"id":"585614","name":"auto-close"},{"id":"585616","name":"non-support-related"}]
Ticket Updated Date - The time the ticket was last updated. Formatted according to the ISO 8601 international standard . Example value: 2019-04-15 08:26:00
AI Rule - The AI rule used to classify campaigns into subcategories. Example values: customers aged 18-24 , campaigns targeting South America , branded search ads , influencer collaborations
Category ID - The ID of the category (grouping dimension, e.g., Tactic, Geography, Product). Example value: 09f58489-713a-4866-bce4-1040c9a1ee71
Category Name - The name of the category (grouping dimension). Example values: Geography , Tactic , Funnel
Subcategory Created Date - The date the subcategory was created. Example value: 2025-09-08
Exclude Providers - The providers excluded from the subcategory. Example values: facebook-ads , google-ads , tiktok-ads
Include Providers - The providers included in the subcategory. Example values: facebook-ads , google-ads , tiktok-ads
Subcategory ID - The ID of the subcategory. Example value: 46c71065-5bbb-4ab6-81ee-39078b23cca0
Subcategory Name - The name of the subcategory (specific group within a category). Example values: 18-24 , Peru , Meta Prospecting , Google PMAX
Campaign ID - The ID of the campaign. Example value: 1234567890
Campaign Name - The name of the campaign. Example values: Catalog Retargeting , US Generic Search , Breakfast of Champions Campaign
Mapping Created Date - The date the campaign was mapped to the subcategory. Example value: 2025-09-08
Channel - The channel or platform where the campaign runs. Example values: facebook-ads , google-ads , tiktok-ads
Subcategory ID - The ID of the subcategory assigned to the campaign. Example value: 46c71065-5bbb-4ab6-81ee-39078b23cca0
Event Hour - The hour of the day the custom expense was incurred, according to a 24-hour clock. Based on the shop time zone at the moment of the event (or the user time zone, if no sales platform is connected). Example values: 07 , 16 , 21
Event Date - The date the custom expense was incurred. Based on the shop time zone at the moment of the event (or the user time zone, if no sales platform is connected).
Campaign ID - The name or ID of the campaign the custom expense is associated with. Note: This may match an existing campaign ID in an integrated ad platform. Edit in Cost Settings > Custom Expenses. Example values: 23852438666180053 , 531011533 , 20620285829
Custom Expense Category - The category of the custom expense. Edit in Cost Settings > Custom Expenses. Example values: Ad Spend , Cashback Booked , Returns Estimate
Channel - The channel or platform related to the custom expense. Note: This may match an existing integrated ad channel. Edit in Cost Settings > Custom Expenses. Example values: facebook , social , microsoft
Is Ad Spend - True if the custom expense is considered an advertising expenditure. Edit in Cost Settings Custom Expenses.
Is Recurring - True if the custom expense is recurring. Edit in Cost Settings > Custom Expenses. Note: Only relevant for fixed expenses. NULL for variable expenses.
Variable Expense Base Metric - The metric upon which the variable custom expense will be based. Edit in Cost Settings > Custom Expenses. Note: Only relevant for variable expenses. NULL for fixed expenses. Example values: Blended Ads , COGS , Orders
Variable Expense Rate - The rate applied to the base metric to calculate the custom expense. Edit in Cost Settings > Custom Expenses, in the percent field. Note: Only relevant for variable expenses. NULL for fixed expenses. Example value: 0.02
Custom Expense Title - The title of the custom expense. Edit in Cost Settings > Custom Expenses. Example values: Podcast , Influencer
Custom Expense Amount - The amount of the expense. By default shown in the shop's currency. Note: For fixed expenses, the amount is set directly by the seller; for variable expenses, the amount is calculated based on the base metric and rate set by the seller, combined with shop prices from the sales, ad, or email/SMS platform (e.g. Shopify, Facebook, Klaviyo). Edit in Cost Settings > Custom Expenses.
Custom Ad Spend - The total amount of custom expenses marked as ad spend.
Custom Expenses Excluding Ad Spend - The total amount of custom expenses, excluding those marked as ad spend.
Event Date - The date the customer journey event occurred. Based on the shop time zone at the moment of the event (or the user time zone, if no sales platform is connected).
Ad ID - The ID of the ad associated with the customer journey event. Example value: 643742158069
Ad Image URL - The thumbnail image URL of the ad associated with the customer journey event. Example value: https://www.example.com/ad-image.jpg
Ad Name - The name of the ad associated with the customer journey event. Example values: Kids Ad 1 , Read Our Latest Blog 03/12/2023 , 8 best fall looks
Ad Set Name - The name of the ad set associated with the customer journey event. Example values: Broad Audience , Bracelets , Wellness
Web Browser - The web browser of the session where the customer journey event originated. Example values: Chrome , Firefox , Safari
Campaign ID - The unique ID of the campaign associated with the customer journey event. Example value: 1234567890
Campaign Name - The name of the campaign associated with the customer journey event. Example values: Catalog Retargeting , US Generic Search , Breakfast of Champions Campaign
Checkout Event Type - The event type recorded by Triple Pixel, corresponding to the step of the checkout funnel. Example values: payment , address , checkout , contact , shipping
Customer Country - The country associated with the customer journey event. For orders and subscriptions, this is the shipping address country. For page visits, add-to-carts, and conversions, this is the visitor's country based on geolocation. See list of countries . Example values: United States , Canada , United Kingdom
Customer ID - The unique customer ID associated with the customer journey event. Assigned by the main sales platform. Example value: 5209503793328
Device - The type of device used by the customer during their website session. Example values: mobile , desktop , tablet , wearable
Discount Code - The discount code for the order associated with the customer journey event. Assigned by the seller in the main sales platform. Example values: WELCOME10 , Replacement for defective item , 807QRWMNK2
Customer Email - The customer’s email address. Example value: [email protected]
Event Name - The name assigned to the custom conversion event. Example values: form_fill , start_quiz , quiz_complete , order_sample , answer_question , request_consultation
Event Timestamp - The exact timestamp when the customer journey event occurred. Formatted according to the ISO 8601 international standard . Example value: 2024-03-16T00:13:03
Fulfillment Status - The order fulfillment status for the order associated with the customer journey event. Example values: fulfilled , partial , restocked
Is New Customer - True if the order associated with the customer journey event is the customer's first. Possible values: true , false Learn how Triple Whale classifies new/returning customers .
Items Purchased - Information about items purchased by the customer in the order associated with the customer journey event.
Lead Click Timestamp - The time of the ad click that led to the customer journey event. Formatted according to the ISO 8601 international standard . Example value: 2024-10-26 20:03:48
Order ID - The unique order ID associated with the customer journey event. Assigned by the main sales platform. Example value: 4930225799243
Order Name - The name of the order associated with the customer journey event. Assigned by the main sales platform. Example values: #2188464 , Ex-2163819-9
Page Type - The type of page the customer interacted with during the customer journey event. Example values: product , collection , cart
Page View Event ID - A unique ID that links to the parent page view associated with the customer journey event. This allows tracking of custom events as child actions within the context of the page they occurred on. Example value: 0m3uyt4g11owByF1cQ
Customer Phone - The customer's phone number. Example value: 18005550199
Product ID - The unique ID of the product in the order associated with the customer journey event. Example value: 7760518986312
Product Image URL - The image URL of the product in the order associated with the customer journey event. Example value: https://cdn.shopify.com/s/files/1/prod1
Product Name - The name (or title) of the product in the order associated with the customer journey event. Example values: $20 USD Gift Card , Unisex Hoodie
URL Query Parameters - The query parameters contained in the URL associated with the customer journey event. Example values: {"tw_adid":"83906898178855", "tw_campaign":"103306890", "tw_source":"bing"," utm_campaign":"Bing Shopping", "utm_content":"HERO SKU Summer Book Run", "utm_medium":"cpc", "utm_source":"bing", "utm_term":"1342506080190763", "variant":"44042133111001"}
Survey Questions - Survey questions asked during the customer journey.
Referrer - The referrer platform of the ad associated with the customer journey event. Example values: shop.example.com , tiktok , google
Session ID - The unique session ID associated with the customer journey event. Assigned by Triple Pixel. Example value: cltlok4y634IRw62AZ_1710700966152
Source - The source of the customer journey event. Example values: snapchat-ads , klaviyo , google-ads , Direct
Subscription ID - The unique ID of the subscription associated with the customer journey event. Example value: 3521068
Tags - Tags for the order associated with the customer journey event. Assigned by the seller in the main sales platform. Example values: Upsell , Order Credits , discount_eligible
Triple Pixel ID - The unique ID assigned by Triple Pixel event to track visitors across sessions, for the visitor associated with the customer journey event. Example value: cltlok4y634IRw62AZ
Customer Journey Event Type - The customer journey event type. Example values: viewed_page , added_to_cart , placed_order , post_purchase_survey_submitted
URL - The URL the customer interacted with during the customer journey event. Example values: myshop.com/cart , myshop.com/products/my_product_07
Discount - The total discount applied to the order associated with the customer journey event. Example values: 41.99 , 7.49 , 71042.30
Order Revenue - The revenue from the order associated with the customer journey event. Example values: 25 , 253850.59
Page Views - The number of pages viewed during the customer journey event. Example values: 1 , 5 , 12
Quantity - The number of products added to the cart (for added_to_cart events) or the number of orders (for placed_order events). Example values: 1 , 3 , 15
Total Price - The total price of the order associated with the customer journey event. Example value: 247.22
Customer Journey Events - The total number of customer journey events within the selected timeframe. Example values: 13 , 452 , 225,897
Price - The price of the purchased item in the order associated with the customer journey event. Example values: 40.59 , 10.99 , 24.50
Product Name - The name (or title) of the product purchased in the order associated with the customer journey event. Example values: $20 USD Gift Card , Unisex Hoodie
Variant Name - The name (or title) of the product variant purchased in the order associated with the customer journey event. Example values: Forest Green , M , iPhone 14 Pro
Stock Keeping Unit (SKU) - The stock keeping unit (SKU) of the product or variant purchased in the order associated with the customer journey event. Example values: SIL-RING-4445 , NVDPROTECTION03
Quantity - The quantity of items purchased in the order associated with the customer journey event. Example values: 1 , 5 , 200
Survey Question - The question asked during the customer journey event. Example value: Which of the following led you to purchase today?
Survey Answer - The answer provided during the customer journey event. Example values: Exchange for a prior purchase , Youtube , QVC , Just decided to try them
Instance Event Date End - End of the segment instance window. Filters which segment instances (runs/snapshots) to include when building the customer list. Use with instance_event_date_start . Example value: 2025-08-31
Instance Event Date Start - Start of the segment instance window. Filters which segment instances (runs/snapshots) to include when building the customer list. Use with instance_event_date_end . Example value: 2025-08-01
Pinned Event Date - The anchor date used to compare before/after segment instance windows. Example value: 2025-08-25
Secondary Event Date End - End of the joined activity window. Filters joined activity pulled from tables other than the Customer Segmentation table (e.g. Orders, Pixel Orders). Use with secondary_event_date_start . Example value: 2025-09-01
Secondary Event Date Start - Start of the joined activity window. Filters joined activity pulled from tables other than the Customer Segmentation table (e.g. Orders, Pixel Orders). Use with secondary_event_date_end . Example value: 2025-08-01
Segment ID - The unique identifier for a segment. Example value: 64b8f144256b30501b2ea1e0
Customer Identity - The identity of the customer in the segment (can be email or customer_id ). Example values: 67b076c419252e53fbc0841g , [email protected]
Customer Identity Type - The type of identity the segment uses for this customer. Example values: email , customer_id
Instance Event Date - The event date used for data from tables other than the Customer Segmentation table (e.g., Orders table, Pixel Orders table). Used in membership/instance joins. Formatted according to the ISO 8601 international standard. Example value: 2025-01-19 22:21:04
Segment Name - The human-readable name of the segment. Example values: Fourth of July Sale , At least 3 orders , Jan Non Recent Active
30-Day List Attrition - Number of customers who were in the segment 30 days before the pinned_event_date , and left the segment on the pinned_event_date .
30-Day List Growth - Number of customers who were not in the segment 30 days before the pinned_event_date , and joined the segment on the pinned_event_date .
30-Day List Persistence - Count of customers who remained in the segment for at least 30 days (were active both 30 days before the pinned_event_date and on the pinned_event_date ).
30-Day Loyal Customers - Number of highly engaged customers who were active on both the start and end dates of a 31-day period and maintained 95% activity frequency (active on at least 29 out of 31 days)
30-Day Recent Joiners - Number of customers who were not in the segment 30 days before the pinned_event_date but joined the segment within the last 29 days leading up to the pinned_event_date .
Ad IDs (Last 7 Days) - Ad IDs for customers from the selected segment instances in the 7 days prior to the pinned_event_date .
Ad IDs (Next 7 Days) - Ad IDs for customers from the selected segment instances in the 7 days after the pinned_event_date .
AOV (Last 7 Days) - Average order value for customers from the selected segment instances in the 7 days prior to the pinned_event_date .
AOV (Next 7 Days) - Average order value for customers from the selected segment instances in the 7 days after the pinned_event_date .
Campaign IDs (Last 7 Days) - Campaign IDs for customers from the selected segment instances in the 7 days prior to the pinned_event_date .
Campaign IDs (Next 7 Days) - Campaign IDs for customers from the selected segment instances in the 7 days after the pinned_event_date .
Channels (Last 7 Days) - Pixel-attributed channels for customers from the selected segment instances in the 7 days prior to the pinned_event_date .
Channels (Next 7 Days) - Pixel-attributed channels for customers from the selected segment instances in the 7 days after the pinned_event_date .
Cities (Last 7 Days) - Shipping cities for customers from the selected segment instances in the 7 days prior to the pinned_event_date .
Cities (Next 7 Days) - Shipping cities for customers from the selected segment instances in the 7 days after the pinned_event_date .
Countries (Last 7 Days) - Shipping countries for customers from the selected segment instances in the 7 days prior to the pinned_event_date .
Countries (Next 7 Days) - Shipping countries for customers from the selected segment instances in the 7 days after the pinned_event_date .
Order Tags (Last 7 Days) - Order tags for customers from the selected segment instances in the 7 days prior to the pinned_event_date .
Order Tags (Next 7 Days) - Order tags for customers from the selected segment instances in the 7 days after the pinned_event_date .
Product IDs (Last 7 Days) - Product IDs purchased by customers from the selected segment instances in the 7 days prior to the pinned_event_date .
Product IDs (Next 7 Days) - Product IDs purchased by customers from the selected segment instances in the 7 days after the pinned_event_date .
Purchase Frequency (Last 7 Days) - Average number of orders per customer from the selected segment instances in the 7 days prior to the pinned_event_date .
Purchase Frequency (Next 7 Days) - Average number of orders per customer from the selected segment instances in the 7 days after the pinned_event_date .
Revenue (Last 7 Days) - Total order revenue generated by customers from the selected segment instances in the 7 days prior to the pinned_event_date .
Revenue (Next 7 Days) - Total order revenue generated by customers from the selected segment instances in the 7 days after the pinned_event_date .
Customer Identity - The identity of the customer in the segment. Can be either email or customer_id type. Example values: [email protected] , 5209503793328
Instance Created Date - The timestamp when the segment instance (run/snapshot) was generated. Example value: 2025-08-25 11:08:39
Schedule - The recurring schedule for running the segment. Example values: once_a_day , once_every_other_day
Segment By - The audience type used to group customers in the segment. Example value: customer_id , email
Segment Created Date - The date when the segment was originally created. Example value: 2023-07-20 08:33:08
Segment Instance ID - The unique identifier for a specific segment instance (run/snapshot). Example value: 64b8f144256b30501b2ea1e0_2025_08_25
Segment Name - The human-readable name of the segment, Example values: Fourth of July Sale , At least 3 orders , Jan Non Recent Active
Number of Customers - The total number of unique customers included in the segment instance.
Number of Orders - The total number of orders placed by customers in the segment during the relevant time window.
Total Revenue - The total revenue generated by customers in the segment during the relevant time window.
Event Date - The date of the customer support event. Based on the shop time zone at the moment of the event (or the user time zone, if no sales platform is connected).
Event Day - The day the customer support event occurred. Derived from event_date .
Event Week - The Sunday of the week during which the customer support event occurred. Derived from event_date .
Event Month - The month during which the customer support event occurred. Derived from event_date .
Event Quarter - The first month of the quarter during which the customer support event occurred. Derived from event_date .
Event Year - The year during which the customer support event occurred. Derived from event_date .
Median First Response Time - The median time taken for the first response to a customer support ticket during the period selected.
Median Resolution Time - The median time taken to resolve a customer support ticket during the period selected.
Tickets Closed - The total number of tickets closed during the period selected.
Tickets Created - The total number of new tickets created during the period selected.
Tickets Replied - The total number of tickets with at least one reply during the period selected.
Address Line 1 - The first line of the customer's default address. Example value: 764 Example Dr.
Address Line 2 - The second line of the customer's default address. Example value: Apt. 603
City - The city of the customer's default address. Example value: San Francisco
Coordinates Validated - Indicates whether the customer coordinates were successfully validated. Possible values: true , false
Country - The country of the customer's default address. See list of countries . Example values: United States , Canada , United Kingdom
Country Code - The country code of the customer's default address. See list of countries . Example values: US , CA , GB
Customer Created Date - The time at which the customer record was created. Formatted according to the ISO 8601 international standard . Example value: 2019-05-22 21:01:29
Customer ID - The unique identifier for the customer, assigned by the main sales platform. Example value: 5209503793328
Customer ID Key - Join key for connecting this table to other tables (e.g. Orders or Pixel Orders tables). Contains customer_id for Shopify shops and email_address for non-Shopify shops (e.g., Amazon, BigCommerce, WooCommerce). Example values: 5209503793328 , [email protected]
Customer Tags - Tags associated with the customer, set in the main sales platform. Example values: Active Subscriber , PayPal_user , Login with FB
Display Name - The display name of the customer. Example value: John Doe
Email Address - The primary email address associated with the customer’s account. Example value: [email protected]
Email Marketing Consent Collected From - The source from which the customer's email marketing consent was collected.
Email Marketing Consent Opt-In Level - The level of consent provided by the customer for email marketing. Example values: SINGLE_OPT_IN , UNKNOWN
Email Marketing Consent Status - The current status of the customer's email marketing consent. Example values: NEVER_SUBSCRIBED , NOT_SUBSCRIBED , UNSUBSCRIBED , SUBSCRIBED
Email Marketing Consent Updated Date - The time at which the email marketing consent was updated. Formatted according to the ISO 8601 international standard . Example value: 2019-05-22 21:01:29
First Name - The customer's first name. Example value: John
Last Name - The customer's last name. Example value: Doe
Last Order ID - The ID of the most recent order from the customer, according to the main sales platform. Example value: 4930225799243
Latitude - The latitude associated with the customer's location. Example value: 34.1413713
Locale - The locale setting associated with the customer's account. Example values: en-US , en_GB , de
Longitude - The longitude associated with the customer's location. Example value: -118.8639169
Metafields - Custom key–value pairs attached to each customer record, used to store additional structured or unstructured data beyond standard fields.
Note - Note attached to the customer profile.
Phone - The customer's phone number. Example value: 18005550199
Platform - The platform associated with the customer record. Example values: shopify , klaviyo
Product Subscriber Status - The customer's subscription status for products. Example values: ACTIVE , PAUSED , CANCELLED , NEVER_SUBSCRIBED
SMS Marketing Consent Collected From - The source from which the customer's SMS marketing consent was collected.
SMS Marketing Consent Opt-In Level - The level of consent provided by the customer for SMS marketing. Example values: SINGLE_OPT_IN , CONFIRMED_OPT_IN
SMS Marketing Consent Updated Date - The time at which the sms marketing consent was updated. Formatted according to the ISO 8601 international standard . Example value: 2019-05-22 21:01:29
State - The state or province of the customer's default address. Example values: Oregon , British Colombia , Michigan
State Code - The state or province code of the customer's default address. Example values: OR , BC , MI
Predicted Spend Tier - A predicted tier for how much the customer is likely to spend. Example values: LOW , MEDIUM , HIGH
Customer Status - The current status of the customer in the system. Example values: INVITED , ENABLED , DISABLED , UNSUBSCRIBED , NEVER_SUBSCRIBED , DECLINED
Tax Exempt - Indicates whether the customer is exempt from tax. Possible values: true , false
Valid Email Address - Whether the email address has passed a validation check. Possible values: true , false
Verified Email Address - Whether the email address has been verified by the platform. Possible values: true , false
Zip/Postal Code - The zip or postal code of the customer's defaults address. Example values: 48104 , 18235-2239 , CH25 9BH
Amount Spent - The total amount spent by the customer.
Number of Orders - The total number of orders placed by the customer.
Metafield ID - The unique identifier of the metafield record. Example values: 44187839136031
Metafield Key - The unique key of the metafield within its namespace, indicating what data it holds. Example values: promised_delivery_date , zone , agree_to_terms
Metafield Value - The raw stored value of the metafield. Format depends on the metafield type (e.g., text, date, boolean, JSON). Example values: 2025-11-10 , true , #241194 , 5a
Metafield Namespace - Logical grouping used to organize metafields by source or purpose. Example values: custom , klaviyo , checkoutblocks
Metafield Type - The data type of the metafield value (e.g., text, date, boolean, JSON, reference). Example values: date , boolean , json , single_line_text_field , customer_reference
Metafield Updated Date - When the metafield was last updated, in shop time zone. Example value: 2025-10-21 07:08:01
Metafield Created Date - When the metafield was first created, in shop time zone. Example value: 2025-10-21 07:08:01
Is Campaign Archived - True if the campaign has been archived. Possible values: true , false
Campaign Creation Date - The time the campaign was created. Formatted according to the ISO 8601 international standard . Example value: 2019-04-15 08:26:00
Campaign ID - The unique ID of the email/SMS campaign, assigned by the email/SMS platform. Example value: 01G2MRY5AF2A4QFJMS5EF8X2MW
Campaign Name - The name of the email/SMS campaign. Example values: Fall Colors Launch , Father's Day Sale 50% Off
Campaign Scheduled Date - The time the campaign was scheduled to be sent. Formatted according to the ISO 8601 international standard . Example value: 2019-04-15 08:26:00
Campaign Sent Date - The time the campaign was sent to recipients. Formatted according to the ISO 8601 international standard . Example value: 2019-04-15 08:26:00
Campaign Status - The status of the campaign associated with the email/SMS. Example values: Sent , Cancelled
Campaign Updated Date - The time the campaign was last updated. Formatted according to the ISO 8601 international standard . Example value: 2019-04-15 08:26:00
Channel - The platform used to send email/SMS. Example values: klaviyo , smsbump
Messaging Channel Type - The messaging channel used to deliver the communication. Example values: email , sms , push
Is Flow Action Archived - True if the specific action within an automation flow has been archived. Possible values: true , false
Flow Action ID - The unique ID for a specific action within an automation flow. Assigned by the email/SMS platform. Example value: 51670312
Flow Action Name - The name of the specific action within an automation flow. Example values: SEND_EMAIL , SEND_SMS , AB_TEST , TIME_DELAY , WEBHOOK
Flow Action Status - The status of a specific action within an automation flow. Example values: draft , live , manual
Flow Action Updated Date - The time the flow action was updated. Formatted according to the ISO 8601 international standard . Example value: 2019-04-15 08:26:00
Is Flow Archived - True if the automation flow has been archived. Possible values: true , false
Flow Created Date - The time the automation flow was created. Formatted according to the ISO 8601 international standard . Example value: 2019-04-15 08:26:00
Flow ID - The unique ID for the automation flow. Assigned by the email/SMS platform. Example value: YuNWdc
Flow Name - The name of the automation flow. Example value: Abandoned cart reminder: 1-3 days , Joined Membership
Flow Status - The status of the automation flow. Example values: draft , live , manual
Flow Trigger Is Triple Whale - True if the flow was triggered by a Triple Whale (Sonar) metric or event. Possible values: true , false
Flow Trigger Metric ID - The ID of the metric or event that triggered the flow. Example value: Lm72Qs
Flow Trigger Metric Name - The name of the metric or event that triggered the flow. Example values: Checkout Started , Added to Cart , Abandoned Cart , Fulfilled Order
Flow Trigger Organization - The platform where the flow trigger originated. Example values: Shopify , API , Klaviyo , Triple Whale
Flow Trigger Sonar Enabled - True if Sonar is enabled for this flow trigger. Possible values: true , false
Flow Updated Date - The time the automation flow was last updated. Formatted according to the ISO 8601 international standard . Example value: 2019-04-15 08:26:00
Message Copy - The full text content of the email message body, including dynamic variables and template tags used for personalization, embedded links, images, and call-to-action buttons. Example value: 'Can't view this email? {% web_view %} Shop our latest collection! [https://example.com/new-arrivals] Get 20% off your first order with code WELCOME20. {% unsubscribe %}'
Message ID - The unique ID for the individual message sent as part of a campaign or flow. Assigned by the email/SMS platform. Example value: SDiqmK
Message Name - The name of the individual message sent. Example value: Welcome Series: Email 2
Message Preview Text - The short snippet of text shown alongside the subject line in the recipient’s inbox, offering a preview of the message content. Example value: Get 20% off your first order – limited time only!
Message Subject - The subject line of the email message, as displayed in the recipient's inbox. Example value: New Fall Collection Just Dropped
Message Template HTML URL - The URL of the hosted HTML template for the email message, fully formatted as rendered for recipients. Example value: https://storage.googleapis.com/email-templates/klaviyo/12345/template.html
Report Type - The type of report generated. Example values: flow , campaign
Clicks - The total number of unique clicks on links within the email/SMS.
Conversion Value - The total value of conversions for the email/SMS campaign / flow.
Conversions - The total number of conversions for the email/SMS campaign / flow.
Delivered Messages - The total number of messages successfully delivered to the targeted recipient.
Opens - The total number of unique email opens.
Recipients - The total number of intended recipients for the email/SMS campaign.
Event Hour - The hour of the day the email/SMS action (e.g. sent, opened, received) occurred, according to a 24-hour clock. Based on the shop time zone at the moment of the event (or the user time zone, if no sales platform is connected). Example values: 07 , 16 , 21
Event Date - The date the email/SMS action (e.g. sent, opened, received) occurred. Based on the shop time zone at the moment of the event (or the user time zone, if no sales platform is connected).
Event Day - The day the email/SMS action occurred. Derived from event_date .
Event Week - The Sunday of the week during which the email/SMS action occurred. Derived from event_date .
Event Month - The month during which the email/SMS action occurred. Derived from event_date .
Event Quarter - The first month of the quarter during which the email/SMS action occurred. Derived from event_date .
Event Year - The year during which the email/SMS action occurred. Derived from event_date .
Campaign Status - The status of the campaign associated with the email/SMS. Example value: Sent , Cancelled
Flow Action ID - The unique ID for a specific action within an automation flow. Assigned by the email/SMS platform. Example value: 49497165
Flow ID - The unique ID for the automation flow. Assigned by the email/SMS platform. Example value: 726935
Flow Status - The status of the automation flow. Example values: draft , live
Message ID - The unique ID for the individual message sent as part of a campaign or flow. Assigned by the email/SMS platform. Example value: UKDRM6
Received Messages - The total number of email messages successfully received by the target audience.
Sent Messages - The total number of messages sent. Note: Applicable to Klaviyo SMS, Yotpo Email, and Yotpo SMS; does not include data for Klaviyo email.
Subscribed Recipients - The total number of recipients subscribed to any email/sms list. Not associated with a specific campaign ( campaign_id will be null).
Unsubscribed Recipients - The total number of recipients who unsubscribed from any email/sms list as a result of the campaign.
Event Date - The date the external revenue was generated. Based on the shop time zone at the moment of the event (or the user time zone, if no sales platform is connected). Note: Each uploaded row can represent either a single date of revenue, or a start and end date. For rows containing a date range, Triple Whale will amortize the amount over the time range.
Breakdown - A JSON array containing product-level details for the revenue. Each element in the array is an object with the following properties: sku (string): The SKU (Stock Keeping Unit) for the product. product_id (string): The unique product ID. amount (number): The quantity of the product sold. revenue (number): The revenue amount for this specific product. This value is automatically converted to your shop's selected currency for display.
Channel - The marketing or sales channel through which the revenue was generated. Example values: online , retail , wholesale , in-store
City - The city where the revenue was generated. Example values: New York , Los Angeles , Chicago
Created At - The timestamp when the revenue record was created in Triple Whale (when the CSV was uploaded and processed). Example value: 2025-01-15T10:30:00.000Z
Source Currency - The original currency in which the revenue was recorded, before conversion to the shop's currency. All monetary values are automatically converted to the shop's selected currency for display. Example values: USD , GBP , EUR Note: All revenue metrics are automatically converted to your shop's selected currency for display.
Location - The physical location or store where the revenue was generated. Example values: Downtown Store , Mall Location , Warehouse A
Source Name - Free-text identifier to name the specific revenue source. Example values: Downtown Store , Amazon B2B , Popup Shop )
Source Type - The type of revenue source. Possible values: retail : Retail revenue wholesale : Wholesale revenue pos : Point of Sale revenue offline : Offline revenue
State - The full state name where the revenue was generated. Example values: California , New York , Texas
State Code - The two-letter state code where the revenue was generated. Example values: CA , NY , TX
ZIP Code - The ZIP or postal code where the revenue was generated. Example values: 10001 , 90210 , 60601
Amount Total - The total revenue amount for the record.
Event Hour - The hour of the day on which the purchase event occurred, according to a 24-hour clock. Based on the shop time zone at the moment of the event (or the user time zone, if no sales platform is connected). Example values: 07 , 16 , 21
Event Date - The date the purchase event occurred. Based on the shop time zone at the moment of the event (or the user time zone, if no sales platform is connected).
Item ID - The unique identifier for the product, as reported by GA4. Typically maps to the product or variant SKU. Example values: 57404707913 , sku123
Gross Item Revenue - The total revenue from items only, before any discounts, tax, shipping, or refunds. Gross Item Revenue = Item Price x Item Quantity
Item Revenue - The total revenue from items only, before tax and shipping (but after refunds). Item Revenue = Item Price x Item Quantity - Refunds
Items Added to Cart - The number of items added to a cart. Each unit counts separately.
Items Checked Out - The number of items in the cart when the checkout process was initiated. Each unit counts separately.
Items Purchased - The number of items included in purchase events. Each unit counts separately.
Items Viewed - The number of items that the customer viewed.
Event Hour - The hour of the day on which the GA4 session started, according to a 24-hour clock. Based on the shop time zone at the moment of the event (or the user time zone, if no sales platform is connected). Example values: 07 , 16 , 21
Event Date - The date the GA4 session started. Based on the shop time zone at the moment of the event (or the user time zone, if no sales platform is connected).
First User Primary Channel Group - The Primary Channel Group attributed to the user's first session. Example values: Organic Search , Affiliates , SMS , Cross-network , Paid Other
Session Default Channel Group - The Default Channel Group assigned to the session. Example values: Organic Search , Referral , Direct , Paid Social , Unassigned
Session Source - The raw traffic source that initiated the session, derived from UTM parameters or the referring domain. Example values: facebook , klaviyo-email-flow , awin
Session Source / Medium - A combined representation of the session's traffic source and medium, used by GA4 to assign the session to a channel group. Example values: facebook / cpc , klaviyo-email-flow / email , awin / affiliate
Active Users - The number of distinct users who had at least one engaged session during the selected time range. GA4 defines an engaged session as one that lasted at least 10 seconds, had a conversion event, or had 2 or more screen/page views.
New Users - The number of users who interacted with your site or app for the first time.
Promotion Views - The number of times users viewed on-site or in-app promotions, such as banners or product carousels.
Screen / Page Views - The total number of page views (for web) and screen views (for app) that occurred during sessions in the selected time range.
Sessions - The total number of sessions that started during the selected date range. GA4 defines a session as beginning with a session_start event and ending after 30 minutes of inactivity by default.
Total Revenue - The total revenue (after refunds) from purchases, in-app transactions, subscriptions and ads, during sessions in the selected time range. Total Revenue = Purchases + In-App Purchases + Subscriptions + Ad Revenue - Refunds
Total Users - The number of distinct users who initiated at least one session during the selected time range, including both new and returning users.
Web Browser - The web browser of the session where the order originated. Example values: Chrome , Firefox , Safari
Session City - The city of the session where the order originated. Example values: San Francisco , Tel Aviv , Kyiv
Session Country - The country of the session. See list of countries . Example values: United States , Canada , United Kingdom
Device - The type of device used by the visitor for the session. Example values: mobile , desktop , tablet , wearable
Landing Page - The URL path (without query parameters) of the page the visitor landed after clicking on an ad or link, indicating the first page viewed in a session. Example value: /myshop/collections/green_sweater
Add To Carts - The number of Add To Cart events during sessions in the selected time range.
Purchase Revenue - The total revenue (after refunds) from purchases and subscriptions, during sessions in the selected time range. Purchase Revenue = Purchases + Subscriptions - Refunds
Purchases - The total number of website and app purchases (orders) during sessions in the selected time range.
Add To Cart Percent - The percentage of add-to-carts out of total sessions. Add To Cart Percent = Number of Add To Carts / Number of Sessions
Customer IDs - A list of customer identifiers collected from connected platforms (e.g., Shopify, Meta, Klaviyo) that have been matched as belonging to the same individual and associated with a single global_id . Example value: [5209503793328, 1308703745320]
Customer Emails - All email addresses collected across platforms and touchpoints (e.g., checkout, marketing platforms, forms, aliases, historical emails) that have been matched as belonging to the same individual and associated with a single global_id . Example value: [ [email protected] , [email protected] , [email protected] ]
Global ID - The identifier assigned by Triple Whale to represent a single individual after probabilistically matching related customer IDs, emails, and Pixel triple_ids across platforms and devices. This is the primary identifier used for identity-level analysis. Example value: er74f7ca-34bd-4u70-mn90-2a7slh385e19
Primary Customer Email - A single selected email address associated with the global_id , representing the most preferred or consistent email for that individual. Useful for deduplicated outreach and identity-based grouping. Example value: [email protected]
Triple Pixel IDs - A list of identifiers generated by the Triple Pixel that represent visits, sessions, or devices that have been matched as belonging to the same individual and associated with a single global_id . Example value: [eltlok4y634IRw62AZ, olthkk4y294WNw62PL]
Event Date - The date the keyword triggered an ad. Based on the shop time zone at the moment of the event (or the user time zone, if no sales platform is connected).
Ad Account Name - The name of the advertiser’s account as defined in the ad platform. Example values: Example Shop , example_shop , ES - International
Channel - The platform through which the ad was delivered. Example value: google-ads
Keyword ID - The unique ID assigned to the keyword by the ad platform. Example value: 313990984637674
Keyword Status - The status of the keyword. Example values: ENABLED , PAUSED , REMOVED
Keyword Text - The text of the keyword as entered in the ad platform. Example values: running shoes , cheap flights , best coffee
Match Type - How closely a user’s search query must match the keyword in order to trigger an ad. Example values: EXACT , PHRASE , BROAD
System Serving Status - Indicates whether the keyword is currently eligible to serve ads. Example values: ELIGIBLE , RARELY_SERVED
CPC Bid - The bid amount set for the keyword (cost-per-click). By default shown in the shop's currency.
Effective CPC Bid - The effective CPC bid after platform bid adjustments are applied. By default shown in the shop's currency.
Quality Score - The quality score assigned to the keyword by the ad platform (0 – 10, higher is better).
Search Absolute Top Impression Share - The percentage of impressions your ads received in the absolute top location (the very first ad above organic results). Search Absolute Top Impression Share = Search Absolute Top Impressions / Impressions Note: Accurate only when grouping by keyword.
Search Budget Lost Absolute Top Impression Share - The percentage of absolute top impressions your ads did not receive because the campaign budget was limited. Search Budget Lost Absolute Top Impression Share = Search Budget Lost Absolute Top Impressions / Impressions Note: Accurate only when grouping by keyword.
Search Budget Lost Top Impression Share - The percentage of top impressions your ads did not receive because the campaign budget was limited. Search Budget Lost Top Impression Share = Search Budget Lost Top Impressions / Impressions Note: Accurate only when grouping by keyword.
Search Impression Share - The percentage of impressions your ads received on the Search Network out of the total impressions they were eligible to receive. Search Impression Share = Search Impressions / Impressions Note: Accurate only when grouping by keyword.
Search Rank Lost Impression Share - The percentage of impressions your ads did not receive because Ad Rank was too low. Search Rank Lost Impression Share = Search Rank Lost Impressions / Impressions Note: Accurate only when grouping by keyword.
Search Rank Lost Top Impression Share - The percentage of top impressions your ads did not receive because Ad Rank was too low. Search Rank Lost Top Impression Share = Search Rank Lost Top Impressions / Impressions Note: Accurate only when grouping by keyword.
Search Top Impression Share - The percentage of impressions your ads received in the top location (any position above organic results). Search Top Impression Share = Search Top Impressions / Impressions Note: Accurate only when grouping by keyword.
Event Hour - The hour of the day the order was placed, according to a 24-hour clock. Based on the shop time zone at the moment of the event (or the user time zone, if no sales platform is connected). Example values: 07 , 16 , 21
Amazon Fulfillment Channel - The fulfillment channel of the Amazon order. Example values: FBA , FBM
Amazon Fulfillment Status - The fulfillment status of the Amazon order. Example values: Pending , Unshipped , PartiallyShipped , Shipped , Canceled , Unfulfillable , InvoiceUnconfirmed , PendingAvailability
Amazon Is Business Order - Indicates if the order is a business order on Amazon. Possible values: true , false
Amazon Marketplace Name - The human-readable name of the Amazon marketplace associated with the order (e.g., "United States of America", "United Kingdom").
Amazon Region - The Amazon region for the marketplace associated with the order (e.g., "North America", "Europe", "Far East").
Billing City - The city of the customer's billing address. Example value: San Francisco
Billing Country - The full name of the customer's billing country. See list of countries . Example values: United States , Canada , United Kingdom
Billing Country Code - The country code of the customer's billing address. See list of countries . Example values: US , CA , GB
Billing State - The state or province of the customer's billing address. Example values: Oregon , British Columbia , Michigan
Canceled Date - The time at which the order was canceled. Formatted according to the ISO 8601 international standard . NULL if the order was not canceled. Example value: 2023-06-15T19:26:30.000Z
Order Created Date - The time at which the order record was created. Formatted according to the ISO 8601 international standard . Example value: 2022-06-15T19:26:30.000Z
Order Currency - The original currency of the order, before conversion to the shop's currency. All monetary values are automatically converted to the shop's selected currency for display. Example values: USD , GBP , EUR
Customer Email - The customer's email address. Example value: [email protected]
Customer First Name - The customer's first name. Example value: John
Customer City - The city of the customer's default address. Example value: San Francisco
Customer Country Code - The country code of the customer's default address. See list of countries . Example values: US , CA , GB
Customer Country Name - The full name of the customer's country. See list of countries . Example values: United States , Canada , United Kingdom
Customer State Code - The state or province code of the customer's default address. Example value: CA
Customer ID Key - Join key for connecting this table to the Customers table. Contains customer_id for Shopify shops and customer_email for non-Shopify shops (e.g., Amazon, BigCommerce, WooCommerce). Example values: 5209503793328 , [email protected]
Customer Last Name - The last name of the customer. Example value: Doe
Discount Code - The discount code or promotion name used in the order. Set by the seller in the main sales platform. Example values: WELCOME10 , Replacement for defective item , 807QRWMNK2
Discount Type - The type of discount received by the customer in the order. Example values: fixed_amount , percentage
Fulfillment Status - The fulfillment status of the order. Example values: fulfilled , partial , restocked
Integration Shipping Status - The shipping status of the order, according to the integrated shipping provider. Example values: LabeledCreated , Completed
Is First Order in Subscription - True if the order is the first in a subscription series. Possible values: true , false
Is New Customer - True if this is the customer's first order. Possible values: true , false Learn how Triple Whale classifies new/returning customers .
Is Subscription Order - True if the order is part of a subscription. Possible values: true , false
Metafields - Custom key–value pairs attached to each order record, used to store additional structured or unstructured data beyond standard fields.
Order ID - The unique order ID, assigned by the main sales platform. Example value: 4930225799243
Order Name - The name of the order as assigned by the seller on the main sales platform. Example values: #2188464 , Ex-2163819-9
Sales Platform - The sales platform where the order was processed. Example values: Shopify , BigCommerce , WooCommerce , Amazon
Products - Details about the products associated with the order (at the level of the variant), including name, product ID, variant ID, type, SKU, etc. Returns the latest product information, not necessarily the data at the time the order was placed.
Shipping City - The city of the shipping address. Example value: San Francisco
Shipping Country Code - The country code of the shipping address. See list of countries . Example values: US , CA , GB
Shipping Country Name - The full name of the shipping country. See list of countries . Example values: United States , Canada , United Kingdom
Shipping Date - The most recent shipping-related date (in case of multiple shipments for the same order), selected from fields supported by the connected shipping platform (e.g., shipped, fulfilled, or shipping label created). Example value: 2024-12-25
Shipping Provider - The integrated shipping provider that manages and processes the order's shipment. Example values: shipbob , shipstation
Shipping State - The province or state of the shipping address. Example value: California
Shipping State Code - The province or state code of the shipping address. Example value: CA
Shipping Zip Code - The zip/postal code of the customer's shipping address. Example values: 48104 , 18235-2239 , CH25 9BH
Shop Timezone - The designated timezone of the shop according to the timezone database .
Source - The origin of the order as designated by the seller on the main sales platform. Example values: web , pos , tiktok
Tags - Tags associated with the order, assigned by the seller on the main sales platform. Example values: Upsell , Order Credits , discount_eligible
Transactions - Details about transactions associated with the order, including payment information and status.
Amazon Estimated Fees - The estimated fees to be charged by Amazon for the order, based on products purchased. Note that this amount is an estimate and is not final until Amazon reports on actual fees.
Cost of Goods (COGS) - The cost of goods for orders within the selected time frame (before refunds). Imported from the main sales platform, or edit these in Cost Settings > Cost of Goods.
Custom Expenses - Additional custom expenses associated with individual orders. Import using the Enrich Orders Data API endpoint.
Custom Gross Profit - Custom gross profit for individual orders. Import using the Enrich Orders Data API endpoint.
Custom Gross Sales - Custom gross sales for individual orders. Import using the Enrich Orders Data API endpoint.
Custom Net Revenue - Custom net revenue for individual orders. Import using the Enrich Orders Data API endpoint.
Custom Orders Quantity - The custom-defined quantity of orders to count for the single order_id . Possible values: 0 , 1 Import using the Enrich Orders Data API endpoint.
Custom Total Items - The custom-defined total number of items in the order. Import using the Enrich Orders Data API endpoint.
Product Discount Amount - The total product discount amount applied to the order.
Shipping Discount Amount - The total shipping discount amount applied to the order.
Estimated Shipping Costs - Estimated shipping costs paid by the seller for orders within the select timeframe. Edit these in: Cost Settings > Shipping
Units Sold - The total number of individual product units sold in the order.
Refunds - Total amount returned to customers for refunded sales, refunded taxes, and refunded shipping. Calculated based on the order date. Note that Triple Whale does not track refunds from third-party return management apps (e.g., Loop), so totals may vary from the sales platform. Refunds = Refunded Sales + Refunded Shipping + Refunded Tax
Shipping Price - The total shipping price of the order (paid by the buyer), including shipping taxes and shipping discounts.
Sale Taxes - Total amount customers paid in taxes, before refunds.
Average Order Value - The average order value (before shipping or taxes), as reported by the sales platform. AOV = (Order Revenue - Shipping Price - Taxes) / Number of Orders
Lifetime Value - The average order revenue per customer, for orders placed within the selected timeframe. LTV = Order Revenue / Unique Customers
New Customer Orders - The total number of orders placed by new customers within the selected time frame. Learn how Triple Whale classifies new/returning customers .
New Customers Percent - The percentage of purchases made by new customers. New Customers % = Number of New Customer Orders / Total Orders Learn how Triple Whale classifies new/returning customers .
Non-Zero Orders - The total number of orders with a revenue greater than zero. Non-Zero Orders = Count of Orders where Order Revenue > $0
Returning Customer Orders - Number of orders placed by Returning Customers. Learn how Triple Whale classifies new/returning customers .
Returning Customer Revenue - Amount of revenue derived from Returning Customers. Learn how Triple Whale classifies new/returning customers .
Returning Customers Percent - Percentage of orders placed by Returning Customers. Returning Customers % = Number of Returning Customer Orders / Total Orders Learn how Triple Whale classifies new/returning customers .
True Average Order Value - The average non-zero order value (before shipping or taxes), as reported by the sales platform. True AOV = (Order Revenue - Shipping Price - Taxes) / Number of Orders > $0
Unique Customers - Number of unique customers who placed orders within the selected timeframe.
Metafield ID - The unique identifier of the metafield record. Example value: 44187839136031
Product ID - The unique ID of the product as set within the main sales platform. Example value: 3891505496131
Product Name - The name of the product as set within the main sales platform. Example values: Green Soft Socks 3-Pack , Paring Knife Travel Case , Gift Subscription
Product Vendor - The vendor of the product as set within the main sales platform. Example values: Acme , XYZ Corp , Brandless
Product Type - The product type as set within the main sales platform. Example values: Jackets , Coffee Mugs , Books
Product Tags - Tags associated with the product, set in the main sales platform. Example values: Upsell , Order Credits , discount_eligible
Product SKU - The SKU (Stock Keeping Unit) for the product as set within the main sales platform. Example values: GP-BACK-02 , A02630 , POP200NAVY
Product Variant ID - The unique identifier for a specific variant of a product as set within the main sales platform. Example value: 29275946877001
Is Gift Card - True if the product purchased is a gift card. Possible values: true , false
Product Properties - Custom key–value properties attached to the product line item (e.g., personalization details, bundle metadata, app-specific fields).
Product Property Name - The name or key of the product property.
Product Property Value - The value assigned to the product property.
Product Duties - Import duties or tariffs applied to the product.
Product Duty ID - The unique identifier of the duty applied to the product.
Product Duty Tax Lines - Tax lines charged on the product duty.
Product Duty Tax Line Amount - The tax amount charged on the product duty per tax line.
Product Duty Amount - The monetary amount of duty charged for the product.'
Product Price - The price of a single product (to the buyer), before discounts. By default shown in the shop's currency. Note: Tax will be included in the product price if the seller has configured the sale to require taxes in the main sales platform.
Total Product Discount - The amount discounted from the product price, before taxes. By default shown in the shop's currency.
Net Product Discount - The amount discounted from the product price, after taxes. By default shown in the shop's currency.
Product Units Sold - The total number of individual units sold for the product.
Product Cost - The cost of a single product (to the seller). By default shown in the shop's currency.
Transaction Created Date - The time at which the transaction record was created. Formatted according to the ISO 8601 international standard . Example value: 2024-12-25 11:30:09
Transaction Processed Date - The time at which the transaction was processed. Formatted according to the ISO 8601 international standard . Example value: 2024-12-25 11:30:09
Transaction Payment Gateway - The payment gateway used for the transaction. Example values: shopify_payments , paypal , gift_card
Transaction Currency - The currency in which the transaction was processed. Example values: USD , EUR
Transaction Status - The status of the transaction. Example values: SUCCESS , FAILURE , AWAITING_RESPONSE , PENDING , ERROR
Transaction Amount - The amount of the transaction.
Transaction Fees - The fees associated with the transaction.
Event Hour - The hour of the day the pixel custom conversion event occurred, according to a 24-hour clock. Based on the shop time zone at the moment of the event (or the user time zone, if no sales platform is connected). Example values: 07 , 16 , 21
Event Date - The date the pixel custom conversion event occurred. Based on the shop time zone at the moment of the event (or the user time zone, if no sales platform is connected).
Channel - The platform through which the ad was delivered. Example values: facebook-ads , google-ads , Direct
Pixel Custom Conversion Event Data - The full data payload in raw JSON format, including all event properties defined for the custom conversion event. Learn more about querying pixel custom conversion event data
Event ID - The unique ID assigned by Triple Pixel to the custom conversion event. Example value: 9m4rs48lg2elVB52xU
Event Timestamp - The time the custom conversion event occurred. Formatted according to the ISO 8601 international standard . Example value: 2022-06-15T19:26:30.000Z
Session ID - The unique session ID assigned by Triple Pixel. Example value: cltlok4y634IRw62AZ_1710700966152
Triple Pixel ID - The unique ID assigned by Triple Pixel to track visitors across sessions. Example value: eltlok4y634IRw62AZ
Event Conversion Value - The monetary conversion value assigned to the custom conversion event.
Linear Weight - The weight assigned to the event when using linear attribution models.
Event Hour - The hour of the day the pixel custom event occurred, according to a 24-hour clock. Based on the shop time zone at the moment of the event (or the user time zone, if no sales platform is connected). Example values: 07 , 16 , 21
Event Date - The date the pixel custom event occurred. Based on the shop time zone at the moment of the event (or the user time zone, if no sales platform is connected).
Pixel Custom Event Data - The full data payload in raw JSON format, including all event properties defined for the custom event. Learn more about querying pixel custom event data
Event Name - The name assigned to the custom event. Example values: form_fill , start_quiz , quiz_complete , order_sample , answer_question , request_consultation
Event Timestamp - The time the custom event occurred. Formatted according to the ISO 8601 international standard . Example value: 2022-06-15T19:26:30.000Z
Page View Event ID - The unique ID for the page view event during which the custom event occurred. Assigned by Triple Pixel. Example value: 9m4rs48lg2elVB52xU
Pixel Custom Events - The total number of pixel custom events recorded within the selected timeframe.
Country Filter - Filters results by country.
Include Custom Ad Spend - Includes custom ad spend in the spend column. Possible: true , false
Order Tags Filter - Filters orders by tags. Matches any order containing the specified comma-separated tags.
Sales Platform Filter - Filter results by sales platform. Possible values: shopify , amazon , woocommerce , bigcommerce , walmart , tiktok-shops
Subscription Filter - Filters results by subscription type. Possible values: subscription_first_order : Subscription First Order subscription_recurring_order : Subscription Recurring Order subscription_order : Subscription First Order + Subscription Recurring Order non_subscription_order : Non-Subscription Purchases non_subscription_recurring_order : Subscription First Order + Non-Subscription Purchases
Use Click Date - Uses click date instead of purchase date for event_date . Possible values: true , false
Event Hour - The hour of the day on which the ad was run or the order was placed, according to a 24-hour clock. Based on the shop time zone at the moment of the event (or the user time zone, if no sales platform is connected). Example values: 07 , 16 , 21
Event Date - The date the ad was run or the order was placed. Based on the shop time zone at the moment of the event (or the user time zone, if no sales platform is connected).
Ad Manager URL - Direct link to this ad in the advertising platform (Facebook, Google Ads, etc.) for quick access to campaign management and performance data. Example value: https://adwords.google.com/aw/overview?campaignId=9117023204
Campaign Type - The type of campaign. For Email/SMS data, this maps to report_type . Example values: PERFORMANCE_MAX , SEARCH , flow , campaign
Messaging Channel Type - The messaging channel used to deliver the communication. Populated for email/SMS providers only; NULL for ad platforms. Example values: email , sms , push
Session Country - The country of the session where the order originated. See list of countries . Example values: United States , Canada , United Kingdom
MS Session Country - The marketplace country code of the session. See list of countries . Example values: US , CA , GB
Destination URL - The destination URL where users land after clicking the ad. Currently available for Meta, Google, and Pinterest. Example value: https://www.myshop.com/products/productA
Pixel Add to Carts - The number of unique users who triggered an Add-to-Cart event, as reported by the Pixel.
Address Details Submitted - The number of times users submitted address details during checkout.
Pixel Bounces - The Pixel-reported number of single-page sessions where the visitor left the site after a single page view.
Channel-Reported Onsite Conversion Value - Revenue from channel-reported purchases made on the ad channel shop (e.g. Meta Shop, TikTok Shop).
Channel-Reported Onsite Purchases - Number of channel-reported purchases made on the ad channel shop (e.g. Meta Shop, TikTok Shop).
Channel-Reported Visits - Number of channel-reported visits. Currently available for Criteo only.
Checkouts Started - The number of checkout processes started.
Add Contact Info - The number of times users submitted contact details during checkout.
SMS Messages Delivered - The channel-reported number of messages that successfully reached the recipients' phones.
Pixel Email Signups - The Pixel-reported total number of users who signed up for the mailing list during a session.
Pixel Gross Sales - Pixel-reported gross sales revenue (before shipping, taxes, discounts, or refunds). Gross Sales = Product Price x Units Sold
Pixel New Visitors - The Pixel-reported number of first-time visitors to the site.
One-Day View Conversion Value - The total value of channel-reported purchases made within one day of viewing the ad.
One-Day View Purchases - The total number of channel-reported purchases made within one day of viewing the ad.
Opens - The channel-reported number of times the email/sms was opened by recipients.
Add Payment Info - The number of times users submitted payment details during checkout.
Received Messages - The channel-reported number of email messages successfully received by the target audience.
SMS Messages Sent - The channel-reported number of SMS messages sent in the campaign.
Pixel Session Page Views - The Pixel-reported number of pages viewed during a website session.
Pixel Sessions - The Pixel-reported number of online store sessions. Note that Triple Whale defines and tracks sessions differently from the main sales platform so there may be variance between the two. Learn how Triple Whale defines and tracks sessions.
Shipping Details Submitted - The number of times users submitted shipping details during checkout.
Subscribed to Mailing List - The channel-reported number of recipients subscribed to any mailing list.
Pixel Time on Site - The Pixel-reported time spent by users on the site during a session, measured in seconds.
Pixel Unique Visitors - The Pixel-reported number of unique visitors to the site.
Unsubscribed - The channel-reported number of recipients who unsubscribed from any mailing list.
Website Purchases - The total number of Pixel-reported purchases (orders) during a website session. Excludes recurring subscription purchases.
Pixel Average Page Views Per Session - The average number of pages viewed by users during each session. Pixel Average Page Views Per Session = Session Page Views / Number of Sessions
Pixel Average Session Duration - The average time users spend on your site per session. Pixel Average Session Duration (in seconds) = Time on Site / (Number of Sessions - Number of Bounces)
Pixel Bounce Rate - The percentage of single-page visits (bounces) out of total sessions. Pixel Bounce Rate = Number of Bounces / Number of Sessions
Channel-Reported Conversion Rate - The percentage of visits that convert into orders, as reported by the channel. Channel-Reported Conversion Rate = Number of Channel-Reported Conversions / Number of Visits
Cost Per Visit (CPV) - The cost for each visit driven by ads. Cost Per Visit (CPV) = Ad Spend / Number of Visits
Pixel Email Signup Rate - The percentage of sessions that result in email signups. Pixel Email SUR = Number of Email Signups / Number of Sessions
Pixel Incremental Return on Ad Spend - The additional revenue generated per dollar spent on advertising by comparing conversions between an exposed group (audience that sees the ad) and a holdout group (control group that does not see the ad). Isolates the incremental ROAS of an ad campaign on driving purchases.
Pixel Conversion Rate - The percentage of website sessions that result in purchases, as reported by Pixel. Conversion Rate = Number of Website Purchases / Number of Sessions
Pixel Conversion Value Delta - The difference between Pixel-reported conversion value and channel-reported conversion value. Pixel CV Delta = Pixel Conversion Value - Channel-Reported Conversion Value
Pixel Cost Per Add To Cart - The cost associated with each add-to-cart action as reported by Pixel. Pixel Cost Per ATC = Ad Spend / Number of Add to Carts
Pixel Cost Per Email Signup - The cost associated with each email signup as reported by Pixel. Pixel Cost Per ESU = Ad Spend / Number of Email Signups
Pixel Cost Per New Visitor - The cost to acquire a new visitor as reported by Pixel. Pixel Cost Per New Visitor = Ad Spend / Number of New Visitors
Pixel Cost Per Visitor - The cost to acquire a unique visitor as reported by Pixel. Pixel Cost Per Visitor = Ad Spend / Number of Unique Visitors
Pixel New Customer Conversion Rate - The conversion rate for new customers as reported by Pixel. Pixel NC CR = Number of New Customer Pixel Purchases / Number of New Visitors Learn how Triple Whale classifies new/returning customers .
Pixel New Visitor Percent - The percentage of all visitors that are new as reported by Pixel. Pixel New Visitor % = Number of New Visitors / Number of Unique Visitors
Keyword ID - The unique ID assigned to the keyword by the ad platform, captured by Triple Pixel from the ad URL. Example value: 313990984637674
Keyword Match Type - How closely a user’s search query must match the keyword. Possible values: EXACT , PHRASE , BROAD
Keyword Status - The status of the keyword. Possible values: ENABLED , PAUSED , REMOVED
Keyword System Serving Status - Indicates whether the keyword is currently eligible to serve. Possible values: ELIGIBLE , RARELY_SERVED
Keyword CPC Bid - The bid amount set for the keyword (cost-per-click). By default shown in the shop's currency. Example values: 1500 , 10,000 , 28,000
Keyword Effective CPC Bid - The effective CPC bid after platform bid adjustments are applied. By default shown in the shop's currency. Example values: 1500 , 10,000 , 28,000
Keyword Quality Score - The quality score assigned to the keyword by the ad platform (0 – 10, higher is better).
Pixel Conversion Value (CV) - Pixel-reported conversion value (order revenue) after shipping, taxes, and discounts (before refunds).Order Revenue = Gross Sales + Shipping + Taxes − Discounts Order Revenue = Gross Sales - Discounts + Shipping + Tax
Pixel New Customer Cost Per Acquisition - The cost to acquire a new customer, as reported by Pixel. Note that Triple Whale classifies all customers as either new or returning, while the main sales platform may leave some unclassified, potentially leading to discrepancies. Pixel NCPA = Blended Ad Spend / Number of New Customer Orders
Pixel New Customer Average Order Value - The average order value for new customers as reported by Pixel. Note that Triple Whale classifies all customers as either new or returning, while the main sales platform may leave some unclassified, potentially leading to discrepancies. Pixel NC AOV = New Customer Pixel Conversion Value / Number of New Customer Pixel Purchases
Pixel New Customer Conversion Rate - The conversion rate for new customers as reported by Pixel. Note that Triple Whale classifies all customers as either new or returning, while the main sales platform may leave some unclassified, potentially leading to discrepancies. Pixel NC CR = Number of New Customer Pixel Purchases / Number of New Visitors
Ad Name - The name of the ad. Example values: Kids Ad 1 , Read Our Latest Blog 03/12/2023 , 8 best fall looks
Attribution Window - The time frame for attributing conversions to the ad. By default lifetime . Example values: 1_day , 7_days , 14_days , 28_days , lifetime Note: group by attribution_window is unavailable on the Pixel Orders table.
Cancelled Date - The time at which the order was canceled. Formatted according to the ISO 8601 international standard . NULL if the order was not canceled. \n \nExample value: 2022-06-15T19:26:30.000Z
Channel - The platform through which the ad was delivered. Example values: facebook-ads , tiktok-ads , Direct
Click Date - The date the ad was clicked. Based on the shop time zone at the moment of the click. Example value: 2024-10-26
Click Timestamp - The time at which the ad was clicked. Formatted according to the ISO 8601 international standard . Example value: 2024-10-26 20:03:48
Customer City - The city of the customer's shipping address. Example value: San Francisco
Customer Country - The country code of the customer's default address. See list of countries . Example values: US , CA , GB
Customer State - The state or province of the customer's shipping address. Example value: CA
Attribution Model - The attribution model used. By default Triple Attribution . Possible values: Total Impact , Triple Attribution , Triple Attribution + Views , Clicks & Views , Linear All , Linear Paid , First Click , Last Click Note that Total Impact is not available on the Pixel Orders table.
Sales Platform - The sales platform where the order was processed. Example values: Shopify , Amazon
Session ID - The unique session ID assigned by Triple Pixel. Note: Only sessions with an order are included in the Pixel Orders table. For data on all sessions, use the Sessions table. Example value: cltlok4y634IRw62AZ_1710700966152
Shop Timezone - The designated timezone of the shop according to the tz database .
Tags - Tags associated with the order, assigned by the seller in the main sales platform. Example values: Upsell , Order Credits , discount_eligible
Triple Pixel ID - The unique ID assigned by Triple Pixel to track visitors across sessions. Example value: cltlok4y634IRw62AZ
UTM Medium - The UTM medium parameter captured by Triple Pixel from the ad URL Example values: sponsored , paid , profile_link
UTM Source - The UTM source parameter captured by Triple Pixel from the ad URL. Example values: web , pos , tiktok , facebook , google , newsletter
Cost of Goods (COGS) - The cost of goods for Pixel-reported purchases within the selected time frame (before refunds). Imported from the main sales platform, or edit these in Cost Settings > Cost of Goods. Note that COGS for Pixel data is set at attribution time and does not get updated subsequently, so may vary from COGS in the Orders table.
Shipping Price - The total shipping price of the order, including shipping taxes and shipping discounts.
Pixel Average Order Value - The Pixel-reported average order value. Pixel AOV = Pixel Conversion Value / Number of Pixel Purchases
Pixel New Customer Purchases - The total number of orders placed by new customers within the selected time frame. Learn how Triple Whale classifies new/returning customers .
Pixel New Customer Revenue - The total revenue derived from orders by new customers. Learn how Triple Whale classifies new/returning customers .
Non-Zero Pixel Purchases - The total number of Pixel-reported purchases with a revenue greater than zero. Non-Zero Pixel Purchases = Count of Pixel Purchases where Order Revenue > $0
Pixel True Average Order Value - The average non-zero order value (before shipping or taxes), as reported by the sales platform. True AOV = (Order Revenue - Shipping Price - Taxes) / Number of Orders > $0
Product Variant ID - The unique ID for a specific variant of a product as set within the main sales platform. Example value: 29275946877001
Product Price - The price of a single product (to the buyer).
Product Cost - The cost of a single product (to the seller).
Event Hour - The hour of the day the post-purchase survey was submitted, according to a 24-hour clock. Based on the shop time zone at the moment of the event (or the user time zone, if no sales platform is connected). Example values: 07 , 16 , 21
Event Date - The date the post-purchase survey was submitted. Based on the shop time zone at the moment of the event (or the user time zone, if no sales platform is connected).
Answer - The response provided by the customer to the survey question. Example values: Online search , Social media , From a friend
Customer ID - The unique customer ID. Assigned by the main shop platform. Example value: 5209503793328
Order ID - The unique order ID. Assigned by the main shop platform. Example value: 4930225799243
Survey Question - The specific survey question asked to the customer. Example value: How did you first hear about us?
Question Type - The type of the question asked. Example values: standard , custom
Source - The traffic source or referral channel that directed the customer to the survey. Example values: google-ads , facebook-ads , snapchat-ads See full list of standardized PPS source IDs
Survey Type (Platform) - The post-purchase survey platform used. Example values: KNO , TW-survey , FAIRING
Include Free Products - Includes products considered "free" based on multi-item discounts. Possible values: true , false Defaults to false . Set to true to match order-based totals with the Summary page. Note: Some discounts are spread across multiple items in an order; if the discount fully covers the price of some of the items, those items are counted as “free".
Include Non-Active Products - Includes non-active (e.g. draft or pending) products. Possible values: true , false Defaults to false . Set to true to match order-based totals with the Summary page.
Collection ID - The unique ID of the collection as defined in the sales platform. Example value: 123456789
Collection Name - The name of the collection as defined in the sales platform. Example values: Summer Gift Guide , Long-Sleeve Packs , Christmas Collection
Entity Type - The entity type of the item. Example values: product , variant , product_collection
ID - The unique ID of the item for the current row. The value depends on the granularity level of the query (variant-level granularity → variant_id ; product-level granularity → product_id ; collection-level granularity → collection_id ). Example value: 3891505496131
Inventory Quantity - The current inventory quantity of the product or variant. Example values: 21749 , 57 , 332
Name - The name of the item for the current row. The value depends on the granularity level of the query (variant-level granularity → variant_name ; product-level granularity → product_name ; collection-level granularity → collection_name ). Example values: Paring Knife Travel Case , Forest Green , Christmas Collection
Product ID - The unique ID of the product as defined in the sales platform. Example value: 3891505496131
Product Image URL - The URL of the product image.
Product Name - The name of the product as defined in the sales platform. This value is always product-level (e.g., “T-Shirt”, “Hoodie”) even when querying variant-level granularity, ensuring each variant row also shows the product it belongs to. Example values: Green Soft Socks 3-Pack , Paring Knife Travel Case , Gift Subscription
Product Tags - Tags associated with the product, assigned by the seller in the sales platform. Example values: 3-pack , Sale , discount_eligible
SKU - The SKU (Stock Keeping Unit) for the product or variant as set within the main sales platform. Example values: GP-BACK-02 , A02630 , POP200NAVY
Variant ID - The unique ID of the variant as set within the main sales platform. Example value: 33193425920151
Variant Name - The name of the variant as defined in the main sales platform. Example values: Forest Green , M , iPhone 14 Pro
Vendor - The vendor of the product or variant. Example values: Route , Canon , Corso , MyShop
Added to Cart Events - Number of times the product or variant was added to a cart. Adding multiple units in a single action counts as one event.
Added to Cart Items - Total quantity of the product or variant added to carts. Each unit counts individually, even when multiple units are added in a single action.
Clicks - Total number of ad clicks attributed to the product or variant, based on its share of units sold per ad. Clicks for Product = (Units Sold for Product / Units Sold for Ad) × Clicks for Ad, summed across all relevant ads and campaigns.
Customers - Total number of unique customers who purchased the product or variant.
Fulfillment Costs - Total costs associated with fulfilling orders that include the product or variant. By default shown in the shop's currency. Fulfillment Costs = Cost of Goods + Handling Fees + (Shipping Price + Payment Gateway Costs) / Total Items in Order × Units Sold Cost of Goods, Handling Fees, and Payment Gateway Costs are configured in Cost Settings . Shipping Price is the amount the customer paid at checkout.
Impressions - Total number of ad impressions attributed to the product or variant, based on its share of units sold per ad. Impressions for Product = (Units Sold for Product / Units Sold for Ad) × Impressions for Ad, summed across all relevant ads and campaigns.
New Customer Fulfillment Costs - Total costs associated with fulfilling orders that include the product or variant, for orders placed by new customers. By default shown in the shop's currency. Fulfillment Costs = Cost of Goods + Handling Fees + (Shipping Price + Payment Gateway Costs) / Total Items in Order × Units Sold Cost of Goods, Handling Fees, and Payment Gateway Costs are configured in Cost Settings . Shipping Price is the amount the customer paid at checkout. Learn how Triple Whale classifies new/returning customers .
New Customer Orders - The total number of orders by new customers that contain the product or variant. Learn how Triple Whale classifies new/returning customers .
New Customer Revenue - The total revenue derived from orders by new customers that contain the product or variant. Learn how Triple Whale classifies new/returning customers .
New Customer Units Sold - Total quantity of the product or variant ordered by new customers. Learn how Triple Whale classifies new/returning customers .
New Customer Total Order Value - The total revenue of orders by new customers that contain the product or variant, before shipping, taxes, discounts, or refunds. Learn how Triple Whale classifies new/returning customers .
Ads - Total number of ads contributing to orders containing the product or variant.
Orders - The total number of orders that contain the product or variant.
Repeat Customers - Total number of unique customers who purchased the product or variant more than once.
Returns - The total number of product or variant units returned.
Product Revenue - The total product-specific revenue from orders that contain the product or variant, after product discounts (before shipping, taxes, or refunds). Product Revenue = (Product Price × Quantity) − Product Discounts
Ad Spend - Total ad spend attributed to the product or variant based on its proportional share of units sold in each ad. This does not include custom ad spend or adjustments for returns. Ad Spend for Product = (Units Sold for Product / Units Sold for Ad) × Ad Spend for Ad, summed across all relevant ads and campaigns.
Units Sold - The total number of individual units sold for the product or variant.
Total Order Value - The total revenue of orders that contain the product or variant, after shipping, taxes, and discounts. Total Order Value = Order Revenue (Gross Sales + Shipping + Taxes - Discounts) for each order containing the product or variant. Note: The full order amount is counted for each product in that order, even if the order contains multiple products.
Visits - Total number of sessions attributed to the product or variant, based on its share of units sold per ad. Visits for Product = (Units Sold for Product / Units Sold for Ad) × Sessions for Ad, summed across all relevant ads and campaigns.
Average Purchase Price - The average price per item sold. Average Purchase Price = Order Revenue / Units Sold
Contribution Margin - The total profit contribution after subtracting fulfillment costs and ad spend from total revenue. Contribution Margin = Order Revenue - Fulfillment Costs - Ad Spend
Contribution Margin Per Item - The profit contribution for each item sold. Contribution Margin Per Item = (Order Revenue - Fulfillment Costs - Ad Spend) / Units Sold
Cost Per Acquisition (CPA) - The cost to acquire a single order. CPA = Total Ad Spend / Total Orders
Cost Per Click (CPC) - The average cost for each click on an ad. CPC = Total Ad Spend / Total Clicks
Cost Per Thousand Impressions (CPM) - The cost to reach 1,000 ad impressions. CPM = Total Ad Spend / (Total Impressions / 1,000)
Click-Through Rate (CTR) - The percentage of ad impressions that resulted in clicks. CTR = Total Clicks / Total Impressions
Gross Profit - The total profit excluding fulfillment costs. Gross Profit = Revenue - Fulfillment Costs
New Customer AOV - The average order value for new customers, indicating the average spend per order by new customers. New Customer AOV = New Customer Total Order Value / New Customer Orders Learn how Triple Whale classifies new/returning customers .
New Customer CPA - The cost to acquire a single new paying customer. New Customer CPA = Total Ad Spend / New Customer Orders Learn how Triple Whale classifies new/returning customers .
New Customer Gross Profit - The gross profit generated from new customers. New Customer Gross Profit = New Customer Revenue - New Customer Fulfillment Costs Learn how Triple Whale classifies new/returning customers .
New Customer ROAS - Revenue generated from new customers relative to ad spend. New Customer ROAS = New Customer Revenue / Ad Spend Learn how Triple Whale classifies new/returning customers .
Pixel Conversion Rate - The percentage of visits who made a purchase. Pixel Conversion Rate = Total Orders / Total Visits
Product AOV - The average order value for products, representing the average amount spent per order. Product AOV = Total Order Value / Total Orders
Return Rate - The percentage of purchased items that customers return. Return Rate = Returns / Units Sold
Return on Ad Spend (ROAS) - The total revenue generated relative to ad spend. ROAS = Order Revenue / Ad Spend
Repeat Purchase Rate - The percent of purchases made by returning customers. RPR = Repeat Customers / Total Orders
Collections - Collections the product belongs to, as set within the main sales platform. Example values: Summer Gift Guide , Long-Sleeve Packs , Christmas Collection
Product Images - Images associated with the product, with details such as image position, dimensions, and source URL.
Integration ID - The unique identifier for the integration (store connection) that this product belongs to.
Platform - The platform or marketplace where the product is listed. Example values: shopify , amazon , custom
Product Description - The description of the product as written by the seller. Example values: Classic everyday denim designed for comfort and versatility, featuring premium stretch fabric, durable stitching, and a timeless silhouette suitable for any wardrobe.
Primary Product Image - The URL of the primary product image. Example values: https://cdn.shopify.com/.../product1.jpg , https://m.media-amazon.com/.../image1.jpg
Product Name - The name (or title) of the product as set within the main sales platform. Example values: Green Soft Socks 3-Pack , Paring Knife Travel Case , Gift Subscription
Product Status - The status of the product. Example values: active , draft , archived
Product Tags - Tags associated with the product, assigned by the seller in the main sales platform. Example values: 3-pack , Sale , discount_eligible
Product Variants - Details about the product variants associated with the order.
Vendor - The vendor of the product variant. Example values: Route , Canon , Corso , MyShop
Product Inventory Quantity - The number of items in stock for the product. Example values: 100 , 50 , 0
Image Position - The position of the image in the product gallery. Example values: 1 , 5 , 19 , 43
Image Width - The width of the image in pixels. Example values: 500 , 1080 , 1500 , 2048
Image Height - The height of the image in pixels. Example values: 500 , 1080 , 1500 , 2048
Image Source - The URL of the product image. Example values: https://cdn.shopify.com/.../product1.jpg , https://m.media-amazon.com/.../image1.jpg
Variant ID - The unique ID of the product variant as set within the main sales platform. Example value: 47095335813393
Variant Name - The name (or title) of the product variant as set within the main sales platform. Example values: 36 S , Titanium / Mild , Black Leather
Variant Description - The description of the product variant. Only supported for Amazon products. Example values: High-rise skinny fit in stretch denim, designed to sit at the natural waist for a flattering, sculpted silhouette.
Variant SKU - The SKU (Stock Keeping Unit) for the product variant as set within the main sales platform. Example values: GP-BACK-02 , A02630 , POP200NAVY
Variant Price - The price of a single product variant (to the buyer). Example values: 69.99 , 10 , 1200
Variant Inventory Quantity - The number of items in stock for the product variant. Example values: 100 , 50 , 0
Event Hour - The hour of the day the refund was processed, according to a 24-hour clock. Based on the shop time zone at the moment of the event (or the user time zone, if no sales platform is connected). Example values: 07 , 16 , 21
Event Date - The date the refund was processed. Based on the shop time zone at the moment of the event (or the user time zone, if no sales platform is connected).
Order Date - The date the original order was processed. Example value: 2025-02-12
Order ID - The unique ID for the original order that was issued a refund. Assigned by the shop platform. Example value: 6024492815432
Refund Order Adjustments - List of refund order adjustments applied to the order. There may be multiple adjustments per order.
Updated At - The time at which the refund record was last updated. Formatted according to the ISO 8601 international standard . Example value: 2022-06-15T19:26:30.000Z
Refunded COGS - Refunded cost of goods (COGS) amount for the selected time period. Calculated based on the refund date.
Refunded Shipping - Refunded shipping amount for the selected time period. Calculated based on the refund date.
Refunded Tax - Refunded tax amount for the selected time period. Calculated based on the refund date.
Product SKU - The SKU (Stock Keeping Unit) for the product, as set within the main sales platform. Example values: GP-BACK-02 , A02630 , POP200NAVY
Order Adjustment Type - The order adjustment type. Valid values: shipping_refund : Refunds related to shipping charges. refund_discrepancy : Discrepancies in the refund amount.
Order Adjustment Tax Amount - The taxes that are added to the order adjustment amount, such as applicable shipping taxes added to a shipping refund.
Order Adjustment Amount - The value of the discrepancy between the calculated refund and the actual refund. If the kind property's value is shipping_refund , then amount returns the value of shipping charges refunded to the customer.
Event Date - The date the review was submitted. Based on the shop time zone at the moment of the event (or the user time zone, if no sales platform is connected).
Attributes with Rating - A list of rating attributes within the review. Set in the reviews platform.
Contains Profanity - True if the review contains profanity. Possible values: true , false
Content - The text content of the review. Example values: Fits nicely , Better quality than it looked in the pictures
Review ID - The unique identifier for the review. Example value: 948f450e-5b38-4a2e-ace6-470b7b5535cf
Is Recommended - True if the product is recommended by the reviewer. Possible values: true , false
Marketplace - The marketplace where the review was submitted. Example value: shopify
Order ID - The unique identifier for the order associated with the review. Example value: 4930225799243
Platform - The platform through which the review was submitted. Example values: okendo , yotpo
Product ID - The unique identifier of the reviewed product. Example value: 3891505496131
Product Name - The name of the reviewed product. Example values: Green Soft Socks 3-Pack , Paring Knife Travel Case , Gift Subscription
Review Type - The type of review submitted. Example value: product
Reviewer Attributes - Attributes associated with the reviewer.
Reviewer Country Code - The country code of the reviewer. See list of countries . Example values: US , CA , GB
Reviewer Country Name - The full name of the reviewer's country. See list of countries . Example values: United States , Canada , United Kingdom
Reviewer Display Name - The display name of the reviewer.
Reviewer Email - The email address of the reviewer.
Reviewer Is Verified - True if the reviewer is a verified customer. Possible values: true , false
Reviewer Name - The name of the reviewer.
Reviewer Verified Status - The verification status of the reviewer.
Sentiment - The sentiment analysis result for the review content. Example values: positive , mixed , negative
Status - The status of the review. Example values: approved , published , unpublished
Title - The title of the review. Example values: Almost perfect , Would not recommend , Absolutely beautiful!
Variant ID - The unique identifier of the reviewed product variant. Example value: 29275946877001
Helpful Count - The number of helpful votes the review has received.
Rating - The rating score assigned by the reviewer.
Unhelpful Count - The number of unhelpful votes the review has received.
Minimum Rating Label - The label for the minimum rating value. Example values: Runs small , Disappointing
Mid Label Rating - The label for the midpoint rating value. Example values: True to size , As expected
Title - The title of the rating attribute. Example values: Size Range , Quality
Type - The type of the rating attribute. Example values: range , multi-select , single-select
Value - The rating value for the attribute. Example values: -1 , 0 , 0.5 , 2
Maximum Rating Label - The label for the maximum rating value. Example values: Runs large , Exceeds expectations
Reviewer Title - The title of the reviewer.
Reviewer Type - The type of the reviewer.
Reviewer Value - The value of the reviewer.
Event Date - The date the search query occurred, in Pacific Time Zone (PT).
Account ID - The unique ID of the connected search source, such as a verified domain in Search Console. Example value: sc-domain:myshop.com
Channel - The platform where the search query occurred. Example value: google
Keyword ID - The unique ID for the keyword that surfaced the site's content in search results. Example value: 313990984637674
Search Query - The exact search term entered by the user that surfaced the site’s content in search results. Example values: nike running shoes , best camping gear
Clicks - Number of times users clicked on the site in the search results.
Impressions - Number of times the site appeared in search results for a query.
Position - The average position where the site appeared in search results for the query.
Event Hour - The hour of the day the website session started, according to a 24-hour clock. Based on the shop time zone at the moment of the event (or the user time zone, if no sales platform is connected). Example values: 07 , 16 , 21
Event Date - The date the website session started. Based on the shop time zone at the moment of the event (or the user time zone, if no sales platform is connected).
Ad ID - The unique ID for the ad associated with the session. Assigned by the ad platform, captured by Triple Pixel in the UTM query parameters. Example value: 120210439891110007
Ad Set ID - The unique ID for the ad set associated with the session. Assigned by the ad platform, captured by Triple Pixel in the UTM query parameters. Example value: 120210439890740003
Campaign ID - The unique ID for the marketing campaign associated with the session. Assigned by the ad platform, captured by Triple Pixel in the UTM query parameters. Example values: 23852438666180053 , 531011533 , 20620285829
Channel - The platform through which the ad was delivered. Derived from UTM parameters and standardized (e.g. a UTM value of fb is standardized to facebook-ads in Triple Whale). Example values: facebook-ads , tiktok-ads , Direct
Country Code - The country code of the session. See list of countries . Example values: US , CA , GB
Device Model - The device model used by the visitor for the session. Example values: SM-A022M , CPH2305 , Note 12
Domain - The domain through which the session was initiated. Example value: exampleshop.com
Event Date Timezone - The time zone in which the event_date and event_hour are based. Equivalent to the designated timezone of the shop according to the timezone database .
Is New Visitor - True if the session was initiated by a first-time visitor. Possible Values: true , false
Marketplace Country - The marketplace country code of the marketplace environment for the session, based on shop settings. See list of countries . Example values: US , CA , GB
Marketplace Country Name - The marketplace country name of the marketplace environment for the session, based on shop settings. See list of countries . Example values: United States , Canada , United Kingdom
Session Start Timestamp - The time at which the visitor initiated the session. Formatted according to the ISO 8601 international standard . Example value: 2022-06-15T19:26:30.000Z
URL Query Parameters - The query parameters contained in the URL of the first page viewed in a session (the page the visitor initially landed after clicking on an ad or link). Example values: {"tw_adid":"83906898178855", "tw_campaign":"103306890", "tw_source":"bing"," utm_campaign":"Bing Shopping", "utm_content":"HERO SKU Summer Book Run", "utm_medium":"cpc", "utm_source":"bing", "utm_term":"1342506080190763", "variant":"44042133111001"}
Session Duration - The total duration of time elapsed during the session, measured in seconds.
Session Page Views - Number of pages viewed during a website session.
Event Hour - The hour of the day the shipment was processed, according to a 24-hour clock. Based on the timezone of the shipping platform. Example values: 07 , 16 , 21
Event Date - The date the shipment label was created. Based on the timezone of the shipping platform.
Shipment Created Date - The time when the shipment record was created in the shipping platform. Formatted according to the ISO 8601 international standard . Example value: 2022-06-15T19:26:30.000Z
Estimated Fulfillment Date Status - The status of the shipment's estimated fulfillment date. Example value: FulfilledOnTime
Is Return Shipment - True if the shipment is a return to the sender. Possible values: true , false
Is Voided Shipment - True if the shipment is voided. Possible values: true , false
Shipment Date - The time when the shipment was actually shipped. Formatted according to the ISO 8601 international standard . Example value: 2022-06-15T19:26:30.000Z
Shipment Status - The current status of the shipment. Example values: LabeledCreated , Completed
Shipping Platform - The platform used to manage and process the shipment. Example values: shipbob , shipstation
Destination Ciy - The destination city of the shipment. Example values: MANCHESTER , SAN JOSE , OROVILLE
Destination Country - The destination country code of the shipment. See list of countries . Example values: US , CA , GB
Destination Country Name - The full name of the destination country of the shipment. See list of countries . Example values: United States , Canada , United Kingdom
Destination State - The destination state of the shipment. Example values: WA , FL , ON
Shipment Updated Date - The time when the shipment record was last updated in the shipping platform. Formatted according to the ISO 8601 international standard . Example value: 2022-06-15T19:26:30.000Z
Number of Items - The number of items contained in the shipment.
Shipment Cost To Shop - The cost of the shipment to the seller. By default shown in the shop's currency.
Channel - The channel where the comment was published. Example values: meta-analytics , twitter-social
Comment ID - The ID of the comment. Example value: 530861436559487_731664866264638
Comment Text - The text content of the comment. Example value: Love this design! Do you ship internationally?
Created Date - The time the comment was created. Formatted according to the ISO 8601 international standard. Example value: 2025-07-16 04:32:29
Page ID - The ID of the page. Example value: 123456789012345
The risk level assessment of the comment. Example values: low , medium , high
The sentiment analysis result for the comment. Example values: positive , negative , neutral
The topic or category classification of the comment. Example values: product_inquiry , shipping , complaint
User ID - The ID of the user that made the comment. Example value: 24237031855927250
User Name - The name of the user that made the comment. Example value: Jane Smith
The timestamp of the last visibility status change. Example value: 2025-07-16 04:32:29
Who changed the visibility status of the comment. Example values: user , system
The visibility status of the comment. Example values: visible , hidden , deleted
Event Date - The date the post containing the mention was created. Based on the shop time zone at the moment of the event (or the user time zone, if no sales platform is connected).
Author ID - The ID of the user that made the mention. Example value: 987654321098735
Author Name - The name of the user that made the mention. Example value: John Smith
Author Username - The username of the user that made the mention. Example value: example_username
Channel - The channel where the post containing the mention was published. Example values: meta-analytics , twitter-social
Conversation ID - The ID of the conversation that the mention is in. Example value: 123456789012345
Created Date - The time the post containing the mention was created. Formatted according to the ISO 8601 international standard. Example value: 2025-07-16 04:32:29
In Reply to User ID - The ID of the user that the mention is replying to. Example value: 123456789012345
Is Thread Starter - Indicates whether the post that the mention is in is the first in a thread. Possible values: true , false
Matched Keyword - The keyword that was matched in the mention. Example values: running shoes , cheap flights , best coffee
Mention Text - The text content of the mention. Example value: @example_user thanks for the shoutout!
Mention Type - The type of mention. Example values: keyword , user , hashtag
Mentioned Post ID - The ID of the post that the mention is in. Example value: 123456789012345_987654321098765
Mentioned Post Permalink - The permanent link to the post containing the mention on the social platform. Example value: https://www.facebook.com/123456789/posts/987654321
Reply to Post ID - The ID of the post that the mention is replying to. Example value: 123456789012345
Sentiment - The sentiment of the mention. Example values: positive , negative , neutral
Topic - The topic of the mention. Example value: custom t-shirt
Mentioned User ID - The ID of the user who was mentioned. Example value: 123456789012345
Event Date - The date the event occurred. Based on the shop time zone at the moment of the event (or the user time zone, if no sales platform is connected).
About - A short description of the page, often provided by the business or creator. Example value: Custom apparel designed to stand out
Category - The business category assigned to the page. Example values: Marketing Agency , Business service
Channel - The channel where the page was published. Example values: meta-analytics , twitter-social
Cover URL - The URL of the page's cover image. Example value: https://scontent-example.fbcdn.net/v/t39.30808-6/cover_image.jpg
Image URL - The URL of the page's profile image. Example value: https://scontent-example.fbcdn.net/v/t39.30808-1/profile_image.jpg
Page Name - The name of the social media page. Example values: Acme Apparel , Horizon Handcrafted Soaps
Page Permalink - The permanent link to the page. Example value: https://www.facebook.com/123456789
Website - The website URL associated with the page. Example values: https://example.com/products/sample-product , https://www.example.com/
Fan Adds - The number of new fans (followers) who followed the page during the selected period.
Fan Removes - The number of fans (followers) who unfollowed the page during the selected period.
Impressions - The total number of times any content from or about the page was shown on a user's screen, including posts, ads, stories, mentions, and shares. Includes repeat exposures.
Paid Impressions - The total number of times paid content from the page, such as ads or boosted posts, was shown on a user's screen. Includes repeat exposures.
Unique Impressions - The number of unique users who saw any content from or about the page during the selected period.
Viral Impressions - The number of times content from the page was displayed to users through social interactions, such as shares, mentions, or recommendations.
Video Views - The number of times videos were viewed on the page during the selected period.
Total Views - The total number of times users visited the page itself during the selected period, including repeat visits.
Channel - The channel where the post was published. Example values: meta-analytics , twitter-social
Created Date - The time the post was created. Formatted according to the ISO 8601 international standard. Example value: 2025-07-16 04:32:29
Call-to-Action Type - The type of call-to-action configured for the post. Example values: SHOP_NOW , SIGN_UP , LEARN_MORE
Call-to-Action URL - The URL linked to the call-to-action button on the post. Example value: https://example.com/products/summer-collection
Event - A platform-generated text string providing extra context about the post, such as page updates or location check-ins. Example values: BlueWave Apparel updated their cover photo. , EcoLoom Studio is in Barcelona, Spain.
Is Published - Indicates whether the post is currently published and visible on the page. Possible values: true , false
Post Permalink - The permanent link to the post on the social platform. Example value: https://www.facebook.com/123456789/posts/987654321
Post Text - The text content of the post. Example value: Show your love story on a custom T-shirt!
Publisher ID - The ID of the user, page, group, or event that published the post. Example value: 987654321098735
Publisher Name - The name of the user, page, group, or event that published the post. Example values: BrightThreads , Urban Tee Co.
Post Type - The format of the post, indicating what kind of media or action it includes. Example values: added_photos , added_video
Updated Date - The time the post was last updated. Formatted according to the ISO 8601 international standard. Example value: 2025-07-20 10:14:05
Event Date - The date the subscription event occurred. Based on the shop time zone at the moment of the event (or the user time zone, if no sales platform is connected).
Subscription Platform - The subscription platform through which the subscription is managed. Example values: recharge , stripe
Active Subscribers - The number of subscribers with an active subscription in the specified time range.
Active Subscriptions - The total number of active subscriptions. Each subscription is counted separately, even if multiple belong to the same customer.
Net Revenue - The total order revenue minus discounts from subscription orders.
New Never-Seen Subscribers - The number of new subscribers who have never had a subscription before and started their first subscription in the specified time range.
Reactivated Subscribers - The number of subscribers who had previously cancelled but have started a new subscription again in the specified time range.
Cancelled Subscriptions - The total number of subscriptions that were cancelled in the specified time range.
Churned Subscribers - The total number of customers who have cancelled all subscriptions in the specified time range.
New Subscribers - The total number of new subscribers acquired in the specified time range.
New Subscriptions - The total number of new subscriptions started in the specified time range.
Subscription Order Revenue - Revenue from all subscription orders in the specified time range, after shipping, taxes, and discounts (before refunds).
First Order Revenue - Revenue from first orders in each subscription in the specified time range, after shipping, taxes, and discounts (before refunds).
Recurring Order Revenue - Revenue from recurring (non-first) subscription orders in the specified time range, after shipping, taxes, and discounts (before refunds).
Cancellation Comments - Additional comments given by the customer at the time of cancellation. Example values: No longer interested , Ordered two by mistake , Just taking a break
Cancellation Reason - The reason for cancellation of the subscription, provided by the customer. Example values: Not the right fit , Issue with shipping , Other
Subscription Created Date - The time when the subscription was created. Formatted according to the ISO 8601 international standard . Example value: 2022-06-15T19:26:30.000Z
Customer ID - The unique ID for the customer associated with the subscription. Example value: 6784521634029
Subscription Ended Date - The time when the subscription was canceled or expired. Formatted according to the ISO 8601 international standard . Example value: 2023-07-11T19:21:30.000Z
Subscription First Order Date - The date when the first order within this subscription was placed. Example value: 2023-04-09
Subscription First Order ID - The unique ID for the first order placed within this subscription. Example value: 5246165483756
Product ID - The unique ID for each product within the subscription. Example value: 7809254686953
Subscription Status - The status of the subscription. Example values: active , cancelled , expired
Subscription ID - The unique ID for the subscription. Example value: 352106812
Subscription Interval - The time unit that defines how often the subscription renews. This indicates the frequency of fulfillment cycles for the subscription. Used in combination with the Subscription Interval Count to determine the exact frequency of fulfillment (e.g., a value of week with an interval count of 2 means the subscription renews every two weeks). Example values: day , week , month
Variant ID - The unique ID for each variant within the subscription. Example value: 43151194915045
Product Price - The price of each product in the subscription.
Product Quantity - The number of products included in the subscription.
Subscription Interval Count - The number of intervals between each subscription renewal. Used in combination with the Subscription Interval to determine the exact frequency of fulfillment (e.g., a value of 2 with an interval of week means the subscription renews every two weeks). Example values: 1 , 2 , 4
Add to Carts - The total number of website sessions that include Pixel-reported Add-to-Cart events.
Annual Recurring Revenue (ARR) - The Pixel-reported annual recurring revenue (ARR) from new subscriptions during a website session.
Bounces - The Pixel-reported number of single-page sessions where the visitor left the site after a single page view.
Monthly Recurring Revenue (MRR) - The Pixel-reported monthly recurring revenue (MRR) from new subscriptions during a website session.
New Subscriptions - The Pixel-reported number of new subscriptions during a website session.
New Visitors - The Pixel-reported number of first-time visitors to the site.
Order Revenue - Pixel-reported conversion value (order revenue) after shipping, taxes, and discounts (before refunds). Order Revenue = Gross Sales + Shipping + Taxes − Discounts
Session Page Views - The Pixel-reported number of pages viewed during a website session.
Time on Site - The Pixel-reported time spent by users on the site during a session, measured in seconds.
Unique Visitors - The Pixel-reported number of unique visitors to the site.
Average Page Views Per Session - The average number of pages viewed by users during each session. Average Page Views Per Session = Session Page Views / Number of Sessions
Average Session Duration - The average time users spend on your site per session. Average Session Duration (in seconds) = Time on Site / (Number of Sessions - Number of Bounces)
Bounce Rate - The percentage of single-page visits (bounces) out of total sessions. Bounce Rate = Number of Bounces / Number of Sessions
Conversion Rate - The percentage of website sessions that result in purchases, as reported by Pixel. Conversion Rate = Number of Website Purchases / Number of Sessions
Inclusive start date (YYYY-MM-DD). Substituted for `@startDate` placeholders in the query.
Inclusive end date (YYYY-MM-DD). Substituted for `@endDate` placeholders in the query.
Human-readable error description, often including ClickHouse diagnostics.