Analytics Help

I have a raw data that I am to analyse under tableau software.
The data basically is a sales data. and it is very straightforward.
Date,Reference,sales rep,customer,customer channel,customer area,,item,item type ,item description,qty,unit price,discount,net price.
one of the questions that is asked is to identify for a specific product, who are the customers that never purchased from this item within a specific period of time.
They need it interactive so that they can "play around" with it.
Any idea how I can achieve this ?
Thanks

1 Comment

LVL 11

Question by

Prabhin MP

2d ago

Kylin not getting start

Kylin not getting started

here is the below error which I'm getting

kafka dependency is /opt/apache-kylin-2.2.0-bin/lib/kafka-clients-1.0.0.jar
Retrieving Spark dependency...
Error: Could not find or load main class exists
ERROR: Unknown error. Please check full log.

3 Comments

Question by

rivkamak

2018-11-02

Google Optimize tracking B page

I set up an AB test on my site with Google Optimize.

I was wondering if there is anything added to the URL as a parameter, or is there is any parameter I can pull using javascript to indentify if the user got to the page via the B page, or they just happened to land there?

4 Comments

Question by

Miss Techie

2018-10-27Solved

Google Index of 301 Redirects

I have searched the Internet for days now trying to determine what happens when an affiliate link is 301 Redirected via cPanel. The main question is that I want to know how the Google Indexing of the Domain and link will show if it is an Amazon affiliate link. Can someone help me to understand this process? I have gone to forums and did days worth of Google Search.

7 Comments

I really need a little intelligence on profitable niches to start a blog. I have gone through hundreds of niches high and low competition. I want to go where the money is right now and in the future. I want to start a little blog to run solo. Can you help me? I really and tired of the get rich schemes and affiliate marketers selling crap. I want to get to the people. I am starting from the ground zero.

3 Comments

Question by

feesu

2018-10-17Private

DM in Arabic for an International Website

An international website that runs with Multilanguage interfaces except Arabic. Digital marketing is handled by a third-party. If we wish to create the Arabic site as completely separate website hosted somewhere else, what are the pros and cons in terms of digital marketing?

1 Comment

I need to pull creative file names through a UTM using DCM as the trafficking platform. Is there anyway to do this on the DCM side or Google Analytics side?

1 Comment

I have Aliexpress affiliate website where I am getting most of my traffic from Search.

