How to see individual events in GA4 reporting (or universal if I can’t do it in ga4)

I have a conversion event in GA4 called "outgoing clicks" to track outgoing clicks. By clicking on "engagement->conversions" I can see that the event is working and I can group them by source or by some other method. What I can’t do is just see the events as rows. What I want is just to see essentially a flat table where each event is a row that looks like this:

event_action  event_category  event_label timestamp {action}  {category} {label} 7/27/2021 10:34:33 {action}  {category} {label} 7/27/2021 10:35:00 {action}  {category} {label} 7/27/2021 10:36:11 {action}  {category} {label} 7/27/2021 10:37:55 {action}  {category} {label} 7/27/2021 10:38:44 

What’s the best way to do this? Why is this so hard? It’d seem like the most common use case for this data would be to want to see them as rows.

Can I make a short-lived readonly snapshot for reporting in Azure SQL DB?

I have an Azure SQL DB (OLTP), that is under considerable load, let’s call it AppDB. AppDB is transactionally consistent, but new rows are written to it constantly. Now I need to populate ReportingDB based on AppDB state every 30 minutes. Reporting population job runs several moderately big queries against AppDB, those queries, unfortunately, can’t be wrapped in a transaction but still have to all run on consistent data. That is, I can’t have situation Query 1 runs=> new rows inserted into AppDB => Query 2 runs. All my queries have to see data the way it was when Query 1 started.

I was hoping I can use Snapshots to create a read-only snapshot for Reporting job to use. From description, creation of such a snapshot should be fast and subsequent "copy on write" performance hit should be manageable. Snapshots lifetime would be under 10 minutes on average.

But now it looks like Azure SQL does not support CREATE DATABASE ... AS SNAPSHOT OF ..., it only supports CREATE DATABASE ... AS COPY OF ..., which I expect to be a lot slower (probably not meant to be used for reporting snapshot).

What would be a good way to create quick and short-lived read-only snapshots for reporting in Azure SQL DB?

P.S. We have considered replication, but it is not an option for us at the moment due to policy limitations.

Adsense Reporting – Finding Earning not Attributed to an Ad Unit

I’ve been a publisher using Adsense since 2006.

Up until sometime in 2020, I was pretty good with having all ad placements allocated to (or "tied to") Ad Units.

Recently though, as much as half of my actual earnings don’t show up in the Ad Units report. e.g. If my overall earnings on a given day was $ 60, only $ 30 of that shows up in the Ad Units report.

Clearly I must have an ad (or multiple ads) running that don’t have an Ad Unit?

How would I go about troubleshooting that?

It’s all on the same site/domain so hopefully it won’t be too hard to track down.

Reporting services 2008 reports connection to azure sql database

Due to the end of support of sql server 2008 R2 we are planning to move the database to azure as a paas service (azure sql database). Right now the application server has reporting services 2008 R2, for now it won’t be moved to the cloud or upgrade his version. The users create the reports, then they upload them to reporting services and generate the desired information, My question is this: since azure sql database uses the latest version of sql server do the users or myself have to redo the reports in a newer version of report builder or visual studio data tools, or the reports will work the same way and the only thing I have to modify is the data sources.

Clubbing together network websites as subdomains and impact on Google Analytics reporting

We have set two milestones for our business that has a network of websites:

• To generate 50,000 impressions per month for www.digitalsplendid.net so as to make it eligible for selling ad space on buysellads.com, a premium marketplace for display ads. • To generate 500$ per month revenue for six months for www.digitalsplendid.net so as to make the same eligible for listing at popular website marketplaces like EmpireFlippers, FE International for sale.

My query is for the above two milestones (50,0000 monthly impressions and 500$ monthly revenue), does it make sense if our network websites (www.digitalsplendid.agency, www.woosplendid.com, www.finsplendid.com, www.digitalsplendid.news, www.howtosplendid.com, www.micsplendid.com) are clubbed together under the flagship website www.digitalsplendid.net by making all these subdomains of digitalsplendid.net. As I also want to make these network websites live on their own domain name, so news.digitalsplendid.net will redirect to www.digitalsplendid.news.

By following the above strategy, I am not sure if the Google Analytics will count the visitors at www.digitalsplendid.news (news.digitalsplendid.net) under www.digitalsplendid.net.

Reporting trident token or other indications of a user in compatibility mode within Google Analytics

I have noticed that the number of users reporting to be using Internet Explorer 9 is high (2%) within browser & OS in Google Analytics. Reviewing the user agent it’s clear a higher number of these are running Internet Explorer 11 in compatibility Mode. It appears google analytics would represent the following user as IE9. However, the trident value of 7 indicates they are using Internet Explorer 11. What’s my browser example

DeviceType Mozilla/5.0+(compatible;+MSIE+9.0;+Windows+NT+10.0;+Win64;+x64;+Trident/7.0;+Touch) 

I’ve seen older threads stating that it’s not possible to report browser by the trident token or if the the user is in compatibility mode.

Is this still the case? Are there other tools within google analytics that could give an accurate represent of the IE 9 usage?

Facebook marketplace-competitors keep reporting me

ok, lets Start. My name is Lana:)

I have been selling products on facebook marketplace for 8 months. It is going great.
Last week I noticed that my listings are not visible but everything else looked normal.
After 3 days FB unblocked me and my listings were public for 1 hour.

Then the same thing happened again but this time I was blocked for 1 day.

I noticed I have competitors (same products) and they have more than 20 fake accounts with listings.
Then I got report from FB that someone…

Facebook marketplace-competitors keep reporting me

Gedit in Ubuntu in VM reporting file changed on disk

Note: I heard that asking about old version is off topic here. But I’m using ubuntu 14.04 which is required by my build environment.

The question is very similar to this one: https://superuser.com/questions/298577/gedit-in-vmware-always-says-file-has-been-modified-since-opening-when-i-save, may be the two have the same cause, but the phenomenon is not exactly the same.

Note: please don’t suggest me to use a newer version of Ubuntu, some of the software I use need 14.04.

I’m using Ubuntu 14.04.4 in VMWare workstation 12.1.1 under Windows 7 x64 and now VMWare workstation 15.1.0 under Windows 10 x64 which makes no difference. I mount a shared folder which is /mnt/hgfs/share to share file with the Windows host easily, and I create and edit a text file like /mnt/hgfs/share/docs/1.txt using GEdit 3.10.4. The shared folder is created with VMWare Workstaion’s GUI under Windows.

Then constantly after a while it will pop up a message “The file “/mnt/hgfs/share/docs/1.txt” changed on disk”. I’m not sure under what condition the message will show up, but I’m sure sometimes I’m not editing the file outside Gedit and sometimes it shows up many times even I’m not editing it in GEdit. The date/time method in the above question doesn’t work.

The more serious problem is that often when I save the file, it says it’s been modified outside and persuades me to drop the edit.

SQL Server Reporting Services Report Viewer – Error Message

We are trying to add the SQL Server Reporting Services Report Viewer webpart to a page, but get the following error:

“An error occurred during local report processing. For more information about this error navigate to the report server on the local server machine, or enable remote errors”

We are running an old version of Sharepoint – I believe it’s Sharepoint 2010.