# Number of times form filled out

## Number of times form filled out

Currently, the only way to see the number of times a form was filled out (not the number of leads that filled out the form) is by looking at the number of conversions on the Landing Page report.

This means that it is impossible to get the number of form fillouts for forms that are not on a Marketo landing page (for example, embedded forms, or forms that have data posted to them via the Forms 2.0 API).

This is such a fundamental Marketing metric, there really needs to be a way to see the number of times that data is submitted to a Marketo form, regardless of how it is sent (via a landing page, via an embed, or an API call).

Thanks!
Natalie

Level 10 - Champion Alumni
Agreeded, Natalie!  I would like to see to something similar to the Statistics you see when you click on a landing page in Marketing Activites for forms as well.
Level 6

It would also be great to have a report that you could view the daily totals of the number of leads who filled out the form.

Anonymous
Not applicable

I actually figured out a way to do this, but it involves some grunt work in Excel. Here's how it works.

You set up a smart list to show the number of leads who filled out the form with a constraint of "Min. number of times" = 1.

When you run the smart list it will return a number, let's say 5648.

You then change the number to Min. number of times = 2. Let's say that returns 2324.

So in Excel:

Form fills     Count

1                 5648

2                 2324

You subtract the number of people who filled out the form at least twice, from the number of people who filled it out at least once.

This will give you the total count of leads who filled out the form ONLY ONCE. 3324.

You keep increasing the minimum number until it returns 0 leads. Let's say we get valid numbers up through 6 form fillouts, "Minimum number of times = 7" returns 0. That means nobody filled it out 7 times or any number of times larger than 7.

So you end up with a table that looks like this, once you know the exact number of form fills, you multiply that by the number to get total fills.

Form Fills     Count     Exact #      # of Fills

1                    5648     3324          3324

2                    2324     1324          2648

3                    1000       500          1500

4                     500        400          1600

5                    100          88             440

6                    12            12               72

7                      0             0                 0

So on this particular form, 5,648 leads filled it out at least once. However because they filled it out multiple times, in this completely made up example they filled out the form 9,584 times.

You'll see interesting patterns here... the 500 people who filled out the form exactly 3 times accounted for 1500 fills, however the 400 people who filled it out 4 times resulted in 1600 fills. Even though fewer people filled out the form 4 times, it accounts for more of the total fills.

EDIT - I wrote this up as a blog post with better screenshots showing how to set up the table in Excel:
Fun With Data: Count the Number of Form Fills

Anonymous
Not applicable

Very cool! Thanks Jordan!

Now if only Marketo had this as a built-in report...

Natalie Lambert

Digital Marketing Specialist

866-932-1801 ext 924 (Toll-Free)

700 St-Antoine Est, Suite 300, Montreal, QC, H2Y 1A6

www.lightspeedpos.com | Unsubscribe

<http://www2.lightspeedpos.com/Internal-IP-test.html>

On Wed, Jul 29, 2015 at 5:24 PM, Jordan Lund <marketingnation@marketo.com>

Anonymous
Not applicable

I think it's that whole "math" thing. Marketo is a very good tool and it's very good at what it does, it's just not a Spreadsheet.

Community Manager
Status changed to: Open Ideas

Level 2

We moved recently from HubSpot to Marketo, and although Marketo is very strong at several areas, I was very surprised that things I took for granted in HubSpot which are indeed basic metrics that we need to evaluate leads on are not available in Marketo and very hard to replicate (without Javascript or coding). Things like counting the number of pages viewed, emails opened, clicked, forms submitted...etc.

Here are 2 screenshots from HubSpot where we can see default properties that HubSpot generates where you can even filter by how many times or add a time frame for almost all of these properties. This idea post is posted more than 6 years ago and till today Marketo didn't catch up, I hope this changes soon!