(http://aliexpressions.com)
(www.essmen.com)

The sites have been around for about 45 days.

I have placed links on Twitter, Reddit, Google Plus, Facebook and Instagram for traffic. And, I have completed the Google Analytics and Google Console.

I submitted the websites to other search engines a few days ago.

I placed the sites on Hotjar, the free version.

I am looking to get more "free" traffic!

I was told that it is best to let the website's index in Google for about six months.

I am going to send out press releases.

I need some good ideas for more traffic. Can you help me? I am a newbie. Thanks in advance.

***Note I tried to put one of my Affiliate Website on Outbrain. I was told that my websites are not a good fit for their Native Ad.***

5 Comments

Are there any tools other than Microsoft Call Quality Dashboard and Skype Analytics for measuring Skype call quality? Audio? Conerence calls? Video? We are mostly a Cisco network. There are shortcomings in the MCQ dashboard that have not been addressed since we adopted it.

0 Comments

Question by

sunhux

2018-10-08SolvedPrivate

Cloud Data analytics security/risk assessment

Would like to assess the data analytics solution in terms of security/risk for service below
(which uses Cloud):

"AAA Solutions, a local- based data and analytics consultancy, provides Information Management and Analytics support to our clients. Our seasoned practitioners bring established tried and trusted models developed through years of practical hands-on implementation and successful project delivery of Data Warehouse, Business Intelligence & Analytics systems. We apply an optimum mix of descriptive, diagnostic, predictive and prescriptive methods to drive business value, cost efficiencies and manage risk.
To establish the Forecasting & Analytics System (FAS) integrating with the top-of-the-line Business Intelligence system and automation of the external variable extraction process to streamline analytics workflow.
Data Source is using Qlik N-printing;
Data Integration & Transaction svcs is using MS SSIS;
Data Marts layer is by MS SQL 2017;
Power BI is by O365;
our on-prem AD sync to O365 AD"

Can only currently think in terms of encryption of data in transit, at rest & at endpoint.
What about data integrity (ConnectDirect did checksumming), cloud security (esp this one)?

I like MS SQL 2017 (as MS SQL 2016 only offers DB encryption in Enterprise Edition) offers
DB encryption even for the non-Enterprise edition

3 Comments

Fundamentals of JavaScript

LVL 12

Learn the fundamentals of the popular programming language JavaScript so that you can explore the realm of web development.

how to create a google analytics segment?

1 Comment

LVL 1

Question by

Member_2_7966113

2018-09-20

Big Data Consultancy and Partnership

Hello Experts,

I would like to start a consultancy providing Data Analytics for industries using technology's like Azure Data Factory, Azure Streaming Analytics, PowerBI, Azure IoT.

I would like to find similar like minded individuals.

I would be happy to inject financial investment if needed.

Can someone let me know where the places to go to meet with like minded people?

Thanks

Carlton

0 Comments

I have completed a 301 Redirect via cPanel using my affiliate link. I have two questions.

How to do I get my website ranked on Google? I have added the website to Google Analytics. One problem is that I was unable to verify it via Search Console.

And, the second question is how do I advertise since it is showing up as Spam to the Search Engines and Social Media websites?

2 Comments

Question by

Miss Techie

2018-09-15Solved

URL not in property

I got an error in the Google Search Console stating "URL not in property." Now, I have added my website to Google Search Console and verified it. I do not have any stats in my Google Search Console other than the sitemmap info but in my Google Analytics I have data. Can someone help me with this error?
URL.png
Search-Console.png

5 Comments

I have a large data (about 44,000 entries) with 10 variables and one outcome. I am trying to figure out a model that can predict the outcome (it is a true/false outcome). So far nothing can predict the outcome more accurately than 65%.
What am I doing wrong?
The outcome is whether the company car needs maintenance (true/false).
The variables are the ID number of person leasing the car, the age of the person leasing the car, starting odometer, ending odometer, starting time, ending time, area the car is being used and car model.
So far the best model that works is the average velocity and end odometer combined but it is not more than 65% accurate in predicting true.
The following variables have no predictive value: age, area, car model, time of day, day of the week

2 Comments

I have a .htaccess file that forces the website to go to https://mysite.com

So no matter how you type it, http://www, www, or whatever configuration it will always take the user to https://mysite.com

I am getting this message when going into Google analytics. Does this have to do with the fact that I have 2 domains in google console? What is the best thing to do regarding this message?

Property YourSite is receiving data from redundant hostnames. Some of the redundant hostnames are:

yoursite.com
www.yoursite.com

Redundant hostnames are counted as separate rows in reports, so hits that are going to the same page on your site from different hostnames will be split into multiple rows. With data split across multiple rows, traffic to specific pages will appear lower than it actually is.

To avoid this problem, consider setting up a 301 redirect from one of your redundant hostnames to the other, or create a search-and-replace filter that strips "www." from hostnames.

Google Tag Assistant Recordings can help you verify that your redirect is setup correctly, or that your filter is working as intended.

2 Comments

I need assistance with updating my google conversion tracking please as they have changed the tags.

This is the tracking code before my head tag...

(function(d,e,j,h,f,c,b){d.GoogleAnalyticsObject=f;d[f]=d[f]||function(){(d[f].q=d[f].q||[]).push(arguments)},d[f].l=1*new Date();c=e.createElement(j),b=e.getElementsByTagName(j)[0];c.async=1;c.src=h;b.parentNode.insertBefore(c,b)})(window,document,"script","https://www.google-analytics.com/analytics.js","ga");ga("create","UA-6620915-45","auto");ga("send","pageview");

Open in new window

On form success I previous used this code below for the conversion event tracking...

ga('send', 'event', { eventCategory: 'contact', eventAction: 'submit', eventLabel: 'hardware'});

Open in new window

This is the info that google sent me: https://support.google.com/google-ads/answer/7548399

Can you please show me what my code should now be?

3 Comments

Question by

angel7170

2018-08-15Private

Interactive Parameter selection

Hello,

I am trying to create a Tableau Line chart for the users to interactively select the measure based on the parameter selection. Please see attached is the sample data.

I want to show the trend of discrepancy based on the report_date for each table. The "measure" should be interactive based on the parameter selection. There are 4 different measures in the attachment and based on each measure, I want the line chart to change.

I am a newbie to Tableau so please help. Thank you so much
dq_daily.xls

Analytics

0 Comments

Question by

Susmitha Sajja

2018-08-08Solved

SQL Server connection Error

I am trying to schedule refresh my data source in tableau online and I am getting a connection failure error. I talked with Tableau support to see if it's anything I did wrong in tableau but they said it's SQL Server issue. I can connect to SQL server using Windows Authentication and create reports and can publish them . when i publish them the server name is coming as localhost. So, I tried to do SQL Server Authentication and used username: sa and password and logged in Tableau Desktop and published the data source but the scheduling doesn't work and gives me an error of connection failure again. So i tried looking at the connections in tableau online. Tried localhost, username sa and when i press test connection it gives an error couldn't found the server.

1 Comment

Question by

bharath balu

2018-08-07Solved

Pivot Table issue in Qlikview

Hi,
I have Pivot table in Qlikview and I need to show subtotal for each region, but am not getting total column in chart.
kindly help me here.
Note: In expression I used "Only" function ex: Only(Sales)

3 Comments

Hi Experts,

I am debugging a share point web parts and I get run time errors for last a few days (I did''t see these errors at the beginning. ) and I have no idea where they are coming from.
I checked master pages and I couldn't find script that calls google analytics.

Exception was thrown at line 24, column 671 in https://www.google-analytics.com/analytics.js
0x800a01ad - JavaScript runtime error: Automation server can't create object
Exception was thrown at line 24, column 778 in https://www.google-analytics.com/analytics.js
0x800a01ad - JavaScript runtime error: Automation server can't create object
Exception was thrown at line 24, column 927 in https://www.google-analytics.com/analytics.js
0x800a01ad - JavaScript runtime error: Automation server can't create object
Exception was thrown at line 15, column 232 in https://www.google-analytics.com/analytics.js
0x800a138f - JavaScript runtime error: Unable to get property 'getRandomValues' of undefined or null reference
Exception was thrown at line 15, column 232 in https://www.google-analytics.com/analytics.js
0x800a138f - JavaScript runtime error: Unable to get property 'getRandomValues' of undefined or null reference
Exception was thrown at line 1649, column 1 in eval code
0x800a138f - JavaScript runtime error: Unable to get property 'Resources' of undefined or null reference
Exception was thrown at line 1649, column 1 in eval code
0x800a138f - JavaScript runtime error: Unable to get property 'Resources'…

3 Comments

How to Detect Traffic From China language hu-hu (reported in google analytics) and divert to a not available in your region page

I notice traffic with language hu-hu in my google analytics with a high bounce rate.

What is the best way of detecting traffic from China - with language hu-hu?

I have a cold fusion 2016 site. Thank you

13 Comments

Referencing this topic: https://community.tableau.com/message/746162#746162

1) I want to take it a step further and hide the relative dates (Start and End date Parameters).
OR
2) Can I populate the start and end date parameters based on my selection?

