Back to source 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.9.1
Type
Source
Platforms
Date Published
Price per 1M rows
Starting from $15
monthly free quota
1M rows
Set up process #
brew install cloudquery/tap/cloudquery
1. Download CLI and login
2. Create source and destination configs
Plugin configurationOverview #
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.9.1"
tables: ["*"]
destinations: ["postgresql"]
# Learn more about the configuration options at https://cql.ink/plausible_source
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
)A best effort maximum number of Go routines to use. Lower this number to reduce memory usage.scheduler
(string
) (optional) (default:dfs
) The scheduler to use when determining the priority of resources to sync. Supported values aredfs
(depth-first search),round-robin
,shuffle
andshuffle-queue
.For more information about this, see performance tuning.
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;