This article refers to an outdated version of the Tag Rocket Reports. We have since upgraded our system to provide more reliable, unified reporting. To learn more about it, and how to configure, go to our Tag Rocket Reports page.
The Reports
This table lists the reports we provide and the resources needed to generate the reports.
| Report | Description | Data Source | BigQuery Query | BigQuery Table |
|---|---|---|---|---|
| Web Vitals | Analyse how good an experience vistors have on your site in relation to Google’s Web Vitals | GA4 via BigQuery | bigquery-materialize-table-web-vitals.sql | web_vitals_summary |
| Purchase Tracking | Shows attributions for purchases and analyses missing browser purchase tracking. | GA4 via BigQuery | bigquery-materialize-table-purchases.sql | purchases |
| Website Errors | Identifies console, JavaScript, Network and JSON-LD errors on the website. | GA4 via BigQuery | bigquery-materialize-table-website-errors.sql | website_errors |
| Missing Pages | Identifies when users visit missing pages. A bad experience. | GA4 via BigQuery | bigquery-materialize-table-missing-pages.sql | missing_pages |
| Shopping Behaviour | Shows how users flow through the steps of the checkout process. | GA4 via the Data Studio Connector |
To create a report, you first need to make sure the data source is available. The following section explains how to set up each data source.
Once you have a data source, you can click on the report link in the table. For the BigQuery based reports, you need to make a copy. More details are here.
Data Sources
GA4 via the Data Studio Connector
This is available as long as the account you have logged into has access to the GA4 property powered by Tag Rocket.
These reports can be used directly with no need to copy them.
GA4 via BigQuery
Several reports require a BigQuery project to process the data for the reports. These are the ones with BigQuery as the source.
Google provides instructions on how to set up the BigQuery project and link it to GA4:
[GA4] Set up BigQuery Export – Analytics Help
You can use the sandbox option. The main limit is the data only lasts 60 days. If you provide a credit card, you can keep the data forever (You will then need to update your datasets details so that it does not expire tables). You may reach a threshold where you will start paying to access the data at some point.
Our BigQuery based report works from special tables created by database queries (SQL). This is to minimise the amount of data the report accesses and from that saves on your data allowance. The script needed for each report is linked to in the table at the top.
Each script needs adding as a scheduled query (we recommend weekly) so that your report data is kept up to date.
You will have to wait about a day for the GA4 export table to show up.
If you are a subscribed Tag Rocket user and are happy to give us access to your BigQuery project, we can set the queries up for you. After giving us access, contact us and we will do the work.
- Go to the scheduled query section of BigQuery (make sure you are on the right project)
- Click the Create Schedule button
- Paste the query into the editor
- Click on the analytics dataset to see details, including its ID and Data location
- In the script, replace all occurrences of DatasetID with your ID
- Select the SCHEDULE->Create new scheduled query menu option
- Name the schedule. e.g. ‘report name for store name
- Select how frequently to run it. e.g. Weekly
- Make sure the data location is set to Default or matches your dataset
- Save
Why not export your BigCommerce data to BigQuery as well
Creating a BigQuery based Report
Click on the link in the top table to open up the template report.
In the report, select “make a copy”.
At this point you are prompted to update the data sources for the new report. In most cases you want to update the first datasource (BigQuery blue icon) to point to your table. Click on the “new data source” and select BigQuery. Then navigate to your table. Check the “Use event_timestamp as date range dimension”. Connect, Add to Report, Copy Report and your there.
Then rename your new report so that it identifies your store.
You can then publish and share the report so others can see it.