Connect Adalyser to MySQL

Register Adalyser with your username and password, save your MySQL connection details, and pair both systems in a datastream. You can then select Adalyser report fields, preview the columns, and write the result to MySQL.

Choose from 43 metrics and 34 dimensions across Accounts, TV Campaigns, and Spot Analysis data. For example, you can organize sales value, cost per lead, client, product, channel, platform, and campaign status into reporting-ready MySQL tables.

An Adalyser-to-MySQL job can begin with a historical fetch and continue on a recurring schedule. The available history and frequency depend on the Adalyser API and your Catchr plan.

Use a valid Adalyser date dimension such as Week Start when configuring the MySQL job. Catchr deletes and rewrites the scheduled window to limit duplicate rows when successive loads overlap.

Create MySQL queries or views that compare sales value, average sales value, cost per lead, and lead-to-sale conversion rate by client, product, channel, platform, or broadcast week. Agencies can reuse these datasets across recurring client reports and compatible reporting tools.

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.