ODBC guide

Generate subscription report

Gets subscription report data for a date range, products, and group-by columns. Use get_subscription_report with WITH parameters such as StartDate, EndDate, Country, ProductPaths, ReportColumns, and GroupByColumns.

SELECT *
FROM get_subscription_report
ORDER BY transaction_date
WITH (
	  Country='AL~UA~US'
	, ProductPaths='odbc-pp-ent-sub~odbc-pp-pro-sub~odbc-pp-std~ssis-pp-pro-sub~ssis-pp-std-sub~ssis-pp-ent-sub'
	, StartDate='monthstart-1m' --or  2022-01-01
	, EndDate='monthend+2d' --or  2022-01-01
	, ReportColumns='transaction_date~transaction_month~transaction_year~activations~average_mrr~cancellations~mrr~new_subscribers~subscriptions'
	, GroupByColumns='transaction_date~transaction_month~transaction_year'
)