daily_product_certificates

Certificates per course, per day. Lets you rank products by completion volume and measure the impact of campaigns on specific courses.

• Grain: (id_tenant, id_product, date)
• ETL strategy: merge
• PK: (id_tenant, id_product, date)

When to use it

• Ranking courses by completion count.
• Comparing newly launched products against the older catalog over equivalent windows.
• Monitoring the completion curve after a launch.

Columns

Column	Type	Description
id_tenant	BIGINT	FK → tenants.id. Part of PK.
id_product	BIGINT	FK → products.id. Certified product. Part of PK.
date	DATE	Issue day. Part of PK.
issues_total	INTEGER	Total issues (including reissues — a reissue counts as a new row).
issues_unique	INTEGER	Distinct learners who received the certificate that day.

The difference issues_total - issues_unique ≈ reissues.

Usage pattern

-- Top 10 courses by certifications in the last quarter
SELECT id_product,
       sum(issues_unique) AS certified_learners,
       sum(issues_total)  AS issues
FROM metrics.daily_product_certificates
WHERE date >= current_date - interval '90 days'
GROUP BY id_product
ORDER BY certified_learners DESC
LIMIT 10;