Dashboards & Reporting

Nicolas_Maiwald
Member

Cannot Retrieve Custom Property in Google Looker Studio

SOLVE

Hi everyone,

thanks for taking the time to read this! A client of mine wants to track how many people in a respective time period have been sent an offer. For that purpose, a filter can be applied to all deals with [Date entered "Offer is sent"]. Unfortunately, this field is not available in Looker Studio via any connector.

To work around the non-existence of this filter in LS, the client has set up a custom property, which gets triggered via a workflow to set a date field corresponding to the date the offer is sent out (see screenshot)

This field is available in Looker, but too inprecise to be of use. How would you approach such a problem? I honestly don't know what to do anymore.

Thanks for your help!

Best

Screenshot 2024-07-24 at 17.31.57.pngScreenshot 2024-07-24 at 17.31.17.png

 

0 Upvotes
2 Accepted solutions
StjepanGrcic
Solution
Top Contributor | Diamond Partner
Top Contributor | Diamond Partner

Cannot Retrieve Custom Property in Google Looker Studio

SOLVE

Hi @Nicolas_Maiwald you could copy this property data to a custom property you create on a deal object and pass that data point. Then you should be able to pull it into Looker Studio since the native integration allows to query custom properties on all the objects. Let me know if this helped. Stjepan copy.jpg

View solution in original post

Nicolas_Maiwald
Solution
Member

Cannot Retrieve Custom Property in Google Looker Studio

SOLVE

Hi all, thanks for all your answers! I've found a workaround by now to first send all the data concerning the "Offers" to a Google Sheet and then retrieve it from their in Looker Studio. Somehow directly pulling it from Hubspot to Looker via the Power My Analytics or Super Metrics connector did not work, but via a Google Sheet works perfectly. 

View solution in original post

0 Upvotes
4 Replies 4
Nicolas_Maiwald
Solution
Member

Cannot Retrieve Custom Property in Google Looker Studio

SOLVE

Hi all, thanks for all your answers! I've found a workaround by now to first send all the data concerning the "Offers" to a Google Sheet and then retrieve it from their in Looker Studio. Somehow directly pulling it from Hubspot to Looker via the Power My Analytics or Super Metrics connector did not work, but via a Google Sheet works perfectly. 

0 Upvotes
HubSpot_Corey
Top Contributor

Cannot Retrieve Custom Property in Google Looker Studio

SOLVE

Hi @Nicolas_Maiwald  and thanks for the tag @BérangèreL ,

 

Apologies for the slow response—I've been away on holiday for the past month. Could you please elaborate on what you mean by "too imprecise to be of use"? Is the issue with how the workflow is being triggered (i.e., not always setting the date stamp), or is the custom property itself not capturing the required information (such as missing or incomplete timestamps)?

Once I have a bit more clarity, I should be able to assist further.

StjepanGrcic
Solution
Top Contributor | Diamond Partner
Top Contributor | Diamond Partner

Cannot Retrieve Custom Property in Google Looker Studio

SOLVE

Hi @Nicolas_Maiwald you could copy this property data to a custom property you create on a deal object and pass that data point. Then you should be able to pull it into Looker Studio since the native integration allows to query custom properties on all the objects. Let me know if this helped. Stjepan copy.jpg

BérangèreL
Community Manager
Community Manager

Cannot Retrieve Custom Property in Google Looker Studio

SOLVE

Hi @Nicolas_Maiwald and welcome to the Community!
We are thrilled to have you here!

Great question, thanks for asking the Community!

I understand that you are using the "Looker Studio Integration" integration and you'd like to sync a custom property. Please let me know if that's not the case.

I love the workaround that you put in place, that's a really good idea! But you are saying that it is not precise enough.

Have you tried in the workflow, to use, instead of the "set property value" to "copy property value"? Would that work better I wonder?

I'd be happy to put you in touch with some of our Top Experts and some of our Community Members: Hi @DMilard, @tmcmillan99, @johnelmer, @shaikhzeba23, @HubSpot_Corey and @StjepanGrcic do you have other suggestions to help @Nicolas_Maiwald, please?

Thank you very much and have a brilliant day!

Best,
Bérangère


Saviez-vous que la Communauté est disponible en Français ?
Rejoignez les discussions francophones en changeant votre langue dans les paramètres !

Did you know that the Community is available in other languages?
Join regional conversations by changing your language settings!


0 Upvotes