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 PMJul 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 PMJul 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 privately to the author option, or direct private reply to this email.

Thanks,
 
Google Logo Ad Manager API Team

Feedback
How was our support today?

rating1    rating2    rating3    rating4    rating5
[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