November 29, 2023 — OWOX BI Pipeline. Introducing ' → Google BigQuery' fully-managed pipeline


We are thrilled to announce the ' → Google BigQuery' pipeline, now available in a Fully-managed status. This means you can now effortlessly set up this pipeline from our user-friendly interface and just get daily currency exchange rates in BigQuery.

Why it matters

This pipeline enhancement is crucial because it elevates automated data collection. Seamlessly connect all your marketing data sources to Google BigQuery without any code. To find any insights built on cost data, it's essential to unify all expenses into a single currency. To achieve this, you'll need our ' → Google BigQuery' pipeline and the Blended AdSpend transformation template.

How it works

Create a pipeline

Setting up the pipeline is straightforward. Visit, create a new Pipeline, choose as the source, and click 'Create & Setup.'

Source and Destination config


Enter the API token, copied from the site, and select the BigQuery dataset as the destination.

Historical data import


After pipeline activation, the first data import occurs the next day, but you can kickstart the historical data load for the past 2 years immediately. We've prepared a detailed setup guide on this page to help you.

Time triggers


Our new pipeline also offers customizable import schedule options: daily, weekly on specific days, or monthly on designated days. Easily configure this on the Time Triggers tab.

Data schema

Detailed information on the data flow structure is available both on the pipeline page and in our Help Center.

Filed Type
date DATE
rate FLOAT
currency STRING



For inquiries or assistance, our support team is ready to help. Reach out to us at, and we'll guide you through any questions or concerns.

Thank you for choosing OWOX BI. Happy analyzing!

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request


Please sign in to leave a comment.