Connect Pardot to MySQL

Add Pardot in Sources and connect the existing MySQL database in Storage. A datastream defines the route, while the job loads the chosen fields into "companies".

Select concrete Pardot fields such as Bounce Rate, Bounces, Click Through Rate, and Day of the month. You can rename the chosen columns, preview the result, and write them to MySQL tables such as accounts, contacts, and companies.

Define the first Pardot fetch, run frequency, and lookback window in the "companies" job. Each scheduled run replaces data inside the configured period.

Use a supported date field to partition "companies". Recurring Pardot runs can then update the selected window instead of adding another copy of the same period.

With Pardot data, a MySQL query can summarize pipeline value, created deals, won deals, and win rate by owner. Model Bounce Rate and Bounces in SQL, then expose the result to dashboards, internal tools, or recurring client reports.

Yes. Connect an existing MySQL database first. The Catchr job creates and populates the destination table you configure inside that database.

Yes. Create a separate datastream and job for each source, write each export to its own table, then combine the data downstream with SQL, views, or your BI tool.