מגלים את הסביבה התחרותית

SELECT
  report_country_code,
  report_category_id,
  traffic_source,
  domain,
  is_your_domain,
  rank,
  ads_organic_ratio,
  page_overlap_rate,
  higher_position_rate,
  relative_visibility
FROM competitive_visibility_competitor_view
WHERE date BETWEEN '2023-06-02' AND '2023-06-27'
  AND report_country_code = 'US'
  AND report_category_id = 536
  AND traffic_source = 'ADS'
ORDER BY rank

{
  "results": [
    {
      "competitiveVisibilityCompetitorView": {
        "reportCountryCode": "US",
        "reportCategoryId": "536",
        "trafficSource": "ADS",
        "domain": "examplepetstore.com",
        "isYourDomain": false,
        "rank": "4",
        "adsOrganicRatio": 8,
        "pageOverlapRate": 0.19,
        "higherPositionRate": 0.46,
        "relativeVisibility": 0.5
      }
    },
    {
      "competitiveVisibilityCompetitorView": {
        "reportCountryCode": "US",
        "reportCategoryId": "536",
        "trafficSource": "ADS",
        "domain": "example.com",
        "isYourDomain": true,
        "rank": "5",
        "adsOrganicRatio": 30,
        "pageOverlapRate": 1,
        "higherPositionRate": 0,
        "relativeVisibility": 0
      }
    },
  ]
}

SELECT
  report_country_code,
  report_category_id,
  traffic_source,
  domain,
  is_your_domain,
  rank,
  ads_organic_ratio,
  page_overlap_rate,
  higher_position_rate
FROM competitive_visibility_top_merchant_view
WHERE date BETWEEN '2022-08-01' AND '2022-09-01'
  AND report_country_code = 'US'
  AND report_category_id = 100
  AND traffic_source = 'ORGANIC'
ORDER BY rank

{
  "results": [
    {
      "competitiveVisibilityTopMerchantView": {
        "reportCountryCode": "US",
        "reportCategoryId": "100",
        "trafficSource": "ORGANIC",
        "domain": "examplepetstore.com",
        "isYourDomain": false,
        "rank": "1",
        "adsOrganicRatio": 0.2,
        "pageOverlapRate": 0.3,
        "higherPositionRate": 0.45
      }
    },
    {
      "competitiveVisibilityTopMerchantView": {
        "reportCountryCode": "US",
        "reportCategoryId": "100",
        "trafficSource": "ORGANIC",
        "domain": "example.com",
        "isYourDomain": false,
        "rank": "2",
        "adsOrganicRatio": 5,
        "pageOverlapRate": 0.67,
        "higherPositionRate": 0.89
      }
    },
  ]
}

SELECT
  report_country_code,
  report_category_id,
  traffic_source,
  date,
  your_domain_visibility_trend,
  category_benchmark_visibility_trend
FROM competitive_visibility_benchmark_view
WHERE date BETWEEN '2022-09-01' AND '2022-09-07'
  AND report_country_code = 'US'
  AND report_category_id = 100
  AND traffic_source = 'ORGANIC'
ORDER BY date

{
  "results": [
    {
      "competitiveVisibilityBenchmarkView": {
        "date": {
          "year": 2022,
          "month": 9,
          "day": 1
        },
        "reportCountryCode": "US",
        "reportCategoryId": "100",
        "trafficSource": "ORGANIC",
        "yourDomainVisibilityTrend": 0,
        "categoryBenchmarkVisibilityTrend": 0
      }
    },
    {
      "competitiveVisibilityBenchmarkView": {
        "date": {
          "year": 2022,
          "month": 9,
          "day": 2
        },
        "reportCountryCode": "US",
        "reportCategoryId": "100",
        "trafficSource": "ORGANIC",
        "yourDomainVisibilityTrend": 0.3,
        "categoryBenchmarkVisibilityTrend": -0.15
      }
    },
  ]
}