Starting Monday, May 8th 2023, Rivery’s Google Ad Manager integration will be upgraded to Google Ad Manger API version 2023-02. This upgrade includes changes on ‘Create a new report’ and ‘Entity’ modes.
What Is Being Updated?
‘Created a new report’ mode:
Deprecated columns (Columns field on the Source tab):
OPTIMIZATION_CONTROL_IMPRESSIONS
OPTIMIZATION_CONTROL_CLICKS
OPTIMIZATION_CONTROL_CTR
OPTIMIZATION_OPTIMIZED_IMPRESSIONS
OPTIMIZATION_OPTIMIZED_CLICKS
OPTIMIZATION_NON_OPTIMIZED_IMPRESSIONS
OPTIMIZATION_NON_OPTIMIZED_CLICKS
OPTIMIZATION_EXTRA_CLICKS
OPTIMIZATION_OPTIMIZED_CTR
OPTIMIZATION_LIFT
OPTIMIZATION_COVERAGE
OPTIMIZATION_BEHIND_SCHEDULE_IMPRESSIONS
OPTIMIZATION_NO_CLICKS_RECORDED_IMPRESSIONS
OPTIMIZATION_SPONSORSHIP_IMPRESSIONS
OPTIMIZATION_AS_FAST_AS_POSSIBLE_IMPRESSIONS
OPTIMIZATION_NO_ABSOLUTE_LIFETIME_GOAL_IMPRESSIONS
OPTIMIZATION_CONTROL_REVENUE
OPTIMIZATION_OPTIMIZED_REVENUE
OPTIMIZATION_CONTROL_ECPM
OPTIMIZATION_OPTIMIZED_ECPM
OPTIMIZATION_FREED_UP_IMPRESSIONS
OPTIMIZATION_ECPM_LIFT
New columns:
YIELD_GROUP_CALLOUTS
YIELD_GROUP_SUCCESSFUL_RESPONSES
YIELD_GROUP_BIDS
YIELD_GROUP_BIDS_IN_AUCTION
YIELD_GROUP_AUCTIONS_WON
YIELD_GROUP_IMPRESSIONS
YIELD_GROUP_ESTIMATED_REVENUE
YIELD_GROUP_ESTIMATED_CPM
YIELD_GROUP_MEDIATION_FILL_RATE
YIELD_GROUP_MEDIATION_PASSBACKS
YIELD_GROUP_MEDIATION_THIRD_PARTY_ECPM
YIELD_GROUP_MEDIATION_CHAINS_SERVED
DEALS_BID_REQUESTS
DEALS_BIDS
DEALS_BID_RATE
DEALS_WINNING_BIDS
DEALS_WIN_RATE
PROGRAMMATIC_RESPONSES_SERVED
PROGRAMMATIC_MATCH_RATE
TOTAL_PROGRAMMATIC_ELIGIBLE_AD_REQUESTS
BID_COUNT
BID_AVERAGE_CPM
NIELSEN_IN_TARGET_RATIO
AD_SERVER_BEGIN_TO_RENDER_IMPRESSIONS
AD_SERVER_UNFILTERED_BEGIN_TO_RENDER_IMPRESSIONS
PARTNER_SALES_PARTNER_IMPRESSIONS
PARTNER_SALES_PARTNER_CODE_SERVED
PARTNER_SALES_GOOGLE_IMPRESSIONS
PARTNER_SALES_GOOGLE_RESERVATION_IMPRESSIONS
PARTNER_SALES_GOOGLE_AUCTION_IMPRESSIONS
PARTNER_SALES_QUERIES
PARTNER_SALES_FILLED_QUERIES
PARTNER_SALES_SELL_THROUGH_RATE
VIDEO_IMPRESSIONS_REAL_TIME
VIDEO_MATCHED_QUERIES_REAL_TIME
VIDEO_UNMATCHED_QUERIES_REAL_TIME
VIDEO_TOTAL_QUERIES_REAL_TIME
VIDEO_CREATIVE_SERVE_REAL_TIME
VIDEO_VAST3_ERROR_100_COUNT_REAL_TIME
VIDEO_VAST3_ERROR_101_COUNT_REAL_TIME
VIDEO_VAST3_ERROR_102_COUNT_REAL_TIME
VIDEO_VAST3_ERROR_200_COUNT_REAL_TIME
VIDEO_VAST3_ERROR_201_COUNT_REAL_TIME
VIDEO_VAST3_ERROR_202_COUNT_REAL_TIME
VIDEO_VAST3_ERROR_203_COUNT_REAL_TIME
VIDEO_VAST3_ERROR_300_COUNT_REAL_TIME
VIDEO_VAST3_ERROR_301_COUNT_REAL_TIME
VIDEO_VAST3_ERROR_302_COUNT_REAL_TIME
VIDEO_VAST3_ERROR_303_COUNT_REAL_TIME
VIDEO_VAST3_ERROR_400_COUNT_REAL_TIME
VIDEO_VAST3_ERROR_401_COUNT_REAL_TIME
VIDEO_VAST3_ERROR_402_COUNT_REAL_TIME
VIDEO_VAST3_ERROR_403_COUNT_REAL_TIME
VIDEO_VAST3_ERROR_405_COUNT_REAL_TIME
VIDEO_VAST3_ERROR_500_COUNT_REAL_TIME
VIDEO_VAST3_ERROR_501_COUNT_REAL_TIME
VIDEO_VAST3_ERROR_502_COUNT_REAL_TIME
VIDEO_VAST3_ERROR_503_COUNT_REAL_TIME
VIDEO_VAST3_ERROR_600_COUNT_REAL_TIME
VIDEO_VAST3_ERROR_601_COUNT_REAL_TIME
VIDEO_VAST3_ERROR_602_COUNT_REAL_TIME
VIDEO_VAST3_ERROR_603_COUNT_REAL_TIME
VIDEO_VAST3_ERROR_604_COUNT_REAL_TIME
VIDEO_VAST3_ERROR_900_COUNT_REAL_TIME
VIDEO_VAST3_ERROR_901_COUNT_REAL_TIME
VIDEO_VAST4_ERROR_406_COUNT_REAL_TIME
VIDEO_VAST4_ERROR_407_COUNT_REAL_TIME
VIDEO_VAST4_ERROR_408_COUNT_REAL_TIME
VIDEO_VAST4_ERROR_409_COUNT_REAL_TIME
VIDEO_VAST4_ERROR_410_COUNT_REAL_TIME
VIDEO_VAST_TOTAL_ERROR_COUNT_REAL_TIME
New dimensions ( Dimensions field on the Source tab):
IS_ADX_DIRECT
EXCHANGE_BIDDING_DEAL_ID
EXCHANGE_BIDDING_DEAL_TYPE
BID_RANGE
BID_REJECTION_REASON
BID_REJECTION_REASON_NAME
AD_TECHNOLOGY_PROVIDER_ID
AD_TECHNOLOGY_PROVIDER_NAME
TCF_VENDOR_ID
TCF_VENDOR_NAME
New dimensions attributes (Dimensions Attributes field on the Source tab):
CHILD_PARTNER_NAME
Line item service entity (Entity mode on the Source tab):
New entity field: youtubeKidsRestricted
What Should You Do?
- If you want to use the new fields / properties within custom reports: update Rivery’s mapping of the relevant reports according to the required fields (using “clear all” and then “Auto Mapping” under your River schema tab).
- If you are currently using deprecated columns:
If no action is taken, deprecated fields / properties will be shown as null in the existing report’s data. If you wish to remove those from the target table, remove those in the schema mapping.