שיפור התמחור

SELECT
  product_view.id, product_view.title, product_view.brand,
  product_view.price_micros, 
  product_view.currency_code, price_insights.suggested_price_micros,
  price_insights.suggested_price_currency_code,
  price_insights.predicted_impressions_change_fraction,
  price_insights.predicted_clicks_change_fraction,
  price_insights.predicted_conversions_change_fraction
FROM PriceInsightsProductView

{
  "results": [
    {
      "productView": {
        "id": "online:en:US:12345",
        "title": "UGG Women's s Classic Mini",
        "brand": "UGG",
        "priceMicros": "124990000"
        "currencyCode": "USD"
      }
      "priceInsights": {
        "suggestedPriceMicros": "135680000",
        "suggestedPriceCurrencyCode": "USD",
        "predictedImpressionsChangeFraction": "0.12609300017356873",
        "predictedClicksChangeFraction": "0.508745014667511",
        "predictedConversionsChangeFraction": "2.3431060314178467"
      }
    },
    {
      "productView": {
        "id": "online:en:US:12346",
        "title": "Nike React Infinity Run Flyknit 2",
        "brand": "Nike",
        "categoryL1": "Apparel & Accessories",
        "priceMicros": "119990000"
        "currencyCode": "USD"
      }
      "priceInsights": {
        "suggestedPriceMicros": "125440000",
        "suggestedPriceCurrencyCode": "USD",
        "predictedImpressionsChangeFraction": "0.1799899935722351",
        "predictedClicksChangeFraction": "0.6203680038452148",
        "predictedConversionsChangeFraction": "1.234868049621582"
      }
    },
    {
      "productView": {
        "id": "online:en:US:12347",
        "title": "  New Balance 327 White Trainers",
        "brand": "New Balance",
        "categoryL1": "Apparel & Accessories",
        "priceMicros": "84990000"
        "currencyCode": "USD"
      }
      "priceInsights": {
        "suggestedPriceMicros": "82000000",
        "suggestedPriceCurrencyCode": "USD",
        "predictedImpressionsChangeFraction": "0.11538799852132797",
        "predictedClicksChangeFraction": "0.5869849920272827",
        "predictedConversionsChangeFraction": "1.3622850179672241"
      }
    }
  ]
}