Portfolio Performance

With these queries you can get daily but also aggregated performance totals per provider.

Aggregated Performance

Apollo Studio

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

fragment PerformanceMetric on PerformanceMetric {
  value
  adSpend
  costRatio
  roas
}

Funnel step performance

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

fragment PerformanceMetric on PerformanceMetric {
  value
  adSpend
  costRatio
  roas
}