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

[Stephen_Usher]

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!

[Tom_Kerlin2]

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.

[SanfordWhiteman]

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]

How would you do that  Sanford?

[SanfordWhiteman]

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]

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]

• 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]

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]

...considering I am not from coding background?

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

[Anonymous]

oh ok