Versions Compared

Key

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

Live Search

depth

spaceKey

2

OMEDACLIENTKB

allChildren

size

true

large

stylepageWelcome to

placeholderSearch the Omeda

Client

Knowledge Base

sortAndReverse

type

first0

page

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.pngImage Modified

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

image-20240425-180307.pngImage Modified

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.pngImage Modified

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

image-20240425-180326.pngImage Modified

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.pngImage Modified

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

image-20240425-180338.pngImage Modified

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.pngImage Modified

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