Documentation / Product / Integrations / Google / Google BigQuery

Google BigQuery: Export Audience Changes

Export audience changes from Lytics to Google BigQuery.

Integration Details

  • Implementation Type: Server-side.
  • Implementation Technique: REST API.
  • Frequency: Batch.
  • Resulting data: Audience segment change events.

This integration utilizes the Google BigQuery APIs to send user data. Once the export is started the job will:

  1. Check if dataset exists, if not create it in Google BigQuery.
  2. Check if a table exists, if not create one.
  3. Generate a CSV in BigQuery by:
    1. Receive segment change events.
    2. Write change event to Google Cloud Storage as a CSV row.
  4. Every 10 minutes Upload the CSV to BigQuery and start writing events to a new CSV.


By default, Lytics exports the following fields to Google BigQuery:

Lytics User FieldDescriptionGoogle BigQuery FieldType
emailEmail Addressemailstring
-Audience Slugsegment_slugstring
-Event TimetimestampTIMESTAMP
-was this an audience Exitexitboolean


Follow these steps to set up and configure an export of audience change events from Lytics to Google BigQuery. If you are new to creating jobs in Lytics, see the Jobs Dashboard documentation for more information.

  1. Select Google Cloud from the list of providers.
  2. Select the Export Audience Changes job type from the list.
  3. Select the Authorization you would like to use or create a new one.
  4. Enter a Label to identify this job you are creating in Lytics.
  5. (Optional) Enter a Description for further context on your job.
  6. From the BigQuery Project input, select the Google BigQuery Project you want to export data to.
  7. From the Audiences input, select the Lytics audience(s) you'd like to track. Leave empty to track all segment changes.
  8. From the BigQuery Dataset input, select the Google BigQuery Dataset you want to export data to.
  9. From the ID Field input, select the ID field in Lytics that'll get mapped to an identifying field in BigQuery.
  10. Click Start Export. gbq-export-audience-change-config