Understanding the Challenge
A community member asked about identifying cloud pages with submissions in the last x days or months, and while there isn’t a straightforward data view that provides this information, there are alternative approaches to achieve this goal.
One possible solution is to look at the target of the submission, such as a Data Extension (DE), and check for record creation timestamps or monitor the DE for changes.
Alternative Approaches
Another approach is to build routines that send daily updates about new record creations, as suggested by a community member.
Additionally, analytics can be used to monitor submit events on cloud pages, providing valuable insights into page activity.
The root cause of this challenge is the lack of a built-in data view that provides a straightforward way to identify cloud pages with recent submissions.
Implementing a Solution
To identify cloud pages with recent submissions, you can use the “_Submissions” data view and filter the results by submission date.
SFMC Query Example
SELECT * FROM _Submissions WHERE SubmissionDate > DATEADD(DAY, -30, GETDATE())
Heads up: Make sure to adjust the date filter to match your specific requirements.
Best Practices
Checklist for Identifying Active Cloud Pages
- Use the “_Submissions” data view to identify cloud pages with recent submissions
- Filter the results by submission date to focus on recent activity
- Monitor analytics for submit events on cloud pages
- Build routines to send daily updates about new record creations
- Regularly review and update cloud pages to ensure they remain active and relevant
What is the best way to identify cloud pages with recent submissions?
Use the “_Submissions” data view and filter the results by submission date.
Can I use analytics to monitor submit events on cloud pages?
Yes, analytics can be used to monitor submit events on cloud pages, providing valuable insights into page activity.
How often should I review and update cloud pages?
Regularly review and update cloud pages to ensure they remain active and relevant.
What is the purpose of building routines to send daily updates about new record creations?
Building routines to send daily updates about new record creations helps to identify cloud pages with recent submissions and stay on top of page activity.
Need help shipping this in production?
Genetrix builds and untangles Salesforce Marketing Cloud and Agentforce setups for teams that want it done right the first time. If anything in this post sounds familiar, talk to us before it ships.