Back to plugin list
Official
Premium
Plausible Analytics
The CloudQuery Plausible plugin extracts information from your Plausible Analytics Stats API and loads it into any supported CloudQuery destination
Publisher
cloudquery
Latest version
v3.2.10
Type
Source
Platforms
Date Published
Price per 1M rows
Starting from $15
monthly free quota
1M rows
Set up process
Overview
The CloudQuery Plausible plugin extracts information from your Plausible Analytics Stats API and loads it into any supported CloudQuery destination (e.g. PostgreSQL, BigQuery, Snowflake, and more).
Authentication
You must have a Plausible Analytics account and an API key. You can find your API key in the Plausible Analytics Settings.
Example Configuration
kind: source
spec:
name: plausible
path: cloudquery/plausible
registry: cloudquery
version: "v3.2.10"
tables: ["*"]
destinations: ["postgresql"]
spec:
site_id: "YOUR_SITE_ID"
api_key: "${API_KEY}"
Configuration Reference
This is the (nested) spec used by this plugin:
site_id
(string
) (required)This is the value of your domain where plausible is deployed. If you're unsure, navigate to your site settings in Plausible and grab the value of the domain field.api_key
(string
) (required)This is your secret API key which you can obtain for your account by going to your user settings page plausible.io/settings.period
(string
) (optional) (default:30d
)Time period to fetch data.filters
(string
) (optional) (default: empty)Filter results, see Plausible Analytics Filters.metrics
([]string
) (optional) (default:["visitors", "pageviews", "bounce_rate", "visit_duration", "visits"]
)Metrics to sync. By default, the plugin will sync all metrics.interval
(string
) (optional) (default:date
)Reporting interval. Valid options aredate
(always) andmonth
(when specified period is longer than one calendar month).base_url
(string
) (optional) (default:https://plausible.io
)Base URL for the Plausible API. If you are using self-hosted version this should be changed to the domain where plausible is hosted.concurrency
(integer
) (optional) (default:10000
)Number of resources to sync in parallel.
Example Queries
Sum all visitors since date
select sum(visitors) from plausible_stats_timeseries where date >= '2021-01-01';
Select all dates where bounce rate was above 50%
select date, bounce_rate from plausible_stats_timeseries where bounce_rate > 50;