Try out all OWOX BI features with a trial period Start for free

Setting up the TrafMag → Google BigQuery pipeline

Note: This pipeline is available for the subscription plans Marketing Data, Reports & Attribution, and Enterprise.

1. On the OWOX BI main page, click Create pipeline:Create_pipeline_blank_en.png

2. As a source, select TrafMag:Create_pipeline_step_1_trafmag_en.png

3. As a destination, select Google BigQuery:TrafMag_Step_2_en.png

4. Select or add new access to a TrafMag account from which you want to export ad cost data:image_325.png

5. Select or add new access to a Google BigQuery account where you want to store the exported data:Step_4_en.png

6. Select a Google BigQuery project and create a dataset you want to upload your data to (or choose an existing one):Step_5_en.png

Note: To setup the data collection successfully, your Google account must have the “BigQuery Admin” role in the project where you want to collect data to. Without this permission, BigQuery won’t let you upload the data.

7. Specify the date that marks the beginning of the period you want to upload cost data for:Step_6_en.png

You can schedule the start of the import on a date in the future or select a past date to upload historical data from your TrafMag account.

Also on this step, specify the VAT rate to exclude from the exported costs. You need this to have your TrafMag cost data consistent with the cost data form other services where VAT is being excluded automatically.

Finally, select the currency you want your cost data to be additionally converted into.

The pipeline uploads ad cost data into two separate fields in your BigQuery data table. One field contains costs in the original currency — just as they appear in the ad service. The other field contains costs converted into the currency you select when creating the pipeline.

The converted costs are useful for the reports where you need to have cost data from different sources presented in a uniform currency.

8. Click Create pipeline.

Done! The pipeline will be uploading data to a partitioned table in the selected BigQuery dataset. The data will be uploaded daily — for the previous day.

OWOX BI will also update the data already uploaded to BigQuery if the data in the TrafMag account would change retrospectively. The update period for historical data is 21 days. This means that 21 days after the import, the data in BigQuery will be totally up-to-date.

The table data schema is in this article.

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

0 Comments

Please sign in to leave a comment.