SplitOut Automate
Used with SplitOut, this automated workflow efficiently retrieves and organizes website performance data from Google Search Console on a scheduled basis. It processes key metrics such as clicks, impressions, CTR, and positions, updating Google Sheets with insights for better decision-making. Ideal for digital marketers and SEO professionals, it streamlines reporting and enhances visibility into website performance over time.
View Large Image
Workflow Overview
Used with SplitOut, this automated workflow efficiently retrieves and organizes website performance data from Google Search Console on a scheduled basis. It processes key metrics such as clicks, impressions, CTR, and positions, updating Google Sheets with insights for better decision-making. Ideal for digital marketers and SEO professionals, it streamlines reporting and enhances visibility into website performance over time.
Target Audience
- Digital Marketers: Professionals looking to track website performance metrics over time.
- SEO Specialists: Individuals needing to analyze keyword performance and page metrics for optimization.
- Web Analytics Professionals: Experts who require detailed reports for stakeholder presentations and decision-making.
- Business Owners: Those interested in understanding their website's traffic and search performance to improve online visibility.
Problem Solved
This workflow automates the retrieval of performance data from Google's Search Console, allowing users to efficiently gather insights on keywords, pages, and dates without manual data collection. It addresses the need for timely and organized reporting, ensuring that users can focus on analysis rather than data gathering, ultimately saving time and enhancing productivity.
Workflow Steps
- Schedule Trigger: The workflow begins on a defined schedule, automatically initiating the data retrieval process.
- Set Your Domain: Users specify the domain to be analyzed and the number of days for which data is required (default is 30 days).
- Get Query Report: An HTTP request fetches keyword performance data from the Google Search Console API.
- Get Page Report: Another HTTP request retrieves page performance metrics using the same API.
- Date Data Retrieval: A separate HTTP request collects data based on date dimensions.
- Data Splitting: The fetched data is split into individual records for further processing through multiple 'Split Out' nodes.
- Edit Fields: Each split data record is processed to map relevant fields (e.g., clicks, impressions, CTR, position) for easy insertion into Google Sheets.
- Update Google Sheets: The processed data is appended or updated in designated Google Sheets documents for keywords, pages, and dates, facilitating organized reporting.