/cs-scripts

Primary LanguagePython

Mailchimp DMP script

mailchimp csv export: https://docs.google.com/spreadsheets/d/1ArDqAQuEE0wLu1q6Lyayql2kSbGcnJ5LxGhmsyZp4Jo/edit?usp=sharing

GOALS

  • get the export into mailchimp
  • overview of possible tags in mailchimp
  • sync mailchimp and mongo (cs)
  • cron on daily basis
  • keep track of changes (events) -> daily raport
  • modular code -> extend to DMP in later stage

Model

  • firstname
  • lastname
  • email
  • tags (csv)

Caveats

Mongo

  • new added
  • tages added

Mailchimp

  • user can unsubscribe
  • manually added -> clean duplicates

How-To-Run

Firstly, go to config.py and specify the right credentials and audience ID.

If you want to run everything in one go. Run db_to_chimp.py first, run chimp_to_db.py after that.

tags

Returns all unique tags present in mailchimp

  • python3 tags.py

Returns a set which contains all unique tags

Cross-validate

Cross-validates Mailchimp and database

  • python3 cross_validate.py

Notes

  • Wie zijn contacts in CSV maar niet in db (400)

  • Backup maken mailchimp to csv

  • Volledige flow simuleren in test mailchimp

mailen naar luc

  • wie zijn contacten
  • verder verloop

flow test

  • nieuw contact in mailchimp
  • na sync in admin dash
  • unsubben in mailchimp
  • na sync niet meer subbed in db