Recurring Task - Fetch analytics data

[LJonnalagadda]

To understand the adoption of eTools across regions and report on a periodic basis. In order to collate data, we would need analytics from PMP by country. This task is to fetch data on the 1st of each month for the previous month.

[LJonnalagadda]

Sample report: pmp_indicator_report.xlsx

[domdinicola]

Columns:

• country
• partner name
• partner type
• PD/SSFA ref (intervention number)
• PD/SSFA status (intervention status)
• PD/SSFA start date (intervention start)
• PD/SSFA end date (intervention end)
• UNICEF US$ cash contribution (intervention total_unicef_cash)
• UNICEF US$ Supply contribution (intervention total_in_kind_amount)
• FR numbers against PD/SSFA (frs intervention_amt)
• Sum of all FR planned amount (sum of all fh.fr_number) for fh in intervention.frs.all
• core value attached (true/false): attachment present or not

[domdinicola]

Rows: one for each intervention