Marketing and Analytics how-to, tips, tricks, and more!
Our team has worked for some of the country's largest agencies and clients...and it wasn't fun. We started Apotheca to escape the "big agency" grist mill that chewed up employees and left clients wanting more. Our boutique agency gives you big agency services and experience, but with the attention and customer service that only smaller agencies can provide.
We specialize in improving the health of your company's marketing programs, through a combination of marketing assessments, website design, paid media, SEO, social media, analytics, content marketing and traditional marketing.
Contact us today to talk about your marketing or measurement needs. www.apothecamarketing.com
Very helpful content. Could you please create a video for a non e-commerce website. You had mentioned that websites might use lead forms/blogs/articles. It would be really helpful to know what metrics might be relevant for such websites
Roy, thanks for doing this podcast me, your insights into SEO are super interesting and valuable. It was awesome to have this discussion with a seasoned expert.
It depends on how you're pulling that data into Looker Studio. If you're using the data connector for GSC, then it should be the same if you're looking at the same dates. However, if you're pulling the data from GA4, there is often latency in the reporting by at least 24 hours. Some other factors that could impact this are: date ranges, filters or segmentation.
Good story and clear explanation. Thank you. I still see many marketing agencies that do not adjust the 301 redirect at URL level. Then they go from three TLDs to one and wonder where the visitors went.
Exactly! I think it's because some agencies don't include their SEO experts in website design projects because they view them as different silos and teams.
RU-vid has been pushing smaller channels to the feed which is how I found this video. Great information. Q: I used fivver to update my SEO and part of that was 300 backlinks, which upon inspection is a bunch of trash blogs. Is this hurting me or helping me? Thanks
It definitely can hurt, especially if Google thinks that you were using blackhat tactics to generate these links (which it sounds like they were). Google will sometimes deindex sites that it thinks are buying or trading links. Backlinks are important, but not as important as they once were. It's much better to focus on quality content, and optimizing your site for Google indexing. We'd be happy to do a quick assessment for you. You can can schedule a free 30 minute consult here: www.apothecamarketing.com/contact#BookACall
Hi! I am looking to create a Looker Studio table so that I can see which days of the week conversions are taking place, categorized by each traffic source (email, direct, organic, etc.). Can you make a video on this, please?
Next video, can you do how to exclude just one landing page from showing up in reporting metrics? Everytime I add a filter and the lanidng page URL, the metrics dont change.
It looks like this may be a bug, because I'm not seeing it in any of my accounts right now either. Google is still showing this option in its documentation (support.google.com/analytics/answer/13722168) and "Scheduled Reports" is still available in the admin, so I don't think they meant to remove it. I would check back in a couple days and see if they fixed the issue. We'll keep an eye on it as well.
I did a bit more digging, and Google supposedly updated this feature, adding a new "email instantly" feature on May 31. So it looks like it is most likely a bug.
@@apothecamarketingThanks again. Out of interest, any advice you could offer on the simplest way to setup monthly reporting on website visitors? I am using WordPress website with SiteKit plugin from Google.
I would need to see the data that you're trying to export. But it often exports "date" as a raw number rather than a formatted date, which can make it difficult to sort. You may need to modify this raw number by creating a date column and using a formula to make it into a date that can be more easily sorted.
I'm trying to compare "transactions" from UA and GA4 year on year. Sessions is fine as it matches up, but the transactions metric will not work. Any way around this?
In GA4 what you want is the "purchase" event, if that's not what you're comparing. Transactions were renamed in GA4, as were a number of other metrics.
I often have issues with displaying data on Looker Studio. Sometimes I get 'null' in the metrics columns, even though the value is not 0. Sometimes I also get a reserved total and cannot see the data split. This usually happens when I have calculated fields. Any ideas on how to solve this? Thanks
I would need to see the specific examples. One thing to keep in mind is that Looker is sometimes using a different attribution model than the reports you may be viewing in GA4. There's also instances where metrics that are available in GA4 are not available in Looker, just like some metrics are available in Explore, but are not in the standard dashboards in GA4. It can get very confusing and frustrating for sure!
Great idea. We're actually working with a company that creates sites for blogs and publishing companies, so we can show what we've been building for them.
It can be a bit finicky depending on what account your browser is logged into versus what account you need to log into for GA4. I had to grant my personal Gmail account access to some of my analytics accounts because the browser kept logging into my personal by default.
Hi @Apotheca Marketing I hope this message finds you well. I recently came across your page and noticed your expertise in Looker Studio. I'm currently working on a project where I'm encountering a challenge and I believe your insights could be incredibly valuable. I'm working on a Looker Studio report page with two tables from different data sets. Each table contains a column of Keywords, and I've set up filters for these Keyword columns in both tables, effectively linking them. However, I'm facing an issue with filtering the tables based on specific keyword terms. Essentially, I'm looking to refine the filtering process so that when I adjust the filter to include any terms found in the Keyword column of one table, the corresponding terms automatically filter the Keyword column in the other table on the same Looker Studio report page. For example, if I select a keyword term like "How" in one column, I want the other table's keyword column to filter terms like "How to learn," "How to do it," and "How we can set up." Given your expertise in Looker Studio, I was hoping you might be able to provide some guidance or insights on how to achieve this functionality. Would you be available for a brief chat or perhaps provide some pointers? Your assistance would be greatly appreciated. Looking forward to your response. Best regards, Supriya
Word to the wise - for the adobe creator - it's a good idea to shorten the URL beforehand as QR codes generated from shorter URLs tend to be easier/ quicker to scan
You can download the data in spreadsheets, which can then be used as a source in Looker Studio. That data can also be added to third-party data platforms such as Google's BigQuery, where it can also be pulled into Looker or other data visualization tools. It's not a very elegant solution, but unless you had Google 360, it's one of your only options.
So, when I try to add the 'session conversion rate' metric to this same report, it's not one of the options? I do have 'purchase' set up as a conversion as indicated. And, we do show sessions and transactions as well. Any ideas why this metric does not appear?
Make sure you're selecting the "Metrics" dropdown and not the "Dimensions". Under metrics you should see options for session conversion and user conversion.
@@apothecamarketing I figured it out. They renamed conversion rates to 'Session key event rate' and 'User key event rate'. Problem solved for anyone else looking.
Hi, thank you for this video. I have a question. Will this dashboard update in real time by itself? So in a weeks time, will one then see the current relevant data?
It will pull in all historical data as soon as you create it (if that data exists in your data source, such as GA4). You can control the date range of the report and the individual charts, so it updates based on the range that you provide. Keep in mind, however, that GA4 is typically 24 hours behind in its reporting.
Unfortunately, Google limits the amount of data that you can export, either directly from GA4 or via Sheets. The only way to get more records is to connect your GA4 account to Google BigQuery (or another third party data tool via API). We did a video about this that you may find helpful: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-_EXMhejNK-Y.html
I cant get the account section to pull up to allow me to select an account and I have admin access to all my client accounts. Pretty stuck at this moment. Tried from a few different emails
I've run into this same issue. I think it has something to do with what account your browser is logged into. In other words, even if you have a Google Sheet opened up using an account that has GA4 access, if your browser is logged into a different account it may not work.
You're not alone. Many companies are moving their GA4 data to BigQuery, though it can get expensive very quickly depending on your data volume and number of queries. We'll look at doing a series of BQ videos in the near future!
thank you very much for the tutorial, we don't have much support in brazil, but unfortunately for me the ga4 reports Builder for Google Analytics is grayed out, do you know where I can get the permissions to use the reports Builder?
Thanks for spreading the knowledge of this problem. We surely can send 100% correct data with measurement protocol; the problem is attributing these numbers to the specific channel. Another problem in advertisement is we cannot measure ROAS no longer, but now only directional analysis is available for us. This is a huge step back to the old fashioned way to measure everything - with spike testing and media buying. All the growths in specific products or geo will result from our marketing activities.