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
- Unlimited Plan - BigQuery integration is included for free
- Other Plans - Available as an add-on for $100/month
Note: You only pay for BigQuery queries you run. No storage costs since data remains in Linkly's BigQuery environment.
How It Works
- Request Access - Contact us through the chat widget to enable BigQuery integration
- Provide Google Accounts - Share the Google account email addresses that need access to the data
- We Grant Access - Your specified Google accounts are granted access to a live view of your workspace data
- Start Querying - Query your click data directly in BigQuery using SQL
Getting Started
To enable BigQuery integration for your workspace:
-
Contact us through the chat widget with:
- Your workspace name
- Google account email addresses that require access
- Whether you're on an Unlimited plan or need the $100/month add-on
-
We'll grant access to the specified Google accounts
-
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 [email protected]
Related Resources
Frequently Asked Questions
How much does the BigQuery integration cost?
It's free for Unlimited plan customers. For other plans, it's available as a $100/month add-on. You only pay for queries you run in BigQuery.
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.