Support Pixel Sandbox

Support recieve a case where the client claims that there is a pixel fire discrepancy between the reporting from TTD, and the site views they are seeing in Google Analytics, with TTD running to approximately double the pixel fires. Can Support help determine why this is with the tools at their disposal.

Should you need it, here is a query to help pull details about events from the event tracker table.

Take a careful look at the referrer URL from the pixel fire, how many different pages are firing this pixel?

Code Snippet:

            
    select
        LogEntryTime,
        OfflineConversionTime,
        AdvertiserID,
        TrackingTagID,
        Country,
        TDID,
        IsGdprApplicable,
        TTDHasConsentForDataSegmenting,
        IsGdprConsentStringPresent,
        ReferrerURL,
        BidderMachineName,
        IPAddress,
        OrderId,
        MonetaryValue,
        MonetaryValueCurrency,
        UserAgent,
        td1,
        td2,
        td3,
        td4,td5,td6,td7,td8,td9,td10,campaignID
    from 
        ttd.ConverstionTracker
    where 
        LogEntryTime >= date(GetUtcDate())-1
        and AdvertiserID = 'Advertiser ID'
        and TrackingTagID in ('Tracking Tag ID')
    order by 2 desc
    limit 100000

Pixel fires way too high!