I want to exclude spam submissions from my form conversion reports without deleting them. I want a conversion rate for real contacts by form and preferably broken out by source.
I’ve tried playing with…
attribution reports (missing form data)
ad reports (because that’s really where the problem is but you can’t filter lists or contact properties)
adding a hidden checkbox to the form (didn’t ever get checked)
The leads get labeled as spam in the lead status property so they’re easy to segment but the reports don’t allow filtering across objects like that. The form, web, and ad reports don’t have a way to add a list or contact filter. While there’s probably a solution using scripts through the API, my code-writing skills are still fairly basic.
@DSUrban_TN I’m not sure which report specifically you’re using, so this is a bit of a guess here. But if you’re creating a Contact report for Form submissions during a specific time frame, you can create an active list of lead status = spam, and exclude anoyone on a list as a report filter. Here’s an example of where I’m starting:
From there, creating a view that includes conversion rates will take some work, but filtering by “list membership is not spam” might be what you’re looking for.
Thanks for tapping in! This gets close but wouldn’t quite hit the metrics I’m looking for. The problem lies in the fact that my contacts likely have multiple form fills and have been in the CRM for a while. This means, I want to calculate my conversion rate from the actual form fills, not the contacts created.
Our solution for now will involve a Google AppScript to pull the form fill counts by channel and have cells to manually enter the number of spam form fills to be factored into the formula where I calculate CVR.
Instead of trying to play wack-a-mole with spam filtering, I decided to tackle it head-on and started using formwatch.ai. Totally game changer! Highly recommend giving it a try
