Geo Performance report bug?

Posted in General by Alex Fri Nov 22 2019 16:04:30 GMT+0000 (Coordinated Universal Time)·1·Viewed 101 times

Hello, sometimes I get non-numeric "metro/dma code", is that a bug? example: Request: {"report_id":8,"report_format":"none","request_details":{"offset":0,"rows":500, "field":["bid_date","line_item_id","creative_id","geo_city","city_name","geo_country","country_name","geo_metro","metro_name","geo_region","region_name","flight_id","flight_name"],"metric":["spend","impression","clicks","video_plays","video_Q1s","video_midpoints","video_Q3s","video_completes","video_skips","measurable_impressions","viewable_impressions","viewable_seconds","conversions","spend_usd"], "sort_by":[{"bid_date":0},{"line_item_id":0},{"creative_id":0},{"geo_country":0},{"geo_region":0},{"spend_usd":0}], "filter":[{"account_id":2},{"advertiser_id":70},{"campaign_id":73},{"creative_id":2107},{"bid_date":">=2019-11-04 00:00:00&&<=2019-11-04 23:59:59"}]}} Part of the Response's payload: "36": { "day": "2019-11-04 00:00", "line item id": "287", "creative id": "2107", "city code": "", "city": null, "country code": "USA", "country": "United States of America", "metro/dma code": "Tampa-St Petersburg (Sarasota), FL", "metro/dma": null, "region/state code": "USA/FL", "region/state": null, "flight id": "0", "flight name": null, "spend": "0.00", "impressions": "1", "clicks": "0", "video plays": "0", "video q1s": "0", "video midpoints": "0", "video q3s": "0", "video completes": "0", "video skips": "0", "measurable impressions": "0", "viewable impressions": "0", "viewable seconds": "0.00", "conversions": "0", "spend usd": "0.00" }, as you can see: "metro/dma code": "Tampa-St Petersburg (Sarasota), FL", "metro/dma": null Thanks!
Dec 4, 2019

got answer via email:
"It is expected behavior, this occurs because of the way we handle geo-data lookups.

We send the IP address on each bid request through a vendor called MaxMind, which returns any available geo information in a standardized format. In instances where DMA is not available in the MaxMind database, we'll fall back to whatever the exchange sends us in that field, which in many cases will not be in the same format that MaxMind uses."


Markdown is allowed