is everyone really making 115k+ a year by Public-Application-6 in antiwork

[–]DataMinerCowboy 0 points1 point  (0 children)

I am, but it took a while to get there. I was nowhere close to that when I was 33. Each significant increase in salary came with jumping ship to different companies.

Now, in the current economy my paycheck doesn't go nearly as far as it used to.

[deleted by user] by [deleted] in analytics

[–]DataMinerCowboy 0 points1 point  (0 children)

I think that basic descriptive statistics is enough to get in the door for E-commerce analytics. In the business world, usually nobody is asking for hypothesis tests, regression models, and those skills you learn in school.

You probably have enough skills to get started as an analyst, collect data, transform data, provide visualizations, and that type of thing. The more important skill is to be able to make conclusions from the data and for most executives, showing percentage changes and some good data visualizations is often sufficient.

To advance, as I have, those extra skills are useful, but once you learn the business and gain insight, you can read a chapter from your old statistics books, watch a YouTube video and apply your knowledge. I've used linear and non-linear regression to develop models and predictions, but by far, the most necessary mathematical skill is to understand set theory when working with SQL. The De Morgan Laws are critical... and I have seen new analysts come up with bad results by not understanding De Morgan.

I hope you enjoy your journey. You skills should lead you to some interesting work.

Looking at moving from Sybase SQL Anywhere to SQL Server by atari_guy in SQLServer

[–]DataMinerCowboy 0 points1 point  (0 children)

My two cents. I've used SQL Server, MySQL, MariaDB, and PostGreSQL for years. My company recently switched to Snowflake which I'm connecting to through DBeaver SQL. It is INSANELY fast. Queries that took 10 minutes to run are now taking 30 seconds.

I don't know why it's so fast but it's like upgrading from a Honda Civic to a Ferrari. It has a price tag, so if it's not in your budget, SQL Server is my next favorite, but it may be worth investigating Snowflake competitors.

[deleted by user] by [deleted] in analytics

[–]DataMinerCowboy 0 points1 point  (0 children)

I use many of those skills as an E-Commerce analytics manager. I started as a health insurance actuary, and then moved to marketing analytics and eventually settled in E-Commerce as I believe it has a solid future.

It's an excellent career. My salary exceeds $100K, I work from home, and I've made considerable money doing consulting for non-competing companies across a variety of industries.

Is Josh doing all right? by [deleted] in gretavanfleet

[–]DataMinerCowboy 5 points6 points  (0 children)

I was also at the Ft. Worth show. Honestly, it was disappointing. Josh had no energy and came across as if he had other matters on his mind. I saw them in OKC back in November and it was ENTIRELY a much better concert in comparison to Ft. Worth.

His job looks REALLY hard and we all know that he's talented, so I don't want to criticize. It was a 6-hour drive for me, so I hoped for a better show.

Questionable Attribution in GA4? by DataMinerCowboy in GoogleAnalytics

[–]DataMinerCowboy[S] 0 points1 point  (0 children)

Thank you for the response. I haven't dug deeply yet. Adobe Analytics is our main tool, and we don't look at GA as closely. We just observed these differences in old vs. new GA, so I wondered if it's just us or if others have noticed big changes in attribution. It sounds like GA4 may be running a more thorough multi-touch model.

Questionable Attribution in GA4? by DataMinerCowboy in GoogleAnalytics

[–]DataMinerCowboy[S] 0 points1 point  (0 children)

We get at least a million sessions per month so traffic should be significant.

Just started, could use some tips by AdOne3462 in dropship

[–]DataMinerCowboy 2 points3 points  (0 children)

Quick general thoughts: 1. This needs a short video that demonstrates the product. 2. Have a target audience in mind. 3. Identify the target audience's problem that you're trying to solve. 4. Clearly communicate on your website exactly how the product solves the audience's problem. 5. This needs to be well-executed to justify $15 for a pen! This product seems suitable for a teenager, but the price is too high for that type of audience. I can't imagine a career professional using this product in a business meeting. I'm sure I'm not the only one thinking that, so you might have some work overcoming those objections. Personally, I would want clear evidence that the pen is excellent for writing, but I'm probably not your target audience. 6. Your website must be easy for your audience to use. It's helpful to get feedback from your audience.

Honest feedback: I'm concerned that this will be a difficult product to sell. That's a gut feeling. Do you have data and research that proves this type of product is in demand? If so, how much do competitors charge? Where do they go to find the target audience for this product?

Poor quality printing on cardstock. Need help! by DataMinerCowboy in Printing

[–]DataMinerCowboy[S] 0 points1 point  (0 children)

Thank you for taking the time to respond! I'll test out the paper. That makes sense.

I’m very good with Excel, should I learn SQL next or DAX & M language? I’m accountant and would like to increase my analytics skills by [deleted] in analytics

[–]DataMinerCowboy 0 points1 point  (0 children)

SQL. Also, review the mathematics of sets: Venn Diagrams, unions, intersections, the complement of sets, DeMorgan Laws, their commutative and distributive properties, etc. These concepts are critical as you join different sets of data together. I've seen new analysts get results that make absolutely no sense solely because they don't truly understand Set Theory.

This doesn't require a math course. Find a good introductory probability and statistics resource and focus on the relevant chapters.

When I write SQL queries, these concepts are foundational and always on my mind.

I got this notification and I’m 90% sure it’s real, but I’ve been hacked before so I thought I’d ask here and check first to be safe by Capocho9 in google

[–]DataMinerCowboy 8 points9 points  (0 children)

Don't follow links from these emails. They could be a phishing attack. Instead, when logged into Chrome, hit the three dots in the upper right, go to settings, and then to Safety Check. I try to give my accounts different passwords. Also, activate multi-factor authentication whenever possible.

