Custom activity based newsletters

[ArnoldMA]

Hi All! 

If we need to accomplish the send of a custom, specific user activity-based newsletter that sends weekly/monthly to all users of a custom app... How would we accomplish this? Think Fitbit weekly activity report they email to all users. 

More specifically: 
How would we create a template inside of HubSpot that pulls in specific user information according to the template sections (Perhaps the top displays how many in-app friends they connected with and the middle section displays how many goals tey achieved, and the bottom tells them what % of their goal they have left to attain) 

How do we get this to send to ONLY the user whose data is pulled into it, and then do that for EVERY app user we have? 

And finally, how do we get this data from the custom-built app into  HubSpot in a way that makes it useful and accessible to this type of requirement? 

Thanks! 

PS. We have a full dev team, whatever we need to build we will build it. Just looking for some direction to get us started.

[ArnoldMA]

Wow thanks for the great response, I'll review this with our developers and check back in if we have follow-up questions. 

[JPanama · Accepted solution]

Hi @ArnoldMA, 

Thanks for getting in touch. Sounds like a great idea and I think we have just the thing to get you started. If you have a CMS Hub Pro or Enterprise, or Marketing Hub Enterprise subscription you can make use of HubDB. 

You can store you app data within tables in HubDB, from there HubDB data can then be retrieved a few ways, depending on your use case. You can: 

•  Query the data externally via the HubDB API 
• Use HubSpot’s HubL markup tags to pull data into the CMS.
• Use the HubDB API with serverless functions to provide an interactive web app experience.

Once you've managed to bridge the gap between your external data and HubDb, you can then render that data in your Marketing Emails using personalisation tokens. You could do this using the Progammable Email feature.

If you're not familiar with HubL, it's our HubSpot Markup Language which is an extension of Jinjava. You can use HubL alongside the Programmable Email beta to pull your HubDB data directly into your Marketing Emails. 

Let me know if you have any questions on this! 

Best, 
Joe (HubSpot Moderator)