V202211 dimensions and column name.

[redfusion Data]

Hi team, 

while pulling extract from Gam we are extracting below mentioned dimensions and columns. 

'dimensions': [
                                        'DATE'
                                        , 'AD_EXCHANGE_DFP_AD_UNIT'
                                        , 'AD_EXCHANGE_CREATIVE_SIZES'
                                        ,  'AD_EXCHANGE_DEVICE_CATEGORY'
                                        , 'AD_EXCHANGE_ADVERTISER_NAME'
                                        , 'AD_EXCHANGE_BUYER_NETWORK_ID'
                                        , 'AD_EXCHANGE_BUYER_NETWORK_NAME'
                                        , 'AD_EXCHANGE_DEAL_ID'
                                        , 'AD_EXCHANGE_DEAL_NAME'
                                        , 'AD_EXCHANGE_TRANSACTION_TYPE'
                                    ],
                        'columns': [
                                        'AD_EXCHANGE_ESTIMATED_REVENUE'
                                        , 'AD_EXCHANGE_CLICKS'
                                        , 'AD_EXCHANGE_AD_REQUESTS'
                                        , 'AD_EXCHANGE_CTR'
                                        , 'AD_EXCHANGE_IMPRESSIONS'

But now due in v202211, we are missing some columns data or the dimensions and columns are not extractable together. 

Kindly let us know respective columns which we can get to extract above combination. 

Thanks and regrads, 

Anjuli

[Ad Manager API Forum Advisor]

Hi Anjuli,

Thank you for reaching out to the Ad Manager API support team. I am Veerabhadra Rao and will be assisting you.

By reviewing your concern, I can confirm that Ad Exchange dimensions and metrics are changed and now available for historical report type dimensions and metrics, from v202205 and for latest versions (which includes v202211). From the release notes, starting from v202205 it states that updated Dimensions and Columns for the "Ad Exchange Historical" to "Historical" report type conversion. Ad Exchange Historical dimensions and metrics are now available for Historical reports. Because of this change, several Ad Exchange dimensions and metrics have been renamed or replaced in the API. To migrate, please refer to the migration guide and the reference documentation for v202202 and earlier.

So, if you want to use the AD_EXCHANGE_ESTIMATED_REVENUE column (for example) in v202208 then, you may check the following process to find historical metrics correspond to Ad Exchange metrics.

1. Check the AD_EXCHANGE_ESTIMATED_REVENUE column corresponding name in UI from the v202202 API documentation which is "Estimated revenue".
2. From the help article migration guide, find the Historical metrics value of "Estimated revenue" i.e "Ad Exchange revenue".
3. Find the column from v202208 API documentation for "Ad Exchange revenue" name of UI metrics i.e "AD_EXCHANGE_LINE_ITEM_LEVEL_REVENUE".
4. By this I can confirm that AD_EXCHANGE_ESTIMATED_REVENUE  column of v202202 is replaced with "AD_EXCHANGE_LINE_ITEM_LEVEL_REVENUE" in v202208 of Ad Manager API.

You may check below mentioned dimensions and columns for v202202 to  v202208

DATE -- DATE
AD_EXCHANGE_DFP_AD_UNIT   --  AD_UNIT_NAME
AD_EXCHANGE_CREATIVE_SIZES --  CREATIVE_SIZE
AD_EXCHANGE_DEVICE_CATEGORY --- DEVICE_CATEGORY_NAME
AD_EXCHANGE_ADVERTISER_NAME -- ADVERTISER_NAME
AD_EXCHANGE_BUYER_NETWORK_ID --  BUYER_NETWORK_ID
AD_EXCHANGE_BUYER_NETWORK_NAME --  BUYER_NETWORK_NAME
AD_EXCHANGE_DEAL_ID -- PROGRAMMATIC_DEAL_ID
AD_EXCHANGE_DEAL_NAME -- PROGRAMMATIC_DEAL_NAME
AD_EXCHANGE_TRANSACTION_TYPE -- PROGRAMMATIC_CHANNEL_NAME
AD_EXCHANGE_ESTIMATED_REVENUE -- AD_EXCHANGE_LINE_ITEM_LEVEL_REVENUE
AD_EXCHANGE_CLICKS -- AD_EXCHANGE_LINE_ITEM_LEVEL_CLICKS
AD_EXCHANGE_AD_REQUESTS -- AD_EXCHANGE_TOTAL_REQUESTS
AD_EXCHANGE_CTR -- AD_EXCHANGE_MATCHED_REQUEST_CTR
AD_EXCHANGE_IMPRESSIONS  -- AD_EXCHANGE_LINE_ITEM_LEVEL_IMPRESSIONS

For further assistance please reach out to us.

Regards,

Veerabhadra Rao Ad Manager API Team

 

ref:_00D1U1174p._5004Q2iMAvT:ref

[redfusion Data]

Thank you for the information : 

The above mentioned columns doesn't looks like they are the new migrated column for new version. Because there are lot of data discrepancy related to that. 

Also, we didn't find any proper documentation for the same. 

But are some of the discrepancies which we found  : 

1.  AD_EXCHANGE_DFP_AD_UNIT   --  AD_UNIT_NAME : Doesn't have 7Plus data in it (Display is missing and Video has less count of data)

2. AD_EXCHANGE_DEAL_ID -- PROGRAMMATIC_DEAL_ID : this column is having only data value as 0

3. AD_EXCHANGE_DEAL_NAME -- PROGRAMMATIC_DEAL_NAME : just have value -  (Not applicable) which is wrong .. We shouldn't receive so may data as NA

Please let us know how to fix it . Our client is looking into the data and can you help us in priority . 

Regards, 

Anjuli

[Ad Manager API Forum Advisor]

Hi Anjuli,

Thank you for getting back to us. This is Anjali a colleague of Veerabhadra Rao and I'll be assisting you with this request.

I understood that you are facing the data discrepancy issues, To analyze the issue in the data pulled, please provide us the below information via Reply privately to the author option.

• Downloaded reports from the API where you are seeing the data discrepancy 
• Complete SOAP request and response logs (SOAP logging must be enabled) 
• Complete SOAP request and response logs of getCurrentUser() method (SOAP logging must be enabled).
• Network code
• Can you confirm if you are seeing the data discrepancy in the UI also? please share with us the downloaded UI report as well.

And, regarding the "Programmatic deal ID " it is a system-generated number used to identify a deal between a buyer and a publisher. Shows "0" if no Preferred Deal, Private Auction, or Programmatic Guaranteed was involved. Previously called “Deal ID” and the "Programmatic_deal_name" will show "(Not applicable)" if no Preferred Deal, Private Auction, or Programmatic Guaranteed was involved. Previously called “Deal name".

Regards.

Anjali Ad Manager API Team

ref:_00D1U1174p._5004Q2iMAvT:ref

[redfusion Data]

Hi team, 

We are using below query structure , 

New Structure : 

'reportQuery': {
                       'dimensions': [
                                        'DATE'
                                        , 'AD_UNIT_NAME'
                                        , 'CREATIVE_SIZE'
                                        ,  'DEVICE_CATEGORY_NAME'
                                        , 'ADVERTISER_NAME'
                                        , 'BUYER_NETWORK_ID'
                                        , 'BUYER_NETWORK_NAME'
                                        , 'PROGRAMMATIC_DEAL_ID' 
                                        , 'PROGRAMMATIC_DEAL_NAME' 
                                        , 'PROGRAMMATIC_CHANNEL_NAME' 
                                    ],
                        'columns': [
                                        'AD_EXCHANGE_LINE_ITEM_LEVEL_REVENUE' #TOTAL_LINE_ITEM_LEVEL_ALL_REVENUE'
                                        , 'AD_EXCHANGE_LINE_ITEM_LEVEL_CLICKS'
                                        , 'AD_EXCHANGE_TOTAL_REQUESTS'
                                        , 'AD_EXCHANGE_LINE_ITEM_LEVEL_CTR'
                                        , 'AD_EXCHANGE_LINE_ITEM_LEVEL_IMPRESSIONS'
                                    ],
                        'adUnitView' : 'HIERARCHICAL',
                        'dateRangeType': 'CUSTOM_DATE',
                        'startDate': start_date,
                        'endDate': end_date
                    }

Can you guide us if we need to add or remove anything to get the desired data which we used to get with the query structure as : 

Earlier Structure : 

 {
                    'reportQuery': {

                        'dimensions': [
                                        'DATE'
                                        , 'AD_EXCHANGE_DFP_AD_UNIT'
                                        , 'AD_EXCHANGE_CREATIVE_SIZES'
                                        ,  'AD_EXCHANGE_DEVICE_CATEGORY'
                                        , 'AD_EXCHANGE_ADVERTISER_NAME'
                                        , 'AD_EXCHANGE_BUYER_NETWORK_ID'
                                        , 'AD_EXCHANGE_BUYER_NETWORK_NAME'
                                        , 'AD_EXCHANGE_DEAL_ID'
                                        , 'AD_EXCHANGE_DEAL_NAME'
                                        , 'AD_EXCHANGE_TRANSACTION_TYPE'
                                    ],
                        'columns': [
                                        'AD_EXCHANGE_ESTIMATED_REVENUE'
                                        , 'AD_EXCHANGE_CLICKS'
                                        , 'AD_EXCHANGE_AD_REQUESTS'
                                        , 'AD_EXCHANGE_CTR'
                                        , 'AD_EXCHANGE_IMPRESSIONS'

                                    ],
                        'adUnitView' : 'HIERARCHICAL',
                        'dateRangeType': 'CUSTOM_DATE',
                        'startDate': start_date,
                        'endDate': end_date
                    }
                }

Please guide us respect to that. 

If possible and if it is quicker solution please feel free to reach out to +61 422109132

Thanks, 

Anjuli

[Ad Manager API Forum Advisor]

Hi Anjuli,

Thank you for getting back to us. I am Chekurthi, Anjali's colleague and will be assisting you.

From the below shared Dimensions and Columns compared with Ad Exchange Historical report type and Historical report type where AD_EXCHANGE_ESTIMATED_REVENUE is AD_EXCHANGE_LINE_ITEM_LEVEL_REVENUE (Ad Exchange revenue) and AD_EXCHANGE_CTR is AD_EXCHANGE_MATCHED_REQUEST_CTR (Ad Exchange matched request CTR). And, I can confirm that the rest are correct which are used from the mentioned Dimensions and Columns. 

Hope this helps. Please note that we can only provide email support for the Ad Manager API. If you need any further query regarding the Ad Manager API you may get back to us.

Regards,

Chekurthi Ad Manager API Team

 

ref:_00D1U1174p._5004Q2iMAvT:ref