Skip to main content
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

FieldTypeRequiredDescription
AccountDropdownYesGoogle Merchant Center account to query
MetricsMulti-selectYesPerformance metrics to retrieve
DimensionsMulti-selectNoData breakdown dimensions
Date RangeDate PickerYesTime period for the report
FiltersFilter BuilderNoConditions to filter the data
SortDropdownNoHow to sort the results
LimitNumberNoMaximum number of rows to return

​
Available Metrics

MetricDescriptionUse Case
ClicksNumber of product clicksTraffic analysis
ImpressionsProduct impression countVisibility tracking
CTRClick-through ratePerformance efficiency
ConversionsConversion eventsSales tracking
Conversion ValueRevenue from conversionsRevenue analysis
CostAdvertising costBudget tracking
CPCCost per clickBid optimization
ROASReturn on ad spendROI analysis

​
Available Dimensions

DimensionDescriptionUse Case
ProductIndividual productsProduct-level analysis
BrandProduct brandsBrand performance
CategoryProduct categoriesCategory analysis
CountryGeographic locationRegional performance
DeviceDevice typeDevice targeting
DateTime periodsTrend analysis
ChannelShopping channelChannel comparison
CampaignCampaign namesCampaign performance

​
Date Range Options

OptionDescriptionUse Case
Last 7 daysRecent weekShort-term trends
Last 30 daysRecent monthMonthly analysis
Last 90 daysQuarterly viewSeasonal trends
Last 12 monthsAnnual viewYear-over-year comparison
Custom RangeSpecific datesTargeted analysis
Compare PeriodsPeriod comparisonPerformance 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:

FieldDescription
Product InfoProduct title, ID, brand, category
Performance MetricsClicks, impressions, CTR, conversions
Financial MetricsRevenue, cost, CPC, ROAS
DimensionsGeographic, temporal, device breakdowns
Summary StatsAggregated 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

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
⌘I