We need to architecture and develop a MySQL database for user behavior (Maybe we should use PostgreSQL).
In the beginning we have 20 million users on different platforms who needs to be in the same database.
The attributes on the users will be
Contact info, subscription status.
We also need to create a table for campaign and traffic sources and reference with whom of your users clicked/responded to a campaign.
We get the clicks stats in daily CSV files with user IDs who all did the same action and we need to ad this action to the records in the database.
We have about 100.000 daily actions that need to be updated in the user records