Database Architecture Design Advice

What do you as a community recommend for approach to the following scenario?

Imagine a platform where I let people carry out small 'actions' and a number of actions together form a campaign. Now I actually want to create a kind of flow in which I link campaigns together in a logical order and thus guide people through the campaigns in that order.

I am thinking of the following campaign structure:

campaign_planning_sequence ( or campaign_planning_flow, but I'm not sure what to choose for names ) table in which I'm going to record the campaigns and the order in which the campaigns are active?

Because it is also important to know where which customer is in the flow / sequence, I also want to keep track of that in a table customer_campaign_planning_flow in which the progress per campaign is kept.

Suppose we want it even more advanced (eg ala ActiveCampaign or other Marketing Automation where you can design a kind of flow and where people go through a flow based on conditions you specify? Could this be a start?