Fix broken query for in_product_marketing metrics

What does this MR do and why?

Describe in detail what your merge request does and why.

Resolves #363781 (closed)

The in_product_marketing_emails metrics have the query generated broken.

• move sent_count and clicked_count to individual methods
• overwrite the methods when generating queries

Screenshots or screen recordings

Previously broken queries

    "in_product_marketing_email_create_0_sent": "SELECT COUNT(\"in_product_marketing_emails\".\"id\") FROM \"in_product_marketing_emails\" GROUP BY \"in_product_marketing_emails\".\"track\", \"in_product_marketing_emails\".\"series\"",
    "in_product_marketing_email_create_0_cta_clicked": "SELECT COUNT(\"in_product_marketing_emails\".\"id\") FROM \"in_product_marketing_emails\" WHERE \"in_product_marketing_emails\".\"cta_clicked_at\" IS NOT NULL GROUP BY \"in_product_marketing_emails\".\"track\", \"in_product_marketing_emails\".\"series\"",
    "in_product_marketing_email_create_1_sent": "SELECT COUNT(\"in_product_marketing_emails\".\"id\") FROM \"in_product_marketing_emails\" GROUP BY \"in_product_marketing_emails\".\"track\", \"in_product_marketing_emails\".\"series\"",
    "in_product_marketing_email_create_1_cta_clicked": "SELECT COUNT(\"in_product_marketing_emails\".\"id\") FROM \"in_product_marketing_emails\" WHERE \"in_product_marketing_emails\".\"cta_clicked_at\" IS NOT NULL GROUP BY \"in_product_marketing_emails\".\"track\", \"in_product_marketing_emails\".\"series\"",
    "in_product_marketing_email_create_2_sent": "SELECT COUNT(\"in_product_marketing_emails\".\"id\") FROM \"in_product_marketing_emails\" GROUP BY \"in_product_marketing_emails\".\"track\", \"in_product_marketing_emails\".\"series\"",
    "in_product_marketing_email_create_2_cta_clicked": "SELECT COUNT(\"in_product_marketing_emails\".\"id\") FROM \"in_product_marketing_emails\" WHERE \"in_product_marketing_emails\".\"cta_clicked_at\" IS NOT NULL GROUP BY \"in_product_marketing_emails\".\"track\", \"in_product_marketing_emails\".\"series\"",
    "in_product_marketing_email_verify_0_sent": "SELECT COUNT(\"in_product_marketing_emails\".\"id\") FROM \"in_product_marketing_emails\" GROUP BY \"in_product_marketing_emails\".\"track\", \"in_product_marketing_emails\".\"series\"",
    "in_product_marketing_email_verify_0_cta_clicked": "SELECT COUNT(\"in_product_marketing_emails\".\"id\") FROM \"in_product_marketing_emails\" WHERE \"in_product_marketing_emails\".\"cta_clicked_at\" IS NOT NULL GROUP BY \"in_product_marketing_emails\".\"track\", \"in_product_marketing_emails\".\"series\"",
    "in_product_marketing_email_verify_1_sent": "SELECT COUNT(\"in_product_marketing_emails\".\"id\") FROM \"in_product_marketing_emails\" GROUP BY \"in_product_marketing_emails\".\"track\", \"in_product_marketing_emails\".\"series\"",
    "in_product_marketing_email_verify_1_cta_clicked": "SELECT COUNT(\"in_product_marketing_emails\".\"id\") FROM \"in_product_marketing_emails\" WHERE \"in_product_marketing_emails\".\"cta_clicked_at\" IS NOT NULL GROUP BY \"in_product_marketing_emails\".\"track\", \"in_product_marketing_emails\".\"series\"",
    "in_product_marketing_email_verify_2_sent": "SELECT COUNT(\"in_product_marketing_emails\".\"id\") FROM \"in_product_marketing_emails\" GROUP BY \"in_product_marketing_emails\".\"track\", \"in_product_marketing_emails\".\"series\"",
    "in_product_marketing_email_verify_2_cta_clicked": "SELECT COUNT(\"in_product_marketing_emails\".\"id\") FROM \"in_product_marketing_emails\" WHERE \"in_product_marketing_emails\".\"cta_clicked_at\" IS NOT NULL GROUP BY \"in_product_marketing_emails\".\"track\", \"in_product_marketing_emails\".\"series\"",
    "in_product_marketing_email_trial_0_sent": "SELECT COUNT(\"in_product_marketing_emails\".\"id\") FROM \"in_product_marketing_emails\" GROUP BY \"in_product_marketing_emails\".\"track\", \"in_product_marketing_emails\".\"series\"",
    "in_product_marketing_email_trial_0_cta_clicked": "SELECT COUNT(\"in_product_marketing_emails\".\"id\") FROM \"in_product_marketing_emails\" WHERE \"in_product_marketing_emails\".\"cta_clicked_at\" IS NOT NULL GROUP BY \"in_product_marketing_emails\".\"track\", \"in_product_marketing_emails\".\"series\"",
    "in_product_marketing_email_trial_1_sent": "SELECT COUNT(\"in_product_marketing_emails\".\"id\") FROM \"in_product_marketing_emails\" GROUP BY \"in_product_marketing_emails\".\"track\", \"in_product_marketing_emails\".\"series\"",
    "in_product_marketing_email_trial_1_cta_clicked": "SELECT COUNT(\"in_product_marketing_emails\".\"id\") FROM \"in_product_marketing_emails\" WHERE \"in_product_marketing_emails\".\"cta_clicked_at\" IS NOT NULL GROUP BY \"in_product_marketing_emails\".\"track\", \"in_product_marketing_emails\".\"series\"",
    "in_product_marketing_email_trial_2_sent": "SELECT COUNT(\"in_product_marketing_emails\".\"id\") FROM \"in_product_marketing_emails\" GROUP BY \"in_product_marketing_emails\".\"track\", \"in_product_marketing_emails\".\"series\"",
    "in_product_marketing_email_trial_2_cta_clicked": "SELECT COUNT(\"in_product_marketing_emails\".\"id\") FROM \"in_product_marketing_emails\" WHERE \"in_product_marketing_emails\".\"cta_clicked_at\" IS NOT NULL GROUP BY \"in_product_marketing_emails\".\"track\", \"in_product_marketing_emails\".\"series\"",
    "in_product_marketing_email_team_0_sent": "SELECT COUNT(\"in_product_marketing_emails\".\"id\") FROM \"in_product_marketing_emails\" GROUP BY \"in_product_marketing_emails\".\"track\", \"in_product_marketing_emails\".\"series\"",
    "in_product_marketing_email_team_0_cta_clicked": "SELECT COUNT(\"in_product_marketing_emails\".\"id\") FROM \"in_product_marketing_emails\" WHERE \"in_product_marketing_emails\".\"cta_clicked_at\" IS NOT NULL GROUP BY \"in_product_marketing_emails\".\"track\", \"in_product_marketing_emails\".\"series\"",
    "in_product_marketing_email_team_1_sent": "SELECT COUNT(\"in_product_marketing_emails\".\"id\") FROM \"in_product_marketing_emails\" GROUP BY \"in_product_marketing_emails\".\"track\", \"in_product_marketing_emails\".\"series\"",
    "in_product_marketing_email_team_1_cta_clicked": "SELECT COUNT(\"in_product_marketing_emails\".\"id\") FROM \"in_product_marketing_emails\" WHERE \"in_product_marketing_emails\".\"cta_clicked_at\" IS NOT NULL GROUP BY \"in_product_marketing_emails\".\"track\", \"in_product_marketing_emails\".\"series\"",
    "in_product_marketing_email_team_2_sent": "SELECT COUNT(\"in_product_marketing_emails\".\"id\") FROM \"in_product_marketing_emails\" GROUP BY \"in_product_marketing_emails\".\"track\", \"in_product_marketing_emails\".\"series\"",
    "in_product_marketing_email_team_2_cta_clicked": "SELECT COUNT(\"in_product_marketing_emails\".\"id\") FROM \"in_product_marketing_emails\" WHERE \"in_product_marketing_emails\".\"cta_clicked_at\" IS NOT NULL GROUP BY \"in_product_marketing_emails\".\"track\", \"in_product_marketing_emails\".\"series\"",
    "in_product_marketing_email_experience_0_sent": "SELECT COUNT(\"in_product_marketing_emails\".\"id\") FROM \"in_product_marketing_emails\" GROUP BY \"in_product_marketing_emails\".\"track\", \"in_product_marketing_emails\".\"series\"",
    "in_product_marketing_email_team_short_0_sent": "SELECT COUNT(\"in_product_marketing_emails\".\"id\") FROM \"in_product_marketing_emails\" GROUP BY \"in_product_marketing_emails\".\"track\", \"in_product_marketing_emails\".\"series\"",
    "in_product_marketing_email_team_short_0_cta_clicked": "SELECT COUNT(\"in_product_marketing_emails\".\"id\") FROM \"in_product_marketing_emails\" WHERE \"in_product_marketing_emails\".\"cta_clicked_at\" IS NOT NULL GROUP BY \"in_product_marketing_emails\".\"track\", \"in_product_marketing_emails\".\"series\"",
    "in_product_marketing_email_trial_short_0_sent": "SELECT COUNT(\"in_product_marketing_emails\".\"id\") FROM \"in_product_marketing_emails\" GROUP BY \"in_product_marketing_emails\".\"track\", \"in_product_marketing_emails\".\"series\"",
    "in_product_marketing_email_trial_short_0_cta_clicked": "SELECT COUNT(\"in_product_marketing_emails\".\"id\") FROM \"in_product_marketing_emails\" WHERE \"in_product_marketing_emails\".\"cta_clicked_at\" IS NOT NULL GROUP BY \"in_product_marketing_emails\".\"track\", \"in_product_marketing_emails\".\"series\"",
    "in_product_marketing_email_admin_verify_0_sent": "SELECT COUNT(\"in_product_marketing_emails\".\"id\") FROM \"in_product_marketing_emails\" GROUP BY \"in_product_marketing_emails\".\"track\", \"in_product_marketing_emails\".\"series\"",
    "in_product_marketing_email_admin_verify_0_cta_clicked": "SELECT COUNT(\"in_product_marketing_emails\".\"id\") FROM \"in_product_marketing_emails\" WHERE \"in_product_marketing_emails\".\"cta_clicked_at\" IS NOT NULL GROUP BY \"in_product_marketing_emails\".\"track\", \"in_product_marketing_emails\".\"series\"",

