Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Knowledge Base Home

Live Search
spaceKeyOMEDACLIENTKB
sizelarge
placeholderSearch the Omeda Knowledge Base
typepage

The Form Submit report provides a summary of Omeda Form Builder form submissions broken out by week.  This report is useful to track submissions for a specific form, or across multiple forms.  For example, track the number of renewal form submissions throughout the year; or track weekly lead form submissions over the course of a LeadGen campaign.

The report filters are composed of Start Date, End Date and optional Form Title.  To profile all forms withing a given date range, select the Form Title filter NULL option:

image-20240425-180302.png

To filter by form, form titles can be entered directly, or wildcards (%) can be used:

image-20240425-180307.png

Each weekly count will show the number of customers who submitted a given form within each week.  Weeks are determined by the report date range; so week 1 is the first 7 days from the report start date, week 2 is day 8 to 14, etc.  Hovering over a Week header will display the date range for the specific week.  Here, the report start date is 3/1 so week 1 runs between 3/1 and 3/7:

image-20240425-180320.png

Counts are clickable and return a more detailed accounting for the form submission, including the products for which a customer registered.

image-20240425-180326.png

The Detail report shows 5 customers submitted the form, representing 12 product registrations.

The first two rows show Jane Smith submitted the ACME Form Submit Test form on 3/12/2021 and registered for 2 products, Picotech News and Tiny Tech Magazine. Jane’s submission counts as 1 form submit and 2 product registrations.

image-20240425-180332.png

The report can be used to show weekly form submissions for an eBook campaign.

image-20240425-180338.png

Or, the report can be exported to Excel to run filters, pivots and charts.  For example, plotting renewal form submissions might suggest opportunities for spreading renewal campaigns throughout the year:

image-20240425-180342.png

8/12/2024 - OPS-95110 - Adding a breakdown by new/existing customers.

Report has been updated to include the option to have the report be broken down by new or existing customers. If yes, we will also show the All option, just as how it is doing currently. How we determined new/existing customers, is by looking at o_stg_transaction.transaction_status_id column. If transaction_status_id = 100, then its new customer, transaction_status_id = 101, then its existing customer, transaction_status_id = 99, then its partially process customer.

This is the new parameters selection for this report:

Form_Submit_Report param example.pngImage Added

If you have it as Yes, then it will be broken down to:

Form_Submit_Report all cust example.pngImage AddedForm_Submit_Report new cust example.pngImage AddedForm_Submit_Report existing cust example.pngImage Added

Table of Contents

Table of Contents
stylenone