1. Dataset Name

aii_credits_plan_purchased_data_e858f220

2. Description

A plan-level dataset that lists every AI Interviewer credit plan purchased by the customer, with no aggregation applied. Each row represents a single purchased plan, including its opportunity name, product type, purchase date, plan start and end dates, and total credits allocated. This dataset powers a row-level audit table of the customer's complete credit purchase history on the AI Interviewer dashboard.

3. Source Tables

• customer_views.ai_credit_purchased_data (sole source table — no joins)

4. Grain

One row per purchased credit plan. Unlike the interview-level credit metrics in ai_interview (which derive total_credits_purchased as a SUM grouped by group_id), this dataset is unaggregated — each plan appears exactly once, with its own start/end dates and individual total_credits value.

5. Dashboards Supported

• AI Interviewer (AII) Dashboard

6. Metrics Supported

7. Known Exclusions / Filters Applied

• No filters, exclusions, or WHERE clauses are applied — this is a direct, unfiltered SELECT from the source table.
• No aggregation is applied; each row represents exactly one purchased plan record, including past, present, and future-dated plans.
• Plans whose start_date has not yet arrived are still included, since there is no date-based scoping in this dataset.

8. Schema