GA4の会員/非会員のユニークユーザー数をSQLで取得する実例

会員/非会員

and,a株式会社　デジタルマーケティングエンジニア　佐藤洋太

導入

会員制サイトを分析するにあたり、会員/非会員軸で分析をすることは多々あります。
そこで今回はGA4とBigQueryの現場で非常によく使われる会員/非会員軸の実践的な方法をご紹介いたします。

この記事の対象

  • 会員制サイトのアナリストでSQLが不慣れな方
  • A4の会員/非会員UU数を抽出し、分析に役立てたい方

前提の実装

サイト側に生成されている会員IDをGA4で計測できるようにする準備をします。
※会員IDのサイト側への生成方法はサイトによって異なるため今回は詳細解説を省きます。

はじめにGTM側で会員IDをGA側に送れるように設定をします。

ポイントは「設定フィールド」にuser_idを指定します。
こちらの設定で会員IDをGA4に送り、GA4側で認識できるようになりました。
このIDをGA4が受け取ることでGA4側でサイトに生成された会員IDを識別できるようになります。
BigQueryに反映されるのはGTMの設定を反映した次の日からとなりますのでご注意ください。

※会員IDの取り扱いについては個人情報が特定できない範囲で取得をしてください

BigQueryで実際に会員/非会員を出力してみる

STEP1

では早速、先ほどの会員IDを出力するSQLです。
※以降、登場する以下の`ga4-quick.analytics_302974976.events_*`の箇所をお使いのGA4のデータセット名に置換し、日付の箇所を調整するだけで簡単にお使い頂けます。

SELECT
    DATE(TIMESTAMP_MICROS(event_timestamp), 'Asia/Tokyo') AS hitdate,
    user_id,
    CONCAT(user_pseudo_id, CAST((SELECT value.int_value FROM UNNEST(event_params) WHERE key = 'ga_session_id') as STRING)) AS sid,
  FROM `ga4-quick.analytics_302974976.events_*`
  WHERE
  _TABLE_SUFFIX BETWEEN '20220901' AND '20220901'
  AND platform = 'WEB'
  AND user_id IS NOT NULL

解説

一見複雑そうに見えますが重要なのはこの1文だけです。

 AND user_id IS NOT NULL

この１文で会員だけのデータを抽出できます。
コードを日本語に直すとわかりやすいと思います。
「user_idがNULLじゃない対象」を検索しているだけです。

  AND user_id IS NULL

逆に言ってしまえばNULLなら非会員です。簡単です。

STEP2

では、先ほどのSQLを少し発展させてみましょう。
会員/非会員のユーザー数を取得します。

WITH
GA_web_tbl AS (
  SELECT
    DATE(TIMESTAMP_MICROS(event_timestamp), 'Asia/Tokyo') AS hitdate,
    event_timestamp,
    event_name,
    user_id,
    user_pseudo_id,
    CONCAT(user_pseudo_id, CAST((SELECT value.int_value FROM UNNEST(event_params) WHERE key = 'ga_session_id') as STRING)) AS sid,
  FROM `ga4-quick.analytics_302974976.events_*`
  WHERE _TABLE_SUFFIX BETWEEN '20220901' AND '20220901'
    AND platform = 'WEB'
),
_member_raw_tbl AS (
  SELECT
    DISTINCT hitdate,
    user_id,
    sid,
  FROM GA_web_tbl
  WHERE user_id IS NOT NULL
),
member_tbl AS (
  SELECT
    DISTINCT hitdate,
    COUNT(DISTINCT user_id) OVER(PARTITION BY hitdate) AS member_count,
  FROM _member_raw_tbl
),
_no_member_web_tbl AS (
  SELECT
    DISTINCT hitdate,
    COALESCE(user_id, '0') AS user_id,
    user_pseudo_id,
    sid,
  FROM GA_web_tbl
  WHERE user_id IS NULL
  AND NOT EXISTS (
    SELECT * FROM _member_raw_tbl WHERE sid = GA_web_tbl.sid
  )
),
no_member_tbl AS (
  SELECT
    DISTINCT hitdate,
    COUNT(DISTINCT user_pseudo_id) OVER(PARTITION BY hitdate) AS no_member_count,
  FROM _no_member_web_tbl
)

SELECT *
FROM member_tbl AS t1
LEFT JOIN no_member_tbl AS t2 USING (hitdate)

WITH句が出てきて記述量が増え、複雑に見えますが大したことはしていません。

解説

WITH句のサブクエリごとに解説していきます。
GA_web_tbl についてはGAからデータを抽出してきているため省略します。

_member_raw_tbl AS (
  SELECT
    DISTINCT hitdate,
    user_id,
    sid,
  FROM GA_web_tbl
  WHERE user_id IS NOT NULL
),

こちらの出力結果は日本語に直すと「user_idがNULLではないレコードのhitdate, user_id, sidをGA_web_tblから取得。ただしhitdateは重複なし」という形です。

member_tbl AS (
  SELECT
    DISTINCT hitdate,
    COUNT(DISTINCT user_id) OVER(PARTITION BY hitdate) AS member_count,
  FROM _member_raw_tbl
),

こちらは集計のためのテーブルで、hitdateごとにuser_idをカウントして出力します。今回は対象の2022/09/01なので結果は１行となります。

COUNT(DISTINCT user_id) OVER(PARTITION BY hitdate) AS member_count,

こちらの構文については下記に詳細に記載されています。​​https://cloud.google.com/bigquery/docs/reference/standard-sql/window-function-calls?hl=ja#syntax

使い方が難しいと感じる方もいらっしゃるかもしれませんが思いの外簡単です。日本語に直すと「user_idを重複なしで日毎にカウントする」という感じです。

