Loading

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.

Choose a Trigger
Start herearrow pointing down
Start herearrow pointing down
Choose an Action
Get Started for Free
  • 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.


OR

By signing up, you agree to Zapier's terms of service and privacy policy.


OR

By signing up, you agree to Zapier's terms of service and privacy policy.

Supported triggers and actions

What does this mean?
    • 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.

    • Profile PropertiesRequired

      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 $email property, you can start sending targeted email notifications using Mixpanel's Notifications product. Other examples of special properties are $name, $phone and $unsubscribed. Learn more about Special/Reserved properties .

    Action
    Write
    • ProjectRequired

    • Dataset

    • Table

      Only trigger for query jobs that reference the selected table. Leave blank for all query job results.

    Trigger
    Scheduled
    Try It
    • Project IDRequired

    • Job IDRequired

    • LocationRequired

    Trigger
    Scheduled
    Try It
    • ProjectRequired

    • DatasetRequired

    • TableRequired

    Action
    Write
    • EventRequired

      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

      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.

    Action
    Write
    • Project IDRequired

    • DatasetRequired

    • TableRequired

    • Sort By ColumnRequired

      Only columns that are type integer, bytes, int64, float, timestamp, date, datetime, numeric, bignumeric are returned. The column will be sorted in descending order. The latest row will be returned.

    • Unique ColumnRequired

      The unique column is used to determine if a row is new. For example if the unique column is id and 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.

    Trigger
    Scheduled
    Try It
    • Project IDRequired

    • DatasetRequired

    • TableRequired

    • Unique ColumnRequired

      The column to match against the value in the WHERE clause. The where clause will be WHERE column = value

    • ValueRequired

      The value to match against the column in the WHERE clause. The where clause will be WHERE column = value

    Trigger
    Scheduled
    Try It
    • ProjectRequired

    • DatasetRequired

    • TableRequired

    Action
    Write

How to connect Mixpanel + Google BigQuery

  1. Step 1: Authenticate Mixpanel and Google BigQuery.
    30 seconds
  2. Step 2: Pick one of the apps as a trigger, which will kick off your automation.
    15 seconds
  3. Step 3: Choose a resulting action from the other app.
    15 seconds
  4. Step 4: Select the data you want to send from one app to the other.
    2 minutes
  5. That’s it! More time to work on other things.
mixpanel logo

About Mixpanel

Mixpanel provides product analytics for understanding user behavior in apps & websites. Build better products faster with instant insights.
Learn more

Related categories

  • Ads & Conversion
google-bigquery logo
google-bigquery logo

About Google BigQuery

BigQuery is Google's serverless and highly scalable enterprise data warehouse, designed to make all your data analysts productive.

Related categories

Get started for free

You can't add more hours to the day. Zapier is the next best thing.


OR

By signing up, you agree to Zapier's terms of service and privacy policy.