Google Analytics stores your website data as a binary large object (blob). It uses SQL views to query the blob to create 32 virtual objects that you can connect to.
NOTE: Knowledge of Google Analytics Reporting API is necessary when selecting which virtual objects to connect to. Google Analytics Reporting API rules for allowed object and metric interactions, described in the Dimensions & Metrics Explorer, impact connecting to Tableau CRM.
When troubleshooting, use the Google Analytics Query Explorer to confirm that the fields that you intend to query are valid.
Tableau CRM creates a GLOBAL_ACCESS_OBJECT virtual object containing fields from the other virtual objects. Use this object to prepare datasets for more complex scenarios.
The Google Core Reporting API includes these limits:
You can select up to seven dimensions and 10 measures for each virtual object that you connect to.
You can sync up to one million rows for each virtual object. When ecuador phone number you sync more than one million rows, Tableau CRM aggregates the data from the extra rows and syncs the data as a row marked “Others.” To sync more than one million rows for an object, consider using the Google BigQuery connector.
I hope that’s answered all of your questions when it comes to Pardot vs Google Analytics! Integrating third-party platforms is essential to having a streamlined and accurate Pardot account, so follow best practices and if you get stuck, feel free to send our team a message.
Share
Hollie Fitzpatrick
Hollie Fitzpatrick
Hollie joined the MarCloud team with extensive B2B marketing experience. With a keen interest in marketing technologies, they strive to find the best solution to increase the efficiency and quality of marketing campaigns through rigorous testing and data analysis. A certified Pardot consultant, Hollie spends her days at MarCloud b