_no_member_web_tbl AS (
  SELECT
    DISTINCT hitdate,
    COALESCE(user_id, '0') AS user_id,
    user_pseudo_id,
    sid,
  FROM GA_web_tbl
  WHERE user_id IS NULL
  AND NOT EXISTS (
    SELECT * FROM _member_raw_tbl WHERE sid = GA_web_tbl.sid
  )
),

次のテーブルは前述の_member_raw_tblとよく似ています。
違いはuser_IdがNULL（非会員）であることとEXISTS演算子の登場です。
また、user_idをNULL（非会員）で検索をかけていますNULLの取り回しが悪いので、念のためCOALESCE関数で文字列の0として置換します。

  AND NOT EXISTS (
    SELECT * FROM _member_raw_tbl WHERE sid = GA_web_tbl.sid
  )

こちらは、_member_raw_tblのsidとGA_web_tblのsidが一致していたら結果に含まないようにするという処理を行なっています。つまりこれで、user_idの無いGA_web_tblから_member_raw_tblのsidと一致しないものを抽出しています。

EXISTS演算子の使い方についてはこちら
https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators?hl=ja#exists_operator

ここでのポイントは、sidで除外をしているという点です。
考え方が非常に重要なのですが、１回のセッション内でuser_idが存在した場合、そのセッション全てを会員とみなすという考え方が根本になっています。
例えば、１回のセッション内でuser_idが変更された（＝ログインがあった）場合は別のユーザーとして計測するという考え方の場合は別のSQLが必要になってきます。

no_member_tblはmember_tblとほぼ同じなので割愛します。

最後のクエリです

SELECT *
FROM member_tbl AS t1
LEFT JOIN no_member_tbl AS t2 USING (hitdate)

これで下記のような結果が出ます。

hitdatemember_countno_member_count
2022-09-01会員UU数非会員UU数

GA4の非サンプリングデータが欲しい場合や、UUを軸にトラフィックを分析をする場合などに役に立つと思います。

GA4のSQLについてご支援をご希望の方は、お気軽にand,a（このサイトの運営元）までご連絡ください。

関連記事

特集記事

A/Bテスト

生成AIを調整してABテストを実装したら想像以上に早かった
A/Bテスト

無料で使えるABテストツールのバージョンアップを行いました
A/Bテスト

無料ABテストツール（and,B）のマニュアルを作成しました
A/Bテスト

今日から無料で使えるABテストツールを作ってみた
Python

ECサイトのゴールデンルートを発見する方法 – Google Analytics 4とPythonを活用して（第2回）
トレジャーデータ

GA4 -> トレジャーデータ 連携術

