Back to plugin list
bitly
Official
Premium

Bitly

This plugin is in preview.

Sync Bitly links stats to a destination of your choice.

Publisher

cloudquery

Repositorygithub.com
Latest version

v1.1.0

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

See installation options

2. Create source and destination configs

Plugin configuration

cloudquery sync bitly.yml postgresql.yml

3. Run the sync

CloudQuery sync

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"]
  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" 
    #optional: get data only for the links on the list 
    only: 
      - bit.ly/1234567
    # optional, includes only links created after the specified date. Supported formats:
    # - "YYYY-MM-DD"
    # - "-<number> <unit>" where number is integer and unit is "day", "week"
    created_after: "-1 day"

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


Subscribe to product updates

Be the first to know about new features.