#1

Below is how we are connecting Promoted Tweets to Line Item & Campaign

‘All Campaigns’ (alias AC)
‘All Line Items’ (Alias ALI)
‘Line Item Statistics’ (Alias LIS)
‘All Promoted Tweets’ (APT)
‘Recent Promoted Tweets Statistics’ (RPTS)

AC.Id = ALI.campaign_id
ALI.id = LIS.id
LIS.id = APT.line_item_id
APT.id = RPTS.id

For calendar year 2018, many line items stats is not extracted via Twitter Ads API , however campaign report is having campaign details listed and even line item id are listed i’n All Line items’ report but just not in Line Item statistics report.

Having said that for 2017 and 2019+ all data is extracted correctly.

#2

Hello,

Thanks for reaching out. Can I verify that the issue is that only 2018 details for the Line Item statistics report is not being extracted?

Is the Line Item statistics report something that your team is working on internally? I see that this was being specified:

LIS.id = APT.line_item_id

Can you confirm that in 2018, there is a line_item_id that is associated with all APT? Would be good if you could provide some example of any 2018 line_item_id which can be extracted individually from the APT.

It will be helpful as well to share the endpoints used for this.

#3

Yes It’s only calender year 2018 for which we not able to extract full Line Item report …i.e. many Line items are missing.
Yes we extract these Ads API reports using DOMO cloud analytics tool and combine these reports for analytics purpose.
Below are few Line_Item_Ids that are for March 2018 , present in APT & ALI but missing in LIS.
b1eyv, b1eyz, b6i42, b7f52, b7f7r

below endpoints are used
All Campaigns : /accounts/{account_id}/campaigns
All Line Items: /accounts/{account_id}/line_items
All Promoted : Tweets /accounts/{account_id}/promoted_tweets?with_deleted=true
Line Item Statistics: /stats/accounts/{account_id}?entity=LINE_ITEM
Recent Promoted Tweet Statistics: /accounts/{account_id}?entity=PROMOTED_TWEET

#4

Hello,

Thanks for the details. Using twurl command, are you able to retrieve details on the relevant line_item_ids?

If you are able to do so, you probably would need to check this issue with the vendor that provides the DOMO cloud analytics tool.