Shopify Sales Tax Report | How to Find and Understand It

hi shopify sellers this is kasheen from,ledger gurus,i am so excited to be here today and to,share with you,a couple questions that we often hear,about shopify,and sellers responsibility when it comes,to sales tax,and i'm going to walk you through how to,find the report you need,to understand sales tax obligations as,a shopify seller,[Music],before i dive in i just want to,encourage all of you to subscribe to our,channel so you get the most,updated and accurate accounting tips and,advice,okay so we have lots of clients,with um that are selling on shopify and,shopify is a great selling platform,and we get questions from them about,sales tax all the time,so before i dive into the actual report,i just want to address a couple,key questions that we've encountered a,lot so the first one is,lots of sellers are wondering if shopify,is responsible for,collecting and remitting sales tax to,different states and the answer is,no shopify is not like amazon it's not a,marketplace facilitator,so it doesn't automatikally collect and,remit sales tax,to the states you have to manually set,it up yourself,and we have a video on how to do that,and you have to,determine where you have nexus and,that's where,you will need to register and report to,the states to learn more about like,determining where you have nexus and,whether you need a seller's permit,um please refer to this other video that,we've done,and leave us any questions that you,might have,okay so i'm now gonna switch over and,share my computer screen so i can walk,you through,where to download the reports and then,i'll walk you through the reports and,just a few tricks on,how to understand the report so you can,determine nexus for yourself,and use the information,on this report to do your sales tax,findings,so this is one of the shopify,accounts that one of our customers have,um,so once you log in you're gonna be on,this home screen,and next you want to go to orders and,then on this top right,you want to click on export so,depending on if you are doing a monthly,filing or you want to review a whole,year of,nexus this is where you would pick order,by date,and select the dates today is january,14th,so if i am doing the return,for december of 2020 i would want to,look at sales from december 1st,to december 31st and then i click on,export orders,for our purpose i'm gonna look at the,last quarter so in case you're a,quarterfinals,um then you want to look from october,1st,so you just click on first and then you,click on the month,and then you click on 31st and then,click on,export order and we can leave it for csv,for excel this format is great if you,want to do a nexus analysis on,all of your sales in 2020 you would go,to the same place,and click on order by date but instead,of going to october 1st,you would go all the way to january 1st,and then all the way over to december,31st,and then click on export order the file,will get,sent to the email address that's,associated with your shopify store,it might take from a few minutes to a,few hours just depending on the volume,of sale,and it might show up as multiple folders,of export this is the one that,i downloaded the first time for q4 of,2020,just for demonstration purposes and,showing you guys,how i utilize this report,um okay so this is the report,you will see once you open it from your,link,in the email and let's expand,all of these so we can go through,everything that's,on this report so we can see,the header really clearly so name is,the transaction id number and you can,see it's duplicated because,um it's by item and not in that order so,this one,uh the customer lauren she bought,one two three four five items,and we can see also on here on the item,name these are all different items but,it's all,for this one customer that's why the,transactions are repeated this many,times,so it says whether it's paid or not what,time it was paid,whether it's fulfilled or not if it is,fulfilled,this is the date where it was fulfilled,and this part is the,financial part so i want to walk through,this for sure,um the subtotal column is what the,customer,end up paying for the product and this,is net of discount so this 215,is net of the 116 discount,amount and then the subtotal plus,shipping plus tax equals,this total which is two two two nine,three,matches right here we can know that this,is,net of discount because if you go,keep going to the right there is,line item price for each of these items,and if we add them up it's 332 dollars,and 20 cents,minus the 116 will give you,the net of 215.90,okay and then if we keep going to the,right this describes the item they,bought,and the and the um pricing for each item,fulfillment status which corresponds,with,earlier what we've seen and then billing,information,um all of these for sales tax purposes,we really want to focus on the ship to,address,so shipping name shipping street,and here ships to address one two,and uh city zip,right here instead of state shopify,closet shipping province,because if it's to like an international,location,lots of other countries use province,instead of state,and country so this shift to column,column,ap is really really important when it,comes to sales tax filings because,this is showing you where the customers,are,which determines your nexus which,determines which state you're going to,file,your return to so these are everything,out on this report what we usually do,to try to analyze this report is to run,a pivot table and i'm gonna,show you that so you can see exactly how,to how to analyze this report so,a lot of these information we want to,strip them out so we're gonna add of,just a few columns um,and you can add more columns depending,on your need but we usually,would do a column to strip out the year,and month and,then we'll do a month a year combined,and it all makes sense in a little bit i,promise and then we'll do a calculated,order number because,when you want to do economic nexus,analysis you want to know how many,transactions you have,into each state on column ap year,we'll just do equal year and we'll strip,out the year from the paid act,information we'll do the same with month,and we'll do this one and then month,year we'll just combine those we'll say,we want to show that it's december,and we'll want a space in between,and then we'll put the ear on there so,it's just december 2020,then this calculated order number,will say we'll use the if function if,this,equals what's up sorry equals,what's above it then,the count is zero because if it's the,same then we don't want it to count,again,if it's not zero then it'll be one but,sometimes,we just want to make sure this always,has,a value so if this,doesn't have anything we'll say it's,zero,if it does it's one okay,just because these are our formula and,modified,columns so i usually want to highlight,them,so i know that these are formulas that i,added,and then we'll drag them down so they,apply to,all to every single order um,okay so and you can see like these ones,they don't have,they don't have one so it's using like,this date,so we'll we'll see that when we run the,pivot table,so then let's click on this little,triangle sign,we'll do insert and pivot table,use all of this range and then on here,is when we can say how do we want this,to be structured so we can analyze it so,we have month and year,so we can filter by the date we want,and then we have,financial status and a lot of our,clients,want to know information by payment,methods,so we can add payment methods on the,filter as well,one other thing we can add is shipping,country,so we can filter out transactions that,are not,us-based right here we'll just put it on,the bottom,okay so these are our filters that we,can use to manipulate data,and then on the role we'll put shipping,province,that's all the states and then we need,to put all the financial information so,we can start analyzing them,so we'll put subtotal shipping,because shipping is taxable in some,states but not other states,and th