For example:
Past Month would display 6/1/18 in the start date and 6/30/18 in the end date.

YTD would display 1/1/18 in the start date and 7/12/18 in the end date, etc

If that is not possible then I just want to be able to hide the start and end date parameters unless I choose CUSTOM.

--------------------------------------------------------------------------------------------

Here is the case statement for the drop-down Date Filter:

CASE [Select Range]

WHEN "Most Recent Date" THEN

//Sunday

IIF (DATEPART('weekday',TODAY()) = 1,(IF DATEADD('day',-3,TODAY()) = [Date] THEN "Keep" Else "Drop" END),

//Monday

IIF (DATEPART('weekday',TODAY()) = 2,(IF DATEADD('day',-4,TODAY()) = [Date] THEN "Keep" Else "Drop" END),

//All other days

IIF (DATEADD('day',-2,TODAY()) = [Date],"Keep","Drop")))

WHEN "Past Week" THEN

IF DATEPART('weekday',TODAY()) = 2 THEN

(IF (DATEPART('week',[Date]) = DATEPART('week',TODAY())-1 OR (DATEPART('week',TODAY()) <= 1 AND DATEPART('week',[Date]) = 1)) AND DATEPART('weekday',[Date]) < 6 AND DATEPART('weekday',[Date]) > 1 AND [Date] > DATEADD('day',-365,TODAY()) THEN "Keep" END)

ELSE

IF …

Analytics

1 Comment

Hi, I checked this page in Google's new url tool:
https://www dot magickitchen.com/meal-delivery/

It says: Indexed, not submitted in sitemap. But I checked the sitemap section, and it's using the one I submitted, in the root, sitemap.xml.
And if you go to that sitemap and search the URL, it's there.

Can anyone explain that to me? WHy would it say not submitted in sitemap when it's clearly there and has been since March? Thanks.

7 Comments

Maintaining an effective business website is a complex task, seeing as how efficiency might be interpreted in different ways. Here are top five techniques and methods to maintain an effective business website.

0 Comments

Add Comment

Analytics

Related Topics

Analytics

Related Topics