Excel 00.png

Fun With Data: Count the Number of Form Fills

Not applicable

Before I came to Marketo I was a HUGE data guy. I loved spreadsheets, I loved databases. I even used to teach spreadsheet and database design. Yes, it is, indeed, a sickness.


So when a client asked me "How can I see the number of form fillouts? Not the leads, I want to see the total number of fillouts." My reaction was, there has to be a way.


And there is, but it involves taking data in Marketo and analyzing it in Excel.


The secret is the Smart List Filter "Filled Out Form" in conjunction with the constraint of "Min. Number of Times".


Excel 00.png


Let's say you take a particular form and tell Marketo "OK, show me everyone who filled out this form at least once." The smart list comes back with a number of 5289.


You then change the smart list and tell Marketo "OK, now show me everyone who filled out this form at least twice." The smart list comes back with a new number of 2254.


By subtracting the number of people who filled it out at least twice from the number of people who filled it out at least once, that will tell you how many times the form was filled out exactly one time. 3035.


Excel 01.png


So it stands to reason that if we find out how many people filled out the form at least 3 times and subtract that from the number who filled it out at least twice, that will tell us how many folks filled it out exactly twice.


Excel 02.png


Then you keep going until you find the highest minimum number that is not 0. When you put in a minimum number and get 0 leads back, you're done because nobody filled out the form that many times and nobody filled it out more than that. (The highest number of times I saw was 57, that was an internal lead who was testing the form and trying to break it.)


Excel 03.png


Now that you know how many leads filled out the form how many times, you can determine the total number of fills. Take the exact number and multiply it by the minimum number.


So those 400 leads that filled out the form 4 times each generated, on their own, 1,600 form fillouts(!)


Total up the "Total Fills" column and you'll find that this group of 5,289 leads managed to fill out that form 9,155 times.


Excel 04.png

Is this article helpful ?


Level 8 - Champion Alumni

Great stuff, Jordan! I was looking for how to get a the number of form fill outs some time ago, is there any chance this kind of data will become available in Marketo out of the box?

Not applicable

As much as I'd like to see it in Marketo, I don't see it happening. We would need a way to automate a spreadsheet function and that level of math is sort of outside the scope of Marketing Automation.

Not applicable

I recognize I'm nearly a year late to this thread but I was just pointed toward it as I look for a way to do some reporting I need that I'm not finding in Marketo.

That's an interesting process that you described, Jordan. It's a creative way of getting at the issue.

As long as an external tool (in this case Excel) has to be used for analysis (and I would rather use anything but Marketo for analyzing the data), it'd be easier to just see a list of activities, the dates on which they were taken, and the lead (or lead ID) that took the action. I don't see a way to pull that sort of report ... though granted I'm new to Marketo.