Power BI Formidable Forms Connector

Our Formidable Forms Power BI connector helps you extract the form submission data for producing valuable analysis.

Formidable Forms is a powerful WordPress plugin for creating forms that empowers users to create a wide range of forms, from simple contact forms to complex solutions-focused forms. The data from formidable forms could contain the leads information and the logs of successful/failed submissions.

Our Formidable Forms Power BI connector is the integration that bridge the gap between your forms and valuable analysis. This connector allow you to exchange data, automate processes, and enhance user experiences.

Let’s dive into the key aspects of the Formidable Power BI Connector:

Vidi Corp offers a standard solution where the data is automatically extracted from Formidable API into an Azure SQL Server database. This database can be then connected to Power BI using the native connector.

The key difference between this formidable connector and all the others is that we extract the data on form logs as well as entries. As a result, you can analyze the success ratio of form submissions and errors that come up when submitting a form.

We fetch the form entries & form logs of all the sites within an account. Form entries give you the leverage to analyze how many people are actually enquiring and are getting converted. With Form logs you can analyze how many of the requests are getting failed due to various reasons.

Benefits of our Power BI Formidable Connector

Efficiency: The connector eliminates manual data entry, reducing errors and saving time.
Enhanced Data Accessibility: Centralized Data Storage: By fetching forms data and storing it in a centralized database, you make the data more accessible to various teams and systems within your organization.
Integration with Other Systems: Centralized data can be easily integrated with other business systems such as Customer Relationship Management (CRM), Enterprise Resource Planning (ERP), and Business Intelligence (BI) tools.
Enhanced User Experience: Seamlessly integrate forms with other tools, providing a smooth experience for users.
Advanced Data Analysis and Reporting By storing form data in a database, you can leverage advanced querying and reporting tools to generate comprehensive reports. This can include trend analysis, performance metrics, and predictive analytics. BI tools can create customizable dashboards that provide visual insights into your data, making it easier to identify patterns and trends.
Flexibility: Customize connectors to fit your specific needs.

Power BI Formidable Connector Table Structure

Forms

ColumnName	Type	Description
id	STRING	Unique identifier for the form
form_key	STRING	Key associated with the form
name	STRING	Name of the form
description	STRING	Description of the form
status	STRING	Current status of the form
parent_form_id	STRING	ID of the parent form, if applicable
logged_in	STRING	Indicates if the form requires login
is_template	STRING	Indicates if the form is a template
editable	STRING	Indicates if the form is editable
created_at	STRING	Timestamp of when the form was created
link	STRING	URL link to the form
site	STRING	Site associated with the form
options*	STRING	Miscellaneous form options as separate columns
_links_self	STRING	Self-referential link for the form resource
_links_collection	STRING	Link to the collection the form belongs to
_links_fields	STRING	Link to the fields of the form
load_date	STRING	Date when the form data was loaded

FormEntries

ColumnName	Type	Description
id	STRING	Unique identifier for the record
item_key	STRING	Key identifying the item
name	STRING	Name of the item or entity
ip	STRING	IP address associated with the record
form_id	STRING	Identifier for the form
post_id	STRING	Identifier for the post
user_id	STRING	Identifier for the user
parent_item_id	STRING	Identifier for the parent item
is_draft	STRING	Indicates if the item is a draft
updated_by	STRING	User who last updated the record
created_at	STRING	Timestamp when the record was created
updated_at	STRING	Timestamp when the record was last updated
site	STRING	Site associated with the record
meta*	STRING	All metadata fields in separate columns
load_date	STRING	Date when the record was loaded

FormLogs

