Get Report

Retrieve Google Merchant Center product performance data and analytics

The Get Report node retrieves comprehensive performance data from Google Merchant Center with customizable metrics, dimensions, filters, and date ranges. Perfect for product performance analysis, conversion tracking, and revenue optimization. This is an AI-powered node that can understand natural language instructions.

---

When to Use It

• Analyze product performance and shopping campaigns
• Track clicks, impressions, conversions, and revenue
• Monitor product search performance
• Generate custom performance reports
• Analyze trends over time periods
• Compare product performance across dimensions
• Create automated reporting dashboards

---

Inputs

Field	Type	Required	Description
Account	Dropdown	Yes	Google Merchant Center account to query
Metrics	Multi-select	Yes	Performance metrics to retrieve
Dimensions	Multi-select	No	Data breakdown dimensions
Date Range	Date Picker	Yes	Time period for the report
Filters	Filter Builder	No	Conditions to filter the data
Sort	Dropdown	No	How to sort the results
Limit	Number	No	Maximum number of rows to return

Available Metrics

Metric	Description	Use Case
Clicks	Number of product clicks	Traffic analysis
Impressions	Product impression count	Visibility tracking
CTR	Click-through rate	Performance efficiency
Conversions	Conversion events	Sales tracking
Conversion Value	Revenue from conversions	Revenue analysis
Cost	Advertising cost	Budget tracking
CPC	Cost per click	Bid optimization
ROAS	Return on ad spend	ROI analysis

Available Dimensions

Dimension	Description	Use Case
Product	Individual products	Product-level analysis
Brand	Product brands	Brand performance
Category	Product categories	Category analysis
Country	Geographic location	Regional performance
Device	Device type	Device targeting
Date	Time periods	Trend analysis
Channel	Shopping channel	Channel comparison
Campaign	Campaign names	Campaign performance

Date Range Options

Option	Description	Use Case
Last 7 days	Recent week	Short-term trends
Last 30 days	Recent month	Monthly analysis
Last 90 days	Quarterly view	Seasonal trends
Last 12 months	Annual view	Year-over-year comparison
Custom Range	Specific dates	Targeted analysis
Compare Periods	Period comparison	Performance changes

---

Output

Returns detailed performance data:

{
  "report_data": [
    {
      "product_title": "Apple iPhone 15 Pro 128GB",
      "product_id": "online:en:US:12345",
      "brand": "Apple",
      "category": "Electronics > Mobile Phones",
      "country": "US",
      "date": "2024-03-15",
      "clicks": 2847,
      "impressions": 45230,
      "ctr": 6.29,
      "conversions": 127,
      "conversion_value": 126873.00,
      "cost": 8945.23,
      "cpc": 3.14,
      "roas": 14.18,
      "currency": "USD"
    },
    {
      "product_title": "Samsung Galaxy S24 256GB",
      "product_id": "online:en:US:67890",
      "brand": "Samsung",
      "category": "Electronics > Mobile Phones",
      "country": "US", 
      "date": "2024-03-15",
      "clicks": 1923,
      "impressions": 38476,
      "ctr": 5.00,
      "conversions": 89,
      "conversion_value": 78452.00,
      "cost": 6234.56,
      "cpc": 3.24,
      "roas": 12.59,
      "currency": "USD"
    }
  ],
  "summary": {
    "total_rows": 2,
    "total_clicks": 4770,
    "total_impressions": 83706,
    "average_ctr": 5.70,
    "total_conversions": 216,
    "total_conversion_value": 205325.00,
    "total_cost": 15179.79,
    "average_cpc": 3.18,
    "average_roas": 13.52
  },
  "date_range": {
    "start_date": "2024-03-15",
    "end_date": "2024-03-15"
  },
  "account_info": {
    "account_id": "123456789",
    "account_name": "Main Store GMC"
  }
}

Report Fields:

Field	Description
Product Info	Product title, ID, brand, category
Performance Metrics	Clicks, impressions, CTR, conversions
Financial Metrics	Revenue, cost, CPC, ROAS
Dimensions	Geographic, temporal, device breakdowns
Summary Stats	Aggregated totals and averages

---

Credit Cost

• Cost per run: 1 credit

---

Common Workflows

Performance Dashboard:

[Select Accounts] → [Get Report] → [Calculate KPIs] → [Generate Dashboard] → [Schedule Updates]

Product Optimization:

[Get Report] → [Identify Low Performers] → [Get Price Suggestions] → [Optimize Listings]

Trend Analysis:

[Get Report - Period 1] → [Get Report - Period 2] → [Compare Performance] → [Identify Trends]

ROI Analysis:

[Get Report] → [Calculate ROAS] → [Filter Profitable Products] → [Scale Campaigns]

---

Report Types

Product Performance Report

Track individual product metrics:

Dimensions: Product, Brand, Category
Metrics: Clicks, Conversions, Revenue, ROAS
Use Case: Product-level optimization

Geographic Performance Report

Analyze regional performance:

Dimensions: Country, Region, City
Metrics: Impressions, Clicks, Conversion Value
Use Case: Geographic targeting optimization

Trend Analysis Report

Monitor performance over time:

Dimensions: Date, Week, Month
Metrics: All key performance indicators
Use Case: Seasonal analysis and forecasting

Brand Comparison Report

Compare brand performance:

Dimensions: Brand, Product Category
Metrics: Market Share, Revenue, Profitability
Use Case: Brand strategy and positioning

Campaign Performance Report

Evaluate shopping campaigns:

Dimensions: Campaign, Ad Group, Product
Metrics: Cost, Conversions, ROAS, CPC
Use Case: Campaign optimization and budget allocation

---

Analysis Examples

Top Performing Products

Metrics: Conversions, Conversion Value, ROAS
Dimensions: Product, Brand
Sort: Conversion Value (Descending)
Limit: 50
Filter: ROAS > 3.0

Underperforming Categories

Metrics: CTR, Conversion Rate, ROAS
Dimensions: Category, Brand
Sort: ROAS (Ascending)
Filter: Impressions > 1000 AND ROAS < 2.0

Seasonal Trends

Metrics: Clicks, Conversions, Revenue
Dimensions: Date, Product Category
Date Range: Last 12 months
Filter: Category contains "Holiday"

Mobile vs Desktop Performance

Metrics: Clicks, Conversions, Revenue
Dimensions: Device, Product Category
Date Range: Last 30 days
Compare: Mobile vs Desktop performance

---

Tips

Report Configuration:

• Start with key metrics (clicks, conversions, revenue) then add specific metrics
• Use dimensions strategically - too many can make data hard to analyze
• Apply date ranges that match your business cycles
• Filter data to focus on relevant segments

Performance Analysis:

• Look for trends rather than single-day fluctuations
• Compare periods to identify changes and opportunities
• Segment by dimensions to find specific insights
• Monitor ROAS closely for profitability tracking

Data Interpretation:

• High impressions + low clicks = visibility issues or poor product appeal
• High clicks + low conversions = landing page or pricing issues
• Good ROAS = successful products worth scaling
• Low CTR = need better product titles/images

Optimization Strategy:

• Identify top performers and increase their visibility
• Find underperformers and optimize or pause them
• Analyze seasonality for better inventory planning
• Track competitor impacts through performance changes

Workflow Integration:

• Combine with product data for comprehensive analysis
• Use with price benchmarks for competitive insights
• Feed into automated optimization workflows
• Schedule regular reports for ongoing monitoring