14 күн бұрын
3 ай бұрын
3 ай бұрын
Пікірлер
@crp9661 3 күн бұрын
Bless you. Quick and clear.
@GrowthLearner 3 күн бұрын
Glad you liked it! Thanks for watching!
@mrdevil6782 3 күн бұрын
Please tech me how to extract email from any website
@LeandroGolinski 4 күн бұрын
you might have exposed your youtube key from 1:56
@GrowthLearner 4 күн бұрын
Thanks for the notice! I used it for another tutorial but I don't have payment attached to that GCP project. Still, appreciate you forn looking out. I'll probably delete it soon.
@rr-jz5ic 5 күн бұрын
thank you so much i was figuring it out for an hour before seeing this 😭😭😭
@GrowthLearner 5 күн бұрын
Glad I could help!
@ahmedmadbouly409 8 күн бұрын
thanks, i need the sheet excel
@africanqueen007 10 күн бұрын
Don't think sonnet 3.5 outperforms GPT vo for data analysis...you can't upload much to sonnet!
@GrowthLearner 10 күн бұрын
I'm seeing that might have to do with the token limit. How much data were you able to upload?
@silvestrecamposano6317 11 күн бұрын
Thanks for the very informative video....
@GrowthLearner 11 күн бұрын
Glad it was helpful! Thanks for watching!
@terrymartin7482 14 күн бұрын
life saver!!
@GrowthLearner 14 күн бұрын
Glad it helped!
@pleasethink4789 16 күн бұрын
This is how you make an instructional video. Straight, simple, clear and to the point. Thanks!
@GrowthLearner 16 күн бұрын
Took me a while to figure that out. Thanks for watching!
@pleasethink4789 16 күн бұрын
@@GrowthLearnerNice. I subscribed.
@GrowthLearner 15 күн бұрын
@@pleasethink4789 appreciate it! Looking to create more videos on GCP among a few other topics.
@ky.ash. 16 күн бұрын
Quick question: tried the formula, absolutely works for bar charts, but when I try to adapt for a column chart, I end up with a column that responds appropriately to the %'s, but doesn't change color. Any idea why this may be?
@GrowthLearner 8 күн бұрын
They're built a bit differently so I wouldn't expect one thing to work for the other. Sorry I couldn't be of more help.
@claireantonette5523 20 күн бұрын
Hi, is it possible to make 1 progress bar with 3 variables in it? I want to make a tracker for my lessons based on the drop down list: Recalled, Familiar, Mastered.
@GrowthLearner 18 күн бұрын
You can make progress bars or rows for each of your variables with the progress bars and then make an overall progress bar combining all 3. Is that what you're asking?
@MESHK0FF 21 күн бұрын
Thanks for this For some reason i can only link to another sheets and docs, a not images...
@GrowthLearner 21 күн бұрын
Thanks for watching! Try typing out the name of the image file. That works for me. It seems like it does give preference to other file types though.
@MEZHGANO 20 күн бұрын
Yes, i'm tried but no luck, fortunately i was able to do this with just copying picture url to the cell, then cell became "smart" with all fancy previews and features)
@GrowthLearner 20 күн бұрын
Glad you found a way!
@AbdulAziz-cj4hg 21 күн бұрын
how about reversing this? because i scrapped instagram followers data and some of them are written in K like theres 3000 followers but theres also 12K followers. how do i make the 12K to 12000?
@GrowthLearner 21 күн бұрын
Use this formula and make sure you change the cell to the desired numerical format: =if((right(F35,1))="K",value(left(F35,(len(F35))-1))*1000,if((right(F35,1))="M",value(left(F35,(len(F35))-1))*1000000,"")).
@masteknisi_ 22 күн бұрын
makasih petunjukknya
@GrowthLearner 22 күн бұрын
Thank you!
@leightonemmons6129 23 күн бұрын
You made this in 2024? Amazing, right when I needed it. MVP.
@GrowthLearner 23 күн бұрын
Sure did! Earlier this year. Thanks for watching!
@Ramprasanna100 23 күн бұрын
This is great thank you. Can I use Google Sheets with multiple tabs?
@GrowthLearner 23 күн бұрын
Absolutely! You can choose the tabs you want to use.
@neathorixon9924 25 күн бұрын
Thank you. Searched everywhere for this!
@GrowthLearner 25 күн бұрын
Glad you found what you were looking for!
@Laurenarchi 26 күн бұрын
Does the trackable URLs account for the attribution window set in the Meta ad? For example if there's a 7 day click attribution, will a sale from someone who clicked the ad but came back and went to the site directly 3 days later, still appear in the data on this report?
@GrowthLearner 18 күн бұрын
This shouldn't impact Meta's nor any other platform's attribution window. Those platforms should still maintain the attribution calculations.
@Beetgrape Ай бұрын
what are the deployment sdks do they provide?
@GrowthLearner Ай бұрын
It looks like they have this SDK to run workloads, lightning.ai/docs/overview/Studios/sdk. I'll have to look into this more, myself.
@Steve-qt2xm Ай бұрын
what the heck is boolean? lol
@GrowthLearner Ай бұрын
Good question. It's a data type that indicates true or false. In this case, it'll check where the URL is an outbound link or not.
@trruthawareness Ай бұрын
even with enhanced tools, it seems hard to get outbound tracking for side bar widgets in wordpress. These widgets have graphics, a title, and links from both. where can i find docs on how to include these links for reporting?
@HkRines Ай бұрын
Why i can do it from my second phone. But i cant from my main account?)
@GrowthLearner Ай бұрын
This isn't the first bug with GPT-4o. Looks like OpenAI is still working some things out. Let me know when it works for you.
@HkRines Ай бұрын
@@GrowthLearner Fu**... My phone autocorrect changed first "Can" to "Cant" : ) Tnx for answer)
@GrowthLearner Ай бұрын
Sure, hope OpenAI works this out soon!
@Bilal-wi8fd Ай бұрын
How to prevent duplicate subscribers?
@GrowthLearner Ай бұрын
Thanks for watching! Brevo should prevent contact duplication. If a subscribed user does submit another email sign-up form, then their contact info would update. Are you seeing a duplication issue?
@marjim318 Ай бұрын
Hi great video thanks for sharing. Is there not a way to add a secondary color to the progress bar like you would for a normal progress bar, for example like this: =SPARKLINE({'Point Tracking'!D27,'Point Tracking'!E27},{"charttype","bar";"color1","#6aa84f";"color2","#f6b26b"}) I'm finding it difficult to add color 2 to the formula, thanks in advance
@GrowthLearner Ай бұрын
Thanks for watching! Are you looking for different colors for different ranges/increments? Like red for 0-33%, yellow for 34-66%, etc.?
@definetheterms1236 Ай бұрын
Is there a way to have the progress bar completely fill up the cell? Instead of having the white border around the bar?
@GrowthLearner Ай бұрын
I don't think there's an easy way to do this. You could try changing the background color of the cell to the same color of the progress bar.
@hayab_u Ай бұрын
the free version of ChatGPT 4o does not allow me to upload csv files (if i upload one, it says that it seems the file has not been uploaded...)
@GrowthLearner Ай бұрын
I'm seeing the bug too. Hopefully they fix it soon. Have you tried other tools?
@SuperAce4444 Ай бұрын
I have Pro, and having the same issues with uploading csv files
@GrowthLearner Ай бұрын
Wonder if they didn't have time to QA some things announcing GPT-4o ahead of Google I/O. Of course voice and video engagement created the most buzz.
@SuperAce4444 Ай бұрын
@@GrowthLearner Quite possible. I even copied and pasted all the information from a small csv file and it broke everytime it tried to “Analyze” it. I have faith it’ll be fixed quick!
@GrowthLearner Ай бұрын
@@SuperAce4444 yeah, sounds like it was rushed. Let us know when you see it working. I'll look out for it too.
@michaelthomas1614 Ай бұрын
What do I have to do if I want to convert a 1.3M into a real number like 1,300,000 ?
@GrowthLearner Ай бұрын
Good idea for a video! Try something like this formula: =INDEX(IF(REGEXMATCH(A1&"", "M"), REGEXEXTRACT(A1, "\d+.\d+|\d+")*1000000, IF(REGEXMATCH(A1&"", "k"), REGEXEXTRACT(A1, "\d+.\d+|\d+")*1000, IF(REGEXMATCH(A1&"", "B"), REGEXEXTRACT(A1, "\d+.\d+|\d+")*1000000000, A1:A4))))
@benalex51 Ай бұрын
Does it work with Sheets?
@GrowthLearner Ай бұрын
For the paid version, OpenAI announced they're rolling out the capability to work with Google Sheets and files from Google Drive, openai.com/index/improvements-to-data-analysis-in-chatgpt/. With the free version of GPT-4o, it looks like you'll have download the file and then upload it to ChatGPT.
@DelosFive Ай бұрын
LOVE this! Thanks so much for sharing. Using it now!!
@GrowthLearner Ай бұрын
Thanks for watching! Glad you found it helpful!
@DiegoJaque-jc1pr Ай бұрын
Thank you! Very useful indeed!
@GrowthLearner Ай бұрын
Thanks for watching! Glad it was helpful!
@user-ro7sb9kd7f Ай бұрын
hi, how can i change the Gantt from weeks to months please
@subhamkumarpandey8920 Ай бұрын
Hey I need help in google analytics reporting.
@GrowthLearner Ай бұрын
What do you need help with? I also have a full tutorial for GA4 reporting, kzfaq.info/get/bejne/ntGFdKp0vdHZYH0.html.
@HenryChatfield Ай бұрын
Very helpful -- thank you! I was struggling to get thousandths decimal specifically for currency. Thanks for showing that you actually accomplish this *without* using the custom currency option.
@GrowthLearner Ай бұрын
Glad you found it helpful! Thanks for watching!
@JuanJoseDiazQuevedo Ай бұрын
can i remove in the label the "K" letter?
@GrowthLearner Ай бұрын
Thanks for watching! Do you mean the abbreviation in the axis label?
@JuanJoseDiazQuevedo Ай бұрын
@@GrowthLearner Yes Sir.
@JuanJoseDiazQuevedo Ай бұрын
I mean, example in the purchase revenue label, the value have a "K" letter. How can I remove that letter? It's possible?
@Safa_jz Ай бұрын
👍👍👍
@GrowthLearner Ай бұрын
Thanks for watching!
@Booyaah69 Ай бұрын
Is real time analytics events such as app_remove possible?
@user-xb8iu4zw7v Ай бұрын
Can't see different options only
@GrowthLearner Ай бұрын
Thanks for watching! When you click on the filter icon, what do you see? This video is similar but may help, kzfaq.info/get/bejne/nZN_pc91nbyqfZ8.html.
@jeffrey_hannah Ай бұрын
Liked, leaving comment. Thank you!
@GrowthLearner Ай бұрын
Much appreciated!
@allenfinley3482 Ай бұрын
You da man
@GrowthLearner Ай бұрын
Back at cha!
@sharoncasto9535 Ай бұрын
I don't want the extra column so how to we work around that. When I delete the original after changing format then I lose the new data
@GrowthLearner Ай бұрын
So you only want to keep the new column? You can hide the original column by selecting it. Are you familiar with how to do that? Or you'll have to copy and paste the new values into another column. Does that help?
@TyMills-bh4rk Ай бұрын
This was very helpful. Thank you
@GrowthLearner Ай бұрын
Glad you found it helpful! Thanks for watching!
@ZEkA10000 Ай бұрын
Syntax error bro
@GrowthLearner Ай бұрын
Are located outside of the U.S.? You might need slightly different syntax. What does your formula look like?
@Think_Stream Ай бұрын
can i add my newly created pages in my website to the google analytics
@GrowthLearner Ай бұрын
Thanks for watching! If you installed Google Analytics to your entire website, it'll automatically track new pages. How did you install GA, manually in the HTML, through CMS plugin, or with a tag manager?
@arifwijanarka 2 ай бұрын
why #error!
@GrowthLearner 2 ай бұрын
Thanks for watching! What does your formula look like?
@arifwijanarka 2 ай бұрын
@@GrowthLearner SPARKLINE(I13 ,{"charttype","bar";"max",100%;"color1","green";"empty","zero"})
@GrowthLearner Ай бұрын
Are you outside of the U.S.? Try this, =SPARKLINE(I13;{"charttype"\"bar";"max"\100%;"color1"\"green";"empty"\"zero"}).
@haiccihx7838 2 ай бұрын
You can install the extension ChangeCase in Google Sheets
@GrowthLearner 2 ай бұрын
Thanks for the suggestion!
@tommytapper9257 2 ай бұрын
How do I know that specific link is being tracked? we never input it anywhere?
@GrowthLearner 2 ай бұрын
Thanks for watching! If you never use it, you send any data to track in Google Analytics. Your campaign data in Google Analytics 4 will confirm that. Are you familiar with finding campaign data?
@KeyAtoms 2 ай бұрын
Can you add the thing we should paste to the description ?
@GrowthLearner 2 ай бұрын
Good idea. Thanks for watching!
@sheelaprajapati8181 2 ай бұрын
The report I created or added not showing my website GSC data. It shows Google's data
@GrowthLearner 2 ай бұрын
Do you see your Search Console account and properties when you add a data source? You may have to add a data source control filter to change all of the data sources for each element.
@sheelaprajapati8181 2 ай бұрын
@@GrowthLearner yes I found. But I am unable to create report for "Linking sites/external links" of GSC data. I do not find "Linking Sites"to dimensions /metrics in the drop-down. Can you please help
@GrowthLearner 2 ай бұрын
I see. Search Console only provides data from Google Search so you won't find data on external sites linking to yours. You'll have to use something like Google Analytics to find sites sending traffic to you. Are you familiar with that?
@sheelaprajapati8181 2 ай бұрын
@@GrowthLearner Appreciated
@GrowthLearner 2 ай бұрын
In case you need it, here's a video for referral traffic, kzfaq.info/get/bejne/hqiZeriKna3NfXk.html. You can put elements with different data sources on the same page using the group function with the data source control filter to make things easier. That way you can change the data source for multiple elements at once.
@josephturcotte6554 2 ай бұрын
Verry helpful! Exactly what I needed.
@GrowthLearner 2 ай бұрын
Glad it helped!
@lee_pfalmer 2 ай бұрын
Thanks!
@GrowthLearner 2 ай бұрын
Thanks for watching!