Welcome to Portal
The connector comes with 75+ hand-picked reports and dashboards organized functionally as Subscription, Churn Analytics, Revenue, and Customer Analytics thus enabling you to easily jumpstart on your analysis.
Zoho Analytics is a self-service BI and data analytics software that lets you analyze your data, create stunning data visualizations, and discover hidden insights in minutes.
It offers the following important capabilities:
Stripe Subscriptions Advanced Analytics integration powered by Zoho Analytics enables you as a business owner to proactively manage and drive your business with deep analytical insights. With Zoho Analytics you can slice and dice your subscription data, derive & analyze key SaaS subscription metrics such as revenue, growth rate, churn rate, cancellation rate, customer growth rate and do much more.
This brings in all the capabilities of Zoho Analytics described above to Stripe Subscriptions users.
Any Stripe Subscriptions user who wishes to analyze their application data can make use of this.
Stripe Subscriptions Advanced Analytics is bundled free for all the paid users of Zoho Analytics. The Zoho Analytics paid plans start at₹1,200 per month. Click to learn more about Zoho Analytics Pricing.
Anyone to whom you privately share your workspace, tables (data), reports and dashboards, created in Zoho Analytics, for collaboration is considered a 'User' in Zoho Analytics. A user is identified by his/her unique email address, with which their Zoho Analytics account was registered.
Suppose you subscribe to the Zoho Analytics Standard plan, you can privately share the data/reports in your account and collaborate with 4 other persons. Now your Zoho Analytics account is said to have 5 users (including yourself).
In Zoho Analytics, a row or record is defined in the same context as in a database (or spreadsheet). In simple terms, a table consists of rows (records) and columns (fields). Each row in a table represents a set of related data and has the same structure. For example, in a table that represents "Invoices", each row would represent a single invoice record. The number of rows calculated for pricing is the sum of all rows/records stored across all your workspace tables in your Zoho Analytics account.
Also refer,
After configuring this connector, you might have to wait some time for the initial fetch to happen. You will receive an email notification once the import is complete. If you access the workspace before the initial fetch, it will not display any data.
The import/sync process of your Stripe Subscriptions data can fail sometimes, due to a variety of reasons. Hence you may receive such mails occasionally. The Zoho Analytics team will look into it immediately and get back to you, after taking the required corrective action.
Case 1: You will receive the Setup Process Failed mail when there is a failure during the initial fetch. In this case, we request you to:
Case 2: You will receive the Synchronization Failed mail if there is any failure during the data synchronization process between Stripe Subscriptions and Zoho Analytics, after the initial setup & import of data. This might be a momentary failure due to any internal issues. This import schedule will get suspended if there are five successive failures.
If you are a Basic plan user, you can synchronize your data once every day.
You can choose to synchronize data at one of the intervals mentioned below.
Yes, you can edit the Stripe Subscriptions connector synchronization setting if you are the administrator of the Stripe Subscriptions Advanced Analytics Database.
To do so,
Yes, you can view the data synced history. Follow the below steps to view the data synced history.
Yes, you can synchronize your Stripe Subscriptions data instantly when needed.
To synchronize your data instantly:
Yes, you can setup the Stripe Subscriptions Advanced Analytics in any of the existing Workspaces or in any of the Advanced Analytics workspace to analyze data together. To do this,
Your Stripe Subscriptions data will be imported into your workspace. Refer to this setup presentation.
At present, we do not provide an option in the user interface. If you require this transfer, please do mail us to support@zohoanalytics.com and we will do this for you.
Once the transfer is done, the new administrator must log in to his Zoho Analytics account and follow the below steps.
Also refer,
You can create reports using the data from the following modules:
Zoho Analytics supports a wide variety of reports.
When you setup/configure the Advanced Analytics for Stripe Connector, 75+ default reports & dashboards are automatically created. These hand-picked reports gives a deep insight on your store in great detail.
Formulas, as the name indicates, are calculations that help you derive key business metrics that can be used in reporting and analysis. Zoho Analytics provides a powerful formula engine to create any type of calculations required, to enable creating the required reports. Refer Adding Formulas in Zoho Analytics to know more.
You can create a custom formula by clicking Add > Formula Column in a Table. Refer to the Adding Formulas in Zoho Analytics help page.
The default formulas added by Zoho Analytics are listed below. You can view these formulas by opening the corresponding table and selecting Add > Edit Formulas from the toolbar. (learn more about the important KPI metrics for Subscription Analytics)
The following are the default formulas in the Subscriptions table
Formula Name |
Formula |
Formula Type |
Description |
Active Subscriptions |
Aggregate |
Countif("Subscriptions"."Is Active Subscription?"='Yes') |
Displays the count of active subscriptions. |
Cancelled Subscriptions |
Aggregate |
countif("Subscriptions"."Is Active Subscription?"='No') |
Displays the count of cancelled subscriptions. |
Churns |
Aggregate |
countif("Subscriptions"."Ended At" < now()) |
Displays the number of people who have unsubscribed. |
Churn Rate |
Aggregate |
("Subscriptions"."Churns"/"Subscriptions"."Active Subscriptions")*100 |
Displays the churn rate percentage of customers who have unsubscribed |
No. Of Subscriptions |
Aggregate |
count("Subscriptions"."Id") |
Displays the number of subscriptions |
All Active Subscriptions |
Aggregate |
Count(if("Subscriptions"."Is Active Subscription?"='Yes',1,null)) |
Displays the count of all subscriptions |
Is Active Subscription? |
Formula Column |
if("Subscription State" = 'Active','Yes','No') |
Displays 'Yes' if the subscription is active and 'No' if the subscription is inactive |
Period Active in Months |
Formula Column |
dateandtimediff(MONTH,"Created Time",ifnull("Ended At",now())) |
Displays the active period of subscription in months |
Subscription State |
Formula Column |
if("Canceled At" is null and "Ended At" is null,'Active','Inactive') |
Displays if the subscription is active or inactive. |
The following are the default formulas in the Invoices table
Formula Name |
Formula |
Formula Type |
Description |
Discount Amount |
Formula Column |
"Total"-"Tax"-"Subtotal" |
Displays the discounted amount |
Paid Invoice Value |
Aggregate |
sumIf("Invoices"."Is Paid?","Invoices"."Subtotal",0) |
Displays the Paid Invoice Value |
MRR |
Aggregate |
sum(Ifnull("Invoices"."Subtotal",0)) - ifnull("Invoices".
"Discounts",0) |
Displays the Monthly Recurring Revenue |
MRR from New
Subscriptions |
Aggregate |
sumIf(month("Subscriptions"."Start Time") = month
("Invoices"."Date") and Year ("Subscriptions". "Start
Time") = year ("Invoices"."Date"), ifnull("Invoices".
"Subtotal",0),0) - ifnull("Invoices"."Discounts",0) |
Displays the Monthly Recurring Revenue for new subscriptions |
MRR from Existing
Subscriptions |
Aggregate |
"Invoices"."MRR"-"Invoices"."MRR from New Subscriptions" |
Displays the Monthly Recurring Revenue for recurring / existing subscriptions. |
ARPU |
Aggregate |
"Invoices"."MRR"/distinctcount("Subscriptions"."Customer Id") |
Displays the Average Revenue per User |
New Subscriptions |
Aggregate |
countif(month("Subscriptions"."Start Time")=month
("Invoices"."Date") and Year("Subscriptions"."Start Time")
=year("Invoices"."Date"),"Invoices"."Id",0) |
Displays the count of new subscriptions every month |
ARPU for new Users |
Aggregate |
sumif(month("Subscriptions"."Start Time") = month("Invoices"."Date")
and Year("Subscriptions"."StartTime")= year ("Invoices"."Date"),
"Invoices"."Subtotal",0) / distinctcount("Subscriptions"."Customer Id") |
Displays the Average Revenue per User |
ARPU Existing Users |
Aggregate |
"Invoices"."ARPU"-"Invoices"."ARPU for new Users" |
Displays the Average Revenue per Existing User |
LTV |
Aggregate |
Sumif("Subscriptions"."Canceled At" is not null,"Invoices"."Subtotal",0) |
Displays the Life Time Value |
Average LTV |
Aggregate |
Avgif("Subscriptions"."Canceled At" is not null,"Invoices"."Subtotal",0) |
Displays the Average Life Time Value |
Unpaid Invoice Count |
Aggregate |
count("Invoices"."Id")-Countif("Invoices"."Is Paid?") |
Displays the count of unpaid invoices |
Unpaid Invoice Value |
Aggregate |
Sumif("Invoices"."Is Paid?",0,"Invoices"."Subtotal") |
Displays the value of unpaid invoices |
Discounts |
Aggregate |
Sumif("Coupons"."Amount Off" is not null,"Coupons".
"Amount Off","Coupons"."Percent Off" * "Invoices"."Subtotal"/100) |
Displays the total discount |
YTD Revenue |
Aggregate |
YTD(sum(Ifnull("Invoices"."Subtotal",0))- ifnull("Invoices"."Discounts",0)
,"Invoices"."Date") |
Displays the Year to Date Revenue |
The following are the default formulas in the Charges table
Formula Name |
Formula |
Formula Type |
Description |
Failed Charges Count |
Aggregate |
Countif("Charges"."Status"='failed') |
Displays the total count of failed charges |
Net Charges |
Aggregate |
Sumif("Charges"."Captured","Charges"."Amount"-"Charges".
"Amount Refunded", 0) |
Displays the net value of charges |
Failed Charges |
Aggregate |
Sumif("Charges"."Status"='failed',"Charges"."Amount") |
Displays the total value of failed charges |
Refund Amount |
Aggregate |
Sumif("Charges"."Refunded","Charges"."Amount Refunded",0) |
Displays the amount to be refunded |
Overall Captured Charge |
Aggregate |
Sumif("Charges"."Captured","Charges"."Amount",0) |
Displays the Overall Captured Charge |
No, you cannot add/modify data in the Stripe Subscriptions data tables. Data from Stripe Subscriptions application will automatically get synced into Zoho Analytics in the different tables (one table for one form). You cannot edit any of this data or add new data records from within Zoho Analytics.
However, you can add new tables and add/import data into that, to create reports combining it with the data from Stripe Subscriptions.
No, you cannot add new columns. But, you can add Formula Columns and Aggregate Formulas (i.e., calculated fields) to these tables to help you create powerful reports. Refer Adding Formulas to know more on this.
Yes, you can add new data tables. Click New > New Table to add a new table in the existing Stripe Subscriptions Workspace.
With this feature, you can import data from other sources or add them manually into your Workspace to analyze and create reports combining this with your Stripe Subscriptions data. You can also import data from other business applications like Google Analytics, Salesforce CRM etc.
Refer:
Yes, you can combine data from your other sources with your Stripe Subscriptions application data for analysis.
To do this, you need to add/import a new data table into the Stripe Subscriptions Workspace as explained in the previous question and then define a look-up to join it with the table from Stripe Subscriptions.
To define a lookup relationship between two tables, it is essential that the tables have at least one column which is common between them. Follow the below steps to look up a column from Stripe Subscriptions along with the data from any other source.
Yes, you can join data from multiple tables to create the reports. Refer to the previous question for detailed help on this.
Query Table allows you to pull data from the tables by writing standard SQL SELECT Queries. You can create reports over this Query Table as you do over a data table. Refer to this help document to know about how to create Query Tables in Zoho Analytics.
You can import and analyze data from all the applications that Zoho Analytics offers integration with. Please refer to our Integrations page to know more.
To import data from the third party business apps,
A lookup relationship will not be created automatically between the Stripe Subscriptions modules and the modules of the application that you are trying to import. You will have to manually link the tables using a look-up relationship.
To manually create a lookup relationship refer this help link.
You can easily share the reports that you create with the other users in your organization. Refer to Sharing and Collaboration help page for more details on this.
Once you privately share a report to your colleagues they will be able to access the reports as you do. Refer here to know how to access the reports.
When a Stripe Subscriptions Administrator configures the Stripe Subscriptions - Zoho Analytics, the tables, and reports will be available only to him/her, by default. The Administrator has to share the workspace with other members of the company. Only then will the default reports be accessible by those members.
To know more, refer to Sharing and Collaboration help page.
The Stripe Subscriptions Administrator who has set up the should share the tables present in ' Stripe Subscriptions Advanced Analytics' workspace with other members of the company. Once this is done, the shared users can create reports based on those tables.
To know more, refer to Sharing and Collaboration help page.
Zoho Analytics offers three user roles - Administrator, Workspace Administrator, and User. Click to know more about the Zoho Analytics Organization Model and User Roles.
This is the expected behavior. Only when the users to whom the reports are being shared is set as a Workspace Administrator, they will be able to edit the reports. If a normal user wants to edit the report, he/she will have to save the report with a new name using the Save As option toolbar. The User can edit this report. To know more about user roles, click here.
You can access the reports that you create by logging into Zoho Analytics.
Yes, you can. Refer the topic Apply filter criteria .
Yes, you can export the report/dashboard in various file formats such as CSV, EXCEL, PDF, HTML, and Image. Click to know more.
In order to print the report/dashboard, you first need to export it. You can export the report in various file formats such as CSV, EXCEL, PDF, HTML and Image. Click to know more.
If you are the Administrator of the Zoho Analytics or a 'Workspace Administrator', you can schedule reports and dashboards to be emailed automatically. Refer to the email schedule section in this help documentation.
You can easily embed the reports & dashboards created in Zoho Analytics in your website, web application or blog. Refer Embedding in Web Pages/Blogs to know more about this.
Yes, Zoho Analytics supports various rebranding options such as Portal rebranding/white labeling and Logo Rebranding .
We offer 24x5 technical support (Monday to Friday). In case if you need our assistance kindly do mail us your questions to support@zohoanalytics.com .
You can also reach out to us on our toll-free numbers -
Yes, certainly. Register for a demo in this page .
Subscribe to receive notifications from this article.