Describe the bug
When frequency of campaigns is > 1, missing values are introduced in the mmm_df table. I assume (haven't checked) that this is because values are joined on an index of sorts.
For example, for three years of data (1095 entries), values are only populated for 546 of them when the campaign length is 2. Similar behavior can be observed for other campaign frequencies - rows are only populated for n/x
rows where n
is the total duration and x
is the campaign duration.
To Reproduce
- Set campaign duration to > 1
Expected behavior
Rows are aggregated to either campaign date period, or values are spread out across dates.
Screenshots
![image](https://private-user-images.githubusercontent.com/8884023/310518459-be3ba723-f51a-4ceb-a01d-b506e7db481e.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MTY3MDQ1NDUsIm5iZiI6MTcxNjcwNDI0NSwicGF0aCI6Ii84ODg0MDIzLzMxMDUxODQ1OS1iZTNiYTcyMy1mNTFhLTRjZWItYTAxZC1iNTA2ZTdkYjQ4MWUucG5nP1gtQW16LUFsZ29yaXRobT1BV1M0LUhNQUMtU0hBMjU2JlgtQW16LUNyZWRlbnRpYWw9QUtJQVZDT0RZTFNBNTNQUUs0WkElMkYyMDI0MDUyNiUyRnVzLWVhc3QtMSUyRnMzJTJGYXdzNF9yZXF1ZXN0JlgtQW16LURhdGU9MjAyNDA1MjZUMDYxNzI1WiZYLUFtei1FeHBpcmVzPTMwMCZYLUFtei1TaWduYXR1cmU9YzVhMzVmZWQwNDBmZmY3MTM2YWIzODAzNmIyNzAyNGFjNjdlN2I1YjQxMWRjYjBkYmFiNjcwMDFhMzQyZDZhZSZYLUFtei1TaWduZWRIZWFkZXJzPWhvc3QmYWN0b3JfaWQ9MCZrZXlfaWQ9MCZyZXBvX2lkPTAifQ.EkRjikv36n0bmXq2q8F-HmFc61NHKSrupqXTu0LnPFQ)
Desktop (please complete the following information):
- OS: Windows 11
- Browser: N/A
- Version: N/A
Additional context
Add any other context about the problem here.