ColumnName	Type	Description
ID	STRING	A unique identifier for each post.
post_author	STRING	The author of the post.
post_date	STRING	The date and time when the post was created.
post_date_gmt	STRING	The GMT date and time when the post was created.
post_title	STRING	The title of the post.
post_excerpt	STRING	A brief summary or extract of the post content.
post_status	STRING	The status of the post (e.g., published, draft, pending).
comment_status	STRING	The status of commenting on the post (e.g., open, closed).
ping_status	STRING	The status of pingbacks/trackbacks on the post.
post_password	STRING	Password protection for the post.
post_name	STRING	The slug or permalink of the post.
to_ping	STRING	URLs to ping.
pinged	STRING	URLs pinged.
post_modified	STRING	The date and time when the post was last modified.
post_modified_gmt	STRING	The GMT date and time when the post was last modified.
post_content_filtered	STRING	Filtered content of the post.
post_parent	STRING	ID of the parent post.
guid	STRING	Global Unique Identifier of the post.
menu_order	STRING	Order of the post in a menu.
post_type	STRING	Type of the post (e.g., post, page).
post_mime_type	STRING	Mime type of the post.
comment_count	STRING	Number of comments on the post.
body_status	STRING	Status of the body (if applicable).
body_responses	STRING	Responses received from the body (if applicable).
response_code	STRING	HTTP response code.
response_message	STRING	Message corresponding to the response code.
cookies	STRING	Cookies associated with the request.
filename	STRING	Name of the file.
http_response_data	STRING	Data received from the HTTP response.
http_response_headers	STRING	Headers of the HTTP response.
http_response_status	STRING	Status of the HTTP response.
post_content_body_status	STRING	Status of the body content in the post.
post_content_body_responses	STRING	Responses received from the body content in the post.
post_content_response_code	STRING	HTTP response code for the post content.
post_content_response_message	STRING	Message corresponding to the response code for the post content.
post_content_cookies	STRING	Cookies associated with the post content.
post_content_filename	STRING	Name of the file associated with the post content.
post_content_http_response_data	STRING	Data received from the HTTP response for the post content.
post_content_http_response_headers	STRING	Headers of the HTTP response for the post content.
post_content_http_response_status	STRING	Status of the HTTP response for the post content.
post_content	STRING	Content of the post.
body_id	STRING	ID of the body (if applicable).
body_company_id	STRING	ID of the company associated with the body (if applicable).
body_company_external_id	STRING	External ID of the company associated with the body (if applicable).
body_first_name	STRING	First name of the body (if applicable).
body_last_name	STRING	Last name of the body (if applicable).
body_address	STRING	Address of the body (if applicable).
body_city	STRING	City of the body (if applicable).
body_state	STRING	State of the body (if applicable).
body_zip	STRING	ZIP code of the body (if applicable).
body_phone_home	STRING	Home phone number of the body (if applicable).
body_phone_mobile	STRING	Mobile phone number of the body (if applicable).
body_phone_work	STRING	Work phone number of the body (if applicable).
body_phone_home_formatted	STRING	Formatted home phone number of the body (if applicable).
body_phone_mobile_formatted	STRING	Formatted mobile phone number of the body (if applicable).
body_phone_work_formatted	STRING	Formatted work phone number of the body (if applicable).
body_email	STRING	Email address of the body (if applicable).
body_contact_method_name	STRING	Contact method name of the body (if applicable).
body_source_name	STRING	Source name of the body (if applicable).
body_tag_list	STRING	Tag list associated with the body (if applicable).
body_avatar	STRING	Avatar image of the body (if applicable).
body_social_link	STRING	Social media links of the body (if applicable).
body_salesperson	STRING	Salesperson associated with the body (if applicable).
body_trial_end_at	STRING	End date of the trial period for the body (if applicable).
body_trial_days_quantity	STRING	Number of days in the trial period for the body (if applicable).
body_gender	STRING	Gender of the body (if applicable).
body_birthday	STRING	Birthday of the body (if applicable).
body_sms_opted_out	STRING	Opt-out status for SMS communications for the body (if applicable).
body_abcfin_status	STRING	ABC/Fin status of the body (if applicable).
body_email_opted_out	STRING	Opt-out status for email communications for the body (if applicable).
post_content_body_id	STRING	ID of the body content in the post (if applicable).
post_content_body_company_id	STRING	ID of the company associated with the