Visisto
Integration

Visisto → BigQuery integration

Stream contacts and events into BigQuery for warehouse-first analytics.
Native integration
Coming soon
Request this integrationBrowse integrations
What you can do

BigQuery capabilities

Everything Visisto sends to BigQuery.
Sync contacts

Push captured contacts to BigQuery automatically after every widget submission.

Send events

Log capture and reward events in BigQuery with timestamps and campaign metadata.

Field mapping

Map form fields to your destination schema so data arrives clean and usable.

Payload

Example delivery

A preview of the data Visisto sends to BigQuery with every event.

Contact payload

8 fields
{
"email": "jane@acme.com",
"phone": "+44 7700 900123",
"first_name": "Jane",
"last_name": "Doe",
"source_url": "https://acme.com/pricing",
"campaign_id": "summer-sale-24",
"widget_type": "spin-wheel",
"captured_at": "2025-06-15T10:32:00Z"
}

Event payload

7 fields
{
"event_type": "capture",
"email": "jane@acme.com",
"timestamp": "2025-06-15T10:32:00Z",
"source_url": "https://acme.com/pricing",
"campaign_id": "summer-sale-24",
"widget_type": "spin-wheel",
"metadata.variant": "A"
}
Setup

Connect BigQuery in 8 minutes

1
Connect BigQuery

Click Connect in the Visisto dashboard and authorise your BigQuery account.

2
Choose data and map fields

Select what to send and match fields to BigQuery. Preview the data before saving.

3
Go live

Publish your integration. Contacts and events start flowing immediately.

Mapping

Field mapping and transforms

Match Visisto form fields to BigQuery properties. Transform data on the fly with simple rules.
emailBigQuery email field
first_nameBigQuery contact name
phoneBigQuery phone property
custom_fieldmapped automatically
Trust

Reliable and secure by default

Every delivery is retried, signed, encrypted and logged so your data arrives safely and reliably.
Automatic retries

Failed deliveries retry with exponential backoff so you never lose contacts.

Signed webhooks

Every request is signed so your endpoint can verify the sender.

One-click replay

Replay any delivery from the dashboard when a tool is back online.

Encrypted in transit

All data is encrypted using TLS. No plain-text payloads.

Delivery logs

See every delivery with status, timestamp, and full payload preview.

No payment data stored

Visisto never stores credit card numbers or payment details.

99.9% uptime target

Designed for reliability with monitoring and alerts built in.

GDPR-friendly

Data controls, export, and deletion to support your compliance needs.

Transforms

Clean data on the fly

Visisto transforms your data before it reaches BigQuery. No code required.

Rename fields

Rename any field to match BigQuery property names.

rename
Input
"full_name": "Jane Doe"
Output
"contact_name": "Jane Doe"

Copy fields

Duplicate a value to a second field without removing the original.

copy
Input
"email": "jane@acme.com"
Output
"email": "jane@acme.com"
"backup_email": "jane@acme.com"

Set a value

Inject a fixed value into every payload automatically.

set
Input
"email": "jane@acme.com"
Output
"email": "jane@acme.com"
"source": "visisto"

Delete fields

Strip sensitive or unwanted fields before delivery.

delete
Input
"email": "jane@acme.com"
"internal_id": "x-9f3"
Output
"email": "jane@acme.com"

Format values

Normalise casing, trim whitespace, or slugify text.

format
Input
"email": " JANE@ACME.COM "
Output
"email": "jane@acme.com"

Split fields

Break a single value into multiple destination fields.

split
Input
"name": "Jane Doe"
Output
"first_name": "Jane"
"last_name": "Doe"

Coalesce values

Pick the first non-empty value from multiple sources.

coalesce
Input
"phone": ""
"mobile": "+44 7700"
Output
"best_phone": "+44 7700"

Derive name from email

Extract first and last name from an email address automatically.

derive_name_from_email
Input
"email": "jane.doe@acme.com"
Output
"first_name": "Jane"
"last_name": "Doe"
FAQ

Frequently asked questions

Common questions about the Visisto + BigQuery integration.

Request the BigQuery integration

BigQuery is on our roadmap. Let us know you need it and we will prioritise it.
Request this integrationBrowse integrations

Start free. No credit card required. Setup in minutes.