Fixed queries

    "in_product_marketing_email_create_0_sent": "SELECT COUNT(\"in_product_marketing_emails\".\"id\") FROM \"in_product_marketing_emails\" WHERE \"in_product_marketing_emails\".\"track\" = 0 AND \"in_product_marketing_emails\".\"series\" = 0",
    "in_product_marketing_email_create_0_cta_clicked": "SELECT COUNT(\"in_product_marketing_emails\".\"id\") FROM \"in_product_marketing_emails\" WHERE \"in_product_marketing_emails\".\"track\" = 0 AND \"in_product_marketing_emails\".\"series\" = 0 AND \"in_product_marketing_emails\".\"cta_clicked_at\" IS NOT NULL",
    "in_product_marketing_email_create_1_sent": "SELECT COUNT(\"in_product_marketing_emails\".\"id\") FROM \"in_product_marketing_emails\" WHERE \"in_product_marketing_emails\".\"track\" = 0 AND \"in_product_marketing_emails\".\"series\" = 1",
    "in_product_marketing_email_create_1_cta_clicked": "SELECT COUNT(\"in_product_marketing_emails\".\"id\") FROM \"in_product_marketing_emails\" WHERE \"in_product_marketing_emails\".\"track\" = 0 AND \"in_product_marketing_emails\".\"series\" = 1 AND \"in_product_marketing_emails\".\"cta_clicked_at\" IS NOT NULL",
    "in_product_marketing_email_create_2_sent": "SELECT COUNT(\"in_product_marketing_emails\".\"id\") FROM \"in_product_marketing_emails\" WHERE \"in_product_marketing_emails\".\"track\" = 0 AND \"in_product_marketing_emails\".\"series\" = 2",
    "in_product_marketing_email_create_2_cta_clicked": "SELECT COUNT(\"in_product_marketing_emails\".\"id\") FROM \"in_product_marketing_emails\" WHERE \"in_product_marketing_emails\".\"track\" = 0 AND \"in_product_marketing_emails\".\"series\" = 2 AND \"in_product_marketing_emails\".\"cta_clicked_at\" IS NOT NULL",
    "in_product_marketing_email_verify_0_sent": "SELECT COUNT(\"in_product_marketing_emails\".\"id\") FROM \"in_product_marketing_emails\" WHERE \"in_product_marketing_emails\".\"track\" = 1 AND \"in_product_marketing_emails\".\"series\" = 0",
    "in_product_marketing_email_verify_0_cta_clicked": "SELECT COUNT(\"in_product_marketing_emails\".\"id\") FROM \"in_product_marketing_emails\" WHERE \"in_product_marketing_emails\".\"track\" = 1 AND \"in_product_marketing_emails\".\"series\" = 0 AND \"in_product_marketing_emails\".\"cta_clicked_at\" IS NOT NULL",
    "in_product_marketing_email_verify_1_sent": "SELECT COUNT(\"in_product_marketing_emails\".\"id\") FROM \"in_product_marketing_emails\" WHERE \"in_product_marketing_emails\".\"track\" = 1 AND \"in_product_marketing_emails\".\"series\" = 1",
    "in_product_marketing_email_verify_1_cta_clicked": "SELECT COUNT(\"in_product_marketing_emails\".\"id\") FROM \"in_product_marketing_emails\" WHERE \"in_product_marketing_emails\".\"track\" = 1 AND \"in_product_marketing_emails\".\"series\" = 1 AND \"in_product_marketing_emails\".\"cta_clicked_at\" IS NOT NULL",
    "in_product_marketing_email_verify_2_sent": "SELECT COUNT(\"in_product_marketing_emails\".\"id\") FROM \"in_product_marketing_emails\" WHERE \"in_product_marketing_emails\".\"track\" = 1 AND \"in_product_marketing_emails\".\"series\" = 2",
    "in_product_marketing_email_verify_2_cta_clicked": "SELECT COUNT(\"in_product_marketing_emails\".\"id\") FROM \"in_product_marketing_emails\" WHERE \"in_product_marketing_emails\".\"track\" = 1 AND \"in_product_marketing_emails\".\"series\" = 2 AND \"in_product_marketing_emails\".\"cta_clicked_at\" IS NOT NULL",
    "in_product_marketing_email_trial_0_sent": "SELECT COUNT(\"in_product_marketing_emails\".\"id\") FROM \"in_product_marketing_emails\" WHERE \"in_product_marketing_emails\".\"track\" = 2 AND \"in_product_marketing_emails\".\"series\" = 0",
    "in_product_marketing_email_trial_0_cta_clicked": "SELECT COUNT(\"in_product_marketing_emails\".\"id\") FROM \"in_product_marketing_emails\" WHERE \"in_product_marketing_emails\".\"track\" = 2 AND \"in_product_marketing_emails\".\"series\" = 0 AND \"in_product_marketing_emails\".\"cta_clicked_at\" IS NOT NULL",
    "in_product_marketing_email_trial_1_sent": "SELECT COUNT(\"in_product_marketing_emails\".\"id\") FROM \"in_product_marketing_emails\" WHERE \"in_product_marketing_emails\".\"track\" = 2 AND \"in_product_marketing_emails\".\"series\" = 1",
    "in_product_marketing_email_trial_1_cta_clicked": "SELECT COUNT(\"in_product_marketing_emails\".\"id\") FROM \"in_product_marketing_emails\" WHERE \"in_product_marketing_emails\".\"track\" = 2 AND \"in_product_marketing_emails\".\"series\" = 1 AND \"in_product_marketing_emails\".\"cta_clicked_at\" IS NOT NULL",
    "in_product_marketing_email_trial_2_sent": "SELECT COUNT(\"in_product_marketing_emails\".\"id\") FROM \"in_product_marketing_emails\" WHERE \"in_product_marketing_emails\".\"track\" = 2 AND \"in_product_marketing_emails\".\"series\" = 2",
    "in_product_marketing_email_trial_2_cta_clicked": "SELECT COUNT(\"in_product_marketing_emails\".\"id\") FROM \"in_product_marketing_emails\" WHERE \"in_product_marketing_emails\".\"track\" = 2 AND \"in_product_marketing_emails\".\"series\" = 2 AND \"in_product_marketing_emails\".\"cta_clicked_at\" IS NOT NULL",
    "in_product_marketing_email_team_0_sent": "SELECT COUNT(\"in_product_marketing_emails\".\"id\") FROM \"in_product_marketing_emails\" WHERE \"in_product_marketing_emails\".\"track\" = 3 AND \"in_product_marketing_emails\".\"series\" = 0",
    "in_product_marketing_email_team_0_cta_clicked": "SELECT COUNT(\"in_product_marketing_emails\".\"id\") FROM \"in_product_marketing_emails\" WHERE \"in_product_marketing_emails\".\"track\" = 3 AND \"in_product_marketing_emails\".\"series\" = 0 AND \"in_product_marketing_emails\".\"cta_clicked_at\" IS NOT NULL",
    "in_product_marketing_email_team_1_sent": "SELECT COUNT(\"in_product_marketing_emails\".\"id\") FROM \"in_product_marketing_emails\" WHERE \"in_product_marketing_emails\".\"track\" = 3 AND \"in_product_marketing_emails\".\"series\" = 1",
    "in_product_marketing_email_team_1_cta_clicked": "SELECT COUNT(\"in_product_marketing_emails\".\"id\") FROM \"in_product_marketing_emails\" WHERE \"in_product_marketing_emails\".\"track\" = 3 AND \"in_product_marketing_emails\".\"series\" = 1 AND \"in_product_marketing_emails\".\"cta_clicked_at\" IS NOT NULL",
    "in_product_marketing_email_team_2_sent": "SELECT COUNT(\"in_product_marketing_emails\".\"id\") FROM \"in_product_marketing_emails\" WHERE \"in_product_marketing_emails\".\"track\" = 3 AND \"in_product_marketing_emails\".\"series\" = 2",
    "in_product_marketing_email_team_2_cta_clicked": "SELECT COUNT(\"in_product_marketing_emails\".\"id\") FROM \"in_product_marketing_emails\" WHERE \"in_product_marketing_emails\".\"track\" = 3 AND \"in_product_marketing_emails\".\"series\" = 2 AND \"in_product_marketing_emails\".\"cta_clicked_at\" IS NOT NULL",
    "in_product_marketing_email_experience_0_sent": "SELECT COUNT(\"in_product_marketing_emails\".\"id\") FROM \"in_product_marketing_emails\" WHERE \"in_product_marketing_emails\".\"track\" = 4 AND \"in_product_marketing_emails\".\"series\" = 0",
    "in_product_marketing_email_team_short_0_sent": "SELECT COUNT(\"in_product_marketing_emails\".\"id\") FROM \"in_product_marketing_emails\" WHERE \"in_product_marketing_emails\".\"track\" = 5 AND \"in_product_marketing_emails\".\"series\" = 0",
    "in_product_marketing_email_team_short_0_cta_clicked": "SELECT COUNT(\"in_product_marketing_emails\".\"id\") FROM \"in_product_marketing_emails\" WHERE \"in_product_marketing_emails\".\"track\" = 5 AND \"in_product_marketing_emails\".\"series\" = 0 AND \"in_product_marketing_emails\".\"cta_clicked_at\" IS NOT NULL",
    "in_product_marketing_email_trial_short_0_sent": "SELECT COUNT(\"in_product_marketing_emails\".\"id\") FROM \"in_product_marketing_emails\" WHERE \"in_product_marketing_emails\".\"track\" = 6 AND \"in_product_marketing_emails\".\"series\" = 0",
    "in_product_marketing_email_trial_short_0_cta_clicked": "SELECT COUNT(\"in_product_marketing_emails\".\"id\") FROM \"in_product_marketing_emails\" WHERE \"in_product_marketing_emails\".\"track\" = 6 AND \"in_product_marketing_emails\".\"series\" = 0 AND \"in_product_marketing_emails\".\"cta_clicked_at\" IS NOT NULL",
    "in_product_marketing_email_admin_verify_0_sent": "SELECT COUNT(\"in_product_marketing_emails\".\"id\") FROM \"in_product_marketing_emails\" WHERE \"in_product_marketing_emails\".\"track\" = 7 AND \"in_product_marketing_emails\".\"series\" = 0",
    "in_product_marketing_email_admin_verify_0_cta_clicked": "SELECT COUNT(\"in_product_marketing_emails\".\"id\") FROM \"in_product_marketing_emails\" WHERE \"in_product_marketing_emails\".\"track\" = 7 AND \"in_product_marketing_emails\".\"series\" = 0 AND \"in_product_marketing_emails\".\"cta_clicked_at\" IS NOT NULL",

These are strongly recommended to assist reviewers and reduce the time to merge your change.

How to set up and validate locally

Numbered steps to set up and validate the change are strongly suggested.

MR acceptance checklist

This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

• I have evaluated the MR acceptance checklist for this MR.

Related to #363781 (closed)