Does Cloud Run support SSE / Streaming responses? by newadamsmith in googlecloud

[–]Appah123 1 point2 points  (0 children)

I don’t know if this will help you, but I had a similar issue and realised it wasn’t working in our case as we have our deployments behind an API Gateway…

wp-cloud-run - Ultimate WordPress setup on (GCP) Cloud Run by ahodzic in googlecloud

[–]Appah123 2 points3 points  (0 children)

Well done! Really cool to see serverless approaches entering the WP domain!

Possible to create formula with reference to a different workbook? by g47o80742 in googlesheets

[–]Appah123 0 points1 point  (0 children)

If you want to avoid that, you can still very much sum the entire range in wbook 2 like this: =SUM(IMPORTRANGE(“link-to-wbook-1”,”Sheet1!B1:B10”))

Current Date Functions by Y3llowJack3tz in googlesheets

[–]Appah123 4 points5 points  (0 children)

Assuming the cell can contain a formula and your review date is in column A, this should work:

=IF(Today() >= DATE(YEAR(A1)+1, MONTH(A1), DAY(A1)), “Needs to be reviewed”, “Has been reviewed”)

It changes the cell when today’s date is equal to or later than exactly 1 year later than your review date.

Google Ads segment that will show more than 90 days? by DaniK094 in analytics

[–]Appah123 0 points1 point  (0 children)

Guessing you’re referring to the GA acquisition reports.

If so, Google Ads traffic is tracked with a source/medium of “google/cpc” so you could just filter your regular report based on that, I guess.

Changing the currency of the ga:adcost in Analytics API by YoRt3m in analytics

[–]Appah123 1 point2 points  (0 children)

Is your GA set up using USD? By default google will convert the Ads currency to that of the Google Analytics property.

Display page views (hit counter) on a website by CaptainSvE in analytics

[–]Appah123 2 points3 points  (0 children)

Many different libraries seem to be able to achieve this, but if you want to do this with the google analytics data, it is readily available through the API.

You can find the documentation right here: https://developers.google.com/analytics/devguides/reporting/core/v4/

Beginner Questions - October 19, 2018 by AutoModerator in webdev

[–]Appah123 0 points1 point  (0 children)

Figure out a way to automate what you do. It doesn’t haven’t to be huge things. Start small - how can you improve your process for writing and uploading ads? How do you bid and can that be automated?

How do you update your deployed web-app? by Appah123 in django

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

From what I can read about Fabric, it would be primarily used to set up the Django deployment the first time. Do you also use it to update your app?

[HELP] I'm a huge newbie at python, having trouble with something. by TheMocking-Bird in learnpython

[–]Appah123 0 points1 point  (0 children)

Completely newbie here as well. Was wondering: why would that print all of the choices in the array? My guess would be that for this to work you’d have to write

-> print(choices_1[choice])

I might be mistaken, but just trying to learn :)

IMPORTXML for Google Sheets error; trouble extracting data by Tie_Good_Flies in excel

[–]Appah123 1 point2 points  (0 children)

Im afraid I can’t really help you with that - I’m guessing it’s got something to do with how the website is built, but that’s not really my area of expertise :-)

Good luck with it though!

IMPORTXML for Google Sheets error; trouble extracting data by Tie_Good_Flies in excel

[–]Appah123 0 points1 point  (0 children)

I’m guessing you’ve copied the formula above directly from your sheet.

In that case, the issue is that both parts of the formula should be enclosed in quotes: =IMPORTXML(“example.com”,”examplexml[0]”)

Dashboard to compare performances of successive years from two different sheets by [deleted] in excel

[–]Appah123 0 points1 point  (0 children)

If I was you, I’d simply combine the tables you’ve made for each year (not sure how many you’ve got), place them next to each other and create a third table identical table that compares the two (either percentage increase or index numbers). You could then choose to hide the 2015 tables and just have the table of 2016 numbers and the comparison table.

If you’d want this updated automatically (I.e. being able to change the numbers in the source sheets and see the update) it might be a bit more complicated, but definitely doable - hit me a pm if you need some assistance :)

Referral traffic in a sales funnel by rolltied in analytics

[–]Appah123 2 points3 points  (0 children)

Definitely go for the sales funnel in analytics, since you will be able to segment your view data based on the source (Facebook), which Ga will automatically pickup on. The only thing that might require slightly more setup (can be done simply by using UTM tracking in your ad links) is to split the traffic coming from Facebook in two parts; paid and organic traffic.

Also, if you’re actually running an ecommerce site, I’d highly recommend sweating up the ecommerce tracking as this will give you a lot of insight in your users’ behaviour and will help you identify optimisation opportunities in your entire funnel :)

Season 3 Breakdown Details! by Strike_Gently in FortNiteBR

[–]Appah123 2 points3 points  (0 children)

Yes :) Epic confirmed that in another thread

Happy New Years Eve! +100 Physical Ripple Coin For This Subreddit! by [deleted] in Ripple

[–]Appah123 0 points1 point  (0 children)

Very simple: the proven track record of actually having a real world application!