In order to set up the data transfer from Facebook or Yandex.Direct to Google BigQuery, you first need to automate cost data import from Facebook or Yandex.Direct to Google Analytics. Here's the article that shows how to configure the automatic import.
After creating the Facebook or Yandex.Direct to Google Analytics pipeline, please do the following:
Step 1. Login to your OWOX BI account and go to the Import to Google BigQuery tab on the Facebook\Yandex.Direct - Google Analytics pipeline page.
FYI: You need to have a paid pricing plan or the active OWOX BI Trial to set up the Facebook\ Yandex.Direct to Google BigQuery pipeline.
Step 2. Check the Activate data import to Google BigQuery box.
Step 3. Select at least one Google account with the access to Google BigQuery or add the new account.
Step 4. Click Save in order to save the changes.
Done! You've activated the import of raw advertising data to Google BigQuery. The first data will be collected within 24 hours after the pipeline is created. The Data set in Google BigQuery link in the Import to BigQuery tab on the pipeline page leads to the table with the collected data in BigQuery. The Data structure link in the same tab leads to the data schema of the imported table.