How can I track MQL activities per week over time (not just last activity)?

[DDias28]

Hi everyone 👋

I'm trying to set up a report/dashboard in HubSpot to track weekly engagement from MQLs — specifically, I want to know which MQLs performed any kind of activity (email, form, page view, etc.) each week over the last 90 days, and ideally across multiple weeks if they engaged more than once.

Here’s the challenge I’m running into:

• HubSpot’s standard “Last Activity Date” only reflects the most recent action, so if someone engaged in Week 30 and Week 31, only Week 31 shows up — they don’t appear in the Week 30 count.

• I’m using Lead Score/Authority Points to detect activities, but this only helps with identifying that an activity occurred — not when or how often.

• I want a clear view of weekly engagement trends, including repeat engagement from the same contacts over multiple weeks.

Has anyone found a best practice or scalable method for tracking and reporting weekly MQL engagement over time — where a contact can appear in multiple weeks?

Ideally I’d love a no-code or minimal-code solution, but open to using Ops Hub, Zapier, or external tools if needed.

Thanks so much in advance!
– Daniel

[DDias28]

Hi Karsten,

Thanks again for the helpful responses so far — I really appreciate the insights. I wanted to follow up to clarify my use case a bit further, as I think it may have been misunderstood slightly.

My core goal is to track weekly engagement activity from MQLs, but with one specific requirement:

I want contacts to appear in multiple weeks if they performed engagement actions during those weeks.

For example:

• If a contact views a page on Tuesday (Week 30), they appear in Week 30's count.

• If the same contact opens an email on Friday (also Week 30), no problem — still just Week 30.

• But if that same contact submits a form in Week 31, I want them to appear again — now in Week 31 too.

What I’ve found is that most standard HubSpot reporting (e.g., using “Last Activity Date” or aggregated custom reports) only displays the latest activity per contact, so you essentially lose visibility into previous weeks if that same contact engaged again later.

What I’m looking for is a way to generate time series reports where:

• A contact can appear in multiple weeks based on repeated engagement.

• I can filter by MQLs (either current or based on when they were an MQL).

• I can include various activity types: email, forms, page views, etc.

Has anyone had success setting up something like this — where each touchpoint is logged with a date, and then visualized over time, with contacts appearing across weeks based on real engagement?

Thanks again for all your support and ideas!

Best regards,
Daniel

[karstenkoehler]

---

@DDias28 wrote:

I wanted to follow up to clarify my use case a bit further, as I think it may have been misunderstood slightly.

My core goal is to track weekly engagement activity from MQLs, but with one specific requirement:

I want contacts to appear in multiple weeks if they performed engagement actions during those weeks.

By building a report that includes Activities as a data source, you will visualize activities (which appear based on their activity data), meaning you'll see multiple entries per contact, not just one. This requirement is met by building a report that includes Activities.

The "Last activity date" that you're referring to is a contact property – which is not was I was referring to.

---

Generally, you would approach this with the custom report builder: https://knowledge.hubspot.com/reports/create-reports-with-the-custom-report-builder

1. Select data sources Contacts + Activities
2. Filter report by contact Lifecycle stage = MQL
3. On the y-axis place '(Count) activities'
4. On the x-axis place 'Activity date'
5. Break down by 'Activity type

---

[karstenkoehler · Accepted solution]

Hi @DDias28,

HubSpot's reporting is not flexible enough to meet all of your requirements but you can get close.

Generally, you would approach this with the custom report builder: https://knowledge.hubspot.com/reports/create-reports-with-the-custom-report-builder

1. Select data sources Contacts + Activities
2. Filter report by contact Lifecycle stage = MQL
3. On the y-axis place '(Count) activities'
4. On the x-axis place 'Activity date'
5. Break down by 'Activity type'

Now, there are a few disclaimers:

• HubSpot cannot (at least I'm not aware of how) display activites that occurred when the contact was a MQL. It can display the activities that happened for contacts who are now a MQL. Activities might have happened before the contact entered that lifecycle stage and still show in the report. Once a contact leaves the MQL stage, their activities will also disappear.
• To work around that, you can also filter the report by the 'Date entered 'Marketing qualified lead'' property – but it comes with similar issues, just a different flavor.
• The above relates to sales activities. If you want marketing activities (form submissions, page views, marketing email interactions), you would either have to create separate reports or create a custom object where each touchpoint creates a record for that custom object so you can visualize it on a timeline. This would actually also give you the flexibility to only create these records while a contact is a MQL, not after: https://knowledge.hubspot.com/object-settings/create-custom-objects

Overall, this will give you a good overview of activities of contacts who are MQLs but it's important to know how to read the report.

Best regards!