In this example, we will create a report that demonstrates the sales effectiveness of each user acquisition channel.
The sales data source is WooCommerce, while GA4 provides data on the user acquisition channels.
The process for creating this report involves the following steps:
- Load data from GA4. Use the Predefined for Ecommerce schema.
- Load data from WooCommerce.
- Clean the WooCommerce data, keeping only the necessary columns.
- Clean the GA4 data by removing rows with no transactions and retaining only the necessary columns.
- For each order in WooCommerce, find the corresponding row in GA4 to obtain information about the advertising network that brought the user.
- Generate a final report showing income for each user acquisition channel.
- Create a dashboard to visualize this report.
Here are more details on the process:
1. Load data from GA4. Prepare a predefined table for Ecommerce.
Let's create a workflow. Name it "GA4 with WooCommerce".
2. Load data from WooCommerce.
3. Clean the WooCommerce data, keeping only the necessary columns.
We need a column with order id (dimension) and sales volume Total (metric).
4. Clean the GA4 data by removing rows with no transactions and retaining only the necessary columns.
You must select at least two columns:
- Source - to show the acquisition channel
- Transaction ID - to use as a key to link the two data sources.
Metrics from GA4 are optional.
5. For each order in WooCommerce, find the corresponding row in GA4 to obtain information about the advertising network that brought the user.
Now, let's connect the data from WooCommerce with the data from GA4. To do this, we will use the Lookup building block.
We will specify the criteria for finding the relevant rows in GA4, ensuring that the Transaction ID matches the Order ID.
6. Generate a final report showing income for each user acquisition channel.
Next, we will create the final report. To do this, collapse all dimensions except for the Source, allowing us to see the total for each user acquisition channel.
Let's name this report "revenue_all_channels."
7. Create a dashboard to visualize this report.
Finally, we will submit the report to the dashboard. For the data source, we will select the newly created workflow "WooCommerce with GA4" and specify the "revenue_all_channels" dataset.
That's it, the dashboard is now ready.