As per Whatsapp policies and Twilio docs, the business initiated conversations require the pre-approved message templates. The Whatsapp API provides a programmatic way to maintain and approve such templates.

Is there an appropriate API endpoint on the Twilio side for the programmatic Whatsapp's templates management? I haven't found anything except the manual template submission using the Twilio console.

I am trying to track a Click conversion with Google Ads using the Rest API but I can't find any helpful resources.

Right now the user flow looks like this:

User clicks on Ad -> User opens Website -> User downloads the Flutter App (gclid will be passed via dynamic links) -> User Signs up -> New Customer.io Event will be triggered (contains gclid) -> Upload conversion to Google Ads

The problem lies with the last step. In customer.io I can only use a Rest Call to upload the converion to Google Ads. I cannot use the client library of Google and I can't figure out from the documentation which call exactly I have to make here. (Unfortunatly Google itself is advising against using the Rest API but also states that it is possible by itself. Also I don't have any other options here than going the route via Customer.io and making the Rest Call)

I would really appreciate any kind of help, thank you!

I am utilizing the Google ads API to pull campaign data and I am having an issue where I would like to use a fixed date range in my query, but it seems to be unavailable as an option in the documentation.

Here is my query:

GAquery = """ SELECT     segments.date,     segments.device,     campaign.name,     metrics.clicks,     metrics.conversions,     metrics.conversions_value,     metrics.cost_micros,     metrics.impressions FROM    campaign WHERE segments.date DURING LAST_30_DAYS ORDER BY     metrics.clicks DESC""" # Issues a search request using streaming. response = ga_service.search_stream(customer_id=customer_id, query=GAquery) 

I am looking to get the LAST_60_DAYS instead of 30, but changing the LAST_30_DAYS to LAST_60_DAYS errors out. Has anyone found a way to code a rolling date range that is not a preset option in the system or are we stuck with only the preset options?

Thanks so much for your help. :)

I am using python to execute the query and retrieve the data from Google Ads I am trying to set start and end date as variable and use these in my query.

The query looks like this:

GAquery = """ SELECT     segments.date,     segments.device,     campaign.name,     metrics.clicks,     metrics.conversions,     metrics.conversions_value,     metrics.cost_micros,     metrics.impressions FROM    campaign WHERE segments.date >= '2021-12-01' AND segments.date <= '2022-02-27' ORDER BY     metrics.clicks DESC""" 

and it is executed by Google Function for Python

response = ga_service.search_stream(customer_id=customer_id, query=GAquery) 

This function does not have element params where i could use %s as placeholder in the query and then call it in params regular execute(sql,conn, params[Sdate,Edate] function in python.

So what i need to do is somehow break the query string, and add the dates in between. Something like this:

sdate = (dt.date.today() - dt.timedelta(days=60)) edate = dt.date.today() GAquery = """ SELECT     segments.date,     segments.device,     campaign.name,     metrics.clicks,     metrics.conversions,     metrics.conversions_value,     metrics.cost_micros,     metrics.impressions FROM    campaign WHERE segments.date """ + """>= """+ str(sdate) +""" AND segments.date""" +  """<=""" +str(edate) + """ ORDER BY     metrics.clicks DESC""" 

So basically i am trying to force variables into GAquery by breaking the query apart inserting it and stitching it together.

It is failing because i am not breaking it correctly and not adding it back together correctly.

Any idea how to handle this?

I have setup a two way communication between business account and customer using whatsapp business apis. I am having trouble understanding media providers that there documentation talks about for sending text message to customer with image/media.

Heres the link to it: https://developers.facebook.com/docs/whatsapp/api/settings/media-providers/

Who are these providers? are they some specified organisation?

I am currently storing the media files in AWS S3 using some pre-signed url method. Can I use media stored in S3 in whatsapp media message?.

An example would be great help.