![]() ![]() Grab the sheet Post-click analysis templateĬheck if your ad spend is generating a positive ROI and how your sponsored ads are performing (in comparison to other channels). ![]() With this e-commerce reporting template, you can keep track of the performance of your online store. Grab the sheet E-commerce reporting template Using your Google Analytics data, this pipeline recipe answers one basic question: Which marketing channel(s) should we be focused on?’ Grab the sheet GA Conversion Index Tracking Plan It assesses your site’s overall success in converting users into consumers, page by page and channel by channel. This reporting template uses Google Analytics to investigate your site’s overall acquisition efficiency. Grab the sheet Analytics Tracking Plan (BigQuery) This custom dashboard uses the Google Analytics add-on for Google Sheets to easily analyse what’s causing organic traffic to decline. Nice □Ī UTM builder with a bunch of functionality for teams like customizable dropdowns that allow you to keep standardized naming conventions and functionality to automatically append a date code to each tracking URL (super useful when using UTM URLs for paid campaigns). Use this heatmap dashboard to easily identify web traffic patterns on your site like which month, day of the week, or time of day gets the most (or least) amount of traffic/conversions. Grab the sheet User Acquisition Heatmap Dashboard Want to heatmap specific metrics in order to identify growing or hot trends over time? This sheet pulls in your Google Analytics data and then displays traffic heatmaps so you can easily see peaks and troughs. Use this sheet to generate your event tracking codes (and keep track of event tracking in GA). Google Analytics event tracking is a useful feature for tracking visitor interactions with your website that would not be normally tracked. Grab the sheet Google Analytics Event Tracking Generator Nice.īuilding UTM parameters can be annoying and time-consuming… Until now! This simple tool helps to build UTM parameters easily in order to track your marketing campaigns in Google Analytics. The GA conversion indexation analysis recipe uses the Agency Data Pipeline stack (Stitch, BigQuery, DBT) to pick channels / landing pages on your site that are over or underperforming. Grab the sheet GA Conversion Indexation Analysis It pulls in Google Analytics data and automatically calculates metrics like visit-to-purchase conversion rate, average order size, and more. This sheet helps you to get a handle on your funnel conversion performance. Grab the sheet Conversion Funnel Analytics It does 12 checks and assigns a simple pass or fail to each (+ instructions on how to fix any issues). This automated Google Sheets template pulls in GA data (+ a Screaming Frog export) and analyses a Google Analytics setup. Year-on-year website performance reporting templateīelow you’ll find loads of useful spreadsheet templates from auditing your GA data, event tracking code generators, UTM tagging, heatmaps and more.Ĭheck out these free Google Sheets analytics templates, reports and generators to make your life a bit easier (and a lot faster): Automated Google Analytics Audit.Website traffic source bubble chart template.Website traffic by device & source reporting template.Website performance by US state reporting template. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |