Option 9: Set up MySQL database as Data Destination for Meta Lead Ads

Video Walkthrough

Description  

MySQL is an open-source relational database management system (RDBMS) used to store, organize, and manage structured data. Using this Datahash connector, you can automatically send Meta Lead Ads data into your MySQL tables for reporting, analytics, or integration with other systems.

Prerequisites  

Before starting, make sure you have:

• MySQL Hostname – The database server hostname or IP
• Port – Port number for the MySQL instance
• MySQL Username – User with read/write permissions to the target database
• MySQL Password – Password for the above user
• Database Name – The database where data will be inserted

Table Name – The table where lead data will be stored

Setup Instructions  

1. Login to Datahash
   • Go to Datahash Studio
   • Enter your credentials
2. Select MySQL as Destination
   • Navigate to Files category under Destinations

Click on the MySQL connector tile 

3. Select Source

• Choose Meta Lead Ads as the source type

• Select the connection name from your existing Meta Lead Ads Source
• Provide a name for this connection

4. Enter MySQL Credentials

• MySQL Hostname
• Port
• MySQL Username
• MySQL Password
• Database Name
• Table Name

5. Validate Credentials

• Click Validate Credentials to ensure the connection is successful

6. Field Mapping

• Map your Meta Lead Form Fields to MySQL Table Columns

• Lead ID (or ID) from the form must be mapped to a column
• Map additional fields as required
• Click Test Connection

7. Complete Setup

• Click Finish
• The connection will appear in your dashboard

Managing Instances  

Add a New Instance  

• Click Edit icon in Manage Connections

• Repeat the setup process with new parameters
• Validate credentials and map fields
• Click Finish
• The new instance will appear in the Manage Existing Connections table

Editing an existing connection instance:

• Click the connection name in Manage Existing Connections
• Click Edit (top right)

• Update any field values

• Click Validate Credentials and Test Connection

• Click Finish
   (If Cancel is clicked, existing settings remain unchanged)