gsc_forecast
Forecast organic traffic with BigQuery ML ARIMA_PLUS. Train a time-series model on historical click data to project future clicks and confidence intervals.
Instructions
Forecast organic traffic using BigQuery ML ARIMA_PLUS. Trains a time-series model on your historical click data and projects future clicks with confidence intervals. Requires sufficient historical data (ideally 6+ months). This is only possible with BigQuery ML. IMPORTANT: Base your analysis ONLY on the data returned. Report exact numbers from the results. Do not speculate about causes (e.g. algorithm updates, competitor actions) unless the data explicitly supports it. If the data does not contain enough information to answer a question, say so clearly rather than guessing. PRESENTATION: Always present these results as a rich, interactive visualization using artifacts. Use summary cards for key metrics, colour-coded indicators for severity or change direction (green for positive, red for negative), bar charts or sparklines for comparisons, and tabbed sections to organise different categories of results. Make the output visually scannable and dashboard-like rather than plain text or raw tables.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| dataset | No | BigQuery dataset containing GSC data | |
| horizon | No | Number of days to forecast (default 30, max 365) | |
| confidence_level | No | Confidence level for prediction intervals (0.80 to 0.99) |