Portfolio Performance

With these queries you can get daily but also aggregated performance totals per provider. Learn more about how to use metrics.

Aggregated Performance

Apollo Studio

query PortfolioV2ContentMetrics($teamId: Int!, $portfolioId: Int!, $period: DateRangeInput!) {
  portfolioV2(teamId: $teamId, portfolioId: $portfolioId) {
    performance(period: $period) {
      funnelSteps {
        funnelStep {
          isAttributed
          isMeasured
          title
          type
        }
        metricTotals {
          providers {
            providerId
            total {
              ...PerformanceMetric
            }
          }
        }
      }
    }
  }
}

fragment PerformanceMetric on PerformanceMetric {
  value
  adSpend
  costRatio
  roas
}

Daily metrics (all funnel steps)

Returns a time-series of daily values for every funnel step in the portfolio at once. Use this to detect seasonal patterns and trends without needing to know the funnel step IDs in advance.

query PortfolioDailyMetrics($teamId: Int!, $portfolioId: Int!, $period: DateRangeInput!) {
  portfolioV2(teamId: $teamId, portfolioId: $portfolioId) {
    performance(period: $period) {
      funnelSteps {
        funnelStep {
          isAttributed
          isMeasured
          title
          type
        }
        dailyMetrics {
          day
          providers {
            providerId
            value {
              adSpend
              value
              roas
              costRatio
            }
          }
        }
      }
    }
  }
}

Daily metrics (single funnel step)

When you only need data for one specific funnel step, pass its ID to narrow the response. This variant also exposes per-content breakdowns.

query FunnelStepPerformance($teamId: Int!, $portfolioId: Int!, $period: DateRangeInput!, $funnelStepId: Float!) {
  portfolioV2(teamId: $teamId, portfolioId: $portfolioId) {
    performance(period: $period) {
      funnelStep(funnelStepId: $funnelStepId) {
        funnelStep {
          funnelStepId
          isAttributed
          isMeasured
          title
          type
        }
        dailyMetrics {
          day
          contents {
            contentId
            title
            isIncludedInOptimization
            providerId
            value {
              ...PerformanceMetric
            }
          }
          providers {
            providerId
            value {
              ...PerformanceMetric
            }
          }
        }
      }
    }
  }
}

fragment PerformanceMetric on PerformanceMetric {
  value
  adSpend
  costRatio
  roas
}