{"heading":null,"id":11896087,"theme":{"name":"none","colors":{"background":"#ffffff","button":"#103B64","buttonText":"#ffffff","heading":"#36434d","text":"#5e6971"},"background":{"blend":"multiply","blur":0,"contrast":75,"grayscale":100,"opacity":38,"url":null}},"button":{"text":null,"url":null},"collectionLayout":"collection-layout-columns-left","contentAlignment":"content-alignment-left","header":{"title":"Contents","text":null,"button":{"text":null,"url":null}},"mediaStyle":"media-style-plain","preLaunch":false,"products":null,"sections":[{"id":962319,"default":true,"name":"Contents","description":null,"blocks":[]},{"id":920,"default":false,"name":"Getting Acquainted","description":"

How to use this Vault, and how to reach us if you need help.

","blocks":[{"id":1292,"icon":"content-text","title":"1) Join us on Slack","length":null,"filesize":null,"preview":false,"download":false,"buttonText":{"preview":"Preview","view":"View"},"urls":{"visit":"/view/courses/the-template-vault/920-getting-acquainted/1292-1-join-us-on-slack"}},{"id":692519,"icon":"content-text","title":"2) All the links","length":null,"filesize":null,"preview":false,"download":false,"buttonText":{"preview":"Preview","view":"View"},"urls":{"visit":"/view/courses/the-template-vault/920-getting-acquainted/692519-2-all-the-links"}},{"id":692524,"icon":"content-text","title":"3) How we can help","length":null,"filesize":null,"preview":false,"download":false,"buttonText":{"preview":"Preview","view":"View"},"urls":{"visit":"/view/courses/the-template-vault/920-getting-acquainted/692524-3-how-we-can-help"}}]},{"id":238024,"default":false,"name":"Agency Life","description":"

Anything related to project management or agency-wide reporting.

","blocks":[{"id":692496,"icon":"cloud","title":"Agency Project Management (Sheets) ","length":null,"filesize":null,"preview":false,"download":false,"buttonText":{"preview":"Preview","view":"View"},"urls":{"visit":"/view/courses/the-template-vault/238024-agency-life/692496-agency-project-management-sheets"}}]},{"id":238021,"default":false,"name":"E-commerce + Lead gen","description":"

Automating email list + e-com shop reporting.

","blocks":[{"id":692501,"icon":"content-text","title":"Mailchimp Analytics (Data Studio) ","length":null,"filesize":null,"preview":false,"download":false,"buttonText":{"preview":"Preview","view":"View"},"urls":{"visit":"/view/courses/the-template-vault/238021-e-commerce-lead-gen/692501-mailchimp-analytics-data-studio"}},{"id":692497,"icon":"cloud","title":"Conversion Funnel Analytics (Sheets) ","length":null,"filesize":null,"preview":false,"download":false,"buttonText":{"preview":"Preview","view":"View"},"urls":{"visit":"/view/courses/the-template-vault/238021-e-commerce-lead-gen/692497-conversion-funnel-analytics-sheets"}},{"id":691949,"icon":"video","title":"Shopify Price + Product Updater (Sheets) ","length":"7 mins","filesize":"96.1 MB","preview":false,"download":false,"buttonText":{"preview":"Preview","view":"View"},"urls":{"visit":"/view/courses/the-template-vault/238021-e-commerce-lead-gen/691949-shopify-price-product-updater-sheets"}}]},{"id":238020,"default":false,"name":"Paid Acquisition","description":"

Anything related to paid media, and automating your way to glory in Sheets, Data Studio and BigQuery.

","blocks":[{"id":691948,"icon":"video","title":"Facebook + Google Ads Dashboard (Data Studio) ","length":"12 mins","filesize":"68.3 MB","preview":false,"download":false,"buttonText":{"preview":"Preview","view":"View"},"urls":{"visit":"/view/courses/the-template-vault/238020-paid-acquisition/691948-facebook-google-ads-dashboard-data-studio"}}]},{"id":238023,"default":false,"name":"SEO","description":"

Automating the nitty gritty SEO workflows, like site audits and reporting.

","blocks":[{"id":692598,"icon":"cloud","title":"Forecast Organic Traffic (Data Studio)","length":null,"filesize":null,"preview":false,"download":false,"buttonText":{"preview":"Preview","view":"View"},"urls":{"visit":"/view/courses/the-template-vault/238023-seo/692598-forecast-organic-traffic-data-studio"}},{"id":780705,"icon":"cloud","title":"Automated SEO Content Audit (Sheets)","length":null,"filesize":null,"preview":false,"download":false,"buttonText":{"preview":"Preview","view":"View"},"urls":{"visit":"/view/courses/the-template-vault/238023-seo/780705-automated-seo-content-audit-sheets"}},{"id":722420,"icon":"cloud","title":"Monthly Keyword Tracking (Data Studio) ","length":null,"filesize":null,"preview":false,"download":false,"buttonText":{"preview":"Preview","view":"View"},"urls":{"visit":"/view/courses/the-template-vault/238023-seo/722420-monthly-keyword-tracking-data-studio"}},{"id":691945,"icon":"video","title":"Meta Tag Rewrite Checker (Sheets) ","length":"7 mins","filesize":"124 MB","preview":false,"download":false,"buttonText":{"preview":"Preview","view":"View"},"urls":{"visit":"/view/courses/the-template-vault/238023-seo/691945-meta-tag-rewrite-checker-sheets"}},{"id":722803,"icon":"cloud","title":"SERP Anomaly Detection (Sheets) ","length":null,"filesize":null,"preview":false,"download":false,"buttonText":{"preview":"Preview","view":"View"},"urls":{"visit":"/view/courses/the-template-vault/238023-seo/722803-serp-anomaly-detection-sheets"}}]},{"id":268095,"default":false,"name":"Advanced Automations","description":"

When you're ready to break out of Sheets and into something more powerful, this is a good place to start.

","blocks":[{"id":692548,"icon":"cloud","title":"Website Quality Audit (BigQuery) ","length":null,"filesize":null,"preview":false,"download":false,"buttonText":{"preview":"Preview","view":"View"},"urls":{"visit":"/view/courses/the-template-vault/268095-advanced-automations/692548-website-quality-audit-bigquery"}},{"id":692544,"icon":"content-text","title":"Shopify + Google Analytics Buyer Segmentation (BigQuery) ","length":null,"filesize":null,"preview":false,"download":false,"buttonText":{"preview":"Preview","view":"View"},"urls":{"visit":"/view/courses/the-template-vault/268095-advanced-automations/692544-shopify-google-analytics-buyer-segmentation-bigquery"}},{"id":692568,"icon":"content-text","title":"Analytics Tracking Plan (BigQuery) ","length":null,"filesize":null,"preview":false,"download":false,"buttonText":{"preview":"Preview","view":"View"},"urls":{"visit":"/view/courses/the-template-vault/268095-advanced-automations/692568-analytics-tracking-plan-bigquery"}},{"id":692537,"icon":"content-text","title":"SEO API Starter (Sheets) ","length":null,"filesize":null,"preview":false,"download":false,"buttonText":{"preview":"Preview","view":"View"},"urls":{"visit":"/view/courses/the-template-vault/268095-advanced-automations/692537-seo-api-starter-sheets"}}]}],"toggles":{"itemIcons":true,"itemDetails":true,"sectionDescriptions":true,"sectionToggles":false,"open":false}}