Skip to content

Instantly share code, notes, and snippets.

@jthandy

jthandy/mailchimp_clicks.sql

Created April 14, 2016 12:14
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save jthandy/daf5daffffa79d9f23a65977f2411a67 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save jthandy/daf5daffffa79d9f23a65977f2411a67 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
mailchimp_clicks.sql
select campaign_id, email_id, action_date as clicked_date
from {{env.schema}}.mailchimp_email_actions
where action = 'click'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment