I am here once again. I have noticed that one of my client's website Organic traffic and referral traffic data have mismatched on Google analytics. When I calculate daily organic data of last 7 day's data then total traffic is 1,933 but the Google analytics is showing 1,805 same as on referral traffic total data of last 7 days is 355 but the google analytics is showing 276. I do not understand why is the data showing mismatched? Please help me. Here is the screenshot below:
You are comparing a daily running tally of users on the site, with the weekly total in Analytics.
The problem is, if a visitor comes to the site more than once during that week, you'll be counting them each time in the daily tally, and Analytics will only count them once for the week. As "Users" is literally "individual visitors during this period" (although that's based on Analytics best estimation, using devices and accounts, so it's not entirely foolproof).
As an example, let's say there are three people who have visited your site, Person A, Person B, and Person C.
Looking at the Analytics data for just Monday or Tuesday, would both show two users, because two different users visited the site each day. But looking at the data for both Monday and Tuesday would show only three users, because only three different users visited the site over that period.
That is what accounts for the discrepancy you're seeing.
A better metric might be to look at sessions. Those are each unique and represent the sum of all visits to the site.
If you'd like to see a breakdown of daily users that does match with the weekly total, you can add "Day of the Month" as a secondary dimension to the weekly report. That will show you the totals with users returning during that period excluded from subsequent days. There are several "day" secondary dimensions, but in your case "day of the month" is going to give the clearest breakdown of data.
