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 workflow 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.

Fields

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

Configuration

Follow these steps to set up and configure an export of audience change events from Lytics to Google BigQuery.

  1. Navigate to Google in the Integrations section of Lytics. google
  2. Select Workflows from the menu on the left.
  3. Select Export Audience Changes from the list of workflows.
  4. Select the authorization you would like to use.
  5. From the BigQuery Project input, select the Google BigQuery Project you want to export data to.
  6. From the Audiences input, select the Lytics audience(s) you'd like to track. Leave empty to track all segment changes.
  7. From the BigQuery Dataset input, select the Google BigQuery Dataset you want to export data to.
  8. From the ID Field input, select the ID field in Lytics that'll get mapped to an identifying field in BigQuery.
  9. Click Start Export. gbq-export-audience-change-config