Data warehouses
/
Google BigQuery

Google BigQuery

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
200+ Pre-built connectors
Zero engineering required
Highly optimized loading
Enterprise SLA
Data warehouses
/
Google BigQuery

Google BigQuery

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Pre-built and automated
Zero engineering required
Automated data normalization
Enterprise SLA
Data warehouses
/
Google BigQuery

Google BigQuery

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
200+ Pre-built connectors
Zero engineering required
Highly optimized loading
Enterprise SLA

BigQuery is Google's serverless, highly scalable, enterprise data warehouse designed for your data analysts. Improvado can load all data gathered from dozens of available datasources to this storage.

How to connect

To work with your GBQ storage imporvado needs only a JSON-file with your GBQ credentials. You can obtain this file by following this instruction on your Google Cloud account. This process is simple and is described well on the GBQ website. Don't forget to set up the jobUser & dataEditor/dataOwner roles given to service account or custom role with needed permissions. Detailed list of needed permissions should look as follows:

Learn more about roles and permissions in GBQ documentation system.

Data formats and breakdowns

Improvado stores data GBQ in "sharding" format, in tables named like "TABLE_NAME_YYYYMMDD".

Typically we break the data down by platform, account, dimension and month, but there are some alternatives. We can implement day-by-day division if you need it.

Additional options

If you want to have your accounts divided into groups and load those groups into different datasets (and even different GBQ accounts), we can handle this. Don't hesitate to reach our support for additional details.

No items found.

Google BigQuery

Available Metrics & Dimensions

You can explore an extensive overview of the full list of all common report types by providers in Improvado Data Dictionary

This list includes such fields as metrics, properties, dimensions, etc.

Talk to our experts to get more details on it.

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

BigQuery is Google's serverless, highly scalable, enterprise data warehouse designed for your data analysts. Improvado can load all data gathered from dozens of available datasources to this storage.

How to connect

To work with your GBQ storage imporvado needs only a JSON-file with your GBQ credentials. You can obtain this file by following this instruction on your Google Cloud account. This process is simple and is described well on the GBQ website. Don't forget to set up the jobUser & dataEditor/dataOwner roles given to service account or custom role with needed permissions. Detailed list of needed permissions should look as follows:

Learn more about roles and permissions in GBQ documentation system.

Data formats and breakdowns

Improvado stores data GBQ in "sharding" format, in tables named like "TABLE_NAME_YYYYMMDD".

Typically we break the data down by platform, account, dimension and month, but there are some alternatives. We can implement day-by-day division if you need it.

Additional options

If you want to have your accounts divided into groups and load those groups into different datasets (and even different GBQ accounts), we can handle this. Don't hesitate to reach our support for additional details.

Google BigQuery

Available Metrics & Dimensions

You can explore an extensive overview of the full list of all common report types by providers in Improvado Data Dictionary

This list includes such fields as metrics, properties, dimensions, etc.

Talk to our experts to get more details on it.

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

We сan migrate your marketing data to the data warehouse

No items found.

Improvado allows you to easily get usable data for your business intelligence

No items found.

Combine data from multiple sources

Over 200 connectors empower your marketing team to use their favorite tools to map data, build and visualize custom reports and more.

Heading
Heading
No items found.

BigQuery is Google's serverless, highly scalable, enterprise data warehouse designed for your data analysts. Improvado can load all data gathered from dozens of available datasources to this storage.

How to connect

To work with your GBQ storage imporvado needs only a JSON-file with your GBQ credentials. You can obtain this file by following this instruction on your Google Cloud account. This process is simple and is described well on the GBQ website. Don't forget to set up the jobUser & dataEditor/dataOwner roles given to service account or custom role with needed permissions. Detailed list of needed permissions should look as follows:

Learn more about roles and permissions in GBQ documentation system.

Data formats and breakdowns

Improvado stores data GBQ in "sharding" format, in tables named like "TABLE_NAME_YYYYMMDD".

Typically we break the data down by platform, account, dimension and month, but there are some alternatives. We can implement day-by-day division if you need it.

Additional options

If you want to have your accounts divided into groups and load those groups into different datasets (and even different GBQ accounts), we can handle this. Don't hesitate to reach our support for additional details.

Dimensions

Gender
Ad Group
Size
Age
Ad
Device
Gepgraphy
Campaign

Metrics

Placement
Time
Device
Conversions
Posts
Geography
Actions
Result Rate
Clicks
Views
Likes
Spend
Web
Plays
Video
Cost
Reach
Comments
Revenue
Age
Campaign
Ads
Shares
Reactions
Purchase
Mobile
Cost
Frequency
Gender
Relevance
Impressions

Available Dimensions

No items found.

Combine data from multiple sources

Over 200 connectors empower your marketing team to use their favorite tools to map data, build and visualize custom reports and more.

Heading
Heading
Explore the full catalog

Connected to the leading data warehouse solutions

Load data into your warehouse of choice within minutes.

Extract data from 200+ pre-built connectors

Connect and manage all your marketing data sources in one platform, both in the cloud or on-premise. Improvado provides a link to more than 200 data sources and connects them with just a few clicks.

Transform your data without SQL skills

Improvado’s approach offers data consolidation on the fly. Combine, map, and normalize data to produce a comprehensive data set surrounding your marketing activities.

Load data to any data warehouse

Connect multiple data sources and analyze them as if they were a single virtual database. You can use Improvado Smart Data Warehouse or connect your own Google BigQuery, Amazon S3, Amazon Redshift, etc.

Analyze data in
real-time

You can use it directly with your favorite business intelligence tools, ingest it to econometric models, populate the enterprise data warehouse, manage your processes, or use it together with the Improvado Mapping Tool.

No items found.

Get all your marketing data in one place

We're here to help with any questions
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.