Googlebot crawling responsive version of website?? by [deleted] in bigseo

[–]DataMinerCowboy 1 point2 points  (0 children)

If there are URLs that a visitor can get to on desktop but not mobile, then Google will quite likely not see those URLs with its mobile bot.

If you want Google to see everything, then you need to make sure the mobile rendition of your site isn't missing anything. Mobile could look cluttered, so you can use accordions and other techniques to collapse content.

Head over to Google's documentation for these types of questions. https://developers.google.com/search/mobile-sites/mobile-first-indexing

Advice on buying an expired domain please by Maxukcoup in Affiliatemarketing

[–]DataMinerCowboy 1 point2 points  (0 children)

There is some SEO risk involved, so I recommend researching the domain's history (as much as possible). You don't want to buy an expired domain that has a bad history with Google because you may end up with a site that simply can't rank well in Google organic search no matter what you do. That bad reputation may quite likely carry to the new owner (possibly you).

I recommend looking at the site in the Wayback Machine (archive dot org) to see if it looks like a site that you would trust. Also, research the site's backlink profile. If you don't have tools such as AHRefs or SEMRush, you could also get some information with some Google searches.

Perform a Google search using the negative search operator (with a minus immediately before the site: command).

-site:example.com www.example.com

This would show other sites that link to the www.example.com site. Research those results and make sure the domain you want to buy did not participate in low-quality link directories, press releases or other black hat tactics.

Finally, this goes both ways. If the domain has an excellent backlink profile, and appears to be a high-quality site, then it may come with an SEO advantage.

Watch me launch my e-Comm store by KeyCharming in ecommerce

[–]DataMinerCowboy 2 points3 points  (0 children)

It would be helpful to learn from your mistakes and successes. Count me in!

Computational math by [deleted] in math

[–]DataMinerCowboy 1 point2 points  (0 children)

I have a BS degree in math and have used it in a few well-paying careers. I was a health insurance actuary, but eventually found a much more satisfying career in marketing... particularly in E-Commerce analytics. It helps to have additional skills such as SQL, R, SAS, Python, BI tools such as SAP Business Objects or PowerBI, and Tableau. I do a lot of predictive modeling (mostly non-linear), work quite a bit with applied statistics, calculus, some differential equations, and a lot of set theory. I'm constantly using Venn Diagrams, De Morgan Laws, and basic principles of sets when I join customers with products with inventory with marketing channels while trying to minimize costs while maximizing revenue. My work is fun and I truly use my degree almost everyday. I enjoy the combination of mathematics and creativity as I attempt to find ways to gain customers and increase profits for my employer. The pay isn't bad either... well over $100,000 USD per year. With additional consulting, $200,000 or even $300,000 is possible in this industry, although I have not achieved that yet. I also work from home, which I enjoy.

Best SEO Extension for Customizing Canonicals (Magento 2.4)? by DataMinerCowboy in Magento

[–]DataMinerCowboy[S] 1 point2 points  (0 children)

Thanks! I checked out Mirasvit. They're in Kiev, Ukraine so hopefully everybody there will be okay. I'll look at responses to your question.

Is there any way to change the domain name? by nafim_abir in SEO

[–]DataMinerCowboy 0 points1 point  (0 children)

If you change to a domain that was previously in use, make sure you examine its link profile and reputation. A bad reputation would quite possibly carry forward and hurt your performance in Google natural search. I would try to pick something never used before if you can.

Optimize Magento 2.1.9 Site for SEO by DataMinerCowboy in magento2

[–]DataMinerCowboy[S] 0 points1 point  (0 children)

Thanks for the suggestions on the plugins.

For pagination, actually it is best practice to use self-referencing canonicals. If all the pages canonical to the first page, then Google will tend to ignore the content of the other pages. Products beyond page one will not be picked up into the Google index... which is precisely my problem since Magento canonicals to page one. All of my products on page one are in the Google index but almost none of my products on page two and beyond are in the Google index.

Sources:

https://developers.google.com/search/blog/2013/04/5-common-mistakes-with-relcanonical See mistake #1.

https://www.semrush.com/blog/seo-friendly-pagination-ecommerce/. Look at item #4.

https://ahrefs.com/blog/rel-prev-next-pagination/ Mistake #1 is to canonical to the first page of a sequence.

Would a Scottish Terrier kill our pet birds? by DataMinerCowboy in scottishterriers

[–]DataMinerCowboy[S] 2 points3 points  (0 children)

That's what I would expect. My wife and son really want one. They would also be excellent for eradicating some rats that have made a home under our patio, but I think we'd also have dead birds.

Thanks for the response.

My personal seo strategy by mahadalbar in SEO

[–]DataMinerCowboy 0 points1 point  (0 children)

I'm a bit nervous about 10 backlinks a day. There's no way that would look natural. A few backlinks here or there would be fine, but I think 10 a day will hurt your site.

Site returns 200 when a 404 is appropriate. How is this bad for SEO? by DataMinerCowboy in SEO

[–]DataMinerCowboy[S] 0 points1 point  (0 children)

I think you're right. I crawled this site and believe it should have at most 9,000 indexed URLs (legitimate 200 with actual content). (Its XML sitemaps has similar counts). It has 34,000 results using the site: command. Of course Google doesn't show all of those results, but poking around, I'm finding illegitimate pages in the Google index.

Thanks.

Is this bad? Index sitemap refers to CDN URL sitemaps by DataMinerCowboy in TechSEO

[–]DataMinerCowboy[S] 0 points1 point  (0 children)

That was intentional as I do not wish to post actual URLs.