Weekly ad report — with takeaways, straight to your inbox

Once a week the scenario gathers data from analytics and ad accounts, compares it to last year, and sends a ready report with takeaways.

  • Gathers all channels for you
  • Compares to the same period last year
  • Adds short takeaways
  • Sends to Gmail and okoCrm
Google
Set it up for yourselfScriptera

How it works

To connect Splunk and Facebook Graph API, you don't need a developer: a ready-made scenario links them in minutes.

  1. Starts when: Schedule Trigger
  2. Then: Weekly Report Agent
  3. Then: Processing for Telegram Report
  4. Then: Send Telegram report
  5. Then: Send mail report
  6. Then: OpenAI Chat Model
  7. Then: Google_Ads
  8. Then: Meta_Ads
  9. Then: Analytics_Domain_1
  10. Then: Analytics_Domain_3
  11. Then: Analytics_Domain_2
  12. Then: Analytics_Domain_4
  13. Then: Analytics_Domain_5
  14. Starts when: Execute Workflow Trigger
  15. Then: Call Google Analytics data: Last 7 days
  16. Then: Assign Google Analytics data input (current year)
  17. Then: Summarize Google Analytics input (current year)
  18. Then: Calculation same period previous year1
  19. Then: Call Google Analytics data: Last 7 days (previous year)
  20. Then: Assign Google Analytics data input (previous year)
  21. Then: Summarize Google Analytics input (previous year)
  22. Then: Processing for Google Analytics Report
  23. Then: Calculator
  24. Then: Calculator1
  25. Then: Calculator3
  26. Then: Calculation same period previous year
  27. Then: Call Google Ads Data: Last 7 days (previous year)
  28. Then: Format data input (previous year)
  29. Then: Assign input (previous year)
  30. Then: Summarize input (previous year)
  31. Then: Format all Google data for LLM
  32. Then: Processing for Google Ads report
  33. Then: Format data input (current year)
  34. Then: Assign data from input (current year)
  35. Then: Summarize input (current year)
  36. Then: Calculate date format for Google Ads request (last 7 days)
  37. Then: Call Google Ads Data: Last 7 days
  38. Then: Call Meta Ads Data: Last 7 days
  39. Then: Assign Meta data from input (current year)
  40. Then: Summarize Meta input (current year)
  41. Then: Call Meta Ads Data: Last 7 days (previous year)
  42. Then: Assign Meta data input (previous year)
  43. Then: Summarize Meta data input (previous year)
  44. Then: Format all Meta data for LLM
  45. Then: Processing for Meta Ads Report
  46. Then: Calculate date format for meta ads request s

You can launch this Splunk + Facebook Graph API integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.

Similar scenarios