Chargebee takes the pain out of subscription billing by integrating with leading payment gateways around the world to let you automate payment collection, invoicing, email notifications and customer management. The Chargebee/Grow integration allows you insights into your data that help you manage your business smoothly.
NOTE: This data source is only available for accounts on the Basic and Professional plans. If you would like to upgrade your plan, talk to your Grow account manager or visit your account's billing page.
How to Connect
Before you get started you will need your Chargebee site URL and API Key.
- Log in to your Grow account and click Add Metric.
- Select Chargebee from the list of data sources and select Add New Auth. For your Chargebee account, you will need your site URL and your API Key.
- You will have a custom site through Chargebee. In the first field, fill in your website name.
- You can find your API key by going to Settings, then API and Webhooks, and finally API Keys. Click the blue Add API Key button to create a new key.
- When you generate an API Key, you are able to set permissions for access with each API Key. You can read through Chargebee’s help documentation here on the different levels of permission.
- Once you have entered this into Grow, click the blue Submit button
And that's it! You are good to go.
Below is a list of the reports Chargebee offers, along with a short description of the information each one returns.
- Customers: A list of all customers and associated billing information.
- Invoices: Details of specific invoices, customer name, amounts, status, type, dates, etc.
- Orders: Details and status of various shipments and orders, etc. (Order management must be set up on account.)
- Subscriptions: Plan type, billing information, amount, customer information, monthly recurring revenue, etc.
- Transactions: List of transactions, by method, gateway, date, amount, referenced invoice, refunded status, etc.
FAQS + Tips and Tricks
Dates come in as UNIX
For Chargebee data, dates and times come in as unix epoch dates and times. Unix epoch time is a system for describing instants in time. It is shown in the number of seconds that have elapsed since 00:00:00 Coordinated Universal Time (UTC), Thursday, 1 January 1970. If a metric returns points in time in unix time, it will likely show up in milliseconds. You can use SQLite to change it into a readable date and time.
Chargebee is that data about currencies come in as cents.
This means you may need to convert it into another format if you would like to view it in dollars. This is easy using the Calculated Columns transform or SQLite.