Main table for building analytics of task and promotion plans. Combines two types of plans — "task" (visits) and "promotion" (promo activities) from the sources info_plandetail and info_planpreparation.
| Field Name | Short Description |
|---|---|
| key_plan_brand_id | Brand identifier |
| key_plan_category_id | Category identifier |
| key_plan_client_id | Client identifier in the plan (for companies, multiplied by -1) |
| key_plan_date | Planned date in the format: weekday, day, month, year |
| key_plan_id | Plan identifier (info_plan.id) |
| key_plan_target_id | Target group identifier |
| key_plan_tasktype_id | Task type identifier |
| key_plan_user_id | User identifier |
| key_task_plan | Visit identifier |
| plan_name | Plan type: task — regular tasks promotion — promotional activities |
| plan_pokr | Coverage indicator (for visits only) |
| plan_promocount | Promo material calculation (taskcount × promocount, only for tasks) |
| plan_taskcount | Number of visits in the plan |