Reach Data Schema Updates

Current Schemas

You can find our existing BigQuery Mirror Schema here and our existing Scheduled Exports schema here.

Schema Change Log

September 20, 2023

BigQuery Mirror

This afternoon, we were able to seamlessly roll out a vastly smaller/faster/cheaper version of your added_people view. It has gone from something like 320GB to 83 MB for a typical client. That’s about 3900x smaller! So hopefully your syncs today took another major step forward.

Scheduled Exports

No changes.

September 19, 2023

BigQuery Mirror

Today, we have introduced new versions of all your views except `added_people` and `person_tag_associations` to make them smaller, faster, and cheaper to query. For views that used to be massive, you will see the biggest differences. For example, a query of the `actions` view used to process about 160GB. Now it will process about 233 MB. That is about 700x smaller! Similarly, a query to `responses` used to process 160GB and now processes about 1GB. 

We have now replaced almost all of your views with the new cheaper versions seamlessly in the background. The only action you have to take is increasing the frequency at which you query them!

Scheduled Exports

No changes.

August 31, 2023

BigQuery Mirror

  • The new Content Sharing tables were using the wrong datatype for their user id columns. So the following fields changed from INTEGER to STRING:
    • content_actions.user_id
    • content_assets.created_by_user_id
    • content_bookmarks.user_id
    • content_feedback.created_by_user_id
    • content_galleries.created_by_user_id
    • content_labels.created_by_user_id
    • content_shared_galleries.created_by_user_id

Scheduled Exports

No changes.

August 29, 2023

BigQuery Mirror

  • Added tables to support many new upcoming features around content sharing:
    • content_actions
    • content_assets
    • content_bookmarks
    • content_feedback
    • content_galleries
    • content_label_associations
    • content_labels
    • content_shared_galleries
    • social_platforms
  • New columns on existing tables
    • action_cards.content_asset_id
    • campaigns.enable_content_library

Scheduled Exports

Possible new value of share_content in the Interaction Type column of the Action Card Interactions export.

August 11, 2023

BigQuery Mirror

  • Added table: user_devices with the following columns:
    • id
    • user_id
    • status
    • platform
    • notification_permissions
    • created_on
    • updated_on
    • reach_native_version
    • locale
  • Added table push_notification_actions with the following columns:
    • id
    • user_device_id
    • push_notification_id
    • action_type
    • created_on
    • updated_on
    • campaign_id
    • notification_campaign_id

Scheduled Exports

No changes

July 20, 2023

BigQuery Mirror

  • Added field: user_to_campaign_associations.last_seen_on

Scheduled Exports

No changes

June 12, 2023

BigQuery Mirror

No changes

Scheduled Exports

  • Three new columns in the Action Card Interactions export:
    • Upload URL
    • Comment
    • Upload Type