Query your Cloud Asset Inventory Using Natural Language - Discover our MCP Server. Learn more ❯

CloudQuery

Report an issue

Back to source list

Official

Bitly source integration documentation

This plugin is in preview.

Sync Bitly links stats to a destination of your choice.

Publisher

cloudquery

Repository

Latest version

v1.2.1

Type

Source

Platforms

Date Published

Download CloudQuery CLI

Documentation Tables Changelog Destinations

Loading plugin documentation

README #

This plugin is now deprecated and will be removed from CloudQuery Hub soon.

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 #

Column name	Type
_cq_sync_time	timestamp
_cq_source_name	string
created_at	timestamp
id	string, primary key
link	string
custom_bitlinks	JSON
launchpad_ids	JSON
campaign_ids	JSON
long_url	string
title	string
archived	boolean
created_by	string
client_id	string
tags	JSON
deeplinks	JSON
references	JSON

With extract_utm set to true, the following columns are also added:

Column name	Type
_cq_sync_time	timestamp
_cq_source_name	string
utm_source	string
utm_medium	string
utm_campaign	string
utm_id	string
utm_term	string
utm_content	string

Bitlinks Clicks #

This table is incremental and adds daily stats.

Column name	Type
_cq_sync_time	timestamp
_cq_source_name	string
link_id	string
date	timestamp
clicks	int64

Bitlinks Click Summary #

Gets a 45 day summary of link clicks.

Column name	Type
_cq_sync_time	timestamp
_cq_source_name	string
link_id	string, primary key
unit_reference	timestamp
total_clicks	int64
units	int16
unit	string

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}.

Column name	Type
_cq_sync_time	timestamp
_cq_source_name	string
link_id	string
timestamp	timestamp
country	string
clicks	int64
unit	string

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}.

Column name	Type
_cq_sync_time	timestamp
_cq_source_name	string
link_id	string
timestamp	timestamp
referrer	string
clicks	int64
unit	string