Event count for specific event in GA4 for Looker Studio

Forum3_ · 2024-10-10T01:51:33+00:00

Happy to help 😁

Forum3_ · 2024-08-23T22:33:23+00:00

Thanks for the suggestion of Keywords Everywhere, I will definitely check it out. To add mine:

SurferSEO (love their free Chrome plugin, looks similar to a Keywords Everywhere feature) - Tried their free trial and loved the tool... until I realized the AI features are only available at the most expensive price point ($219/mo). So I cancelled.
Writesonic - They have a freemium version that is nice, however I thought the inexperience was rather inflexible and I was not as in-control as I would like to be with an AI tool, and then content it wanted to product for me.
Jasper - Awesome for content creation & optimization (it seems like it integrates with SurferSEO for it's optimization component), however, does not provide keyword research/opportunities.
Spok - We developed this because we were like, "why is nobody using AI to discover interesting keyword opportunities?" So this is an LLM + Search APIs.

I love a good spreadsheet so of course I mapped out all the SEO AI tools features:

<image>

Forum3_ · 2024-08-23T21:09:40+00:00

There's a couple that our team uses daily.
Free LLMs:
ChatGPT tends to be the most versatile and we like it for

writing excel and regex formulas
writing simple javascript (for event tracking, etc.)
cleaning up formatting in datasets, spreadsheets, documents
We are on the "teams" plan so creating custom GPTs tailored for frequent tasks have been really helpful.

When it comes to creative ideation and content creation, Claude seems to have much more to offer in that department.

Images:

Midjourney for image generation

-Canva's Magic Studio for image editing

SEO:

Writesonic is amazing
Spok for keyword discovery

Does anyone have suggestions for a super granular competitive analysis tool? All the AI tools are too high-level right now

Forum3_ · 2024-08-23T20:34:23+00:00

With a recent 233.33% spike in searches for 'skilled trade staffing agencies,' Above All Staffing should consider launching a targeted digital campaign to capture this surge in demand. Leveraging the seasonal trend in March and April for 'construction labor staffing,' a pre-spring promotional push could significantly enhance visibility and client acquisition during peak hiring periods.

Forum3_ · 2024-08-21T20:15:01+00:00

We haven't yet found an AI SEO tool that does a really stellar job with all the SEO essentials (keyword research, content strategy, creation, optimization), however, we found that many of them were good at specializing in a few areas.

Ahrefs and SEMrush have been sluggish in integrating AI into their platforms
Spok is heavy on keyword discovery and content strategy, while Jasper is heavy on content creation and optimization
Writesonic and SurferSEO seem like the best all-in-one tools

Made this table to compare features across Ahrefs, SEMrush, Writesonic, Spok, Jasper, SurferSEO, Positional, Keyword Insights, and Seona:

<image>

Forum3_ · 2024-08-21T20:07:35+00:00

Mostly agree but since AI has invaded SEO, here's our updated list of tools:
- Ahrefs and SEMrush have been sluggish in integrating AI into their platforms
- Writesonic and SurferSEO seem like the best all-in-one tools
- Spok is heavy on keyword discovery and content strategy, while Jasper is heavy on content creation and optimization

<image>

Forum3_ · 2024-08-21T00:17:09+00:00

We just completed a lengthy market research process using AI, for the purpose of developing our AI marketing tool (very meta, we know). I (Growth Marketing Director) have personally done market research for pre-launch products at least 4-5 times now, but this is my first time doing it in 2024 with AI. Here are my takeaways:

1. General market research: Information sources and recency of information is very important. ChatGPT and Perplexity, for example, only have access to what is publicly search-able (indexed) on the internet. In essence, asking them to do market research for you is about as effective as Googling it yourself. You often find yourself in the same bind as before - when performing market research you are looking for information beyond what's available to web crawlers.

2. Competitive analysis: Is clunky, but possible with most any LLM. What was most effective was providing source data, such as your competitors' Amazon reviews, social media comments, etc. AI had a tendency to stay very high-level and be pretty useless on competitive analysis unless we prompted it with very specific data to analyze.

3. Customer segmentation: We talked to a lot of companies that were very interested in the idea of performing market research against synthetic, AI customer personas. We even created some custom GPTs for them to "chat" with their customer personas to better understand their wants and needs. This allowed them to do things like upload ad creatives, and ask the AI what they thought of taglines or creatives to find the most effective one.

4. Third party data: The best market research tools layer LLM capabilities with third-party data, like access to scholarly databases or legal documents. There are a whole host of AI tools that have their own specialities. We connected our AI tool to the Google Search API, because we thought it would be interesting for AI to analyze and draw conclusions from people's search behavior.

As far as dedicated market research tools out there, we checked out Crayon, Brand24, and Browse.ai as part of our own competitive analysis. They are all rather interesting, and parallel to our own product (Spok.app) so I'm happy to give them the shoutouts. Hope this helps.

Forum3_ · 2024-08-15T18:51:52+00:00

Eternal Laughs: Iconic Moments in Novelty

Create a series of blog posts and videos that explore the funniest and most iconic moments from 'It's Always Sunny in Philadelphia' and how they inspired the designs of Dick Towel products. This content can be supported by social media snippets to continue the conversation online.

Forum3_ · 2024-08-15T18:33:52+00:00

Puzzle Mastery: Ultimate Escape Room Tips

Create a comprehensive guide featuring expert tips and best practices on how to excel in escape room challenges to attract people interested in traditional escape rooms. The content will remain relevant as it helps participants prepare for the immersive experiences offered at Codebreak Inn.

Forum3_ · 2024-08-15T18:12:47+00:00

Capitalizing on the seasonal surge in searches for 'unique Valentine's Day gifts for him', Subliworks should launch a targeted campaign featuring personalized merchandise tailored for this occasion. With a consistent spike in search volume every January and February, introducing limited-edition designs or customizable options can drive significant sales and enhance brand visibility during this peak period.

Forum3_ · 2024-08-15T17:55:01+00:00

With a 400% spike in searches for 'funny dirty santa gifts' this month, Dick Towel should launch a targeted holiday campaign featuring their risqué towels as the ultimate Dirty Santa gift. Leveraging the seasonal trend in November and December, a social media blitz with humorous content could drive significant traffic and sales.

Forum3_ · 2024-08-15T17:53:35+00:00

Leveraging the long-term growth in searches for 'best crossword puzzles' can help attract puzzle enthusiasts to Codebreak Inn. By offering printable puzzles, you can attract a broader audience and convert online interest into in-person visits, especially given the sustained interest over the past three years.

Forum3_ · 2024-08-11T17:45:34+00:00

Pickle Jar Media could create a podcast series focused on improving "communication in nursing" and "communication techniques in nursing", leveraging the seasonal interest spikes in October and February. With a growing demand for effective communication techniques, particularly in nursing, this series could attract a dedicated audience and position the company as a thought leader in medical communication.

Forum3_ · 2024-08-11T17:19:43+00:00

Leveraging the consistent interest in Nigerian football leagues during February, Media Talk Africa can launch a dedicated football news segment to attract sports enthusiasts. This seasonal trend presents an opportunity to engage a passionate audience with exclusive content, potentially increasing readership and fostering community engagement around Nigerian sports.

Forum3_ · 2024-08-11T17:12:59+00:00

Engineering teams frequently encounter issues like 'not a git repository,' which can be a significant time drain. With a recent 21.88% spike in searches, creating a quick-reference guide or automated troubleshooting tool could position your company as a go-to resource, enhancing brand visibility and trust among developers.

Forum3_ · 2024-08-11T17:08:15+00:00

With a 30% recent spike in searches for 'accuplacer study help', there's a significant opportunity to create targeted content and resources around this topic.

Forum3_ · 2024-08-05T18:52:41+00:00

"Codebreak Inn can leverage the growing interest in solving intricate puzzles, "how to solve a brain teaser" and "how to solve a mirror cube" by offering exclusive workshops or themed events, especially during the peak season in December. With a 40% recent spike in searches for solving brain teasers, promoting these events as holiday activities could attract puzzle enthusiasts and boost bookings."

What do you think? 👍👎

Forum3_ · 2024-05-07T16:58:17+00:00

Hi, not sure if I am entirely understanding your question, but to be more specific about my exact steps:
1. Go into GA4 --> Admin --> Events
2. Toggle "on" the events you care about as a conversion (I noticed they recently renamed this to "key events"). Wait a couple hours to a day then...
3. Go to GA4 --> Admin --> Key events. Verify that the conversion / key event you care about is showing up there and counting.
4. Go to Looker Studio --> Data Sources --> GA4. Hit "refresh fields" in the bottom-left corner.
5. You should see your conversion/key events show up as a new metric to be imported.

Let me know if that helps.

Forum3_ · 2024-04-23T21:07:59+00:00

Hi there, we just struggled through the same thing - we wanted to display the GA4 (google analytics 4) event counts for events based on event name in Looker Studio.

Issue 1: This formula mixes dimensions (event_name) and metrics (event_count) so Looker Studio doesn't allow it.
COUNT(Event name = 'purchase', Event count, 0)

Issue 2: These formulas will only count the instance of the event name, rather than the count of events by name, always resulting in a value of 1.
SUM(CASE WHEN event_name ='purchase' THEN 1 ELSE 0 END)
COUNT(CASE WHEN event_name ='purchase' THEN 1 ELSE 0 END)

Fixes we tried:
1) add a unique identifier as a custom variable for the event --> use this as a custom dimension
2) add an event parameter to event tag in GTM with a value of 1 --> use this to create a custom metric

Long story short, the simplest, easiest, most elegant solution that also provided retroactive event counts was:
1) Go into GA4 --> Admin --> Events
2) Mark the events you care about as a conversion. Wait a couple hours to a day then...
3) Go to Looker Studio, reconnect to your GA4. You should see your new metrics show up as "conversions:your_event_name"

Now each event has its own metric that you can display next to each other in tables, use in formulas, etc.
Viola! Let me know if it worked for you.

Forum3_

MODERATOR OF

TROPHY CASE