Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

We have implemented the Insights Data Warehouse with the Google product BigQuery. BigQuery is a fully-managed, serverless data warehouse solution that enables scalable, cost-effective and fast analysis over petabytes of data and supports querying using ANSI SQL. Google BigQuery is the interface to your data.

In the Ingenious Platform, data accumulates in all our products. This data is stored in our company-wide data lake, which we have implemented with Apache Kafka. If an event happens in the system, the data is immediately pushed to BigQuery and is processed hourlyseveral times a day.

...

Using Google BigQuery as a data warehouse allows you to use different analysis tools and to query your data individually. For example you can use Google Data Studio to create complex reports according to your requirements. Other tools that can be used are:

...

Furthermore, it is possible to create data exports directly from BigQuery.

In Insights Data Warehouse the following data is currently available for analysis:

...

Trail

  • Ad Impressions

  • Clicks

  • Untracked Requests (all requests we were not able to properly process)

...

Finance

  • Conversions, including attributed winners and additional data

...

Partnerships

  • Advertisers

  • Partners

  • Entities

  • Adspaces

  • Conversion-Targets & Tracking-Categories

Creatives

...

Next steps: