Data is not populating in pgehres.donatewiki_counts for some recent email sends, despite them having donations.
Query below:
SELECT
CASE
WHEN donatewiki.utm_source IN ('70761231')
THEN 'sp70761231'
ELSE donatewiki.utm_source
END AS utm_source,
SUM(donatewiki.count) AS donatewiki_clicks
FROM pgehres.donatewiki_counts AS donatewiki
where donatewiki.utm_source in
('sp73399844',
'sp73399864',
'sp73399872',
'sp73399880',
'sp73399857',
'sp73399879',
'sp73399852',
'sp73399875')
GROUP BY
CASE
WHEN donatewiki.utm_source IN ('70761231')
THEN 'sp70761231'
ELSE donatewiki.utm_source
END;