Saving reports & looks and downloading data in ChurnIQ Studio – Help Center

How to save the Look in ChurnIQ Studio?

In ChurnIQ Studio all visualizations like charts or tables are known as Looks. If you are happy with the results of your work, you can save you data in the following way:

Go to the Explore section, select the Options button and then hoover on Save-> As a Look

Enter the name of a folder and choose My folder as a place to save the Look. You can also provide some additional information in the Description field.

How to create a dashboard?

Dashboard in ChurnIQ studio is a space that allows for displaying multiple related data points in a clear easy to understand way.

At this point, it is impossible to create a dashboard directly in the main page of ChurnIQ studio however it is possible to create one based on your report while saving the Look.

To do this, you need to select the options button and hoover on Save -> As a new dashboard.

The new window will pop up. Here you have to enter the name of your dashboard in the Title tab and select My Folder as a place where the dashboard will be saved.

Once you’re done with that, your dashboard is ready.

My Folder

My folder is a default folder where you can keep all your Looks. It can be found at the top right corner within the analytics page.

If you share a common workspace, all the users of the account can view and edit reports and Looks as it doesn’t require admin access.

Favorite reports

If you want to select your most popular reports, all you have to do is to enter My Folder and press on a heart icon.

This way a chosen report will appear automatically at the top of the list in the Favorites folder.

Exporting and scheduling

If you want to download your data in the form of a report, all you have to do is choose the Options button and select Download.

In a dropdown menu you can choose the format of the file. The available options include popular formats like: TXT, Excel Spreadsheet, CSV, JSON, HTML, Markdown and PNG.

You can choose if you need only raw data or a visualization. For data, choose “As displayed in the data table”. At this step you also need to select if you want the data values to be formatted and specify the scope of data.

Data pane has a maximum of 5000 rows to view. If you’d like to export all rows, then choose All results.

How to schedule the export?

ChurnIQ Studio empowers you to effortlessly share data from dashboards, data tables, or visualizations generated through Explores and Look queries. These can be seamlessly integrated with your existing tools and workflows. The scheduling capabilities allow for both instant, one-time deliveries and recurring "schedules" for periodic content updates. Deliveries can be directed to various built-in destinations like email, webhooks, Amazon S3 buckets, or SFTP servers.

For creating a schedule, click Options and select Send from the dropdown menu.

Having it selected, the schedule window will pop up. At this step, you can choose from the following delivery options that include: Email, Webhook, Amazon S3, SFTP, Google Drive, Google Sheets and Zapier. Then click on the Send button to export the data.

Important: Remember that each delivery option requires applying different parameters.

Report types - understanding the exported data

Each exported file is represented by a single table. Within this table, every column has two names:

Display Name: This is the name shown in the export when formatting is turned off.
Data Source: This indicates the original data used to populate the column for a specific report.

Measures and dimensions are included as columns in these tables, depending on the report being exported. Measures typically represent numerical values (e.g., sales, profit), while dimensions provide context for analysis (e.g., date, product category).

Note: The specific measures and dimensions present in each export will vary based on the report configuration.

Transaction based