How to find tax and other financial reports on your Shopify account

[Music],hi what's up guys on today's video,i will be showing you how do i generate,my tax report papers as you know this,season most of us are filing our tax for,our business for our personal,incomes and stuff like that so i will be,showing you a fast and quickest way you,can find your yearly statements or,monthly or quarterly whichever how you,want to file your tax so let's go and do,it okay,so you will come to this page,and you will click on the analytiks,under analytiks you will see reports and,live view so we will need a report so we,click on the reports,once you go that page you go scroll down,and you will see a summary total sales,tax tips and payments so what we need,over here is only tax for tax purpose,you click on the tax here,and,over here on the old channels it will,give you an option for which categories,you want to print out for your facebook,sales for pinterest for google cells or,any other channels so whatever you want,you pick it from here and for example,you can pick online store,and it will show you this page over here,you can change the date,over here we are doing for last year so,you change the date,to zero one zero one,for some of you if you are filing,quarterly the dates will be different on,my case this is a new business so i will,be doing from last year only from,january to,december,so i'll be changing to this to december,and zero one no sorry 31 and we click,apply,so it will generate all the report over,here for you and you can print it from,this page or also you can export it so,when you click export it will ask you,how you want the airport,sorry,so it will ask you in what format you,wanted i want full report so when you,click export it will bring it on excel,spreadsheet,[Music],and you open it right here so the report,will take out all the cells that made on,that year,how much tax you collected how many,orders you made and all that information,but you can't hide those parts if you,don't want to take it to your income tax,barida who's filing it for you if you,don't want to show you can hide some of,the,collins over here but it will show you,how much you have owned for that,government so this is how i make mine i,hope you learned something from this,this is a short video thank you for,watching see you,[Music],you

More:Microsoft Buying TikTok? Instagram Reels? Here's What You Need to Know.

How I Read My Shopify Reports / Analytics For Beginners! 2020

