Hi @EYener, @EChetty and I spoke briefly about this and wanted to know the calculated metrics and columns that you would like to add to the existing pageview datasets.
We can decide the best approach once we get an idea of what FR is interested in. Thanks!

@JMando : could you perhaps provide the calculated metrics and columns that FR would like to add to the pageview datasets ?

I believe we wanted to be able to add fiscal year (FY1920, FY2021, FY2122, etc.) along with groupings for our fundraising campaigns using a combo of project and country_code (en6c, India, Japan, Bundle, etc.).

Fiscal Year example code (mysql syntax, but believe we can make something similar work too):

CASE
	WHEN MONTH(date) < 7 THEN CONCAT('FY', RIGHT(CAST(YEAR(date) - 1 AS CHAR), 2),
        RIGHT(CAST(YEAR(date) AS CHAR), 2))
    WHEN MONTH(date) >= 7 THEN CONCAT('FY', RIGHT(CAST(YEAR(date) AS CHAR), 2),
        RIGHT(CAST(YEAR(date) + 1 AS CHAR), 2))
    END AS fiscal_year

India, for example, would be:

project IN ('hi.wikipedia', 'en.wikipedia') AND country_code IN ('IN') THEN 'India Campaign'

Thanks @JMando .
To make sure I understand, something like

1. fiscal_year column for all the records in both the tables
2. fr_campaign column which will be populated for the pageview records where the campaign was running.
   • Example: pageviews from Nov 25 - Dec 31 from US, CA, IE, GB, NZ, AU will have a value like 'en6c Campaign'

That is right. With the addition that we would also want to limit to the language wiki we fundraised in for the campaign (like en.wikipedia for en6c).

Right! ok. I will discuss further with the team and get back to you.