Creating GA4 Tag Rocket Reports

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.

We’ve developed several reports which work with the data created by the Tag Rocket app for BigCommerce. Before you can use the report, you will need to have installed Tag Rocket and Set up Google Analytics 4 in the app. Then we need to create a data source that points to your GA4 property.

Creating the Data Source

The reports are built using Google Data Studio. The first thing you need to do is create a special Data Source that can be used to connect your own store’s data with the report.

At the moment, the standard Data Source for GA4 is not usable. It randomly messes up the custom definitions. We have worked out the following steps to create a special Data Source that can be used in our reports. Hopefully, GA4/Data Studio fix this in the near future.

1. Copy the latest Data Source Template version from the table above by opening the template and clicking on the copy icon and the copy button
2. Select your GA4 account from the connection options, then click the ‘Reconnect’ button. The new data source is now based on your property. A popup will appear, indicating lots of issues. Ignore them and click ‘Apply’
3. Rename it (top left) to include your store’s name. That way, you know which store and which version of the data source you are looking at. e.g. ‘Tag Rocket GA4 – My Store – vX.Y’
4. Sometimes Data Studio duplicates some of the inbuilt fields with only one of the copies working. If you see any invalid formula warnings, then it is probably the case. Check through all the fields and add a ‘ 2’ after the make of duplicates. This will then let you try each duplicate in any failing formula.
5. You now need to fix all the custom definition based fields, so the data source works. Check every field starting with an @ (indicates it uses custom definitions) and make sure all formulas match the formulas in the custom definitions fields table at the end of this guide. If the formula fails, then you may have to try the other duplicate for the referenced field.

Reports will have errors or be inaccurate if the functions on those fields are incorrect.

Your data source is now ready to use to power new reports.

Creating the Reports

1. Click on a report link to see the report
2. Click the menu (ellipsis icon), then “Make A Copy”
3. Select the data source you have previously created
4. Click ‘Copy Report’
5. Rename the new report (top left) to include your store name. e.g. ‘GA4 Tag Rocket Report – My Store – vX.Y’

You should now have a working report based on your own GA4 property. If you have only just published your GA4 tag in Tag Rocket, you will have to wait a day or two before you start seeing data.

Data Source Updates

Your data source can be re-used in new updates of the reports. However, some report updates may require the addition of new fields. This table lists all the custom fields, their values, and what version of the data source they were last changed/added in. When adding the field, enter the name id and formula (you can’t change the id once you have saved it). Afterwards, you can change the type or aggregation if required (bold).

Pre v2.0 data sources are not usable for these reports. You would need to create a new data source.

If you do decide to create a data source from scratch, you will have to add all the following fields. In some cases, fields refer to other fields which have to be added before them.

The following # fields directly relate to core GA4 properties. They are required but do not need checking to see if their formula is correct after a copy.

The @ fields relate to GA custom definitions, and they do need checking to make sure they have the correct formula after a copy.

CASE
WHEN #Event name = 'LCP' THEN
CASE
WHEN @Web Vitals value <= 1 THEN "0-1"
WHEN @Web Vitals value <= 2 THEN "1-2"
WHEN @Web Vitals value <= 3 THEN "2-3"
WHEN @Web Vitals value <= 4 THEN "3-4"
WHEN @Web Vitals value <= 5 THEN "4-5"
WHEN @Web Vitals value <= 6 THEN "5-6"
WHEN @Web Vitals value <= 7 THEN "6-7"
WHEN @Web Vitals value <= 8 THEN "7-8"
WHEN @Web Vitals value <= 9 THEN "8-9"
ELSE "9+"
END
WHEN #Event name = 'FID' THEN
CASE
WHEN @Web Vitals value <= 10 THEN "000-010"
WHEN @Web Vitals value <= 25 THEN "010-025"
WHEN @Web Vitals value <= 50 THEN "025-050"
WHEN @Web Vitals value <= 75 THEN "050-075"
WHEN @Web Vitals value <= 100 THEN "075-100"
WHEN @Web Vitals value <= 300 THEN "100-300"
ELSE "300+"
END
WHEN #Event name = 'CLS' THEN
CASE
WHEN @Web Vitals value <= 0.05 THEN "0.00 - 0.05"
WHEN @Web Vitals value <= 0.1 THEN "0.05 - 0.10"
WHEN @Web Vitals value <= 0.25 THEN "0.10 - 0.25"
WHEN @Web Vitals value <= 0.5 THEN "0.25 - 0.50"
WHEN @Web Vitals value <= 1 THEN "0.50 - 1.00"
ELSE "1+"
END
ELSE "Unknown"
END