Report column name	Column type	Table.column_name	Type	Description
Campaign Discount Rate	Dimension	campaign.campaign_discount_rate	decimal(35,6)	The percentage of a discount applied by the campaign.
Campaign End Date	Dimension	campaign.campaign_end	date	The date of campaign end that was set during the campaign creation.
Campaign ID	Dimension	campaign.campaign_id	bigint	A unique identifier of the specific campaign, if a coupon was applied to discount the transaction.
Campaign Max Coupons Available	Dimension	campaign.campaign_max_coupons_available	int	Refers to the total number of times that a coupon code can be used across all users.
Campaign Name	Dimension	campaign.campaign_name	varchar(255)	The name of the coupon campaign, if a coupon was applied to discount the transaction.
Campaign Start Date	Dimension	campaign_start	date	Start date of a campaign.
Cancellation Fee	Dimension	transactions.cancellation_fee	decimal(35,6)	Value of the cancellation fee.
Value of the cancellation fee	Dimension	transactions.cancellation_fee_currency	string	Currency in which refund was completed.
Cancellation ID	Dimension	transactions.cancellation_id	varchar(65)	Unique identifier of a refund.
Cancellation Reason	Dimension	transactions.cancellation_reason	varchar(140)	Reason for the subscription cancellation if provided. "Cancellation reason" is provided by the customer at the moment of cancellation. Cancellation reason is a free text field in our APIs, so it's up to the broadcaster how it's configured on the front end (for better data consistency we recommend configuring a dropdown list of predefined values in order to get more consistent insights on the cancellation reasons).
Cancellation Type	Dimension	transactions.cancellation_type	string	Type of the cancellation. Binary variable: refund or chargeback.
Coupon Code	Dimension	transactions.couponcode	varchar(65)	A code used for promotions or support purposes that can be generated and distributed by a broadcaster. A customer can enter this to receive free access or a discount.
Coupon Code ID	Dimension	transactions.couponcodeid	int	Unique identifier of the coupon code.
Coupon Redeemed	Dimension	transactions.coupon_redeemed	int	Identifies if the selected coupon code was redeemed (value 1) or not (null).
Currency Exchange Rate	Dimension	transactions.paymentcurrencytopublishercurrency	int	Exchange rate of the payment from the original currency to the default publisher's currency. In case the currencies are the same in both cases, the rate equals 1.
Customer Account Activation Date	Dimension	customer.accountActivationDate	date	Date of the account creation
Customer Email	Dimension	transactions.customer_email	string	Customer Email
Customer External ID	Dimension	transactions.customer_external_id	varchar(255)	External Customer unique identifier, if populated in the payment process.
Customer First Name	Dimension	customer.firstName	string	Customer's first name, if provided through Cleeng Capture.
Customer ID	Dimension	transactions.customerid	bigint	A unique reference ID for each customer.
Customer Last Login Date	Dimension	customer.lastLoginDate	date	Date of the customer's last login.
Customer Last Name	Dimension	customer.lastName	string	Customer's last name, if provided through Cleeng Capture.
Customer Payment Method Expiry Date	Dimension	customer.payment_method_expiry_date	date	Date on which customer payment method will expire.
Customer Registration Source	Dimension	customer.registeredFrom	string	Indication if the customer was registered with an email or via the API driven solution.
Discount Rate	Dimension	transactions.discount_rate	decimal(35,6)	The rate of a discount applied on your offer price.
Discount Rate Percentage	Dimension	transactions.discount_rate	decimal(35,6)	The percentage of a discount applied on your offer price.
Discount Type	Dimension	transactions.DISCOUNTTYPE	string	Indication if the discount was created by a coupon or was it a free purchase.
Discount Value	Dimension	transactions.discount_value	decimal(35,6)	Value of the discount applied on an offer price.
Distribution Channel	Dimension	transactions.distributionchannel	varchar(20)	Store or method that was used for the last transaction.
External Payment	Dimension	transactions.EXTERNAL_PAYMENT	int	Indicator if payment was external (1) or managed by Cleeng (0).
Gift ID	Dimension	transactions.gift_id	int	A unique gift identifier (ID) that each gift has.
Is Free Trial	Dimension	transactions.IS_FREE_TRIAL	string	Indicator if the subscription is a free trial or not.
Is Refund	Dimension	transactions.row_type	string	Enables to exclude refunds from the list of transactions.
Offer Currency	Dimension	transactions.offercurrency	varchar(3)	The currency in which the offer is set by the broadcaster.
Offer Group ID	Dimension	transactions.offer_group_id	varchar(16)	The identifier of the whole group of offers in case there are multilingual offers dedicated for particular countries.
Offer Group ID Title	Dimension	offer.offer_group_id_title	varchar(255)	The name/title of the whole group of offers in case there are multilingual titles for offers dedicated for particular countries.
Offer ID	Dimension	transactions.offer_id	varchar(16)	Cleeng’s offer identifier of the transaction. The structure is as follows: the first letter defines the type of offer. It is followed by 9 numbers, underscore, and country code, e.g. S123456789_PL.
Offer Iteration Start Ts Date	Dimension	transactions.OFFER_ITERATION_START_TS	date	The date on which subscription started.
Offer Period	Dimension	offer.offer_period	varchar(10)	Subscription renewal period (ex. monthly, 3-months, 6-months).
Offer Price	Dimension	transactions.offerprice	decimal(35,6)	Value of the offer price including tax in offer currency.
Offer Price Excl Tax	Dimension	transactions.offerpriceexcltax	decimal(35,6)	Value of the offer price without tax in offer currency.
Offer Recurrence Type	Dimension	transactions.offerid_prefix	string	Indicates if the offer is recurring (subscription) or any other (VoD, Pass, Event, Rental) - "non-recurring".
Offer Title	Dimension	transactions.offer_title	string	The name/title of an offer.
Offer Type	Dimension	offer.offer_type	string	A parameter of the transaction offer. The Cleeng framework supports multiple offer types. They are all accessible via API and can be integrated within any CMS or platform. - Live PPV (Event offer, Live offer) - Pass (Season Pass) - Subscription offer (deprecated term: subscription plan) - TVOD (Single offer, Rental offer).
Offerid Description	Dimension	offer.offerid_description	string	Full description of an offer (if applied).
Payment Currency	Dimension	transactions.paymentcurrency	varchar(3)	Currency in which the transaction was completed.
Payment External ID	Dimension	transactions.payment _service_order_id	string	External payment ID, if populated in the payment process through the APIs and webhooks.
Payment Gateway	Dimension	transactions.paymentgateway	string	Payment gateway used at the transaction checkout.
Payment Method	Dimension	transactions.payment_method	varchar(30)	The method used by a customer to make a purchase - Mastercard, Visa, AMEX, iDEAL, sms, ivr, direct banking, etc.
Publisher Currency	Dimension	transactions.publisher _currency	varchar(3)	Broadcaster's currency, usually the same as the ‘offer currency’ but not necessarily.
Reversed Transaction ID	Dimension	transactions.reversed_transaction_id	string	A unique identifier (ID) of the transaction which is refunded (reversed). Cancellations always refer to the initial transaction.
Subscription At Coupon Redemption	Dimension	transactions.subscription_at_coupon_redemption	string	Indicator if the subscription at the redemption is new or already an existing one.
Subscription ID	Dimension	transactions.subscription_id	bigint	It is a unique identifier of a subscription (recurring offer purchased by a specific customer) at Cleeng.
Subscription Switch Direction	Subscription Switch Direction	transactions.subscription _switch_direction	string	Upgrade or downgrade (based on your switch settings).
Subscription Switch ID	Dimension	transactions.subscription _switch_id	string	A unique reference ID for each switch.
Subscription Switch ID	Dimension	transactions.subscription _switch_id	string	A unique reference ID for each switch.
Subscription Switch to Offer ID	Dimension	transactions.subscription _switch_from_offer_id	string	ID of the subscription that was changed (switched from).
Subscription Switch Updated Date	Dimension	transactions.SUBSCRIPTION_SWITCH_UPDATED_AT	date	The date when the switch parameters were updated.
Transaction Country	Dimension	transactions.country	string	Country registered at the transaction. It can be something entirely different from customer country,
Transaction Date	Dimension	transactions.date	date	Date and time of the transaction.
Transaction External Data	Dimension	transactions.transaction _external_data	string	Additional information about the transaction delivered by the broadcaster.
Transaction ID	Dimension	transactions.transaction_id	varchar(50)	A unique transaction identifier (ID) that each transaction has.
Coupons Redeemed count	Measure	churniq_studio_transactions.coupons_redeemed_count	int	Count of Coupon redemptions (applicable with Campaign-related columns).
Customer Count	Measure	churniq_studio_transactions.customer_count	int	Distinct Count of CustomerID. Works with all dimensions.
Discount Value	Measure	churniq_studio_transactions.sum_discount_value	int	Sum of Discount Value in Publisher Currency.
Revenue	Measure	churniq_studio_transactions.publisher_revenue_publisher_currency	int	Sum of Publisher revenue in publisher currency.
Subscriber Count	Measure	churniq_studio_transactions.subscriber_count	int	subscriber is a customer with offer type = "Subscription".
Subscriptions Count	Measure	churniq_studio_transactions.subscription_count	int	Distinct count of SubscriptionID (not Subscriber).
Transaction Count	Measure	churniq_studio_transactions.transaction_count	int	Distinct count of TransactionID.
Transaction Price	Measure	churniq_studio_transactions.transaction_price	int	Value of the transaction with tax in the transaction currency.
Transaction Price excl Tax	Transaction Price excl Tax	churniq_studio_transactions.transaction_price_excl_tax	int	Value of the transaction in the broadcaster currency without tax.

