Skip to main content

Notifications

Customer Insights - Journeys forum

Report showing all form submissions across multiple forms?

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

We are in the process of transitioning from ClickDimensions to Dynamics for Marketing.  WIth ClickDimensions, there was a 'Posted Forms' view which would give me a report of all posted form records over a specified date range (the form name, the contact name, form submission date, etc).

I'm having trouble finding a similar view in Dynamics for Marketing.  I can use the insights to see submissions to one form at a time, but I would like a summary view for all (we have over 100 forms so reviewing submissions one at a time is not sustainable).

Any tips on how to pull a report of all submissions over a specified date range?  Thanks!

  • tcmanders Profile Picture
    tcmanders 27 on at
    RE: Report showing all form submissions across multiple forms?

    Hello Christian,

    I am running into an issue when using the report template for Form Submissions. I get an error that the field 'SubmittedValues' is not found in the FormSubmitted table. This is causing the rest of the data to fail to load. I can validate that there is at least one form with submissions and I can see the submitted values in the D4M interface.  Any ideas on how to resolve this?  The other MarketingAnalyzer templates that do not pull in Form Submissions work fine and pull in the data.

    Thank you.

    Tim Manders

  • Suggested answer
    RE: Report showing all form submissions across multiple forms?

    Hallo Jason,

    while we have not an overarching insights view for form submissions across all forms, Campaigns, etc. directly in the Dynamics 365 Marketing product it is not to hard to create a Power BI report for the same.

    For your convenience I have made a quick report using our marketing reporting capabilities for Power BI. Please find the template for download here

    It contains a homepage for all the forms you may have, the form submission timeline, submission details view and a breakdown for the submitted values. Find an overview of the report here.

    Homepage

    pastedimage1569237720564v1.png

    Submission timeline

    pastedimage1569237765811v2.png

    Submission detail view

    pastedimage1569237805583v3.png

    Submission value breakdown

    pastedimage1569237849168v4.png

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,965 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,817 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans