GA360导出至BigQuery后，DCM维度与指标的获取方式咨询

Great question—let’s break this down clearly so you can get the data you need.

Do DCM dimensions/metrics come with the default GA360 BigQuery export? #

Short answer: Only a limited set of DCM data is included, and only if your GA360 and DCM accounts are properly integrated.

The standard ga_sessions_* tables from GA360’s BigQuery export will include fields prefixed with dcm_ (like dcm_campaign, dcm_adgroup, dcm_cost) if you’ve set up the GA360-DCM integration and enabled data sharing. But these fields only reflect DCM activity that’s been captured and tied to GA sessions—they don’t include the full raw dataset from DCM itself (like all impressions, clicks, or offline conversions that didn’t trigger a GA session).

If you’re not seeing any dcm_ fields in your export, double-check that:

• Your GA360 property is linked to your DCM account in the GA admin panel
• You’ve enabled the "Share data with DoubleClick Campaign Manager" setting
• The DCM data has had time to sync (it can take 24-48 hours for new integrated data to show up in BigQuery)

Best way to get full DCM raw data #

If you need the complete set of DCM dimensions and metrics (not just what’s tied to GA sessions), here are your top options:

• Direct DCM to BigQuery Export: This is the gold standard. Campaign Manager 360 lets you export its full raw data directly to a dedicated BigQuery dataset. This includes every impression, click, conversion, and all native DCM dimensions (like advertiser IDs, placement details, creative versions) that aren’t captured in GA. Once exported, you can join this data with your GA BigQuery tables using shared identifiers like dcm_click_id, user IDs, or session IDs to get a unified view.
• Enhance your GA360-DCM integration: If you only need DCM data that’s tied to GA user behavior, make sure your integration is fully configured (as noted above). This will populate the dcm_* fields in your ga_sessions_* tables with the relevant DCM attributes linked to each session.

Can you use the Core Reporting API? #

Yes, but with limitations. The Core Reporting API can pull the same DCM-related dimensions/metrics that are available in the GA interface (and the ga_sessions_* tables). However:

• It only returns data that’s been captured by GA (so no full DCM raw data)
• It has strict request quotas, making it impractical for pulling large volumes of historical data
• It’s better suited for small, targeted reports rather than full-scale data warehousing

If you need full DCM raw data, the direct BigQuery export from DCM is far more efficient.

内容的提问来源于stack exchange，提问作者Iyad Al aqel