search

GoogleCloudPlatform / marketing-analytics-jumpstart

Marketing Analytics Jumpstart consists of an easy, extensible and automated implementation of an end-to-end solution that enables Marketing Technology teams to store, transform, enrich with 1PD and analyze marketing data, and programmatically send predictive events to Google Analytics 4 to support conversion optimization and remarketing campaigns.
Apache License 2.0
102 stars 35 forks source link

Question: Dealing with multiple Google Ad and Google Analytic properties #190

Open jonathan-moulds-sb opened 1 week ago

jonathan-moulds-sb commented 1 week ago

Hi,

Firstly thanks for the amazing resource, this really is a great accelerator.

I do have a question on approaches or best practices when consolidating multiple Google Ad and Google Analytics tenancies/properties into a single Marketing Data Store?

It looks like the template has been set up for Google Ads to handle multiple datasets but for google analytics Is it better to consolidate the "events_" table in each export into a single view or set up seperate dataform loads for each property? Could this be handled through these templates?

Any suggestions or guidance on approach would be greatly appreciated.

Thanks

kingman commented 4 days ago

Hi Jonathan,

For handling multiple GA4 exports corresponding to multiple properties we recommend to change the GA4 export parameter to become a list of multiple dataset similar to the ads_export_data parameter. Then in dataform code make changes to the GA4 related pipelines to take property_id as a input so that it creates separate datasets for each property, something in the style: marketing_ga4_base_prod_xxxx and marketing_ga4_v1_prod_xxxx and for all the feature engineering and ML pipelines in MAJ the property parameter need to be added so that it sources the correct underlying dataset for it's process. It's not recommended to consolidate event data for multiple properties into single table or dataset, as the data should be used separately for each properties in all the MAJ pipelines.