We're going to learn how you can add ROY by time column to your GoogleAd task board. As you know the formula for Roys age conversion value by cost. But if you want to calculate ROY by time, then you have to consider convergent value by convergent. Divided by cost. Okay. Hi guys. I'm Ruth from Solutions Eight, and in this video we're going to launch how you can add Roys by time column to your Google A dashboard. Roys, as you know, it stands for data. and to analyze realtime data, you need to add Roy by time, not Roy. as you know, the formula for Roys age conversion value by cost. But if you want to calculate by time, then you have to consider convergent value by convergent. Divided by cost. The difference between conversion value and conversion value by conversion time. H conversion value by convergent time will show all the conversion happen in between your viewing date. like we are viewing last 14 days data. Your conversion value by conversion. Time column will show all the conversion value reset within this timeframe last 14 days. And the conversion value transfer, it is conversion value by click time, not conversion time. it'll calculate all the conversion that has been the click for that conversion, the in between the last 14 days. actually I have created another. Explaining the difference between conversion versus conversion by conversion time, you can wash that tutorial to. Understand clearly the difference between and the concept. Then you can continue watch this two to add s by time column to your Google art dashboard. Okay, so actually we need to create a custom column to add ROEs by time column. okay, so as you can see we have added this column here. It is calculating ROS by time and it is calculating as I. all the S received in between 14 days. So it is tracking realtime data. So to add Roys by time column, you need to create a custom column. go to here columns, then you can modify the columns, then you can scroll down. Then here is custom columns. Just expand this. And here you can create a new custom column. As you can see, we have already added by time column, but I will show you how we can create a new column to track, to use by time from scratch. click here plus a new plus custom column. Then you can name your. Then if you want to add the description, then you can act. Then here you. Need to add a column for that. So, as I said, Roy, by time is if you, conversion value by conversion value by conversion time divided by cost, then you can calculate voice. here, click on the plus icon. Then you can search for conversion value by conversion. This is not a glitch. I'm interrupting the video you're watching because I need to remind you that I'm always looking for people to join our team. So if you're passionate about Google Ads and you wanna work with the best Google Ads agency on the planet, please go to so late.com/apply. Speaking of working with the best Google Ads agency on the planet, if you're having trouble with Google Ads and you want professional help, that's what we do. You can go to so late.com, that's s o l eight.com to apply for your free, no obligation action plan. And if I've. Any level of value at all. Maybe think about giving me a thumbs up and subscribe to our channel. That's how we juice the YouTube algorithm so they actually know that I know what I'm talking about. If you have questions, comments, concerns, or confessions, hit me below in the comments, and now back to your regularly scheduled program. Okay, so here is our conversion value by conversion. Then you need to divide it by cost. Okay, so click here, divide icon, then just by just type cost. Okay sir. Reach cost. And as you know, Roys always calculate in percentage format. So you need to change the data format number to Then you just need to save. You can save this. Okay? After saving, you'll see your custom column Here. You can uncheck this. No, check mark this. Then you can just apply. Then if you. Drag here. Then you can see the rose by time column and you can analyze the real time rose in this way. So in this way you can. add Rose by time column to your Google Art dashboard. I hope you like this video. If you have like this, please thumbs up and please share this video with your friends colleague, wherever you can, and subscribe to this channel to watch this kind of valuable. I. Hey, so thank you for watching and see again. Bye-bye.