[Music],all right guys we got a,very very very,interesting topic to cover today,okay it's not that interesting honestly,it's kind of boring but,it's pretty essential when you are,starting an online business with your,shopify account,and what that actually is is how to read,your shopify,analytiks aka,all the data that shopify collects as,people start interacting with your store,it gives you back a lot of valuable data,analytiks reports whatever,inside your shopify um some of which is,more important than other information,i'm just going to share with you in this,video the things that i look at and the,things that i think are important,and what some of these things mean and,how to read them,and yeah that's pretty much it,so let's hop into this video and,hopefully by the end of it you'll have a,better understanding,of your shopify dashboard and what all,these numbers and all these data points,actually are telling you about your,store,so yeah that's that's it all right guys,welcome back yes i'm wearing a,completely different outfit because i,rewatched this video that i shot,yesterday,and it was completely blurry so i am,going to reshoot my,video and yeah this is just the life of,trial and error so this is how you get,better at the things that you're trying,to get good at so i'm gonna hop,into my desktop view now and we're gonna,see the inside of a new,shopify store that i have just started,i'm gonna share with you some of the,analytiks that i personally,look at and how i calculate the numbers,that i think are important,so i can't speak for anyone else this is,just what i do based off my experience,so yeah if you enjoy this video make,sure you give it two thumbs up and,subscribe,to the channel because that just helps,my channel so,all right we're gonna hop into desktop,view right now,okay cool so this is the inside of a new,shopify store that i'm currently,building,out and off the top of the bat the,column or the area that you're going to,be looking at is this analytiks section,here so i just want to go over a few,key data points that i personally look,at every day and what that means,for your store so the first thing off,the bat obviously something you,look at every single day is your total,sales um but one thing to note about,this box here is this is actually your,net,sales so it's the gross sales minus,discounts and returns,so if you sold a thousand dollars with,the product that day and 500 of that,you issued 500 with a return product,it's only going to show you 500,it's not gonna show you the thousand,dollars if you issued refunds for that,day or something,also discounts so if you're running,sales if you're giving 10 off 20 percent,off whatever and,the product was 50 bucks they had 10,bucks off it's gonna show,forty dollars there in that sale it's,not gonna show the fifty dollars,but another thing to know about that,column is that it's including your taxes,and shipping labels so if you're giving,free shipping,obviously that's not going to show in,that column but if they're paying for,shipping,and say the project was fifty dollars,and shipping was three dollars it's,gonna show the 53 dollars there,as well as taxes if you are collecting,taxes for your state,so that's just something to note because,that's actually not your money at the,end of the day,that is money that you're gonna either,be spending buying the labels or,the taxes that you're gonna readmit to,your state so the next,thing that i look at is an online store,session,so a session if you think about it,similarly to,when you walk into a store every time,you walk,in and then leave the store that is a,session whether you bought something or,not right,so say you went to the into the store,you picked some stuff up you added them,into your shopping bag and then you,didn't buy anything you put everything,back and you left,that was a session if you came back to,that store,30 minutes later after you ate lunch,that would count as a new store session,so tiknically one person could have,five sessions,in one day on your store but the,important thing to know with your store,sessions your sessions in,comparison to your actual conversions,that you're getting,which will bring us to this column down,here which is an online store conversion,rate,and i don't want you to think of a,conversion as just a sale because the,conversion in the marketing world can,mean,a number of different things it's,whatever the goal is that you're trying,to get the person to do so,if the goal was you're trying to acquire,leads for real estate and you wanted to,get their name and their phone number,that is a conversion right it's whatever,action you want someone to take on your,store,and so that's why you are going to see,these two data points down here which is,added to cart and reach checked out,because tiknically those are,conversions,those are goal oriented activities that,we want all of our customers to be doing,when they're on our website your,purchase conversion rate which is going,to be,the amount of sessions that you had for,the day divided the amount of purchases,that you actually,got so it's going to be if you had 10,purchases and 100 people,um visited your store that day it would,be 10 divided by 100 which is gonna give,you that percentage,and a good versus bad conversion rate is,gonna look different,for per niche right and so you don't,really know what,the goal of your conversion rate niche,is per se,especially when you're starting out,unless you can find like a,cross-the-board niche average you want,to go above the average of,the niche that you're in whether it's,sportswear where it's fast fashion or,maybe you're selling furniture,or home decor whatever it is if you can,find accurate data points somewhere that,shows you what an industry averages,if you can beat that industry average,obviously that's what you're going for,even if you do find the industry average,and,you know you're running traffic to your,store and the numbers make,sense and i always say as long as the,numbers make sense,i mean it matters you're always trying,to do better than what you have,but for instance like if it only costs,you,in your store a certain amount of money,in marketing right,to get people to your store and you know,that every time you get 100 people to,your store two and a half people are,gonna buy right,and you have a 2.5 conversion rate as,long as you're profitable in making,money after marketing and fees and,product costs and taxes and,merchant fees as long as you're making,money and you're happy with that with,that number,at that point you're just trying to keep,getting your conversion rate higher and,higher and higher,but again a good conversion rate,compared to a bad conversion rate is,depending on the back end of your store,and your cost,and what it's actually costing you to,acquire people to get that traffic to,your store because,different niches some are going to cost,more and some are going to cost less,so for me i know that in my other store,if i get 100 people to my store and two,and a half,of those people actually make a purchase,then i am profitable,after my marketing expenses my my costs,my employees everything else um you,always want to do,higher than that for me even a one,percent is,not that bad um but obviously you're,always going to want to try,to do better in the time that you're,actually gonna look at these,conversion rates um i don't really look,at them that much,but they will be key point indicators,when something is going wrong so if you,have a 10,add to cart rate and then all of a,sudden your reach checkout rate is 0,that's telling you that something's,probably wrong in your website,whether it's your loading time whether,there's a piece of copy that's written,in there that's just like throwing,people off and getting them to like quit,your store,maybe they're reaching a checkout point,and they see something that says no,returns or something,and that makes them drop off knowing,these data points will,be like a key p

