Back to source list
Official
Bitly
This plugin is in preview.
Sync Bitly links stats to a destination of your choice.
README #
Bitly Source Plugin for CloudQuery
Bitly plugin for CloudQuery to get links and their stats.
Spec #
kind: source
spec:
name: "bitly"
registry: "docker"
path: "docker.cloudquery.io/cloudquery/source-bitly:v1.0.0"
tables: ['*']
destinations: ["sqlite"]
# Learn more about the configuration options at https://cql.ink/bitly_source
spec:
group_id: ${BITLY_GROUP_ID} # mandatory
api_token: ${BITLY_API_TOKEN} # mandatory
extract_utm: true # optional. If set, extracts utm_tags from the long_url into separate columns
# optional. unit to use to query last 1 {unit} of clicks by a country. Default: month. Values: hour, day, week, month.
#countries_summary_unit: "month"
# optional. unit to use to query last 1 {unit} of clicks by a referrer. Default: month. Values: hour, day, week, month.
#referrers_summary_unit: "month"
Tables #
Bitlinks #
With
extract_utm
set to true
, the following columns are also added:Bitlinks Clicks #
This table is incremental and adds daily stats.
Bitlinks Click Summary #
Gets a 45 day summary of link clicks.
Bitlinks Clicks Countries #
This table is incremental and adds stats based on the configured value of
countries_summary_unit
.Each sync adds rows (if not present already) for the last 1 {
countries_summary_unit
}.Bitlinks Clicks Referrers #
This table is incremental and adds stats based on the configured value of
referrers_summary_unit
.Each sync adds rows (if not present already) for the last 1 {
referrers_summary_unit
}.