Who can use this: Tech admin
Available on: Data Cloud
Gong is updating how the WEEK field represents submissions made for a future fiscal period in the FORECAST_SUBMISSIONS and FORECAST_SUBMISSIONS_HISTORY tables. WEEK can now hold negative integers for submissions made before the forecast period. This change takes effect on October 14, 2026. This change may affect your queries, filters, reports, or dashboards that use Forecast submission data.
What changed
The WEEK field now records how many weeks before the period type begins a submission was made. If the period type is a quarter, then it’s how many weeks before the start of the quarter.
This is in addition to existing behavior: active-period submissions continue to use positive WEEK values as before. Because multiple future period submissions are now stored separately, you may also see more data per fiscal period than before.
Understand negative WEEK values
Before this change, every submission made for a future fiscal period was stored as WEEK = 0, regardless of when it was submitted in the run-up to that period.
With this change, future period submissions can now have negative WEEK values. WEEK = -1 is the last cadence week before the fiscal period starts. Earlier weeks have lower values: WEEK = -2, WEEK = -3, and so on. There is no lower limit. Existing future period submissions will remain as WEEK = 0. These will be updated in the future to reflect the correct negative values.
The following table shows how this applies to a 13-week quarter:
When the submission was made | WEEK before this change | WEEK after this change |
|---|---|---|
Submission made 1 week before the beginning of next Quarter | 0 | -1 |
Submission made 4 weeks before the beginning of next Quarter | 0 | -4 |
Submission made on the 3rd week of the current Quarter | 3 | 3 (unchanged) |
What you may need to review
If your queries, reports, dashboards, or downstream tables include logic based on Forecast submission data, check for the following:
Anything that filters or queries on WEEK = 0 or assumes WEEK is non-negative: WEEK can now be negative for future period submissions. Conditions like
WEEK = 0orWEEK >= 0may no longer capture all future period data.Anything built on Forecast submission data that expects one row per period type (quarter or month) for future submissions: You may now see multiple rows per fiscal period, one for each cadence week in which a submission was made.
Frequently asked questions
Does this change affect WEEK values for submissions made during the current fiscal period?
No. WEEK values for submissions made while the fiscal period is already underway (positive integers) are not affected. Only submissions made before the fiscal period starts are changing from WEEK = 0 to negative values.
How do I identify which fiscal period a submission is for?
Use the PERIOD_TYPE, PERIOD_YEAR, and PERIOD_NUMBER fields. These fields identify the fiscal period and are not changing.
Will existing WEEK = 0 rows still appear after this change?
[VERIFY: The behavior of existing WEEK = 0 rows is not yet confirmed. This answer will be filled in before the article is published.]