PMax data via GBQ DataTransfer

[Anna Khan]

Dear Google :) 

After quite a bit of digging, I managed to locate Asset Group level data for Performance Max campaigns in the default tables delivered via Data Transfer in BigQuery.
However, the data in those tables is incomplete. In some accounts, I can see costs for only 2 out of 10 groups, while in others I get only group names and IDs but no stats.

Are you aware of this issue, and is there a timeline for fixing these tables and releasing the complete data? 

Many thanks!

Posting my query here as well in case it’s useful to anyone.

with group_names as (

SELECT distinct asset_group_id, asset_group_name

FROM `XXX.google_ads.p_ads_AssetGroup_XXX`

WHERE TIMESTAMP_TRUNC(_PARTITIONTIME, DAY) >= TIMESTAMP("2025-09-01")

)

 

, stats as (

SELECT distinct asset_group_product_group_view_asset_group,

REGEXP_EXTRACT(asset_group_product_group_view_asset_group, r'([0-9]+)$') as group_id,

segments_date, round(sum(metrics_cost_micros)/1000000,2) as costs

FROM `XXX.google_ads.p_ads_AssetGroupProductGroupStats_XXX`

WHERE TIMESTAMP_TRUNC(_PARTITIONTIME, DAY) >= TIMESTAMP("2025-09-01")

group by all

)

 

select asset_group_name, asset_group_id, segments_date, sum(costs) as costs

from stats right join group_names

--from stats join group_names

on stats.group_id = group_names.asset_group_id

--where segments_date = "2025-09-02"

group by all