More:How to Sell On Ebay For Beginners 2019 - Step By Step Tutorial

4 Essential Shopify Reports To Grow Your Store

hey guys it's christian here and today,we're gonna go over four essential,reports to grow your shopify store let's,get started,all right so the first report we're,gonna tok about is the traffic report,this shopify report tells you all about,your website traffic it breaks down the,data according to each channel so,channels can be organic social direct,referral email or paid search among,others,with this traffic report you can,determine which channel is actually,bringing you the most money and this can,help you decide which to prioritize in,the future for example if your revenue,from organic searches is pretty low then,this is probably an opportunity for you,to invest some money into organic,searching right,you can also optimize your website for,those specific keywords so that you can,rank a little bit higher when it comes,to organic searches right if that's,something important to you and it makes,sense for your business now the traffic,report just really quickly you can find,it,by going to analytiks dashboards and if,you scroll down here in the dashboard,you'll see some of the most important,data and some of the ones that we'll be,toking about today so that one's going,to be the online sessions by traffic,source you can see a quick snapshot,right here but you can actually click on,the view report,and this will show us,the sessions by refer so some of the,things that we're toking about social,direct search,this will actually give you the names of,those,more specific in the social for example,facebook tiktok instagram etc and it,will tell you the visitors and the,sessions,and obviously you can change the the,date range here from instead of just,today um to a month a year etc so you,can kind of get a better idea of where,people are coming from uh to your store,now before we keep moving on i just want,to say welcome to everyone new my name,is christian pinyon one of the,co-founders here at bitbranding we've,been helping frustrated store owners,since 2015 become impactful store owners,through tutorials tactiks and strategies,and the one way you can support our,channel is by hitting that subscribe,button and turning on notifications all,right the second report that we have is,the average order of value shopify,allows you to pull a separate port on,average order value or aov and this,it calculates this by dividing the total,value of your sales by the number of,sales made in a given period so the,total value of your sales include taxes,and discounts in there and shopify,doesn't include returns in this,computation right your aov can determine,the future direction of your marketing,strategy so for instance if you are,making a large volume of sales but your,aov is low,you can increase it by bundling,cross-selling or upselling more products,you can also add a free shipping to,encourage customers to put more items in,their basket since they're going to be,not spending anything on shipping they,may be able to spend a little more on a,few more products now in order to get to,that report we're gonna go again to,dashboard,and we scroll just a little bit we'll,see average order value and like i said,this is just a little snapshot we can,click on the view report,and this will show us the average order,value over,time now you're interested in some apps,that will help you increase the average,order value by bundling cross-selling or,upselling to different products then you,need to check out this video right here,that we did on top four shopify apps for,your clothing store that we share a few,of those in there that will help you,generate more all right so the third,report that you need to be looking over,to make sure that you're growing your,store is sales over time report the,sales over time report gives you the,number of orders and total sales you've,made over a specific time period you can,specify a different date range like,monthly quarterly and so on,with this kind of information you can,draw conclusions as to which of your,efforts are working,and strategize accordingly so for,example if you saw an increase in the,second quarter after you optimize your,site for specific keywords for example,uh you can conclude two things one you,should continue right to improve your,seo because it's working and two uh,consumers are actually using those,keywords to,make searches and that leads them to,your store and release them to more,sales on your store so it's an important,thing to consider uh the sales over time,plus whatever you whatever changes you,made during that time right so if it was,the keywords then that's something that,it's working for you potentially if it's,marketing on facebook or it's marketing,on tiktok for example for this,partikular month or this partikular,quarter you saw that increase in there,then you can probably um attribute some,of those things um to those sales,so in order to get to the sales overtime,report um that should be one of the very,first ones in here and something that,you're probably already looking at,almost every day which is the total,sales report here and click on view,report,and this will show us the,uh here let me change the date range to,last year,apply,and as we can see,and at the end of the year for this,partikular store um is usually,really really good,so we'll have to determine what we're,doing,right here in order to get those sales,all right and lastly we have our,returning customer report the returning,customer report tells you which of your,previous customers actually are,returning to your store to purchase more,than just that one product you can,arrange them based on how much they,spend so far and the report also,includes,your customers first purchase date and,last purchase day and the total number,of orders to update,you want to know who,of your customers are actually returning,so that you can appropriately show them,appreciation and continue to nurture,those relationships right um for example,a well-timed gift for,some of your,highest,customers where you know they purchase,the most out of you,is something really well,really well done,another thing could be personalized,emails just just saying thank you right,but that personalized note,will trust me will,go a long way and ensure that they,continue right to to keep coming back,and purchasing from your store so,valuing your returning customers also,makes it more likely that they will,refer other people family friends and,colleagues to to your store because of,that personalized touch not a lot of,people are doing that,in order to see that returning customer,rate um that's also in the dashboard,you'll see it over here it says customer,return rate,you see for this store right here we,have it at 66 percent which is,incredible,now a little bit more about the customer,return rate you probably want to,there's a sweet spot right to to this,number uh i would say 20 to 30 you're,probably maybe a little bit low um 32 or,not not 30 40 to 50. that's probably,like the sweet spot somewhere around in,there if you're higher than 50 then that,means that you have a very low customer,base and you don't have enough people,coming into your store so i would argue,that if you have something above 50 60,70 even,that will be something that's probably,on the higher range so you'll want to,consider,using some tactiks or marketing in order,to increase more traffic into into your,store so keep that in mind,all right that's all we have for you,today again the analytiks on your store,is something very important that you,need to make sure that you're looking at,maybe not every day but every week for,sure and running reports printing these,reports looking at them studying them to,make sure that you can make better,decisions for your store if you have any,questions about reports or the dashboard,the analytiks or anything like that,leave us a comment down below and we'll,make sure to help you,determine what's best for your store you,know leave us some love like this video,subscribe to our channel and we'll see,you

