[Forminator Pro] Google Looker Studio integration with Forminator

0

Please consider adding a native integration for data visualization for Google Looker with Forminator:

Looker Studio:
https://lookerstudio.google.com/u/0/navigation/reporting

  • Alfredo Galano Loyola
    • Staff

    Hello cornelius_butler
    I hope you are doing well today.

    After checking how Google Looker Studio works, it looks like the key is the Data Source.
    A Data Source is needed to pass the data to Google Looker Studio and then with the Data Source set it is possible to start creating the reports.
    [attachments are only viewable by logged-in members]
    Unfortunately, everything points to the connectors for Google Looker Studio need to be created by Google and not for a third party.

    Forminator Pro is a WordPress plugin, usually, WordPress sites use MySQL Database, but even if a connector for MySQL Database exists in Google Looker Studio the data from the forms could be hard to format and it could make the site vulnerable if the Database allows external connections.

    The Google Looker Studio can use Google Sheets and CSV files as Data Sources.

    Forminator Pro can be integrated with Google Sheets, so, it’s possible to feed a Google Sheet with data submitted from a Forminator Pro form and then use that Google Sheet in Google Looker Studio as a Data Source.
    Google Sheet integration: https://wpmudev.com/docs/wpmu-dev-plugins/forminator/#google-sheets
    How to use Google Sheet as Looker Data Source: https://www.youtube.com/watch?v=AgZcow4JPy0

    Another possible option will be to export all the submissions of the form as CSV file and then use them as Data Source in Google Looker Studio.

    Exporting submission: https://wpmudev.com/docs/wpmu-dev-plugins/forminator/#exporting-submissions

    Thanks for bringing this to our attention and we hope the workaround provided helps you to use this interesting tool.

    Best regards,
    Alfredo