Compare Google Analytics 4 and Ads data for online store


Key e-store sales metric such as revenue, CPA, and ROAS based on ads platforms, GA and Shopify. Data pulling to Google Sheets, blending there and connecting to GDS.

Data sources: Google Analytics, Google Ads, Facebook Ads, Shopify

Pre-sets: Ecommerce reports in GA and conversions in the ads platforms.

Go to Looker Studio template page

The templates are delivered within 24 hours during the working days. The delivery requires manual processing but we try hard so in 90% of the cases we deliver it faster!

Check out the template video overview:


More details? 

Above all, we designed this report template to provide businesses with key e-store sales metrics, including revenue, cost-per-acquisition (CPA), and return on ad spend (ROAS). The data sources for this report include Google Analytics, Google Ads, Facebook Ads, and Shopify, providing a comprehensive view of sales performance across multiple platforms.

Basically, to generate the report, I pulled the data from each of these sources and blended in Google Sheets, allowing for a holistic analysis of e-store sales performance. The report includes information such as total revenue, revenue by platform, CPA, and ROAS, enabling businesses to identify which platforms are driving the highest sales and which may require further optimization.

Consequently, by connecting the blended data in Google Sheets to Google Data Studio, businesses can easily create interactive dashboards and visualizations of the data, enabling them to quickly and easily share insights with stakeholders.

Pre-sets for this report include ecommerce reports in Google Analytics and conversions set up in the ads platforms, ensuring that businesses have access to the necessary data to generate the report.

Overall, our e-store sales metrics report template is a powerful tool for businesses looking to optimize their sales performance across multiple platforms. By providing a comprehensive view of key sales metrics and enabling businesses to easily share insights with stakeholders, our report template empowers businesses to make data-driven decisions and drive better results.

Check out the article-overview here.