From your data warehouse (Google BigQuery) you can directly query your data to answer any questions you have.
We're always on hand to help write queries, answer questions and help you write queries. If you'd like help or you'd like to know more please get in touch!
How It Works
Within Google BigQuery all your data is stored. We keep your data forever and it is updated in realtime - so it always completely up to date.
In BigQuery all your data is stored in tables. Each event is a table. Every event is a row, and every column is a property. You can see all your events in the Permutive dashboard. In BigQuery you can see the same events, and query the data directly.
See Your Data
On the left-hand side, in the drop down, you can see your project name and a list of all the events you're collecting. If you double-click on the events you can look at the event schema for each property and see every result.
Looking at the events for our demo 'Zeitgeist' project:
By double-clicking on articlepageview_events I can see the event schema
By clicking on 'Preview' I can see a list of all my events. This list is in time order starting from the very first event received.
Top tip: Click on 'Last' at the bottom to see your most recent events!
Write a Query
The big red 'Compose Query' button in the top-left corner opens the query editor. Here you can type in your query and click the red 'Run Query' button to see the results.
This query counts the total Article Pageview events in the Zeitgeist project.
- To leave the Query Editor, click the grey x in the top-right corner.
- You can save a query by clicking on 'Save Query'.
See Your Query History
Click on 'Query History' in the top-left to see every query you've ever run.
Here you can:
- See if the query ran succesfully. It will either have a green tick or a red exclamation mark
- Click on the query to see the SQL
- Click 'Open Query' to open the query. This will immediately open the query iwth the results from when it last ran. I found this super useful as it saves having to re-run queries!