Documentation Index
Fetch the complete documentation index at: https://documentation.outpost.pub/llms.txt
Use this file to discover all available pages before exploring further.
Invite only — The BigQuery integration is available by invitation only. Contact Outpost to request access.
What gets exported
Outpost populates three BigQuery tables:| Table | Description |
|---|---|
| Ghost Members | Member records with subscription status, tier, labels, and signup date |
| Stripe Customers | Payment history, subscription status, LTV, and billing data |
| Plausible Analytics | Page view data from your Plausible integration (if connected) |
Setup
Create a Google Cloud project
If you don’t have one, create a project in Google Cloud Console.
Create a BigQuery dataset
In BigQuery, create a dataset to receive Outpost data. Note the dataset ID.
Create a service account
Create a service account in Google Cloud with BigQuery Data Editor and BigQuery Job User roles. Download the credentials file (JSON format).
Connect in Outpost
Go to Settings → Integrations → BigQuery and upload the credentials file. Enter your project ID and dataset ID.
Export schedule
After the initial full export, Outpost runs automatic incremental exports on a configurable schedule (default: daily). Only records that have changed since the last export are included.Use cases
- Custom dashboards in Looker, Data Studio, or Tableau
- Cohort analysis across multiple months
- Revenue forecasting with subscription data
- Joining Outpost member data with ad server or analytics data
- Cross-publication reporting for multi-property publishers