Come and Meet CloudQuery at RSA Conference 2025 in San Francisco Learn more ❯

CloudQuery

Back to source list
bitly
Official

Bitly

This plugin is in preview.

Sync Bitly links stats to a destination of your choice.

Publisher

cloudquery

Repository

github.com

Latest version

v1.1.9

Type

Source

Platforms

Date Published

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 #

Column nameType
_cq_sync_timetimestamp
_cq_source_namestring
created_attimestamp
idstring, primary key
linkstring
custom_bitlinksJSON
launchpad_idsJSON
campaign_idsJSON
long_urlstring
titlestring
archivedboolean
created_bystring
client_idstring
tagsJSON
deeplinksJSON
referencesJSON
With extract_utm set to true, the following columns are also added:
Column nameType
_cq_sync_timetimestamp
_cq_source_namestring
utm_sourcestring
utm_mediumstring
utm_campaignstring
utm_idstring
utm_termstring
utm_contentstring
This table is incremental and adds daily stats.
Column nameType
_cq_sync_timetimestamp
_cq_source_namestring
link_idstring
datetimestamp
clicksint64
Gets a 45 day summary of link clicks.
Column nameType
_cq_sync_timetimestamp
_cq_source_namestring
link_idstring, primary key
unit_referencetimestamp
total_clicksint64
unitsint16
unitstring
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}.
Column nameType
_cq_sync_timetimestamp
_cq_source_namestring
link_idstring
timestamptimestamp
countrystring
clicksint64
unitstring
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}.
Column nameType
_cq_sync_timetimestamp
_cq_source_namestring
link_idstring
timestamptimestamp
referrerstring
clicksint64
unitstring



© 2025 CloudQuery, Inc. All rights reserved.