Data Discrepancies Between UI and API


#1

Hello,

We are seeing some metrics discrepancies between the data displayed/exported from the twitter UI and those reported from the API for some Campaigns. In particular we are seeing major difference in the number of impressions reported. Here is an example below…

URL: /1/stats/jobs/accounts/18ce54f85zs
POST PARAMS: Post Params: {‘placement’: ‘ALL_ON_TWITTER’, ‘metric_groups’: u’ENGAGEMENT,BILLING,VIDEO,MEDIA,WEB_CONVERSION’, ‘country’: None, ‘start_time’: ‘2016-11-18T00:00:00-05:00’, ‘entity’: ‘6hbph’, ‘platform’: None, ‘end_time’: ‘2016-11-25T00:00:00-05:00’, ‘granularity’: ‘DAY’, ‘entity_ids’: u’6mbwd,6mbzs,6mc0d,6mc0y,6pq7z,6pq80,6pq81,6pq82’, ‘segmentation_type’: None}

Here is a screen shot of the twitter UI for the campaign by day…

Here is the report header…

    'request': {
    'params': {
        'placement': 'ALL_ON_TWITTER',
        'metric_groups': ['ENGAGEMENT', 'BILLING', 'VIDEO', 'MEDIA', 'WEB_CONVERSION'],
        'country': None,
        'start_time': '2016-11-18T05:00:00Z',
        'entity': 'CAMPAIGN',
        'platform': None,
        'end_time': '2016-11-25T05:00:00Z',
        'granularity': 'DAY',
        'entity_ids': ['6hbph', '6hbp', '6hbtt', '6hbu6', '6hbuo', '6hbv0', '6hbvd', '6hbvh', '6hbvk', '6hbvp', '6mbpk', '6mbri', '6mbsf', '6mbsr', '6mbt4', '6mbtf', '6mbud', '6mbv7'],
        'segmentation_type': None
    }
},

Here is the response from the API for the request campaign…

{
    'id': '6hbph',
    'id_data': [{
        'metrics': {
            'conversion_downloads': {
                'metric': None,
                'sale_amount': None,
                'post_engagement': None,
                'sale_amount_view': None,
                'order_quantity_engagement': None,
                'sale_amount_engagement': None,
                'order_quantity': None,
                'post_view': None,
                'order_quantity_view': None
            },
            'video_views_100': None,
            'video_3s100pct_views': None,
            'likes': None,
            'replies': None,
            'tweets_send': None,
            'impressions': [381, 21, 402, 80, 54, 55, 17],
            'conversion_custom': {
                'metric': None,
                'sale_amount': None,
                'post_engagement': None,
                'sale_amount_view': None,
                'order_quantity_engagement': None,
                'sale_amount_engagement': None,
                'order_quantity': None,
                'post_view': None,
                'order_quantity_view': None
            },
            'media_engagements': None,
            'conversion_site_visits': {
                'metric': None,
                'sale_amount': None,
                'post_engagement': None,
                'sale_amount_view': None,
                'order_quantity_engagement': None,
                'sale_amount_engagement': None,
                'order_quantity': None,
                'post_view': None,
                'order_quantity_view': None
            },
            'url_clicks': None,
            'conversion_sign_ups': {
                'assisted': None,
                'sale_amount': None,
                'post_engagement': None,
                'sale_amount_view': None,
                'order_quantity_engagement': None,
                'sale_amount_engagement': None,
                'order_quantity': None,
                'post_view': None,
                'order_quantity_view': None,
                'metric': None
            },
            'retweets': None,
            'video_total_views': None,
            'clicks': [3, 0, 2, 2, 1, 1, 0],
            'video_cta_clicks': None,
            'conversion_purchases': {
                'assisted': None,
                'sale_amount': None,
                'post_engagement': None,
                'sale_amount_view': None,
                'order_quantity_engagement': None,
                'sale_amount_engagement': None,
                'order_quantity': None,
                'post_view': None,
                'order_quantity_view': None,
                'metric': None
            },
            'video_views_50': None,
            'video_views_75': None,
            'card_engagements': None,
            'billed_engagements': None,
            'media_views': None,
            'qualified_impressions': None,
            'engagements': [3, 0, 2, 2, 1, 1, 0],
            'billed_charge_local_micro': None,
            'carousel_swipes': None,
            'video_mrc_views': None,
            'follows': None,
            'app_clicks': None,
            'video_content_starts': None,
            'video_views_25': None
        },
        'segment': None
    }

Any idea as to what could be causing these differences?

Thanks,
Tom Boilard


#2

Hi @juanshishido - Any thoughts on this?

Please let me know if you need any other information.

Thanks,
Tom


#3

I believe the issue may be related to ALL_ON_TWITTER vs PUBLISHER_NETWORK placements and how we are importing the data. Investigating fully now…

Thanks,
Tom Boilard


#4

Hello,

We verified that the issue is on our end. We need to import analytics for both ALL_ON_TWITTER as well as PUBLISHER_NETWORK for entities that have associated line items that have a PUBLISHER_NETWORK placement.

Thanks,
Tom Boilard


Campaign data mismatch for same account id
#5

Thanks for letting us know, @tboilard!