generator.explores.funnel_analysis_explore

 1"""Funnel Analysis explore type."""
 2
 3from __future__ import annotations
 4
 5from pathlib import Path
 6from typing import Any, Dict, Iterator, List, Optional
 7
 8from ..views import View
 9from . import Explore
10
11
12class FunnelAnalysisExplore(Explore):
13    """A Funnel Analysis Explore, from Baseline Clients Last Seen."""
14
15    type: str = "funnel_analysis_explore"
16    n_funnel_steps: int = 4
17
18    @staticmethod
19    def from_views(views: List[View]) -> Iterator[FunnelAnalysisExplore]:
20        """
21        If possible, generate a Funnel Analysis explore for this namespace.
22
23        Funnel analysis explores are only created for funnel_analysis views.
24        """
25        for view in views:
26            if view.name == "funnel_analysis":
27                yield FunnelAnalysisExplore(
28                    "funnel_analysis",
29                    {"base_view": view.name},
30                )
31
32    @staticmethod
33    def from_dict(name: str, defn: dict, views_path: Path) -> FunnelAnalysisExplore:
34        """Get an instance of this explore from a dictionary definition."""
35        return FunnelAnalysisExplore(name, defn["views"], views_path)
36
37    def _to_lookml(self, v1_name: Optional[str]) -> List[Dict[str, Any]]:
38        view_lookml = self.get_view_lookml("funnel_analysis")
39        views = view_lookml["views"]
40        n_events = len([d for d in views if d["name"].startswith("step_")])
41        defn: List[Dict[str, Any]] = [
42            {
43                "name": "funnel_analysis",
44                "description": "Count funnel completion over time. Funnels are limited to a single day.",
45                "view_label": " User-Day Funnels",
46                "always_filter": {
47                    "filters": [
48                        {"submission_date": "14 days"},
49                    ]
50                },
51                "joins": [
52                    {
53                        "name": f"step_{n}",
54                        "relationship": "many_to_one",
55                        "type": "cross",
56                    }
57                    for n in range(1, n_events + 1)
58                ],
59                "sql_always_where": "${funnel_analysis.submission_date} >= '2010-01-01'",
60            },
61            {"name": "event_names", "hidden": "yes"},
62        ]
63
64        return defn