Cannot Run reportType: FUTURE_SELL_THROUGH | Get "unexpected error"

26 views

Skip to first unread message

Chad Levrini

unread,

Jul 23, 2025, 4:38:45 PM Jul 23

to Google Ad Manager API Forum

Hello:

I'm trying to pull future sell-through metrics and having difficulty pulling the most basic dimensions and metrics. Can someone try to figure out what is going on? Do we need to use reportType? Or, is the future sell-through reporting no longer supported through the API?

My Request (snippet):

# Initialize the Google Ad Manager client and services

def initialize_gam_client ():

"""Initializes the Google Ad Manager client and services."""

try :

client = ad_manager.AdManagerClient.LoadFromStorage ()

return {

"client" : client ,

"report_service" : client.GetService ( "ReportService" , version= "v202505" ),

"network_service" : client.GetService ( "NetworkService" ),

}

except Exception as e :

print ( f"Error initializing GAM client: {e} " )

raise

# Set up the GAM client instance

gam = initialize_gam_client ()

client = gam [ "client" ] # Get the main client object for DataDownloader

# Set the start and end dates for the report.

current_date = datetime.now () .date ()

# Define dates for Future Sell-Through (Start of Current Month to End of Year)

# Start date is the first day of the current month

start_date_calc = date ( current_date.year , current_date.month , 1 )

# End date is December 31st of the current year

# This ensures the range is exactly 1 year for monthly granularity.

end_date_calc = date ( current_date.year , 12 , 31 )

start_date_gam = {

'year' : start_date_calc.year ,

'month' : start_date_calc.month ,

'day' : start_date_calc.day

}

end_date_gam = {

'year' : end_date_calc.year ,

'month' : end_date_calc.month ,

'day' : end_date_calc.day

}

# Define the report query as a simple Python dictionary directly.

report_query = {

'dimensions' : [ 'DATE' ],

'columns' : [ 'TOTAL_FORECAST_IMPRESSIONS' ],

'dateRangeType' : 'CUSTOM_DATE' ,

'startDate' : start_date_gam ,

'endDate' : end_date_gam ,

'reportType' : 'FUTURE_SELL_THROUGH'

}

The Reponse:

" An unexpected error occurred during report processing: 'reportType'"

Thank you!

Chad

Ad Manager API Forum Advisor

unread,

Jul 23, 2025, 6:35:45 PM Jul 23

to google-doubleclick...@googlegroups.com

Hi,

Thank you for reaching out to the Ad Manager API support team.

From the provided information, I have checked the API guide and I can confirm that the ReportQuery object does not take the reportType field via API. Please provide us with the following details to investigate the issue further.

Confirm, if you are able to fetch the report via UI.
If yes, provide us with the uncropped UI screenshot.
Complete SOAP request and response logs from API ( SOAP logging must be enabled).
UserService.getCurrentUser (if unable, you may just provide the email address used to make API request).

You can send the details via Reply privatelyto the author option, or direct private reply to this email.

Thanks,

Ad Manager API Team

Feedback
How was our support today?

[2025-07-23 22:35:29Z GMT] This message is in relation to case "ref:!00D1U01174p.!500Ht01swbFc:ref" (ADR-00319967)

Reply all

Reply to author

Forward

0 new messages