Mixpanel + Google BigQuery Integrations
Zapier lets you send info between Mixpanel and Google BigQuery automatically—no code required. With 5,000+ supported apps, the possibilities are endless.
- Free forever for core features
- 14 day trial for premium features & apps
Trusted at companies large and small
Connect your apps and automate workflows
Easy automation for busy people. Zapier moves info between your web apps automatically, so you can focus on your most important work.
Distinct ID (Profile ID)Required
The user's distinct_id. If you are sending Events to Mixpanel in addition to Profiles, this property value should be identical to the distinct_id property attached to events so that you can connect events to profiles. Tell me more about distinct_id.
Properties contain information about the profile. For example, for a user profile, properties can be things like an email address, where they came from, or their age. These properties allow you to drill down to very specific segments of users/customers and learn more.
Properties are sent as key-value pairs where the key is the property name and the value is the property value. Tell me more about properties.
Certain property keys are special/reserved. For example, if you include the
$unsubscribed. Learn more about Special/Reserved properties .
Only trigger for query jobs that reference the selected table. Leave blank for all query job results.
A name for this Event. For example, 'Brand Mentioned in Tweet' or 'Payment Made'. Tell me more about Events.
Distinct ID (Profile ID)
A way to uniquely identify your users (or more generally, profiles). If you are sending Profiles to Mixpanel in addition to events, this property value should be identical to the Distinct ID property attached to the Profile so that you can connect events to people records. Tell me more about distinct_id.
Event Properties are bits of extra information that you send along with your Events describing the details of that action. They are usually specific to the Event they’re describing and don’t apply universally to other Events. Leveraging Event Properties allows you to conduct deeper analysis to better understand user behavior for a specific action. For example, a 'Song Added to Playlist' event could have 'Artist' and 'Playlist' as the properties. Properties are sent as key-value pairs where the key is the property name and the value is the property value. Tell me more about properties.
Use the + sign to add properties to this event.
Sort By ColumnRequired
Only columns that are type
bignumericare returned. The column will be sorted in descending order. The latest row will be returned.
The unique column is used to determine if a row is new. For example if the unique column is
idand the latest row has an id of 1, then the next time the trigger runs, if the latest row has an id of 2, then the trigger will return the row with an id of 2.
The column to match against the value in the WHERE clause. The where clause will be
WHERE column = value
The value to match against the column in the WHERE clause. The where clause will be
WHERE column = value
How to connect Mixpanel + Google BigQuery
- Step 1: Authenticate Mixpanel and Google BigQuery.30 seconds
- Step 2: Pick one of the apps as a trigger, which will kick off your automation.15 seconds
- Step 3: Choose a resulting action from the other app.15 seconds
- Step 4: Select the data you want to send from one app to the other.2 minutes
- That’s it! More time to work on other things.
Get started for free
You can't add more hours to the day. Zapier is the next best thing.