Getting started with Dataslayer for BigQuery
How it works Use our web interface to transfer data easily from our API to BigQuery: Select your Datasource (Facebook, Google Ads, Google Analytics…) Select Date and Time Select Dimension and Metrics Create a Schedule and frequency to transfer data to your BigQuery DatasetFew readersSolution to the BigQuery error: “This app was blocked”
Do you see this o a similar message when trying to access our BigQuery integration? BigQuery error message This error means our app was blocked because Dataslayer has not been added as a trusted app in BigQuery. To fix it, you just need to add Dataslayer as a trusted app at this link: https://admin.google.com/u/1/ac/owl/list?tab=configuredAppshttps://admihttps://admin.google.com/u/1/ac/owl/list?tabFew readersHow to visualize your BigQuery data into Google Data Studio
Do you know that you can select all the existing data sources from our API (Facebook Ads, GA, Google Ads, LinkedIn, Instagram...), combine all of them and import all your marketing data into BigQuery using Dataslayer? Then you can visualize or create reports using Data Studio, without any code! Learn more here: https://dataslayer.ai/dataslayer-bigquery/Few readersBest BigQuery Practices thanks to Dataslayer
The best way to start with Dataslayer for BigQuery is to do a historical data import, so you can have all your data into BigQuery. Then you must do a automated transfer so you can have your data updated at the moment in an automated way, without any manual task. See the video above to learn how to do it!Few readersFeatures to upload historical data into BigQuery
When uploading data to Big Query, we can find different options depending on our needs. It is not the same to upload data from a couple of months than from several years, so we are going to see the different options we have when transferring our information using Dataslayer. Schedule, to schedule periodic uploads. Ideal for keeping the data updated periodically. Manual (ideal for upload Historical DaFew readersHow to store your Google Universal Analytics data in BigQuery
Afraid of losing your historical Google Universal Analytics data when it goes away in July 2023? Don't worry anymore! Thanks to Dataslayer you can store all your historical UA data in a data warehouse such as BigQuery without the need of knowing any coding language!Few readers