I saw some traffic from "Discover" for a few days but later it back to zero again.
And I never got any traffic from "Discover" since 5/16/21.
What is this for?
Thanks
Tag: Google
google apps script – Duplicate and rename a sheet (only it`s data) at fixed hr and day
every monday I’ve to make a copy of a sheet which is called week_nn, where nn is a progressive number of the current week for that sheet from its beginning. At some point of the day, we have to fix those data to make a history, and so I duplicate the sheet which take the standard name of “copy_of_week_nn_WIP” to “copy_of_week_nn_FRZ”. If possible, I’d like to automathize this with a triggered script (time/day, in this case, every monday), because sometimes it happened if forgot the task and also, because it`s a stupid job…how I could possible do it?
reporting – Google Analytics 4 – Explore section reports share with edit access
I am using GA4 property to track my website data.
I have created a couple of reports from “Explore” option on the left side. (Funnel/ free form/ bar/ donut).
I want to share this report to other users – who are having the following access – Edit, Collaborate, Read and Analyze.
But when they view report shared by me – they are not able to edit any report property – for example not able to change the date on the top left, not able to change the metric value/ not able to change the dimension value.
How to share editable exploration report in GA4 ? Is there an option of this? Should I change the access of the users?
Google Sheet filter issue – Web Applications Stack Exchange
I have a Google Sheet that collects responses from a Google Form, this collects contact details and preferred location. I shall call this workbook Feeder.
In a second Google Workbook (called placements) the data from the feeder sheet is imported into a sheet via =importrange. In addition, this workbook has a series of sheets for each preferred location. These sheets display the records for each preferred location using =filter (on the data that has been imported via =importrange).
Additional information is typed in associated columns for each record in the preferred location sheets.
My issue is if a new entry is made in the feeder worksheet – it will populate in the correct location sheet (which is sorted by last name) – but will misplace the “additional information” that has been typed for the existing records.
Any help would be really grateful received.
seo – How to show same company’s different office address in google based on the user’s country?
our company has five offices in five countries , once the user search in google, I need to show the office address based on the user’s country, for example if the user search from US , I need google to show US office address automatically, also if the user search a specific office address then the search result will show that country office address, for example, the user search “ABC UK or ABC UK office address ” then the search result shows the UK office address. How can I do that?
google cloud platform – GCP, basic IPv6 set up for Linux VM Instance
I’m trying to set up a simple VM in Google Cloud Platform that can ping ipv6.google.com successfully. I’m using these GCP docs regarding IPv6 support, including :
Here’s what I’ve done so far:
- In my project, I created a VPC subnet called “proj-net” in region “us-west2”, and enabled IPv6 for it using the gcloud command:
gcloud compute networks subnets update proj-net
--stack-type=IPV4_IPV6
--ipv6-access-type=EXTERNAL
--region=us-west2
- I created a Debian 10 VM instance called “test-srv-1” then enabled IPv6 with:
gcloud compute instances network-interfaces update test-srv-1
--ipv6-network-tier=PREMIUM
--stack-type=IPV4_IPV6
--zone=us-west2-a
According to the documentation, the GCP is to provide a /64 and the NIC should be assigned the first address from that range. And, a default route and firewall rule should be set up to allow outgoing traffic (should allow the ping.)
From the test-srv-1 VM, when I try to ping Google with IPv6, I get a No Route error:
$ ping6 ipv6.google.com
PING ipv6.google.com(lax31s01-in-x0e.1e100.net (2607:f8b0:4007:80e::200e)) 56 data bytes
From fe80::4001:ff:fe00:0%ens4 (fe80::4001:ff:fe00:0%ens4): icmp_seq=1 Destination unreachable: No route
I’m still learning IPv6 admin concepts as well as learning how GCP deals with addressing/routing for instances. It’s challenging to know what GCP is to provide, and what I need to set up on the VM host, so I’m looking for any advice on next steps.
For more information, here is what I can see on the VM:
The IPv6 information for the VM’s interfaces look like this:
2: ens4: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1460 state UP qlen 1000
inet6 2600:1900:4120:1415:0:1::/128 scope global
valid_lft forever preferred_lft forever
inet6 fe80::4001:aff:fe04:2d2/64 scope link
valid_lft forever preferred_lft forever
And the routes:
Kernel IPv6 routing table
Destination Next Hop Flag Met Ref Use If
::1/128 :: U 256 2 0 lo
2600:1900:4120:1415:0:1::/128 :: U 256 1 0 ens4
fe80::/64 :: U 256 2 0 ens4
::/0 fe80::4001:aff:fe04:201 UGDAe 1024 3 0 ens4
::1/128 :: Un 0 5 0 lo
2600:1900:4120:1415:0:1::/128 :: Un 0 3 0 ens4
fe80::4001:aff:fe04:2d2/128 :: Un 0 4 0 ens4
ff00::/8 :: U 256 4 0 ens4
::/0 :: !n -1 1 0 lo
Can anyone give me any advice on how to take next steps?
security – How secure is google chrome’s saved passwords?
How secure is Google Chrome’s password-saving functionality? I learned that it saves passwords to a file and a database in which all the passwords are encrypted. In particular, I would like to know if Chrome is the only application that can decrypt it, or if any person or application can grab the plaintext password once the encrypted password is stored on the computer.
How can I include two formulas in a single cell in Google Sheets?
I’m in the process of making a spreadsheet of stocks that I’m watching in Google Sheets. I want to include the daily price and percentage change in a single column. I found a helpful Docs Editors thread, and I was able to get it working the way it’s formatted in the answer from that thread.
What I’m starting with is the following input (A2 contains a ticker symbol):
=GOOGLEFINANCE(A2,”change”)&” | “&GOOGLEFINANCE(A2,”changepct”)
That displays this (using random numbers):
1.25 | 3.15
That technically works. However, I’d like the data to display in a different way. This is what I’d prefer:
+$1.25 (+3.15%)
The parentheses are the most important part, but I’d also like to show the dollar sign, percent symbol, and plus symbol if possible (the minus symbol will always show for negative values, but I want to also always see the plus symbol for positive values).
I’ve changed the input to the following:
=GOOGLEFINANCE(A2,”change”)&” (“&GOOGLEFINANCE(A2, “changepct”)”)”
That gives me an error that says, “Formula parse error.” Changing it to
=GOOGLEFINANCE(A2,”change”)&” (“&GOOGLEFINANCE(A2, “changepct”)
gives a functioning result, but it’s of course missing the closing parenthesis. The cell displays as
1.25 (3.15
What am I doing wrong? Any help is appreciated!
How can I show historical performance for stocks in Google Sheets?
I’m in the process of making a spreadsheet of stocks that I’m watching in Google Sheets. I want to include columns showing historical performance (1-month, 3-month, etc.) for all the stocks included in the sheet. I thought I had it figured out after finding this Reddit thread, but it’s not working.
Starting with 1-month performance, here’s what I’ve entered in the relevant cell: “=GOOGLEFINANCE(A2)/GOOGLEFINANCE(A2,”close”,TODAY()-30)” (cell A2 contains a ticker symbol). The error message says, “Function DIVIDE parameter 2 expects number values. But ‘Date’ is a text and cannot be coerced to a number.”
I tried removing “”close”” (which changes the input to “=GOOGLEFINANCE(A2)/GOOGLEFINANCE(A2,TODAY()-30)”), but I still get an error. This time, it says, “Function GOOGLEFINANCE parameter 2 value is invalid for the symbol specified.”
What am I doing wrong? Any help is appreciated!
google – Custom Chrome DNS-Over-HTTPS not working
I’m trying to configure Chrome to use a DNS-Over-HTTPS server not in the drop down list. Everytime I put in a valid address Chrome reports:
Please verify that this is a valid provider or try again later
I think there’s something funny with the way Chrome expects the server format but I haven’t been able to find any specific documentation, however when you examine the Chrome settings page and look at the drop down list, you can see how some addresses are prefixed with ‘chrome.‘ while others have a placeholder ‘{?dns}‘
<select id="secureResolverSelect" class="md-select" aria-label="Provider options">
<option value="">Custom</option><option value="https://chrome.cloudflare-dns.com/dns-query">Cloudflare (1.1.1.1)</option>
<option value="https://dns.google/dns-query{?dns}">Google (Public DNS)</option>
<option value="https://doh.cleanbrowsing.org/doh/family-filter{?dns}">CleanBrowsing (Family Filter)</option>
<option value="https://chromium.dns.nextdns.io">NextDNS</option>
<option value="https://doh.opendns.com/dns-query{?dns}">OpenDNS</option>
<dom-repeat style="display: none;"><template is="dom-repeat"></template></dom-repeat>
</select>
If I try just https://cloudflare-dns.com/dns-query it fails but if I add the ‘chrome.‘ prefix before cloudflare then it works. Also other providers like https://dns.quad9.net/dns-query do not work.
This is the latest Chrome version 92.0.4515.107 (Official Build) (64-bit) on a Windows 10 x64 box. Is this a Chrome bug?
