Can it help with SQL queries?

Yes, it includes reference SQL patterns for identifying top performers, detecting trends, and finding wasted ad spend.

Does it support product variants?

Yes, it defines the relationship between individual Variant IDs (SKUs) and Product IDs (item_group_id) for accurate aggregation.

What platforms does this skill cover?

It includes metrics and data structures for Google Ads, Google Analytics 4 (GA4), Meta (Facebook/Instagram) Ads, and Google Merchant Center product feeds.

How does it handle attribution?

The skill provides logic for multi-channel attribution, including blended ROAS formulas and priority-based scoring across different ad platforms.

What is View Velocity?

It is a specific metric included in the skill that compares short-term views to long-term history to identify trending products before they hit peak sales.

Ecommerce & SEM Metrics Reference

Name: Ecommerce & SEM Metrics Reference
Author: Expanly

byExpanly

0•

分析と監視

Provides a comprehensive knowledge base and data models for ecommerce analytics, SEM performance, and cross-channel attribution scoring.

This skill equips Claude with specialized domain knowledge for Search Engine Marketing (SEM), paid social, and ecommerce business intelligence. It includes detailed schemas for Google Ads, GA4, and Meta Ads, along with standardized formulas for ROAS, AOV, and view velocity. Ideal for developers building scoring models, automated reporting tools, or performance dashboards, it ensures consistent metric definitions and multi-channel attribution logic across disparate data sources like Google Merchant Center and Meta Catalogs.

主な機能

01Performance segmentation strategies based on revenue and stock status

020 GitHub stars

03Standardized KPI definitions for Google Ads, Meta Ads, and GA4

04Cross-channel attribution logic and blended ROAS calculations

05Product feed data models including custom labels and variant mapping

06Pre-defined SQL patterns for trend detection and wasted spend analysis

ユースケース

01Normalizing data fields across GA4, Google Ads, and Meta Ads

02Developing trend detection algorithms for product catalogs

03Building automated ecommerce performance scoring models

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add expanly/expanly-claude-code-agents sem-ecommerce-metrics

For use in Claude.ai and ChatGPT

Download Skill