Google BigQuery

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

Google BigQuery

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

Google BigQuery

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

About AdRoll

AdRoll is a retargeting and prospecting platform for advertisers.

Publishes cross-channel ad campaigns to over 500 ad exchanges, including Facebook, Twitter, Instagram, and Google.
Has proprietary real-time bidding algorithm, so you don’t overpay for ad space or placement.
Offers prospecting tool so you can find and market to new audiences who match your current ones.
Allows for automation and high data portability.

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.
No items found.

Getting started is easy. Be up and running in minutes

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Your marketing data, simplified🤘
SCHEDULE A DEMO

Resources