Understanding the Shopify Sales Report

hi i'm brushaw kapanis in this video,we're going to discuss the headers of,the sales report from shopify,so i've just notiked that a lot of,e-commerce entrepreneurs and the,marketers they are really confused about,the headers that are given in the cells,report that we extract from shopify,so let us just you know try and,understand that what that headers are,and put an end to the confusion that,happens every time,so first of all let me take you through,that report first,so this is a report uh that,you would see in shopify uh this is,actually,a real sales report but obviously i've,blurred it it's my client and,so i can't show you the names but yeah,so,if you see this is the day we don't want,to do anything with that in this video,orders gross sales discounts,returns and net sales shipping tax and,total sales,a lot of people don't understand what is,what and,like what are the calculations and a lot,of things right so let's go to the,jamboard and try to understand these,headers okay,so we are actually going to take a small,example,we are not going to rely on these,numbers that'll create more confusion,so we're going to take a small example,and we'll try to understand,every header okay so for that um,let's take an example wherein we are,selling t-shirts one t-shirt is for ten,dollars,and we have ten orders in a month or in,a year or whatever,time frame that you wanna take let's say,a month okay,and uh out of the 10 orders that we have,got,we gave discounts to three orders and,the discounts were 10,each uh two of them returned back and,three orders for three hours we charge,shipping and for three orders we have,charged,taxes let's let's make it that that,simple okay,uh now the first thing the first thing,here is orders right,so here you will be able to understand,that how many orders we have got in that,specific time period so let's say for,month,so over here we have 10 odds right so,the number one header is 10 orders,now gross sales what are gross sales,very simply to put,to put here is that 10 orders,into how much is one t-shirt,this 10 t-shirt right so 10 orders into,10,is equal to 100,and this is my cross sales,now let's say this is the gross size,right all right okay now this,is gross sales number two column here,gross,sales now after that,there is discounts so as mentioned in,this,example like what we have decided is,that we have given 10,discount to three orders so,quite simply,ten percent discount to three orders ten,percent of dollar ten,is one dollar so for three orders we,have given a discount of,three dollars in total so let me make a,box of here,so that three dollars is gonna be,from the gross sales itself,so if you can see,okay go to back,nice okay now at this point of time,what do we have,gross sales minus,discounts,so i'm gonna put one more,text box here and say minus dollar,three okay now the next column is,returns right so quite simply let's say,we have we have had two returns okay,and just for simplicity let's say that,people who did not get the discount have,returned,the t-shirt so the returns are going to,be in total of,10 into 2 that is 20 dollars right,so let me just frame this,okay sorry for the size,but yeah okay now,this is dollar,20 because,two of them have given that back to us,right,so now minus,returns,and when gross sales minus discounts,minus returns is this your term which we,call this net sales,right so now this is equal to,net sales,minus dollar 20 and that,is equal to,how much is that it is,dollar 77 so at this point of time,our net sales are dollar 77,this is that column now,let's now let's add our,shipping and taxes so let's see now,so we had like 10 orders two of them,returned it back to us,now we have charged shipping to three of,them,and we have charged access to three of,them let's say shipping is dollar two,per,uh per order uh so for three of them we,have charged,six dollars so,forget about the ratio here okay just,just pardon me for that,so this is,dollar six and that is shipping,so shipping is here now,we also have taxes right so let's say,we have a one dollar as taxes,and we have taken it from three orders,that will come here,dollar three,okay so net sales is done shipping is,done and taxes is done,now what are the total,sales so this net sales,now this dollar 77 plus,dollar six shipping and plus,dollar three,is equal to,total sales and that is equal to,86 dollars,right so this is total,sales,quite simply let me just show you with,net sales plus,shipping plus taxes is equals to,total sales so if,we can plot it here let me just,give a number to net sales,and this,and this,so this is net sales for us,the yellow ones right,so this is the simplification,of the headers of the sales report,so i hope you have understood the,headers of the sales report,if you have any questions put down in,the comments i'll surely address them,or maybe if you want me to explain it,or maybe if you want me to explain it a,little bit further i'll do that too,thank you see you again

