Google BigQuery Integration

Linkly provides seamless integration with Google BigQuery, giving you a live view to query your workspace's click data directly in BigQuery.

Overview

The BigQuery integration enables you to:

  • Live data access - Query your workspace's click data directly in BigQuery with a live view
  • Analyze at scale - Leverage BigQuery's powerful analytics capabilities on your click data
  • Custom reporting - Build custom dashboards and reports using tools like Looker, Data Studio, or Tableau
  • Data consolidation - Join click data with other business metrics in your BigQuery queries
  • Real-time insights - Data is continuously updated as clicks occur

What Data is Available?

You can query comprehensive click data including:

  • Click timestamp
  • Short link URL and destination URL
  • Geographic location (country, city, region)
  • Device information (type, operating system, browser)
  • Referrer information
  • IP address (when enabled)
  • UTM parameters
  • Custom metadata and tags

Pricing

BigQuery integration is included on the Enterprise plan. You only pay for the BigQuery queries you run — no storage costs, since data remains in Linkly's BigQuery environment.

How It Works

  1. 1
    Request Access - Contact us through the chat widget to enable BigQuery integration
  2. 2
    Provide Google Accounts - Share the Google account email addresses that need access to the data
  3. 3
    We Grant Access - Your specified Google accounts are granted access to a live view of your workspace data
  4. 4
    Start Querying - Query your click data directly in BigQuery using SQL

Getting Started

To enable BigQuery integration for your workspace:

  1. 1

    Contact us through the chat widget with:

    • Your workspace name
    • Google account email addresses that require access
  2. 2

    We'll grant access to the specified Google accounts

  3. 3

    Start querying - You'll receive the dataset location and can immediately start running queries on your click data

Security and Compliance

  • Encryption - All data is encrypted in transit and at rest
  • Access control - Only specified Google accounts can access your data
  • GDPR compliance - PII can be excluded or anonymized upon request
  • Audit logs - Full audit trail available through GCP logging

Support

For assistance with the BigQuery integration, contact us through the chat widget or email support@linkly.com

Frequently Asked Questions

How much does the BigQuery integration cost?

BigQuery integration is included on the Enterprise plan. You only pay for the queries you run in BigQuery itself.

How quickly does data appear in BigQuery?

The live view is updated in real-time, with new clicks typically appearing within seconds.

Can I access historical data?

Yes, you'll have access to query all historical click data for your workspace through the BigQuery view.

What information do I need to provide?

Just contact us through the chat widget with your workspace name and the Google account email addresses that need access to the data.

Can I add more Google accounts later?

Yes, simply contact us through the chat widget with the additional Google account addresses you'd like to grant access to.

Does this affect my Linkly dashboard?

No, the BigQuery export runs independently. All data remains available in your Linkly dashboard as usual.

What happens if the export fails?

We have automatic retry logic and monitoring in place. Failed exports are queued and retried. You'll be notified of any persistent issues.

What's the data latency?

Data is streamed in real-time with typical latency under 5 seconds from click to BigQuery availability.

Plan availability

Available on Enterprise only

Compare plans →
FreeStarterProBusinessEnterprise

Get 100 short links and track 500 monthly clicks for free.

Get Started for Free

No credit card required

High volume? Talk to our team