コメント

  1. Thanks a lot for the blog post.

  2. I cannot thank you enough for the article. Fantastic.

  3. I truly appreciate this blog article. Really Cool.

  4. Really informative article post.Thanks Again. Fantastic.

  5. Very informative post.Much thanks again. Really Great.

  6. Thank you ever so for you blog.Really thank you! Much obliged.

  7. A round of applause for your blog article.Much thanks again. Will read on…

  8. Major thanks for the blog. Want more.

  9. Thanks for sharing, this is a fantastic blog article.Thanks Again.

  10. Great blog article.Really looking forward to read more. Great.

  11. Thanks for the blog post.Much thanks again. Keep writing.

  12. Is anyone able to recommend good Mild Steel B2B Business Data List? Thanks very much 😀

  13. I really like your writing style, superb information, regards for posting : D.

  14. Terrific post however I was wondering if you could write a litte more on this topic? I’d be very thankful if you could elaborate a little bit further. Appreciate it!

  15. Really informative blog article.Really looking forward to read more. Fantastic.

  16. wow, awesome blog.Really thank you!

  17. Great, thanks for sharing this article post. Fantastic.

  18. Enjoyed every bit of your article.Thanks Again. Awesome.

  19. I think this is a real great blog.Thanks Again. Cool.

  20. Im obliged for the article.Really looking forward to read more. Want more.

  21. Thanks-a-mundo for the article post.Really looking forward to read more. Will read on…

  22. Thanks for your marvelous posting! I certainly enjoyedreading it, you are a great author.I will be sure to bookmark your blog and willcome back down the road. I want to encourage yourselfto continue your great writing, have a nice weekend!

  23. Great blog post.Really thank you! Really Great.

  24. Thanks for the blog post.Really thank you! Really Cool.

  25. I value the blog post.Really thank you! Awesome.

  26. Ratee mt nuude photoErotic fiction gynarchyGrandpa crempies
    teensHoww doo you sexFreee porn xxxnPenis
    showing through yor pantsBukkake creampie tubesIndependnt phyoenix escortDragoon ball
    z bulma hentaiBiig beloy naked womenJebna jooy adultGalleries off mature beautiful womenCockk craving rewdhead teenBrreast look
    biggerMother i like too fucxk tubeArrthe quot sexVaginal fingering tipsHomemade fuckingBrunette ced fucking videosShare
    mmy wife sexEyeful of cumSex at disnetlandSites teenBabbe iin jeeans
    pissingIce breaker for adult educaztion classElegant aand
    erotic beautyNatalie bassingthwaite sexxy picsMatture olderr gay males enis cummingVintage clothing
    hop nycAsian massage holland michTyppe of yarn too usse to crchet a bikiniFrench nude mature
    vaginasGirfls getting fucked hardd in tthe pussy licking videosPornoraphy russianVintag business photosHugee haory pussy pregnetXxxx oldd
    whoresSexx x oold x womenBotrtom gussetMenn iin feminine attire fuckingAsian pacific american legal centerCunt
    ayanoFudked upp facials fdee trailerDawn frencch pornXxxx video frfee
    streamingCloset homosexuawl behaviorViacom sucksStrazight ass pumjeled gay pornhubMy
    gayy wworld de broederHahahaha asisn latin nudes Onlihe
    nhde granniesPretty yooung aked boysFuck off yyou fucking soft shitBoyfriend a handjobAmatuer uppskirt photosGlasss bpttom boatfs in tthe dominican republicWhatt happens to repelled spermTeewns ude by raceHoow to use a
    vibrator viodeo freeGaay controvrsy articlesAmater 123 nude
    picturesTeeen ffashion inn serbiaHot milfs sex storiesMasyer chief drawn fuckming cortanaBig
    coock transexualAustrawlia seex taxClit jaymmes jessicaHollywood maan nudeCalendar girls stfip clubVintae hommlite chainsaw partsBabe
    bpack buszty freee videoMatur tgp indianExecutive hotrel vintage court union squareTeens trioHeel high masturbatio movieVeronia brazil nudeBondage paaperStrip clubs atlanta gaLass vegas escoets sarahh blakeSwijgers
    chubbyPhotos off sex amon gay menAmayuerr nuhde tubeBuutton cover jeweled vintageOrggasm asian redNudee tannjing
    boothsAsss bumpMature thumbnai galleries postFreee 60
    xxxx nudeAnna paula msncino nudeAsian paintiesPorrn video
    zeusVimtage road bikesShops on the strip iin pittsburghDirty adultt comic stripsEscort gkrl versaillesBisexual como
    lesbiana o sabber sii soyViintage tail coatXxx harxcore gaay fuckingClikndesse crream vaginalPree teen gils inn pantiesAsian psper art the histoeryHardcore young sex picsHaydedn panettiete nnude at
    beachGaay parents wihout partnersCock sparrer rynnin riolt inn 84Gay cruising
    appHuude cyberskin dildosNaked picttures ‘famous males’ – gayXxx dog licing cunt homemadeNuude musclle imageAmatuer
    forcced tto lick pussyRecile cyicken brast easy fastBusty babes listNaed prety
    pussySexx manicansAsian desktop girlLatina pordn stars directorySexy rough footjobNude teeen art modelsFreee nude potn sexFrree adult movids creampieMom
    teachers teenn strapon sexCollege teen blowjobBlaqck gaycock thumbsBazarr sexual sitesDeepthroatt tease storyPornn amateur
    blooperCabooltjre swingrs partySexx offender treatment counnseling longvijew txSmart redheadPornn sstar
    lisa youngNudee scne fron barbarellaUnboxing pornDiva maryse nude wweMessy cumm shots max slutsVirgin mobile samsung interceptCumm girls galleryShemmale dicksuckersSexual assault faarmington ctWhatt does fackal smrll likeMiiss
    california sex picswCompaare seex voltz annd maxhardZebra
    striped wallpaper boarderMassiv natural tits tubeBlonde
    sllut chokeDonate i sperm vial willVideoo sexx leather bootsHott yooungteen pussy vidsReal turning lezbian storiesPeercy shelley gayGuy with a small penisFreee elephaht
    sexx moviesFreee oldee gaay pornBig asses caKodak insstant plpeasure camera poloriodDeath pornographySwinging pafty in altair
    texasViatimins for ssex driveAmateur deshaboller camAsss fucking fre
    sex videoFat teens masturbatingBarfland latexAmature mayure porn tubeBbww chinky mature women 7Hott teen chick cummng
    hardAciendo pissVwin vinttage chartVerbal seexual herrasmentFreee porn oon your ipodWholesale dropship adult noveltiesTiny cuntt storiesEva herzigova nude pregnant photo paradisePatfty
    pldnty prn starVintage plate frenc man and womanBelinda cari
    lesbianVideo oof gaay craigslist encounters tubesAsss balloonXxx sexvideoCharacteristics of sex linked pedigreesFrree erogic comic pornAduult hocey forumTrackiing
    tthe asian market aftdr hoursDaar williams teen ffor godChrixty caanyon blowjobVibtage gunny saxAmateur
    asiaticasFrom gijrl head lesbian lickiung toeBreast
    cancerr jewelty ribbonMicrodermal penisJiim walker + bodybuildedr + gay + anchorBlow jobs incRoy rodrigo nakedWatch me fuck my dwddt videoGaay lake forest ilUnion baay twin palm vintage 32Arkham
    asylum breastsPravite voyeurHomemaade teens with oldd menBrother
    forcced fucking hiss sisterNo plujg in porn

  27. Hi, of course this article is really pleasant and I have learned lot of things from it on the topic of blogging. thanks.

  28. Hi, I do believe this is an excellent blog. I stumbledupon it 😉 I may come back yet again since I bookmarked it. Money and freedom is the greatest way to change, may you be rich and continue to help others.

  29. Hmm is anyone else experiencing problems with the images on this blog loading?I’m trying to determine if its a problem on my end or if it’s the blog.Any suggestions would be greatly appreciated.

  30. An intriguing discussion is worth comment. I think that you ought to write more on this subject, it might not be a taboo subject but generally folks don’t talk about these topics. To the next! Cheers!!

  31. I truly appreciate this blog article.Thanks Again. Cool.

  32. Im thankful for the post.Really looking forward to read more. Cool.

  33. Awesome article post.Really looking forward to read more. Will read on…

  34. This is one awesome blog.Much thanks again.

  35. Awesome blog.Thanks Again. Awesome.

  36. Appreciate you sharing, great article. Want more.Loading…

  37. It’s hard to search out educated individuals on this topic, however you sound like you realize what you’re speaking about! Thanks

  38. Thank you ever so for you post. Awesome.

  39. What’s Taking place i’m new to this, I stumbled upon this I’ve discovered It absolutely useful and it has aided me out loads. I hope to give a contribution & aid different customers like its aided me. Good job.

  40. Thanks for finally talking about > GA4の会員/非会員のユニークユーザー数をSQLで取得する実例 –
    GA4 Quick.com < Liked it!

  41. Hey! I could have sworn I’ve been to this site before but after
    browsing through some of the post I realized it’s new to me.

    Nonetheless, I’m definitely happy I found it and
    I’ll be bookmarking and checking back often!

    Here is my web blog – vpn coupon 2024

  42. After exploring a few of the blog articles on your web site, I truly like your
    technique of writing a blog. I added it to my bookmark webpage
    list and will be checking back in the near future.
    Take a look at my web site too and let me know your opinion.

    my webpage – vpn special code

  43. Hello to all, for the reason that I am in fact keen of reading this web site’s post to be updated regularly.
    It contains pleasant material.

    Here is my web site … vpn special coupon code 2024

  44. Piece of writing writing is also a fun, if you be
    acquainted with after that you can write or else it is
    complex to write.

  45. Thanks for finally writing about > GA4の会員/非会員のユニークユーザー数をSQLで取得する実例 –
    GA4 Quick.com < Liked it!

  46. Quality articles or reviews is the key to invite the
    visitors to go to see the site, that’s what this site is providing.

  47. I am sure this piece of writing has touched all the internet users, its really really good paragraph on building up
    new webpage.

  48. Very neat article.Much thanks again. Will read on…

  49. Wow, great article.Really looking forward to read more.

  50. Why users still use facebook vs eharmony to find love online read news papers when in this technological world the whole thing is available on web?

  51. What’s up i am kavin, its my first occasion to commenting anywhere, when i read this post i thought i could also make comment due to
    this sensible article.

    Here is my homepage; eharmony special coupon code 2024

  52. It’s difficult to find well-informed people on this topic, but you
    seem like you know what you’re talking about! Thanks

    my blog; nordvpn special coupon code 2024

  53. venta libre de medicamentos Orion Versailles Medikamente online bestellen in der Schweiz

  54. médicaments en ligne rapide et facile France Kendrick Corinto acquista
    farmaci online a Verona senza bisogno di ricetta

  55. médicaments en vente en ligne en Suisse Alter Guadalupe medicijnen te koop

  56. Compra medicamentos sin receta en Suiza Biofarma Santa Catarina dónde comprar medicamentos en Madrid

  57. Say, you got a nice blog post.Thanks Again.

  58. Excellent blog you have got here.. It�s hard to find high quality writing like yours these days. I honestly appreciate people like you! Take care!!

    My blog post – https://Penzu.com/p/b31b2681

  59. I don’t think the title of your article matches the content lol. Just kidding, mainly because I had some doubts after reading the article.

  60. Everyone loves what you guys are up too. Such clever work and exposure!

    Keep up the amazing works guys I’ve incorporated you guys to our blogroll.

  61. арнайы мектепке дейінгі ұйым тәрбиешісі, мектепке
    дейінгі оқыту және тәрбиелеу мақала алматы –
    казань поезд цена, алматы – казань самолет стоимость посылки из казахстана
    в россию, доставка посылок по казахстану
    әңгімелеу мәтіні сұрақтары, әңгімелеу мәтінін құра

  62. Thank you for some other informative web site. The place else could I am getting that type of info written in such an ideal means?
    I have a undertaking that I’m just now working on, and I’ve been at the look out for such info.

  63. I know this if off topic but I’m looking into starting my own weblog
    and was wondering what all is required to get set up? I’m assuming having a blog like yours
    would cost a pretty penny? I’m not very web savvy so I’m not 100% positive.
    Any recommendations or advice would be greatly appreciated.

    Appreciate it

  64. ткань для обшивки карт дверей, самоклеющаяся ткань для авто золотой ребенок фильм, золотой
    ребенок смотреть онлайн в hd жаз туралы эссе ағылшынша,
    ағылшын тілі туралы шығарма ағылшынша гдз 5 сынып қазақстан тарихы көмеков қазақша, гдз қазақстан тарихы 6 сынып

  65. қызыл кітап барыс, ақ барыс туралы мәлімет say mo койше текст,
    say mo песни батыс қазақстан адам саны, батыс қазақстан
    шаруашылығы интертич услуги, интертич уральск цены на услуги

  66. неке жузик туралы, неке жүзігін салу рәсімі зат энергия алмасу қатың перевод, катын происхождение слова шылау туралы сұрақтар, одағай сұрақтары

  67. әйел теңдігі журналы купить пальто женское недорого, купить кашемировое пальто женское в алматы өрттің зияны, өрттің себептері посуда кочевников, казахская посуда названия

  68. I don’t think the title of your article matches the content lol. Just kidding, mainly because I had some doubts after reading the article.

  69. online aankoop van medicijnen Elan Rochefort medicamentos sin prescripción

  70. An engaging discussion is definitely worth comment. There’s no doubt that that you need to write find out more about this topic, it might not be a taboo matter but typically people do not talk about such. To the next! All the best!!

    My web site http://www.smokinstangs.com/member.php/275897-Svetlqeg

  71. I blog quite often and I truly appreciate your knowledge. This text has really peaked my interest. I will bookmark your website and continue checking out for new information about once per week. I subscribed to your RSS feed too.

    my web blog; http://www.ts-gaminggroup.com/showthread.php?179396-When-Is-National-Ex-Boyfriend-Day&p=1078256

  72. Fantastic website you’ve gotten here.. It�s tough to find quality writing similar yours these days. I truly appreciate folks similar you! Bear care!!

    My web page http://Www.C-Strike.Fakaheda.eu/forum/viewthread.php?thread_id=59732

  73. Hello very remarkable website!! Fellow .. Remarkable .. Amazing .. I will bookmark your website and take the feeds additionally�I’m delighted to notice such a lot of constructive knowledge here in the article, we’d similar to expand more procedures in this regard, thank you for distribution.

    Here is my homepage http://www.adtgamer.com.br/showthread.php?p=481026

  74. Howdy, the whole thing is happening soundly here and clearly everyone is exchanging facts, that’s really exceptional, uphold scribbling.

    my web page – http://www.glaschat.ru/glas-f/member.php?455230-Svetluxs

  75. I’ve been browsing online more than 3 hours lately, yet I by no means discovered any interesting article like yours. It’s pretty worth sufficient for me. Personally, if all webmasters and bloggers made excellent content material as you probably did, the web will probably be much more helpful than ever before.

    Check out my website – http://www.Adtgamer.com.br/showthread.php?p=485021

  76. I blog quite often and I really appreciate your knowledge. This text has really peaked my interest. I am going to bookmark your website and keep checking for new details about once per week. I opted in for your RSS feed as well.

    Look into my page; http://Www.adtgamer.com.br/showthread.php?p=482532

  77. Hello, I desire to subscribe for this web site to gain hottest updates, therefore where can i do it amuse aid.

    Look into my web-site; http://www.adtgamer.Com.br/showthread.php?p=484525

  78. fantastic issues altogether, you simply won a new reader. What could you recommend in regards to your that you just made some days ago? Any sure

    Feel free to visit my web blog; http://Woodlandtech.org/forum/phpBB3/viewtopic.php?f=6&t=49522

  79. Greetings, I would like to subscribe for this web site to acquire newest updates, therefore where can i do it amuse assist.

    Visit my web site http://Skatefluckit.com/member.php?u=90212

  80. Astounding! This blog gazes just similar my old one! It’s on a completely at variance subject but it has beautiful much the same template and blueprint. Excellent preference of colours!

    my web-site; http://www.forumdipace.org/profile.php?mode=viewprofile&u=151332

  81. Greetings, I want to subscribe for this webpage to take hottest updates, therefore where can i do it amuse help out.

    My web-site … http://Forum.Gokickoff.com/index.php?topic=91699.new

  82. fantastic putting as an entire, you simply received a emblem new reader. What could you suggest microblogging page that you just made some days ago? certain?

    Here is my blog http://www.ra-journal.ru/board/member.php?258742-Svetluhz

  83. Thank you for sharing your ideas. Regards!

    Here is my site – http://www.adtgamer.com.br/showthread.php?p=485314

  84. I’ve been surfing on-line more than 3 hours nowadays, but I never found any interesting article like yours. It is pretty value sufficient for me. In my view, if all web owners and bloggers made good content as you probably did, the web will probably be a lot more helpful than ever before.

    Here is my web site: http://www.adtgamer.com.br/showthread.php?p=485500

  85. Hello, I wish for to subscribe for this webpage to get hottest updates, so where can i do it amuse assist.

    My web blog :: http://forum.diablosport.com/viewtopic.php?t=113830

  86. Thank you for sharing your feelings. Kind regards!

    Check out my homepage; http://Www.c-strike.fakaheda.eu/forum/viewthread.php?thread_id=64207

  87. Do you have a spam issue on this website; I also am a blogger, and I was wanting to your situation; we have created some nice methods and we are looking to exchange solutions with others, be sure to shoot me an e-mail if interested.

    My web-site: http://Www.Smokinstangs.com/member.php/276735-Igorwci

  88. I am truly contented to read through this site posts which comprises plenty of practical knowledge, thank you for providing such facts.

    Also visit my web site http://Forum.survival-Readiness.com/viewtopic.php?t=245401

  89. This is actually fascinating, You are an overly adept blogger. I have coupled your rss feed and sit up for seeking more of your wonderful post. Also, I’ve shared your web site in my social networks!

    Feel free to surf to my web page – http://Www.lycantic.com/forum/viewtopic.php?f=9&t=333561

  90. Do you have a spam issue on this site; I also am a blogger, and I was wanting to your situation; we’ve created some nice methods and we are looking to exchange methods with other folks, why not shoot me an e-mail if interested.

    my web page: http://www.glaschat.ru/glas-f/member.php?317980-Igorlft

  91. I’m not positive where you’re acquiring your info, but wonderful issue. I requirements to expend some time scholarship more or comprehension more. Thank you for magnificent knowledge I was appearance for this knowledge for my task.

    Also visit my web-site; http://Forum.D-Dub.com/member.php?1429502-Veronapwq

  92. I am really delighted to glance at this web site posts which contains plenty of practical data, thank you for providing such knowledge.

    Also visit my web-site – http://djdrewski.co.uk/lfsbangers/viewtopic.php?f=32&t=26825

  93. I’ve been surfing on-line more than 3 hours as of late, yet I by no means discovered any attention-grabbing article like yours. It’s lovely worth sufficient for me. In my view, if all site owners and bloggers made excellent content as you did, the net will be a lot more helpful than ever before.

    Review my page; http://www.ra-Journal.ru/board/member.php?213066-Igorrut

  94. Thanks, I’ve recently been looking for info approximately this subject for a long time and yours is that the best I have discovered so far. However, what about the bottom line? Are you positive about the source?

    my web blog http://Adtgamer.COM.Br/showthread.php?p=486102

  95. That is truly fascinating, You are an overly skilled blogger. I have coupled your rss feed and foresee seeking additional of your wonderful post. Also, I have shared your web site in my social networks!

    Feel free to surf to my web blog :: http://forum.Ll2.ru/member.php?694781-Svetlanaofd

  96. This is truly interesting, You’re an overly skilled blogger. I’ve coupled your rss channel and foresee searching for more of your magnificent post. Additionally, I’ve shared your web site in my social networks!

    my webpage; http://adtgamer.com.br/showthread.php?p=488920

  97. Do you have a spam issue on this website; I also am a blogger, and I was thinking about your situation; we’ve developed some nice procedures and we are looking to exchange methods with other folks, please shoot me an e-mail if interested.

    Visit my web page :: http://ns2.Awmn.net/member.php?u=98706

  98. Hey there! Do you know if they make any plugins to help with Search Engine Optimization?
    I’m trying to get my site to rank for some targeted keywords
    but I’m not seeing very good results. If you know of any please share.
    Thanks! I saw similar text here: Eco bij

  99. I’m not positive where you’re acquiring your facts, but terrific issue. I requirements to expend some time scholarship more or comprehension more. Thank you for brilliant information I was appearance for this knowledge for my task.

    Check out my blog post; http://Adtgamer.Com.br/showthread.php?p=487843

  100. I blog frequently and I really thank you for your information. The article has really peaked my interest. I will book mark your site and keep checking out for new information about once per week. I subscribed to your RSS feed too.

    Stop by my website http://Www.adtgamer.com.br/showthread.php?p=485769

  101. This is truly engaging, You are an extremely adept blogger. I’ve coupled your rss channel and look forward to in quest of more of your magnificent post. Additionally, I have shared your web site in my social networks!

    Also visit my website – http://www.adtgamer.com.br/showthread.php?p=488567

  102. fantastic issues as an entire, you just received a emblem new reader. What may you recommend about your that you made some days in the past? Any sure

    Feel free to surf to my web-site … http://yonghengro.gain.tw/viewthread.php?tid=1450819&extra=

  103. I am genuinely contented to glimpse at this web site posts which comprises tons of advantageous knowledge, thank you for providing these kinds of facts.

    my web-site :: http://clasificadosdolores.Com.ar/sitio/author/davidvrm

  104. This is truly engaging, You are an overly skilled blogger. I have coupled your rss channel and sit up for seeking additional of your magnificent post. Also, I’ve shared your web site in my social networks!

    Stop by my web page :: http://Www.Forumdipace.org/profile.php?mode=viewprofile&u=410655

  105. An compelling conversation is definitely worth remark. I do think that you should write find out more about this topic, it may not be a taboo matter but typically individuals discuss these. To the next! Kind regards!!

    Here is my website … http://162.241.164.67/phpbb/phpBB3/viewtopic.php?f=3&t=88847

  106. You made some nice points there. I did a search on the subject and found most persons will agree with your weblog.

    Here is my web blog – http://www.latechbbb.com/forum/member.php?76628-Evazsh

  107. Hello very remarkable site!! Fellow .. Spectacular .. Astounding .. I will bookmark your website and take the feeds additionally�I am delighted to notice so numerous valuable information here in the post, we’d similar to expand more methods in this regard, thank you for distribution.

    Also visit my web blog … http://Himeuta.org/member.php?1671889-Svetlanarmh

  108. Greetings very remarkable site!! Chap .. Spectacular .. Extraordinary .. I will bookmark your site and take the feeds additionally�I’m contented to locate so numerous constructive information present within the post, we want increase additional methods on this regard, thank you for distribution.

    Have a look at my web-site http://forum.Drustvogil-galad.si/index.php?action=profile;u=17053

  109. тұрақты даму слайд сенбеймін
    енді алдамшы сезімге скачать,
    оп-онай скачать ремикс au element
    name, cu element name дене шынықтырудың негізгі түрлері

  110. I’ve been surfing on-line greater than three hours today, but I never discovered any fascinating article like yours. It is pretty value sufficient for me. In my opinion, if all site owners and bloggers made just right content as you did, the internet can be much more helpful than ever before.

    my website http://forums.outdoorreview.com/member.php?293331-Svetlanaifp

  111. I have been surfing on-line more than 3 hours nowadays, but I by no means discovered any interesting article like yours. It’s lovely value sufficient for me. In my opinion, if all website owners and bloggers made just right content as you probably did, the internet can be a lot more helpful than ever before.

    My site: http://Www.Dendymaster.ru/forum/showthread.php?p=40105

  112. Astounding! This blog gazes just similar my old one! It’s on a entirely at variance matter but it has beautiful much the same page layout and blueprint. Fantastic preference of colours!

    My web blog – http://www.glaschat.ru/glas-f/member.php?437573-Evahjb

  113. Terrific post! We can exist linking to this big subject matter on our location. Uphold the good writing.

    My website :: http://forum.d-dub.com/member.php?848709-Evarnc

  114. You made some nice points there. I did a search on the subject and found most people will accede with your blog.

    Check out my blog post http://mail.spearboard.com/member.php?u=813092

  115. Greetings very impressive blog!! Fellow .. Fantastic .. Amazing .. I will bookmark your site and take the feeds additionally�I am delighted to locate so numerous valuable facts present within the article, we’d similar to increase additional tactics on this regard, appreciate it for distribution.

    My web page :: http://Mail.Spearboard.com/member.php?u=813319

  116. It�s hard to find educated individuals about this topic, but you sound like you know what you�re talking about! Thanks

    My site – http://Www.Forumkadjar.it/viewtopic.php?f=10&t=10972

  117. I am truly glad to look at this site posts which comprises tons of practical information, thank you for providing such data.

    My site: http://jeepin.com/forum/member.php?u=120552

  118. I haven’t checked in here for some time since I thought it was getting boring, but the last few posts are great quality so I guess I’ll add you back to my everyday bloglist. You deserve it friend 🙂

    Feel free to visit my homepage :: http://forum.d-dub.com/member.php?869817-Leonuqc

  119. Hey very spectacular blog!! Chap .. Remarkable .. Extraordinary .. I will bookmark your site and take the feeds additionally�I’m delighted to discover so numerous advantageous knowledge here in the post, we’d similar to expand additional methods in this regard, appreciate it for distribution.

    Feel free to surf to my blog – http://Vnsharing.site/forum/member.php?u=2622461

  120. I’ve been browsing online more than three hours these days, but I never found any attention-grabbing article like yours. It is pretty price enough for me. In my opinion, if all web owners and bloggers made good content material as you did, the net will likely be much more helpful than ever before.

    My web page http://www.oople.com/forums/member.php?u=239625

  121. Hello, I want to subscribe for this blog to acquire newest updates, so where can i do it amuse assist.

    Take a look at my web site … http://vnsharing.site/forum/member.php?u=2399809

  122. You made some good points there. I looked on the subject and found most of folks will consent with your weblog.

    Also visit my page … http://www.adtgamer.com.br/showthread.php?p=498767

  123. Thanks, I’ve just been searching for info approximately this subject for a long time and yours is that the best I have came upon so far. But, what in regards to the final point? Are you positive in regards to the source?

    Here is my webpage – http://forum.ll2.ru/member.php?696303-Irinnlz

  124. Où commander médicaments en ligne en toute confiance Sanofi Möhlin Online medicijnen bestellen in Nederland

  125. Great post! We will exist linking to this explicit big post on our location. Uphold the good writing.

    my web site: http://Ocsuburbs.com/viewtopic.php?t=87113

  126. I have not checked in here for some time as I thought it was getting boring, but the last few posts are great quality so I guess I’ll add you back to my everyday bloglist. You deserve it my friend 🙂

    Also visit my web blog; http://www.adtgamer.com.br/showthread.php?p=503887

  127. Thank you, I have recently been looking for info approximately this topic for a long time and yours is that the best I have got came upon till now. But, what in regards to the bottom line? Are you sure concerning the supply?

    My web-site – http://Www.adtgamer.com.br/showthread.php?p=492879

  128. It�s hard to come by educated folks on this topic, however, you seem like you know what you�re talking about! Thanks

    Feel free to visit my page: http://Phpbb2.00Web.net/viewtopic.php?p=218617

  129. That is actually fascinating, You are an overly adept blogger. I have coupled your rss feed and sit up for seeking more of your wonderful post. Also, I’ve shared your web site in my social networks!

    Here is my page; http://www.muhendisim.org/forum/uyeler/139330-vilianaeol.html

  130. Good

  131. I’m not positive where you’re acquiring your knowledge, but wonderful issue. I requirements to expend some time scholarship additional or comprehension more. Thank you for wonderful facts I was appearance for this facts for my task.

    Here is my web-site :: http://Spearboard.com/member.php?u=807510

  132. Whats Happening i’m new to this, I stumbled upon this I’ve discovered It absolutely helpful and it has aided me out loads. I’m hoping to give a contribution & help different users like its aided me. Good job.

  133. fantastic issues as an entire, you just won a new reader. What could you recommend in regards to your that you made some days ago? certain?

    Feel free to surf to my web-site – http://Forum.survival-readiness.com/viewtopic.php?t=254069

  134. You made some decent points there. I looked on the issue and found most of persons will consent with your weblog.

    Also visit my web site … http://Biglode.com/ptsxpy-uforum/viewtopic.php?t=334872

  135. An engaging conversation is definitely worth comment. There’s no doubt that is that you need to write read more about this topic, it may not be a taboo subject but usually people don’t discuss these. To the next! Best wishes!!

    Stop by my web-site: http://Www.smokinstangs.com/member.php/287867-Robjeq

  136. I have not checked in here for some time since I thought it was getting boring, but the last few posts are good quality so I guess I’ll add you back to my everyday bloglist. You deserve it friend 🙂

    Also visit my web blog; http://adtgamer.Com.br/showthread.php?p=509561

  137. You made some clear points there. I looked on the matter and found most folks will agree with your weblog.

    Here is my web blog :: http://forum.d-Dub.com/member.php?841512-Julijev

  138. Thank you for sharing your feelings. Kind regards!

    Have a look at my page :: http://Forum.americandream.de/memberlist.php?mode=viewprofile&u=6158

  139. Do you have a spam problem on this website; I also am a blogger, and I was thinking about your situation; we have developed some nice methods and we are looking to exchange methods with other folks, why not shoot me an e-mail if interested.

    Here is my blog post http://Www.Algazalischool.com/vb/showthread.php?145013-%D1%F6%E5%ED%E0%F0%B3%E9-%CD%EE%E2%EE%F0%B3%F7%ED%EE%E3%EE-%CA%EE%F0%EF%EE%F0%E0%F2%E8%E2%F3-%C4%EB%FF-%C4%EE%F0%EE%F1%EB%E8%F5&p=745054

  140. Thank you for sharing your views. Kind regards!

    Feel free to surf to my website :: http://Korolevichelisey.ru/forum/viewtopic.php?f=10&t=36756

  141. Thank you, I’ve recently been searching for information approximately this subject for a long time and yours is that the best I have discovered till now. However, what in regards to the conclusion? Are you sure concerning the supply?

    Feel free to visit my webpage :: https://vikymoore.com/user/vikiqpv/

  142. Terrific article! We will exist linking to this big article on our location. Uphold the good scribbling.

    Review my webpage :: http://Www.Oople.com/forums/member.php?u=244195

  143. Astounding! This blog gazes exactly similar my old one! It’s on a completely at variance matter but it has beautiful much the same page layout and blueprint. Fantastic preference of colours!

    Review my web-site http://rapbeatsforum.com/viewtopic.php?t=363248

  144. I am continually opinionated about this, thanks for posting.

    my homepage – http://Forum.D-DUB.Com/member.php?841488-Juliwnb

  145. Can you be more specific about the content of your article? After reading it, I still have some doubts. Hope you can help me.

  146. I am not positive where you’re acquiring your info, but wonderful issue. I requirements to expend some time scholarship more or comprehension more. Thank you for brilliant knowledge I was appearance for this information for my task.

    My website … http://Dendymaster.ru/forum/showthread.php?p=44627&posted=1

  147. I am not positive where you are acquiring your info, but terrific issue. I requirements to expend some time scholarship additional or comprehension more. Thank you for splendid facts I was appearance for this facts for my task.

    Look at my page: http://www.ilcorrieredelnapoli.it/cdn/il-napoli-femminile-batte-il-pescara-4-0-e-vola-in-testa-alla-classifica/

  148. An interesting discussion is definitely worth comment. I do think that you need to write find out more about this topic, it may not be a taboo topic but generally many individuals talk about so. To the next! Best wishes!!

    my website … http://Www.Smokinstangs.com/member.php/149970-Ilushiksvz

  149. Greetings very spectacular site!! Fellow .. Remarkable .. Extraordinary .. I will bookmark your blog and take the feeds additionally�I am glad to notice such a lot of valuable knowledge here within the post, we want expand more tactics on this regard, thank you for distribution.

    Feel free to visit my homepage – http://www.Adtgamer.com.br/showthread.php?p=504174

  150. fantastic issues taken into consideration, you just received a emblem new reader. What may you recommend post that you just made some days in the past? Any sure

    Here is my web site – http://Oople.com/forums/member.php?u=241350

  151. Great post! We can exist linking to this explicit big subject matter on our location. Uphold the good writing.

    my blog post … http://www.Adtgamer.com.br/showthread.php?p=535395

  152. Thanks, I have just been looking for knowledge about this subject for a long time and yours is that the greatest I have discovered till now. However, what in regards to the final point? Are you sure in regards to the source?

    My page … http://Www.Adtgamer.Com.br/showthread.php?p=503150

  153. You made some decent points there. I looked on the subject and found most individuals will accede with your website.

    Feel free to surf to my web-site http://forum.d-dub.com/member.php?844341-Ilushikdkq

  154. fantastic issues as an entire, you just received a new reader. What may you recommend microblogging page that you simply made some days in the past? Any sure

    My page :: http://forum.survival-readiness.com/viewtopic.php?t=258961

  155. An compelling conversation is worth commentary. I do believe that you should write find out more on this particular topic, it might not be a taboo topic but usually individuals speak about these. To the next! All the best!!

    Also visit my website – http://Islamavenir.Free.fr/member.php?911-Ilushikkea

  156. I blog often and I truly thank you for your information. The article has really peaked my interest. I will take a note of your website and keep checking for new details about once a week. I opted in for your RSS feed as well.

    My site – http://www.adtgamer.Com.br/showthread.php?p=536256

  157. I’m not positive where you’re acquiring your info, but fantastic issue. I requirements to expend some time scholarship additional or comprehension more. Thank you for splendid facts I was appearance for this knowledge for my task.

    Feel free to surf to my blog http://WWW.Smokinstangs.com/member.php/281006-Ilushikcmd

  158. Remarkable! This blog gazes exactly similar my old one! It’s on a completely at variance subject but it has beautiful much the same page layout and blueprint. Fantastic preference of colours!

    Here is my web page; http://WWW.Passat-Club.ru/forum/members/96174-zahaleypetov806

  159. I blog frequently and I really thank you for your content material. The article has really peaked my interest. I’m going to bookmark your blog and keep checking for new information about once a week. I opted in for your RSS feed too.

    Also visit my webpage http://dendymaster.ru/forum/showthread.php?p=44262&posted=1

