# Guide: Using Profitwell with Databox

## How to connect ProfitWell to Databox

![](/assets/guide-using-profitwell-with-databox_1.1fe8af73a8b0a67537b64a36f89740f0a3c8e972fcba45c0991f33716a7d82f4.4783b0ec.gif)

To connect a ProfitWell Account in Databox, go to **Data Sources > + New connection.** Type **ProfitWell** in the search bar and click on the green **Connect** button.

This will open the **Authorization** window, which is where you will be prompted to enter a name for the ProfitWell connection and the API Token for your ProfitWell Account. The API Token can be found in ProfitWell by navigating to **Account Settings > Integration > ProfitWell API > Connect to the ProfitWell API**.

## How much historical data is synced when you first connect ProfitWell to Databox?

When you connect a new ProfitWell Data Source in Databox, 2 months worth of historical data is initially synced.

Certain Metrics may have more or less historical data available. For more information about the amount of historical data available for a specific Metric, please contact our Support Team at [help@databox.com](mailto:help@databox.com).

ProfitWell integrates with apps like Stripe, Chargebee, etc. The amount of historical data available from these integrations is limited by the service.

Once your ProfitWell Data Source is connected and actively syncing data, we store the data that's collected in our own database. This allows us to accumulate more data over time as more data syncs are made so that you can report on more historical ProfitWell data in your Databox reports. Learn more [here](/data-sync-storage-security-in-databox).

## What time zone does ProfitWell data sync in?

ProfitWell data is synced in the time zone set in the ProfitWell Account. For example, if your ProfitWell Account time zone is set as EST, your ProfitWell data will sync with Databox in EST.

## Which ProfitWell integrations are supported in Databox?

Data from these integrations are accessible from ProfitWell's API:

- Stripe
- Braintree
- Chargebee
- Zuora
- Recurly


The amount of historical data available from these integrations is limited by the service.

## How to access pre-built ProfitWell Templates

![](/assets/guide-using-profitwell-with-databox_2.c22e60fd07b46a3061352dda45e9ad94f46f1f787f6f56a8433e678218bbc0f9.4783b0ec.gif)

1. Navigate to **Databoards > Public Templates**
2. In the **Data Source** drop-down list, select **ProfitWell**
3. To view a preview of the Template populated with dummy data, click **Preview**
4. To pull the Template into your Account and re-populate it with your own ProfitWell data, click **Use Template**
5. Select the appropriate **ProfitWell** Data Source from the drop-down list to complete the process. The Databoard will be re-populated with data from the selected ProfitWell Account and can be found on the  **Databoards** page


Once the Databoard is available on the **Databoards** page, it is completely disconnected from the public Template. Therefore, you can further customize this Databoard to meet your specific needs using the [Designer](/overview-designer).

## How to build a ProfitWell Databoard

![](/assets/guide-using-profitwell-with-databox_3.202abd51ce8bf6e866465e2a98d6a7e8c4884d5becbb60d3e0de8fdf3af604e1.4783b0ec.gif)

1. Navigate to  **Databoards** > **+ New Databoard** > **Start Blank**
2. Click on the **Metric**  **Library** icon on the left-hand side of the Designer
3. Select **ProfitWell** from the **Data Source** drop-down list in the Metric Library
4. View the list of pre-built ProfitWell Datablocks. Drag and drop your selected Datablock onto your Databoard
5. If a pre-built Datablock isn't available for your use case, click on the  **Visualization types** icon under the **Metric Library**icon
6. View the list of Visualizations available in Databox. Drag and drop your selected Visualization onto your Databoard
7. Click on the Datablock on the Databoard to open the corresponding **Datablock Editor** on the right-hand side of the Designer
8. Select the appropriate ProfitWell Data Source and Metric in the right-hand Datablock Editor. This will update the Datablock, and will populate the Datablock with the appropriate data
9. Complete steps 4-8 until your Databoard is complete


View a full list of ProfitWell Metrics available in Databox [here](https://app.databox.com/data-manager/metrics/ProfitWell).

## Granularity Restrictions

- We can only pull in keywords that rank in the Top 500. Keywords that are not ranked in this range won't be displayed in Databox.
- Due to API limitations, weekly granularity is not supported. This may affect visualization options for Charts in Databox.


## API Limitations

- ProfitWell's API only returns daily and monthly granularities (for certain metrics only daily or monthly).
- The summed up daily values returned from the API might not match with the monthly value. For example, if you select the Month to date interval, you might see a discrepancy between the summed daily values on Bar/Line Charts and the total number for the interval.
- Due to API limitations, when you choose a Metric and select a Date Range like "This Month" the value will be plotted on the graph for the entire month. This means that if you look at the Metric on the 9th of February and the value is 30, it will display 30 for all remaining days in the month (February 9-28). This will result in a straight line on your chart until the end of the month. Each day, as new data is synced, the chart will be updated with the daily value.