I had some questions regarding the data schema of Infusionsoft tables that exist. All are mainly about the datasets / tables that exist within Infusionsoft.
Table Schema - https://developer.infusionsoft.com/docs/table-schema/
Need these answers so I can pull data outside Infusionsoft via API and build custom reports accordingly.
What happens to the Leads table (Lead Id - Opportunity Title etc) as they move across various stages - does the same row get updated or new latest row is added with new stageId.
I understand that this is also shown in StageMove Table also with OpportunityId’s in there - but need to know what happens to original “Leads” table as Opportunities move across various stages
Which datasets/tables can we get open, click and engagement rates for email sequences?
Where can we get data for Campaign reporting - are there any API endpoints that allow this data pull?
I spoke to chat but they were not able to answer these questions.