Skill UI

A comprehensive guide detailing the process of migrating data warehouses to Snowflake from major sources like Amazon Redshift, Google BigQuery, or on-premise databases. This resource covers critical steps including schema conversion (handling dialect differences like STRUCT/ARRAY to VARIANT), robust data transfer methods (S3/Cloud Storage, Python/Pandas), data validation techniques (checksums, row counts), and essential SQL syntax translation patterns.

Direct access to Google's SEO data APIs, including Search Console, PageSpeed Insights, CrUX field data, URL Inspection, Indexing API, and GA4 organic traffic for real search and Core Web Vitals analysis.

A robust API-backed skill for fetching YouTube transcripts, searching video content, browsing channels, and extracting playlists. It functions reliably from any cloud server environment, bypassing limitations found in local tools like yt-dlp or reliance on Google API keys. Ideal for building research corpora, competitive intelligence monitoring, and systematic content analysis.

HasData is a comprehensive cloud platform designed for extracting structured public web data. It supports three core execution modes: Web Scraping API for arbitrary URLs (including JS rendering), pre-parsed Scraper APIs for known platforms (like Google or Amazon), and asynchronous Scraper Jobs for bulk or recursive crawling. Ideal for market research, e-commerce intelligence, job data collection, and local business lead generation.

Use the HasData CLI to access real-time, structured web data from major platforms. This tool provides dedicated subcommands for various APIs (including Google SERP, Amazon, Zillow, Booking, etc.), enabling users to automate data collection, scrape specific URLs, and retrieve structured information like local business listings, product pricing, and real estate data directly from the command line.

This advanced helper assists users in writing, debugging, and validating complex formulas, pivot tables, and array functions for platforms like Excel and Google Sheets. It ensures formulas are robust by handling common edge cases (e.g., blank rows, mixed data types, time zone quirks) and provides detailed, worked examples. It also manages cross-platform dialect translation.

A comprehensive tool to scan all connected digital marketing platforms (e.g., Google Ads, Meta, TikTok) for statistically significant deviations from established performance baselines. It detects performance drops (traffic, conversions, ROAS) or unexpected growth opportunities, classifying anomalies by severity (Critical, Warning, Info) and providing probable root causes and immediate action plans. Essential for proactive campaign management and cost control.

This tool allows users to export comprehensive marketing data—including KPIs, contact records, campaign results, and performance snapshots—to external data stores. It supports integration with BigQuery for advanced data warehousing, Google Sheets for stakeholder collaboration, and Supabase for custom application development. The process includes mandatory PII handling, schema transformation, and detailed execution summaries to ensure compliance and data integrity for downstream analytics and reporting.

A comprehensive tool for importing structured data from various sources (CSV, JSON, Google Sheets) into connected platforms like CRMs, email marketing systems, or custom data stores. It manages the entire import pipeline, including automated field mapping, rigorous data validation, deduplication against existing records, and critical compliance verification (GDPR, CCPA). Features a mandatory execution gate for risk management.