Analysis/data on campaign impact on seat assignment

We are using eio_publish.access_shared.assignment_daily table for our analysis while you recommended ADP_WORKSPACES.GSI_ANALYTICS_SHARED.LC_KPI_FINAL_WITH_USAGE . Is the table you recommended not using the snapshotted data? How are these two tables different?

• if your table also has the snapshotted data, I am guessing she would need to join the experiment data with assignment data on dates too?

The table you recommended does not have pool_id info. Would we not need the pool_id info. Considering the fact that experiment is runing on primary admins of a team and each tenant(team) can have multiple products, so we would have to join with both tenant id and pool id?

Data required:
Tenant ID

Oxygen ID

Seat Assignment data