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.

ReportDescriptionData SourceBigQuery QueryBigQuery Table
Web VitalsAnalyse how good an experience vistors have on your site in relation to Google’s Web VitalsGA4 via BigQuerybigquery-materialize-table-web-vitals.sqlweb_vitals_summary
Purchase TrackingShows attributions for purchases and analyses missing browser purchase tracking.GA4 via BigQuerybigquery-materialize-table-purchases.sqlpurchases
Website ErrorsIdentifies console, JavaScript, Network and JSON-LD errors on the website.GA4 via BigQuerybigquery-materialize-table-website-errors.sqlwebsite_errors
Missing PagesIdentifies when users visit missing pages. A bad experience.GA4 via BigQuerybigquery-materialize-table-missing-pages.sqlmissing_pages
Shopping BehaviourShows 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.

Steps to add a scheduled query
  1. Go to the scheduled query section of BigQuery (make sure you are on the right project)
  2. Click the Create Schedule button
  3. Paste the query into the editor
  4. Click on the analytics dataset to see details, including its ID and Data location
  5. In the script, replace all occurrences of DatasetID with your ID
  6. Select the SCHEDULE->Create new scheduled query menu option
  7. Name the schedule. e.g. ‘report name for store name
  8. Select how frequently to run it. e.g. Weekly
  9. Make sure the data location is set to Default or matches your dataset
  10. 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.