Revise Email Template for Follow Notifications

[Mephistic]

Goal

We want the Email Template for Follow Notifications to reflect the most recent design revisions in preparation for the launch.

Figma: https://www.figma.com/design/mpVTvbRTjwxWjrZS9B8HNA/Bills-Details-%26-Mission-Center-V2?node-id=924-3762&t=p26h4zzMmFlZbqpn-0

Success Criteria

• [ ] Emails sent by the Social Layer Notifications look like the spec in the linked Figma

[Mephistic]

Here is the current email template, courtesy of Matt V: https://www.figma.com/design/mpVTvbRTjwxWjrZS9B8HNA/Bills-Details-%26-Mission-Center-V2?node-id=924-3762&t=p26h4zzMmFlZbqpn-0

There are two components here:

• Ensuring we have ready access to the data needed to render the template:
  • Bills with counts of new testimonies + basic bill details (Bill ID, Short Bill Summary, Number of Endorse/Oppose/Neutral since last notification)
  • Open question: What is the max number of bills this should pull? Just 4 like in the design? More? If the number of updated bills goes over the cap, how do we choose which bills to display (and should we warn the user that the bill list is incomplete, or is that redundant with the newsfeed link?)
  • Users/Orgs with new submitted testimony (Top X orgs with Top Y testimonies)
  • Open question: How many orgs should we show? Just 4 like in the design, or more? If there are more orgs with submitted testimonies, how should we select which ones to display? Should we include something to indicate that there are more updates than the ones in the email in this case, should we rework the language so that it's clear the email is just "highlights" rather than a complete summary, or does this not matter?
  • Open question: How many new testimonies should we show? Just 6 like in the design, or more? If the user/org has submitted more testimony than this cap, which testimonies should we include?
• Updating the HTML Email template to reflect the newest design linked above

I'll open new issues for each of these components shortly: the work here is related, but can likely be done in parallel once we agree on a data structure. Some of this work may already be done (especially on the data side, it's not clear what progress was made there before the dev hand-off).

[mvictor55]

1. We can cap the content at 4 orgs/bills. We will add a "see more" button at the bottom of each section (bills + orgs) that directs to the newsfeed.
2. The bills should be shown in order of most testimony received since the previous email update (if not too difficult) - otherwise, random is fine.
3. The orgs should be shown in order of most testimony submitted since the previous email update (if not too difficult) - otherwise, random is fine,
4. I'm not quite sure I get the intent of your last question re "new testimonies". The idea is to show the number of testimonies an org has submitted since the previous email update. There is no cap on the amount of new testimonies an org can submit (other than the fact that they can only submit one testimony per bill and there are 8000+ bills)

Let me know if anything is unclear. In the finalized figmas I'll add annotations explaining the functionality, including the above