How can I compile a list of all forms used in a specified time period?

Stephen_Usher
Level 1

How can I compile a list of all forms used in a specified time period?

Is there any way to do this? We have many forms in our instance but they are not all in use. For GDPR I am trying to put together a list of all the forms filled out in the past 3 months to know where we should be focusing first. Is there any way to pull this information together other than a smart list that pulls in all form fills during this time and then going through each individuals activity record to find what form they filled out? This is obviously not a great way to do it when we are considering several thousands of leads during this time period. Thanks!

9 REPLIES 9
Tom_Kerlin2
Level 8

Re: How can I compile a list of all forms used in a specified time period?

Marketo doesn't have a stand-alone form report, but form fill information (i.e. conversion numbers) can be found by creating a Landing Page Performance Report. In the report's Setup tab, specify the date of activity and then view the report to see the conversion metrics. If you export the report and then filter out the landing pages with "0" conversions, you'll have all of the landing pages, and by extension all forms, used in a specified time period. It will take some time, but you can go back and make note of all of the forms that are currently being used on those landing pages.

Also, you can vote on some ideas by clicking on links below:

1.)

2.)

3.)

Note: Approaching this way will only work for forms hosted on Marketo landing pages or forms that are iframed on your website.

Tom Kerlin
SanfordWhiteman
Level 10 - Community Moderator

Re: How can I compile a list of all forms used in a specified time period?

I'd extract the Activity Logs via API for those 3 months and search that way. That's the way to get the results for all forms (embedded and named).

Anonymous
Not applicable

Re: How can I compile a list of all forms used in a specified time period?

How would you do that  Sanford?

SanfordWhiteman
Level 10 - Community Moderator

Re: How can I compile a list of all forms used in a specified time period?

How would you do that Sanford?

Have you read the API docs on https://developer.marketo.com?

Either the Bulk Extract or Bulk Export APIs can be used.

Anonymous
Not applicable

Re: How can I compile a list of all forms used in a specified time period?

What I mean is ....how can you find out if you have 1000 forms via Marketo which ones are being actively used and which ones are not being used?

Nimisha

SanfordWhiteman
Level 10 - Community Moderator

Re: How can I compile a list of all forms used in a specified time period?

  • You get your Activity Logs for the Filled Out Form activity via the API.
  • You group the activity entries by Form ID to determine which ones to consider "active"
  • You compare to the list of all forms.
Anonymous
Not applicable

Re: How can I compile a list of all forms used in a specified time period?

Hi Sanford,

I am still lost...there is a lot of code I see on the pages you provided.

Is there any easy way to understand and do this? Which step is easy to complete...considering I am not from coding background?

  • You get your Activity Logs for the Filled Out Form activity via the API.
  • You group the activity entries by Form ID to determine which ones to consider "active"
  • You compare to the list of all forms.
SanfordWhiteman
Level 10 - Community Moderator

Re: How can I compile a list of all forms used in a specified time period?

...considering I am not from coding background?

You can't do this if you aren't a coder.

Anonymous
Not applicable

Re: How can I compile a list of all forms used in a specified time period?

oh ok