Subscriber based

Report column name	Column type	Table.column_name	type	description
Calendar for Active Subscribers - Date	Dimension	calendar_table.dt_date	date	Date for Active Subscribers measure only
Churniq Studio Subscribers - Date	Dimension	churniq_studio_subscribers.date_ts_date	date	Date for all other measures except for Active Subscribers
Cancellation Reason	Dimension	churniq_studio_subscribers.cancellation_reason	string	Reason of cancellation (if collected by the survey)
Churn Reason	Dimension	churniq_studio_subscribers.churnreason	string	Reason of churn (if collected by the survey)
Country	Dimension	country_codes.country	string	Country of a subscriber (collected at registration)
Customer ID	Dimension	churniq_studio_subscribers.customerid	bigint	A unique reference ID for each customer.
Email	Dimension	churniq_studio_subscribers.customer_email	string	Customer Email
Expiration Date	Dimension	churniq_studio_subscribers..expiry _date	date	Date on which the subscription expired or will expire.
First Name	Dimension	churniq_studio_subscribers.firstName	string	Customer's first name, if provided through Cleeng Capture
Gift ID	Dimension	churniq_studio_subscribers.gift_id	int	A unique gift identifier (ID) that each gift has
Last Name	Dimension	churniq_studio_subscribers.lastName	string	Customer's last name, if provided through Cleeng Capture
Offer ID	Dimension	churniq_studio_subscribers.offer_id	string	Cleeng’s offer identifier of the transaction. The structure is as follows: the first letter defines the type of offer. It is followed by 9 numbers, underscore, and country code, e.g. S123456789_PL.
Offer Lifetime In Days	Dimension	churniq_studio_subscribers.offer_lifetime _in_days	int	Lifetime of an offer connected to the subscription, counted as a concatenation of SubscruptionID and OfferID
Offer Payment Type	Dimension	churniq_studio_subscribers.offer_payment _type	string	Indicates if the selected offer is free or paid.
Offer Period	Dimension	churniq_studio_subscribers..offer_period	string	Subscription renewal period (ex. monthly, 3-months, 6-months).
Offer Status	Dimension	churniq_studio_subscribers.offer_status	string	Current status of the offer. More detailed version of Subscription Status.
Offer Title	Dimension	churniq_studio_subscribers.offer_title	string	The name/title of an offer.
Subscriber Payment Type	Dimension	churniq_studio_subscribers.subscriber _payment_type	string	Indicates if Subscriber is on paid or free plan.
Subscriber Payment Type Conversion	Dimension	churniq_studio_subscribers.subscriber _payment_type_conversion	string	Shows if a Subscriber was converted from free to paid or vice versa.
Subscriber Status	Dimension	churniq_studio_subscribers.subscriber_status	varchar(30)	Current status of the subscriber.
Subscription End Date	Dimension	churniq_studio_subscribers.end_date	date	Indicates the real end date of the subscription. If the subscription is active: expiration date, If in grace period: last day of the grace period, If churned: last day when the subscription was active.
Subscription ID	Dimension	churniq_studio_subscribers.subscription_id	bigint	It is a unique identifier of a subscription (recurring offer purchased by a specific customer) at Cleeng.
Subscription Start Date	Dimension	churniq_studio_subscribers.start_dt_date	date	Date on which the subscription begins.
Subscription Status	Dimension	churniq_studio_subscribers.subscription_status	string	Indicates if the subscription is started, churned or continues.
Switch Type	Dimension	churniq_studio_subscribers.switch_type	string	Indicates if a subscription was upgraded or downgraded.
Active Subscribers (with Calendar Date)	Measure	churniq_studio_subscribers.count_distinct _subscribers	int	Total count of all active subscribers. That excluded non-recurring offers like passes.
Cancellations	Measure	churniq_studio_subscribers.count_cancellations	int	Count of cancellations.
Churned Subscribers	Measure	churniq_studio_subscribers.subscribers _churned	int	Count of all subscribers with status “churned”.
Converted Trials	Measure	churniq_studio_subscribers.trials_converted	int	Count of all trials that converted to a paid offer.
Downgraded Subscribers	Measure	churniq_studio_subscribers.subsribers _downgraded	int	Count of all Subscribers who downgraded. To understand how downgrades are indicated, see Subscription Upgrades and Downgrades documentation.
Net subscribers growth	Measure	churniq_studio_subscribers.net_subscribers _growth	int	Sum of new subscribers + winback subscribers - sum of churned subscribers.
New Subscribers	Measure	churniq_studio_subscribers.new_subscribers	int	Count of all subscribers with status “new”.
New Subscribers Including Winbacks	Measure	churniq_studio_subscribers.new_subscribers _including_winbacks	int	Count of all subscribers with status “new” or “winback”
Paid subscriptions due last week	Measure	churniq_studio_subscribers.paid_subscriptions _due_last_week	int	All subscriptions with payment type “paid” that were due last week.
Paid subscriptions due this week	Measure	churniq_studio_subscribers.paid_subscriptions _due_this_week	int	All subscriptions with payment type “paid” that are due in the current week.
Renewed subscriptions last week	Measure	churniq_studio_subscribers.renewed _subscriptions_last_week	int	All subscriptions with payment type “paid” that were renewed last week.
Renewed subscriptions this week	Measure	churniq_studio_subscribers.renewed _subscriptions_this_week	int	All subscriptions with payment type “paid” that were renewed in the current week.
Started Trials	Measure	churniq_studio_subscribers.trials_started	int	All new trials
Upgraded Subscribers	Measure	churniq_studio_subscribers.subscribers _upgraded	int	Count of all Subscribers who upgraded. To understand how an upgrade is indicated, see Subscription Upgrades and Downgrades documentation.
Winback Subscribers	Measure	churniq_studio_subscribers.subscribers _winback	int	Count of all subscribers with status “winback”. To understand how a winback is indicated, see the help center article.