Shopify Analytics Tutorial: How To Use Shopify Analytics (Understand Shopify Analytics and Reports)

without reading and analyzing your,shopify analytiks all the efforts that,you are making in order to improve your,store and in order to improve your,marketing plans are very similar to,gambling because they are not based on,strong foundations and on data so i want,you to stop gambling and i want you to,start building your decisions on data,and i want you to make sure that you are,doing the right thing in order to,improve your business hi there i am,rehab and on this youtube channel i,share with you videos related to,e-commerce entrepreneurship and more and,in today's video i'm going to show you,in details how you can read your shopify,reports and how you can analyze them in,a previous video on this youtube channel,i showed you the top five metrics that,you should be tracking on your store,however if you want to take things to a,totally next level like if you want,truly to understand how your store is,performing and if you want to monitor,everything i highly recommend you to,watch this video because in this video,we are going to take things into a next,level so this video is much more,advanced and the things we are going to,discuss in this video are also much more,advanced before starting with the data,and with analyzing the numbers and the,reports i want to invite you to check,the free workshop i'm offering in this,workshop i show you the exact framework,that you should be applying to your,business in order to be able to attract,convert and retain your customers so if,you want to improve your business and if,you want to boost your revenue and your,profit i highly recommend you to go down,and to take this free workshop it's 100,free so you don't need to pay anything,and it will give you a very good idea,about how you can make your business,strong and sustainable so go down and,take this free workshop and let's start,with our topic i'm not going to repeat,the metrics i have discussed in my,previous video if you want to see them,you can go and watch the previous video,and i highly recommend you to do that,the things we are going to see in this,video are different they are related,somehow to the previous metrics but they,are much more detailed so the first,thing you have to know is that shopify,reports are divided into three different,types the first type is the acquisition,reports the second type is the behavior,reports and the third type is the,marketing reports and in this video we,are going to tok about the behavior,reports and the acquisition reports,because i don't use the marketing,provided by shopify i use third-party,softwares and platforms in order to run,my marketing strategies and campaigns,that's why i don't use the marketing,data provided by shopify so everything,related to email marketing to paid ads i,follow these numbers up on the platforms,where i'm running my campaigns so for,facebook i do that on facebook ads for,email marketing i do that on clevview,for google ads i do that directly on,google so if you are doing any marketing,directly here on shopify you can use,these reports however i don't use them,so i'm not going to discuss them in this,video let's start with the first type of,reports i'm going to discuss and they,are the acquisitions reports,and here we have three reports that we,should be checking the first one is,sessions over time the second one is,sessions by refer and the third one is,sessions by location and i'm going to,explain each one of these and i'm going,to tell you why they are very important,and how you can use them to analyze your,store performance and your customers,acquisitions,so let's start by sessions over time so,the sessions over time is a report that,shows you the number of visitors during,a certain period so you can check this,report in order to see which days are,bringing the most of traffic,search in here for spikes and drops and,try to understand them so let's say for,example i went in here and i changed,this to the last 19 days for example,and i clicked on apply and i'm seeing,the results by day for example in here,i'm seeing a very big spy i should be,analyzing this spike in order to,understand what happened on this exact,day and why i received a lot of traffic,compared to the other days and for,example in here i'm seeing a drop and i,should be analyzing this drop and so on,this is how you analyze this report and,this is how you can use it in order to,understand well what's happening with,your traffic and why some days are,bringing more traffic than others is so,you can see what are the things that,working and copy them if i scroll down,in here i can see the table and also in,here you can apply filter and try to,understand more what's happening with,your traffic so for example in here you,can choose to see the conversion rate,so in this exact day for example if we,go in here the day i have i was seeing a,a very big increase in the number of,traffic it was april 4 i guess let me,see how much,the conversion rate was at this exact,day,going into april 4 my conversion rate,was was zero so although i received a,lot of traffic i didn't make any sales,which means that the traffic i received,is not a good traffic it's not well,targeted which means that i shouldn't be,doing the same thing because this,traffic didn't bring me any sale so in,addition to checking the number of,people you actually,attracted toward your store you have to,make sure that you are attracting the,right customers and in order to judge,whether you are attracting the right,kind of audience or your potential,customers actually you have to see your,conversion rate so you analyze both,things at the same time first you see if,you are receiving more traffic or less,traffic then you judge the quality of,the traffic by seeing the number of,conversion rate or number of added to,cart and things like that,also in here to understand more what's,happening you can for example filter by,source to know from where did you,receive this traffic so you go in here,and in here you choose,to see the source of the traffic so you,click on,refer name and you see the referrer name,for each of your days so let me go back,in here to april 4 and see from where,exactly did i receive this traffic,so here i am on,april 4 for example and i've received,this traffic from facebook and from,google,i will go in here and i will choose the,exact date so it's april which means,it's zero four,zero one,okay i will remove the conversion rate,to be able only to see the source okay,and now i can see that on april 4th for,example,which should be the day where i received,more traffic than the usual i was,referring i was receiving this traffic,from google and from direct source,let me see else okay so this is how in,addition to seeing the quality of the,traffic i received i also saw the source,of the traffic so,that's how you do that you check out the,results you have then you analyze them,and then you go to filters and you add,filters in order to understand well,what's happening so moving now to the,next report we have and this report is,sessions by refer and it's very similar,to what i have done with that when i,added the filter of the refresh so you,go in here to sessions by refer,in here let's choose for example um last,90 days,and in here i'm seeing in the last 90,days which,source of traffic was performing the,best so for example google in here drove,me most of the traffic let me judge the,quality of the traffic by going in here,and clicking on conversion rates,let me see for example the conversion,rate of the google sessions because in,this way i will understand if the google,if google is performing well,if google traffic is performing well,so this is google for example the,conversion rate coming from google is,very low which means if i'm running ads,in order to drive traffic to my store,through through google ads my ads are,not performing well because the,conversion rate is very low however you,should know that if you are running ads,it's very normal to have a low,conversion r