Dear Ads API support team,
Firstly, there is a line_item_id = “mepw2” contains 3 promoted_tweet_id (“95ilhj”, “9hqk52” and “95illv”)
# Request:
GET https://ads-api.twitter.com/11/accounts/18ce55d2r9i/promoted_tweets?count=1000&with_deleted=true&line_item_ids=mepw2
# Response:
[
{
"line_item_id": "mepw2",
"deleted": false,
"updated_at": "2022-05-12T07:23:33Z",
"tweet_id": "1501453840062631936",
"approval_status": "ACCEPTED",
"created_at": "2022-05-12T07:23:31Z",
"id": "95ilhj",
"entity_status": "ACTIVE"
},
{
"line_item_id": "mepw2",
"deleted": false,
"updated_at": "2022-08-31T11:21:03Z",
"tweet_id": "1564935823283593216",
"approval_status": "ACCEPTED",
"created_at": "2022-08-31T11:21:01Z",
"id": "9hqk52",
"entity_status": "ACTIVE"
},
{
"line_item_id": "mepw2",
"deleted": true,
"updated_at": "2022-08-18T01:20:35Z",
"tweet_id": "1524651840750505986",
"approval_status": "ACCEPTED",
"created_at": "2022-05-12T07:25:48Z",
"id": "95illv",
"entity_status": "ACTIVE"
}
]
But in the report data, the sum(billed_charge_local_micro) in report data of PROMOTED_TWEET entity (316392106) is greater than LINE_ITEM (168717541), the other metric still return the same value.
=> I think this is an abnormal value. Please check with the below attachment requests/responses
** I. With LINE_ITEM entity
sum(billed_charge_local_micro) = 16871754 (I.1)
*** I.1. Get report for line_item_ids=‘mepw2’
sum(billed_charge_local_micro) = 168717541
# With placement=ALL_ON_TWITTER
- Request
POST https://ads-api.twitter.com/11/stats/jobs/accounts/18ce55d2r9i?placement=ALL_ON_TWITTER&entity=LINE_ITEM&entity_ids=mepw2&granularity=DAY&metric_groups=ENGAGEMENT%2CVIDEO%2CBILLING%2CMEDIA%2CWEB_CONVERSION&start_time=2022-10-23&end_time=2022-10-24
-> return job_id: 1590640095849156608
- Report data of job_id: 1590640095849156608
{
"data_type": "stats",
"time_series_length": 1,
"data": [
{
"id": "mepw2",
"id_data": [
{
"segment": null,
"metrics": {
"billed_charge_local_micro": [
168717541
],
...
}
}
]
}
],
"request": {
"params": {
"start_time": "2022-10-22T15:00:00Z",
"segmentation_type": null,
"entity_ids": [
"mepw2"
],
"end_time": "2022-10-23T15:00:00Z",
"country": null,
"placement": "ALL_ON_TWITTER",
"granularity": "DAY",
"entity": "LINE_ITEM",
"platform": null,
"metric_groups": [
"ENGAGEMENT",
"VIDEO",
"BILLING",
"MEDIA",
"WEB_CONVERSION"
]
}
}
}
# With placement=PUBLISHER_NETWORK
- Request
POST https://ads-api.twitter.com/11/stats/jobs/accounts/18ce55d2r9i?placement=PUBLISHER_NETWORK&entity=LINE_ITEM&entity_ids=mepw2&granularity=DAY&metric_groups=ENGAGEMENT%2CVIDEO%2CBILLING%2CMEDIA%2CWEB_CONVERSION&start_time=2022-10-23&end_time=2022-10-24
-> return job_id: 1590639361044856833
- Report data of job_id: 1590639361044856833
{
"data_type": "stats",
"time_series_length": 1,
"data": [
{
"id": "mepw2",
"id_data": [
{
"segment": null,
"metrics": {
"billed_charge_local_micro": null,
...
}
}
]
}
],
"request": {
"params": {
"start_time": "2022-10-22T15:00:00Z",
"segmentation_type": null,
"entity_ids": [
"mepw2"
],
"end_time": "2022-10-23T15:00:00Z",
"country": null,
"placement": "PUBLISHER_NETWORK",
"granularity": "DAY",
"entity": "LINE_ITEM",
"platform": null,
"metric_groups": [
"ENGAGEMENT",
"VIDEO",
"BILLING",
"MEDIA",
"WEB_CONVERSION"
]
}
}
}
** II. With PROMOTED_TWEET entity
sum(billed_charge_local_micro) = 316392106 (II.1 + II.2 + II.3)
*** II.1. Get report for promoted_tweet_id=‘95ilhj’
sum(billed_charge_local_micro) = 316392106
# With placement=ALL_ON_TWITTER
- Request
POST https://ads-api.twitter.com/11/stats/jobs/accounts/18ce55d2r9i?placement=ALL_ON_TWITTER&entity=PROMOTED_TWEET&entity_ids=95ilhj&granularity=DAY&metric_groups=ENGAGEMENT%2CVIDEO%2CBILLING%2CMEDIA%2CWEB_CONVERSION&start_time=2022-10-23&end_time=2022-10-24
-> return job_id: 1590642485159923713
- Report data of job_id: 1590642485159923713
{
"data_type": "stats",
"time_series_length": 1,
"data": [
{
"id": "95ilhj",
"id_data": [
{
"segment": null,
"metrics": {
"billed_charge_local_micro": [
316392106
],
...
}
}
]
}
],
"request": {
"params": {
"start_time": "2022-10-22T15:00:00Z",
"segmentation_type": null,
"entity_ids": [
"95ilhj"
],
"end_time": "2022-10-23T15:00:00Z",
"country": null,
"placement": "ALL_ON_TWITTER",
"granularity": "DAY",
"entity": "PROMOTED_TWEET",
"platform": null,
"metric_groups": [
"ENGAGEMENT",
"VIDEO",
"BILLING",
"MEDIA",
"WEB_CONVERSION"
]
}
}
}
# With placement=PUBLISHER_NETWORK
- Request
POST https://ads-api.twitter.com/11/stats/jobs/accounts/18ce55d2r9i?placement=PUBLISHER_NETWORK&entity=PROMOTED_TWEET&entity_ids=95ilhj&granularity=DAY&metric_groups=ENGAGEMENT%2CVIDEO%2CBILLING%2CMEDIA%2CWEB_CONVERSION&start_time=2022-10-23&end_time=2022-10-24
-> return job_id: 1590643312482209793
- Report data of job_id: 1590643312482209793
{
"data_type": "stats",
"time_series_length": 1,
"data": [
{
"id": "95ilhj",
"id_data": [
{
"segment": null,
"metrics": {
"billed_charge_local_micro": null,
...
}
}
]
}
],
"request": {
"params": {
"start_time": "2022-10-22T15:00:00Z",
"segmentation_type": null,
"entity_ids": [
"95ilhj"
],
"end_time": "2022-10-23T15:00:00Z",
"country": null,
"placement": "PUBLISHER_NETWORK",
"granularity": "DAY",
"entity": "PROMOTED_TWEET",
"platform": null,
"metric_groups": [
"ENGAGEMENT",
"VIDEO",
"BILLING",
"MEDIA",
"WEB_CONVERSION"
]
}
}
}
*** II.2. Get report for promoted_tweet_id=‘9hqk52’
sum(billed_charge_local_micro) = 0
# With placement=ALL_ON_TWITTER
- Request
POST https://ads-api.twitter.com/11/stats/jobs/accounts/18ce55d2r9i?placement=ALL_ON_TWITTER&entity=PROMOTED_TWEET&entity_ids=9hqk52&granularity=DAY&metric_groups=ENGAGEMENT%2CVIDEO%2CBILLING%2CMEDIA%2CWEB_CONVERSION&start_time=2022-10-23&end_time=2022-10-24
-> return job_id: 1590644346818531328
- Report data of job_id: 1590644346818531328
{
"data_type": "stats",
"time_series_length": 1,
"data": [
{
"id": "9hqk52",
"id_data": [
{
"segment": null,
"metrics": {
"billed_charge_local_micro": null,
...
}
}
]
}
],
"request": {
"params": {
"start_time": "2022-10-22T15:00:00Z",
"segmentation_type": null,
"entity_ids": [
"9hqk52"
],
"end_time": "2022-10-23T15:00:00Z",
"country": null,
"placement": "ALL_ON_TWITTER",
"granularity": "DAY",
"entity": "PROMOTED_TWEET",
"platform": null,
"metric_groups": [
"ENGAGEMENT",
"VIDEO",
"BILLING",
"MEDIA",
"WEB_CONVERSION"
]
}
}
}
# With placement=PUBLISHER_NETWORK
- Request
POST https://ads-api.twitter.com/11/stats/jobs/accounts/18ce55d2r9i?placement=PUBLISHER_NETWORK&entity=PROMOTED_TWEET&entity_ids=9hqk52&granularity=DAY&metric_groups=ENGAGEMENT%2CVIDEO%2CBILLING%2CMEDIA%2CWEB_CONVERSION&start_time=2022-10-23&end_time=2022-10-24
-> return job_id: 1590645208840294402
- Report data of job_id: 1590645208840294402
{
"data_type": "stats",
"time_series_length": 1,
"data": [
{
"id": "9hqk52",
"id_data": [
{
"segment": null,
"metrics": {
"billed_charge_local_micro": null,
...
}
}
]
}
],
"request": {
"params": {
"start_time": "2022-10-22T15:00:00Z",
"segmentation_type": null,
"entity_ids": [
"9hqk52"
],
"end_time": "2022-10-23T15:00:00Z",
"country": null,
"placement": "PUBLISHER_NETWORK",
"granularity": "DAY",
"entity": "PROMOTED_TWEET",
"platform": null,
"metric_groups": [
"ENGAGEMENT",
"VIDEO",
"BILLING",
"MEDIA",
"WEB_CONVERSION"
]
}
}
}
*** II.3. With promoted_tweet_id=‘95illv’
This entity is deleted at 2022-08-18T01:20:35Z
=> so there is no report data for date range (2022-10-22T15:00:00Z, 2022-10-23T15:00:00Z)
Please help me to investigate this abnormal value case. I hope to receive your reply ASAP.
Thank you very much!
David.
