> ## Documentation Index
> Fetch the complete documentation index at: https://docs.eykdata.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Firmhouse

> Connect your Firmhouse project to Eyk with a Project Access Token, so your subscription orders and customers land in BigQuery.

Connect Firmhouse to Eyk to collect your subscription orders, subscriptions and customers.

To give Eyk access for server-side tracking instead, see [Firmhouse](https://docs.eykdata.com/tracking/firmhouse.md) under Server-side tracking.

## What Eyk builds from this data

Eyk copies your orders, products and customers into your own BigQuery project. BigQuery is the data warehouse Eyk sets up for you. Data from all your stores lands in the same tables, so you can compare stores side by side.

| Table in BigQuery | What it holds |
| - | - |
| `fact_sales_items` | Every order line, with its discounts, refunds, shipping, taxes and costs |
| `dim_product_variants` | Your product catalog, down to each variant |
| `dim_customers` | Each customer once, with their country and marketing consent |
| `fact_attributions` | Your revenue per marketing channel, campaign and ad, for each attribution model |
| `rfm_segmentation_scores` | Each customer's RFM segment, with how recently, how often and how much they buy |
| `rfm_segmentation_segment_descriptives` | Each RFM segment, with its number of customers and their average orders and spend |

In Canvas and Alvin AI, these tables show up as **Sales**, **Product Variants**, **Customers** and **Attributions**. Attribution needs Eyk's first-party tracking on your website. Eyk builds the RFM tables when RFM segmentation is on for your organization.

Connect an ad platform too, to see your return on ad spend and your profit after ad spend next to your sales. To open your BigQuery project, click **Google BigQuery** at the bottom of the Eyk sidebar.

Firmhouse also adds your subscriptions: when they start, pause and stop. Firmhouse does not send a product catalog.

## Before you start

You need:

* Project manager access to your Firmhouse project.
* Access to the **Sources** page in Eyk.

Setup has two parts. First you generate a Project Access Token in Firmhouse. Then you enter it in Eyk.

## Part 1: Generate a token in Firmhouse

**1. Open Integrations**

In your Firmhouse project, go to **Settings** >> **Integrations**.

**2. Generate a token**

Generate a Project Access Token and copy it. You need it in Part 2. The [Firmhouse documentation](https://developer.firmhouse.com/graphql-api/getting-started#authentication) shows where to find it.

## Part 2: Add the source in Eyk

**1. Open the source library**

In Eyk, go to **Sources** and click **Add new source**.

**2. Select Firmhouse**

In the **Data source library**, click **Add** next to **Firmhouse**.

**3. Enter your token**

Paste the token from Part 1 under **Project Access Key**.

![Firmhouse source form in Eyk with the Project Access Key field](https://mintcdn.com/eyk-data/bLMX2sfOr9PtO8G_/images/sources/firmhouse-eyk-form.png?fit=max\&auto=format\&n=bLMX2sfOr9PtO8G_\&q=85\&s=530fb92d15bc86d40adbe7c4687ba355)

**4. Add the source**

Click **Add source**.

## Check it worked

In Eyk, go to **Sources**. Firmhouse is in the list with the text **Your data source is connected.** Eyk updates your BigQuery tables every night.

## Troubleshooting

> [accordion] Firmhouse shows Attention needed
>
> Open the Firmhouse source in Eyk and check the token. If it no longer works, generate a new token in Firmhouse and enter it there.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.