Confirm Demandbase Data Flow in Google Analytics 4

Context

You can measure the health of your Demandbase Google Analytics 4 (GA4) integration using a custom report created within the GA 4 property. The custom report compares the number of page view events received to the number of Demandbase Events received in GA4. Since the Demandbase Event was set up to fire on each page view, the difference allows you to calculate the percentage of page views where no Demandbase data was collected.

Prerequisite/Preparation

You must have Google Analytics Admin permissions.

Steps

1. In GA, do the following to create a new custom report:
   a. Click Explore in the left menu.
   b. On the Explorations page, click the option to create a blank exploration.
   
2. In the Variables section for the new report, enter the following:
   
   • Exploration Name: Enter a name for the custom report. For example, Demandbase Health Check.
   • Custom: Select the date range starting with the day after you enabled the Demandbase GA4 integration and ending with the latest available date.
   • Dimensions: Click the plus sign, search for, and import the dimensions listed below.
     • Page path + query string
     • Hostname
     • Event name
   • Metrics: Click the plus sign, search for, and import the Event count metric.
     
3. In the Tab Settings section for the new report, enter the following:
   • Rows: Add the Page path + query string and Hostname dimensions.
   • Columns: Add the Event name dimension.
   • Values: Add the Event count metric.
   • Filters: Do the following to create a filter.
     a. Add the Event name dimension.
     b. Select matches regex for the filter match type.
     c. Enter page_view|Demandbase_Event for the filter expression. Ensure that you use the name of the custom Demandbase Event you created previously. 
     

Next Steps

Review the report after you create and update its settings. The report should look similar to the following example with the page path and number of events being specific to the GA4 property used.

To use the custom report, compare the number of page view events received to the number of Demandbase Events received in GA4. Since the Demandbase Event was set up to fire on each page view, the difference allows you to calculate the percentage of page views where no Demandbase data was collected.

In the example report, we calculated the percentage of page views where no Demandbase data was collected as follows:

((15,960 - 15,072) / 15,960) x 100 = 5.56%

To make the same calculation for your GA4 report, do the following:

• Replace 15,960 with the total page view event count from your GA4 report
• Replace 15,072 with the total Demandbase Event count from your GA4 report

Tip: A percentage below 20% indicates the integration was set up successfully. If the percentage is above 20%, reach out to your Demandbase Account team for assistance.