Add analytical axes
Create analytical axes to enrich your data and refine your analyses. Learn to easily add new axes from your Fincome interface or import file.
The analytical axes allow you to segment your data according to custom dimensions: customer size, industry, acquisition channel, geography, etc. They can be created on each Fincome object: invoice, invoice line, customer, product or plan.
Two management modes are possible:
Manual addition from Fincome or your Excel files: ideal for occasional or low-volume axes, which you can update over time.
Automated addition : the axes can also be automatically pulled from the metadata of your integrated billing tools (e.g.: Chargebee, Stripe, Sellsy...) or via Fincome API if your internal systems already send this information.
💡 Note: invoice lines are the smallest common denominator for the most detailed analyses.
Before creating your axes, we recommend consulting the article Determining relevant axes to choose the dimensions most useful for your business.
1- Automatic pulls
a. Via the metadata of your integrated billing tools
If you have connected a billing tool to Fincome (e.g.: Chargebee, Stripe, Sellsy, Pennylane…), the custom fields already present in those systems (called custom fields or metadata) can be automatically imported as analytical axes.
Concretely:
Fincome detects customer, product or subscription metadata during synchronization.
These fields become available as analytical axes in your analyses (filtering, breakdown, reporting...).
💡 Example: if your Stripe subscriptions contain a “Region” field, Fincome retrieves it automatically and you can then filter your MRR by region in your dashboards.
b. Via the Fincome API
TheFincome API can be used in two ways depending on your data configuration:
To upload your complete billing data (invoices, subscriptions, customers) when you do not use a native connector,
Or simply to enrich your existing data with additional fields (metadata, business attributes, tags, etc.), even if your invoices are already synchronized via a connected tool.
In both cases, the attributes you add (for example a “acquisition channel” or “customer type” field) are automatically integrated as analytical axes in Fincome.
🔗 See the article on enriching data via API
2- To add manually
a. From the Fincome interface
Go to the Data.
Select the type of data concerned (customer, invoice, product, etc.).
Click on Add a column.
Name your axis (e.g.: Customer size, Industry, Geography…).
Enter the values:
line by line,
or by selecting multiple lines using the checkboxes on the left (you can filter before selecting).
💡 Axes created here are immediately usable in your Analytics reports and charts.
b. Via Excel import
From the Data tab
You can also import data enrichment files. For this:
Go to the "Data"
Select the type of data for the axis you want to create
Click the button "Enrich your data" and download the template
Once the excel file is downloaded, you will find the list of the chosen object (for example the list of all customers). To add axes:
Add as many columns ascustom axis as you want (one column = one axis)
Fill the axis columns with the desired values for each row
Once the file is finalized, save it, then reimport it on the same page used to download it.
From your initial data import (in the case where you integrate your billing data via excel file)
You can also add a column in your data import file. This column will automatically be considered as an analytical axis linked to the Customer object.
Add the values for each of the rows. When you import your data, the added columns will be automatically uploaded as customer analytical axes.
Best practices
Choose consistent values and stable (e.g.: “SME”, “Enterprise account” rather than variable labels).
Avoid duplicates or different spellings for the same value.
Update your axes regularly when your segmentation evolves.
And after?
Once your axes are created, you can use them in your analyses to filter, break down and compare your metrics. ➡️ See the article Using analytical axes in your analyses to learn how to put them into practice.
Last updated