SAP Marketing Cloud and Goggle BigQuery integration without Google Analytics

[mikhail_naumov2]

Dear experts, we are trying to import data from Goggle BigQuery using standard integration.

It looks like it’s only possible if BigQuery data are coming from Google Analytics which is not our case. We upload data to BigQuery directly from ecommerce web site without using Google Analytics.

This limitation looks very strange and artificial, can anyone confirm and explain reason behind this?

[former_member599277 · Accepted solution]

Dear Mikhail / Victor,

Yes , as per the current design , it's not possible to only use BigQuery without the Google Analytics 360 integration.

When the datasets are retrieved from Google BigQuery, a check is performed that ensures that the datasets have a corresponding view in Google Analytics.

If no corresponding Google Analytics view is found for a dataset, the dataset is not considered.

Here is the documentation for usage of BigQuery in Google Query Configurations

Querying Interaction Data from Google BigQuery

I recommend you to submit your idea of improvement so that your idea could be evaluated by product management; refer to note ##2812948.

https://influence.sap.com/sap/ino/#/campaign/38

Best Regards,

Saravanakumar.

[mohannad_el-jayousi]

Hello Mikhail,

Can you please detail your scenario further? What clickstream tracking tool is used on the ecommerce website? Are you trying to pull the records from BigQuery as SMC interactions?

There already exists an influence request for this, please add your vote.

Kind regards,

Mohannad

[mikhail_naumov2]

Hi Mohannad, thanks for the reply, yes, the idea was to pull contacts IDs and interactions, more less as per standard business scenarios currently provided. In our case, ecommerce solution based on Magento, it pushes data we need directly to Google BigQuery somehow, no seperate clickstream tracking tool is used to my knowledge.

[vvicentv]

We are facing exactly the same scenario described by Mikhail. Any explanation of how to achieve it will be very appreciated.