Hi there,
I’m trying to get a better understanding of the hierarchy of the various entities and what exactly they correspond to in the interface. My end goal is to pull stats at the most granular level possible and then aggregate up where necessary.
I wonder if you could tell me two things:
- First, what does each entity correspond to in the interface?
- Second, what relationship do the entities have with one another.
My findings so far are:
Accounts This is the entity chosen immediately after logging in. I have been able to reconcile the IDs seen here. I believe an account has a one-to-many relationship with a funding instrument.
Funding instruments This is the entity referred to in the interface as a funding source. I believe a funding instrument has a many-to-one relationship with an account and a one-to-many relationship with a campaign.
Campaigns This is the entity that can be seen in the campaigns tab in the interface. I believe it has a many-to-one relationship with a funding instrument. I assume it has a one-to-many relationship with line items but I have not been able to confirm this.
Line items I am not sure what these correspond to in the interface. I assume that these have a many-to-one relationship with campaigns and a one-to-many relationship with promoted_tweets but I have not been able to confirm this.
Promoted accounts I am not sure what these correspond to in the interface. I assume that these have a many-to-one relationship with line items but I have not been able to confirm this. I am not sure if these relate to promoted tweets or not.
Promoted tweets I am not sure what these correspond to in the interface but could it be the items under the tweets tab? I believe that these have a many-to-one relationship with line items. I am not sure if these relate to promoted accounts or not.
I believe these are all the entities for which you can pull stats. If I’ve missed any others, could you please direct me to them?
I appreciate that this might be a difficult question to answer so please ask if you need more information!
Thanks,
Jake