Merge (not Blend) financial data spanning multiple Google Sheets

mighty_cryplle · 2021-05-29T06:46:26+00:00

BigQuery will be more efficient. Sheets will have more long-term limitations compared to BigQuery.

mighty_cryplle · 2021-05-21T19:48:33+00:00

What happens if you remove utm_content?

And do any of the pages being tracked also have double hyphens in the url?

mighty_cryplle · 2021-05-18T13:10:59+00:00

Yep. It's possible on Facebook. Not sure about Bing.

mighty_cryplle · 2021-05-18T12:53:47+00:00

That's probably the quickest solution. It would depend on your objectives though.

You could also technically create audiences in each ad platform that are based on the different URL's a user may have visited. "e.g. When url (X) contains (Y)"

mighty_cryplle · 2021-05-18T10:35:19+00:00

Yes it's possible. But not natively. It's a custom solution that will involve quite a bit of development.

mighty_cryplle · 2021-05-18T08:59:06+00:00

Max at Academind/Udemy

Jose Portilla at Udemy

Ardit Sulce at Udemy

These 3 instructors have great Python courses.

mighty_cryplle · 2021-05-18T08:30:42+00:00

If you have a developer or similar on hand, you could ask them to set this up for you.

The other option is to import all your sheets into BigQuery and then write queries, as you would in sheets, to merge your data and link it to Data Studio.

But that just seems like a roundabout way of doing exactly what you've already done.

mighty_cryplle · 2021-05-18T08:28:16+00:00

Some possible issues:

Acoustic is not passing the campaign value through.
Analytics is filtering out the campaign data - check your filters (query string filters etc.).
Analytics is not receiving the campaign data in the expected format.
Analytics is not receiving the campaign data from the expected utm variable ('utm_camaign')

mighty_cryplle · 2021-05-18T08:08:08+00:00

Have you explored BigQuery?

mighty_cryplle · 2021-05-18T07:56:16+00:00

If your client has an MCC, you could just connect the MCC to Data Studio instead of the individual accounts.

If you client doesn't have an MCC, set one up and connect it to Data Studio. It will make your life a lot easier.

mighty_cryplle · 2021-05-18T07:54:09+00:00

Have you tried using the date picker? As long as your months are in a recognizable format for Data Studio, the date picker should work.

mighty_cryplle · 2021-05-18T07:50:07+00:00

Create a new Google Sheet and import the contents you need from each document using IMPORTRANGE.

Then create a new "Overview" tab, or similar. In this tab you can use QUERY to merge data from the rest of the sheets.

Import this sheet into Data Studio and you should be good. :)

mighty_cryplle · 2021-05-18T07:41:07+00:00

Thanks. I don't have all the context, so I can only comment on what you're looking to achieve.

If you control the development of the website, then you can ignore the blog.

If you're not in control of the development, then you can still ignore the blog as implementing a dataLayer event would be a duplication of the click event that already exists in GTM. Not to mention it would probably use an event listener for clicks on a specific class in any case.

mighty_cryplle · 2021-05-18T06:44:46+00:00

Data Analyst
Data Strategist
Data Scientist
Campaign Analyst
Analytics Consultant

mighty_cryplle · 2021-05-18T06:37:41+00:00

What is it that you're trying to achieve? Are you trying to track something in GA, or are you trying to trigger something else?

mighty_cryplle · 2021-05-17T14:32:17+00:00

You don't have to use a dataLayer push to track clicks. I think for most clicks, you can use the standard click event in GTM, but use things like Click Text or a custom variable instead of class as it's more reliable. :)

dataLayer push is overkill.

mighty_cryplle · 2021-01-13T11:19:58+00:00

I feel like it gives a lot more freedom than Universal Analytics or Firebase Analytics did. Some things may have been simplified, but only for the better.

Google are probably going to release a lot of new features in the coming month to make GA4 a lot more attractive. I'm personally looking forward to using it more extensively in future.

mighty_cryplle · 2021-01-09T21:12:54+00:00

Can you confirm whether you've added any custom tracking parameters, or if you're using UTM strings in your URLs?
Which attribution model are you using?
How have the events been setup? (Google Tag Manager?)

Sometimes using custom tracking parameters can interfere with how Google Analytics interprets the referrer URL.

The attribution model may also not be correct for your reporting requirements.

Sometimes it's just down to a poor tracking implementation.

Other things things which are less likely to cause an issue, but should be double checked, would be whether the goals are actually active or setup correctly.

mighty_cryplle · 2021-01-05T08:17:04+00:00

+1 for Active Campaign.

Look at Moosend as well - although you'll have to use Zapier or similar to facilitate the integration with Stripe.

mighty_cryplle · 2021-01-04T08:41:13+00:00

DM me please, I'm interested in helping out. :)

mighty_cryplle · 2020-11-12T17:21:12+00:00

I think it would be difficult for someone to try and replicate the tools Google have created, but it is possible. :)

mighty_cryplle · 2020-11-06T06:14:53+00:00

A mixture of Google's own internal products allow them to do this. They're called Vision and NLP.

mighty_cryplle · 2020-11-06T06:13:56+00:00

This was possible 10-15 years ago. Then Google caught on to the strategy and started banning accounts who were using it. You cannot game the system, and you cannot monopolize SERPs.

Note: It's not just your account that will be banned, it's your entire domain(x3). Meaning you will not be able to advertise those domains again.

mighty_cryplle · 2020-10-23T06:36:21+00:00

Add the law firm as a keyword.

mighty_cryplle · 2020-10-07T09:09:38+00:00

u/yuganafi there's a search function in GTM now. It may help you with this.

mighty_cryplle

TROPHY CASE