Marketing Analytics use case - query from and update Google Ads

[Cassandra-Clark]

As a user, I want to be able to connect to my Marketing Analytics data from Google to evaluate the success of my ad campaigns. I also want to be able to update Google Ads with data from another source so that it can be used to accurately report on non-google campaigns.

• Authenticate with Google Ads
• Connect to Google Ads
• Read from Google Ads
• Join to secondary datasource
• Write updates to Google Ads via API
• Create Google Ads connector to support most common APIs (list TBD, might become its own issue)

[enso-bot]

Cassandra Clark reports a new STANDUP for today (2023-12-13):

Progress: started work on procuring an advertising related ancillary dataset, worked on video edits, fraud example, meetings It should be finished by 2024-01-31.

Next Day: #8196 Table.running function, #8537

[jdunkerley]

Can you put a skeleton in a google doc of what it will be and aim to review on 2024-01-03

[enso-bot]

Cassandra Clark reports a new STANDUP for today (2024-01-02):

Progress: identified appropriate datasets and wrote up design, learning google APIs It should be finished by 2024-01-31.

Next Day: more icon work, 8196, finish republishing fraud demo and updating blog with revised 'merge' changes

[enso-bot]

Cassandra Clark reports a new STANDUP for today (2024-01-03):

Progress: created service account for google analytics, started module development It should be finished by 2024-01-31.

Next Day: more icon work, 8196, finish republishing fraud demo and updating blog with revised 'merge' changes

[enso-bot]

Cassandra Clark reports a new STANDUP for today (2024-01-04):

Progress: csv parsing complete, working on massaging existing data for test. Worked on fraud demo, running into issues with set It should be finished by 2024-01-31.

Next Day: finish icons, finish 8537 v1 workflow, finish fraud demo fixes

[enso-bot]

Cassandra Clark reports a new STANDUP for today (2024-01-05):

Progress: Finished fraud demo fixes. Marketing use case ready for review Monday It should be finished by 2024-01-31.

Next Day: finish icons

[enso-bot]

Cassandra Clark reports a new STANDUP for today (2024-01-09):

Progress: Marketing service account permissions resolved, made progress on workflow. Icon work, researched and suggested ideas for churn dataset It should be finished by 2024-01-31.

Next Day: finish icons

[enso-bot]

Cassandra Clark reports a new STANDUP for yesterday (2024-01-10):

Progress: Marketing analytics workflow built, ran into an issue with RS256 encryption requirements, continuing tomorrow It should be finished by 2024-01-31.

Next Day: resolve marketing analytics authentication and encryption

[enso-bot]

Cassandra Clark reports a new STANDUP for yesterday (2024-01-10):

Progress: Made some progress on integrating updated Google Analytics authentication into Google_Apis It should be finished by 2024-01-31.

Next Day: Finish google analytics authentication, Churn analysis with James

[enso-bot]

Cassandra Clark reports a new STANDUP for yesterday (2024-01-12):

Progress: pivoted strategy for marketing analytics to use project based polyglot library It should be finished by 2024-01-31.

Next Day: Finish google analytics authentication, Churn analysis with James

[enso-bot]

Cassandra Clark reports a new STANDUP for today (2024-01-15):

Progress: worked on google analytics authentication with polyglot It should be finished by 2024-01-31.

Next Day: Google analytics authentication, Churn analysis with James, create bookclub

[enso-bot]

Cassandra Clark reports a new STANDUP for yesterday (2024-01-17):

Progress: worked on marketing analytics use case, published book club. It should be finished by 2024-01-31.

Next Day: Google analytics authentication, icons

[enso-bot]

Cassandra Clark reports a new STANDUP for today (2024-01-18):

Progress: Google analytics work with polyglot, icons work It should be finished by 2024-01-31.

Next Day: Google analytics authentication, icons

[enso-bot]

Cassandra Clark reports a new STANDUP for the provided date (2024-01-19):

Progress: Got polyglot working properly with Google analytics, icons second group close to done, submitted error reporting bug for polyglot It should be finished by 2024-01-31.

Next Day: Google analytics authentication, icons