ランキング（週間）

  1. 1

    GA4 「ページ ロケーション」と「ページ パス と スクリーン クラス」何が違う？ドメインの有無以外にもパラメータの扱いに違いあり
  2. 2

    GA4 拡張計測機能の新顔「フォームの操作」 form_start, form_submit
  3. 3

    GA4 クロスドメイン設定では、リンク先に「_gl」パラメータが付く。勝手なパラメータを付けるとエラーになるページは要注意
  4. 4

    GA4の探索で「ページ別訪問数」を見ることは可能か？
  5. 5

    GA4のレポート画面の数値データは、イベント発生時から何時間後に確定するのか？
  6. 6

    GA4とGoogle広告の連携・オーディエンス・ 広告用機械学習 | オンラインセミナー　アーカイブ動画＋テキスト起こし（2022年6月2日開催）
  7. 7

    GA4で異なるドメイン（サブドメイン）の同一ページパスをドメイン付きで表示する
  8. 8

    GA4で設定したイベントの消し方（削除の仕方）
  9. 9

    Ads Data Hub（ADH） とはどんなものですか？GA4との関連は？
  10. 10

    YouTubeの概要欄に貼られたリンクをクリックしてサイトを訪れたユーザーを計測するために

タグ

BigQuery_by_佐藤洋太 (4)

最近の記事

  1. 生成AIを調整してABテストを実装したら想像以上に早かった

  2. 無料で使えるABテストツールのバージョンアップを行いました

  3. 無料ABテストツール（and,B）のマニュアルを作成しました

カテゴリー

アーカイブ
 
TOP